Project

General

Profile

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