Specification » History » Version 5
chin-yeh, 09/21/2011 10:54 AM
1 | 1 | chin-yeh | {{toc}} |
---|---|---|---|
2 | |||
3 | h1. Specification |
||
4 | |||
5 | h2. Suggested Payment Flow |
||
6 | |||
7 | !payment_flow.png! |
||
8 | 2 | chin-yeh | |
9 | h2. Table(s) Used |
||
10 | |||
11 | * *MPAY_INTERFACE:* |
||
12 | <pre> |
||
13 | <code class="SQL"> |
||
14 | create table ecos.mpay_interface( |
||
15 | order_id varchar(15) not null, |
||
16 | trx_type varchar(5), |
||
17 | shopper_ref_no integer, |
||
18 | currency varchar(3), |
||
19 | charge_amt decimal(15,2), |
||
20 | status varchar(5), |
||
21 | 4 | chin-yeh | bank_authcode varchar(30), |
22 | 2 | chin-yeh | datetime timestamp, |
23 | error_msg varchar(155), |
||
24 | is_valid varchar(5) not null with default 'N') |
||
25 | ); |
||
26 | |||
27 | 3 | chin-yeh | alter table ecos.mpay_interface add primarykey(order_id); |
28 | 2 | chin-yeh | </code> |
29 | </pre> |
||
30 | 5 | chin-yeh | |
31 | h2. Error Code |
||
32 | |||
33 | Refer to the following documents in the document:"Integration Guides": |
||
34 | * Integration Guide for Alipay |
||
35 | * Integration Guide for CUP |