Specification » History » Revision 5
Revision 4 (chin-yeh, 09/20/2011 05:54 PM) → Revision 5/9 (chin-yeh, 09/21/2011 10:54 AM)
{{toc}}
h1. Specification
h2. Suggested Payment Flow
!payment_flow.png!
h2. Table(s) Used
* *MPAY_INTERFACE:*
<pre>
<code class="SQL">
create table ecos.mpay_interface(
order_id varchar(15) not null,
trx_type varchar(5),
shopper_ref_no integer,
currency varchar(3),
charge_amt decimal(15,2),
status varchar(5),
bank_authcode varchar(30),
datetime timestamp,
error_msg varchar(155),
is_valid varchar(5) not null with default 'N')
);
alter table ecos.mpay_interface add primarykey(order_id);
</code>
</pre>
h2. Error Code
Refer to the following documents in the document:"Integration Guides":
* Integration Guide for Alipay
* Integration Guide for CUP