Specification » History » Version 3
chin-yeh, 10/17/2011 05:08 PM
| 1 | 3 | chin-yeh | {{toc}} |
|---|---|---|---|
| 2 | |||
| 3 | 1 | chin-yeh | h1. Specification |
| 4 | 2 | chin-yeh | |
| 5 | h2. Payment Flow |
||
| 6 | |||
| 7 | !payment_flow.png! |
||
| 8 | 3 | chin-yeh | |
| 9 | |||
| 10 | h2. Interface Table Used |
||
| 11 | |||
| 12 | *NMI_INTERFACE* |
||
| 13 | <pre> |
||
| 14 | <code class="SQL"> |
||
| 15 | create table nmi_interface ( |
||
| 16 | order_id varchar(15) not null, |
||
| 17 | trx_type varchar(5), |
||
| 18 | shopper_ref_no integer, |
||
| 19 | currency varchar(3), |
||
| 20 | charge_amt decimal(15,2), |
||
| 21 | status varchar(5), |
||
| 22 | bank_authcode varchar(10), |
||
| 23 | datetime timestamp, |
||
| 24 | modify_datetime timestamp, |
||
| 25 | error_msg varchar(155), |
||
| 26 | is_valid varchar(5) default 'n' not null |
||
| 27 | ); |
||
| 28 | |||
| 29 | alter table nmi_interface add primary key (order_id); |
||
| 30 | </code> |
||
| 31 | </pre> |