Specification » History » Version 6
chin-yeh, 09/05/2011 10:51 AM
| 1 | 1 | chin-yeh | {{toc}} |
|---|---|---|---|
| 2 | |||
| 3 | h1. Specification |
||
| 4 | |||
| 5 | 6 | chin-yeh | h2. Reference |
| 6 | 1 | chin-yeh | |
| 7 | 6 | chin-yeh | h3. Transaction Code |
| 8 | |||
| 9 | 1 | chin-yeh | !vp_transaction_code.jpg! |
| 10 | 4 | chin-yeh | |
| 11 | 6 | chin-yeh | h3. Error Code |
| 12 | 5 | chin-yeh | |
| 13 | !vp_error_code.jpg! |
||
| 14 | |||
| 15 | 1 | chin-yeh | h2. Table Schema |
| 16 | |||
| 17 | h3. VP_INTERFACE |
||
| 18 | |||
| 19 | 2 | chin-yeh | This table stores those events which are needed to submit to VP services. It can also be used to track the status of the submitted events. |
| 20 | 1 | chin-yeh | |
| 21 | <pre> |
||
| 22 | <code class="SQL"> |
||
| 23 | create table vp_interface ( |
||
| 24 | id int not null generated always as identity, |
||
| 25 | process_code varchar(30), |
||
| 26 | trx_id varchar(30) not null, |
||
| 27 | trx_type varchar(15), |
||
| 28 | country_code varchar(10), |
||
| 29 | member_id varchar(20), |
||
| 30 | member_name varchar(100), |
||
| 31 | 3 | chin-yeh | trx_date varchar(8), |
| 32 | 1 | chin-yeh | reg_date varchar(8), |
| 33 | expiry_date varchar(8), |
||
| 34 | vp_amount decimal(10,2), |
||
| 35 | invoice_amount decimal(10,2), |
||
| 36 | status varchar(15), |
||
| 37 | last_updated timestamp, |
||
| 38 | error_code varchar(10), |
||
| 39 | error_message varchar(255), |
||
| 40 | primary key (id) |
||
| 41 | ); |
||
| 42 | |||
| 43 | create unique index idx_vp_id_type on vp_interface(trx_id,trx_type); |
||
| 44 | create index idx_vp_status on vp_interface(status); |
||
| 45 | create index idx_vp_err_code on vp_interface(error_code); |
||
| 46 | </code> |
||
| 47 | </pre> |