Specification » History » Version 4
chin-yeh, 10/17/2011 05:38 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 | 4 | chin-yeh | is_valid varchar(5) default 'N' not null |
27 | 3 | chin-yeh | ); |
28 | |||
29 | alter table nmi_interface add primary key (order_id); |
||
30 | </code> |
||
31 | </pre> |