Specification » History » Revision 8
Revision 7 (chin-yeh, 09/21/2011 03:59 PM) → Revision 8/9 (chin-yeh, 11/21/2011 04:48 PM)
{{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',
external_trx_id varchar(20)
);
alter table ecos.mpay_interface add primary key(order_id);
</code>
</pre>
h2. Error Code Description
Refer to the following documents in the document:"Integration Guides":
* Integration Guide for Alipay
* Integration Guide for CUP
* Integration Guide for VM