Project

General

Profile

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