Specification » History » Revision 2
Revision 1 (chin-yeh, 08/02/2011 03:27 PM) → Revision 2/7 (chin-yeh, 08/08/2011 11:47 AM)
{{toc}} h1. Specification h2. Table(s) Used h3. DP_INTERFACE <pre> <code class="SQL"> create table dp_interface ( id int not null generated always as identity, process_code varchar(30), trx_id varchar(30) not null, trx_type varchar(15), country_code varchar(10), member_id varchar(20), trx_date varchar(8), dp_amount decimal(10,2), invoice_amount decimal(10,2), status varchar(15), last_updated timestamp, error_code varchar(10), error_message varchar(255), primary key (id) ); create unique index idx_dp_id_type idx_dp_trx_id on dp_interface(trx_id,trx_type); dp_interface(trx_id); create index idx_dp_status on dp_interface(status); create index idx_dp_err_code on dp_interface(error_code); </code> </pre>