Project

General

Profile

Specification » History » Version 6

chin-yeh, 09/21/2011 11:57 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 6 chin-yeh
h2. Error Code Description
32 5 chin-yeh
33
Refer to the following documents in the document:"Integration Guides":
34
* Integration Guide for Alipay
35
* Integration Guide for CUP