Specification » History » Version 7
chin-yeh, 09/21/2011 03:59 PM
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 | 7 | chin-yeh | is_valid varchar(5) not null with default 'N', |
25 | external_trx_id varchar(20) |
||
26 | 1 | chin-yeh | ); |
27 | 2 | chin-yeh | |
28 | 7 | chin-yeh | alter table ecos.mpay_interface add primary key(order_id); |
29 | 2 | chin-yeh | </code> |
30 | </pre> |
||
31 | 5 | chin-yeh | |
32 | 6 | chin-yeh | h2. Error Code Description |
33 | 5 | chin-yeh | |
34 | Refer to the following documents in the document:"Integration Guides": |
||
35 | * Integration Guide for Alipay |
||
36 | * Integration Guide for CUP |