Project

General

Profile

Specification » History » Revision 3

Revision 2 (chin-yeh, 09/20/2011 04:04 PM) → Revision 3/9 (chin-yeh, 09/20/2011 04:56 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(10), 
    datetime timestamp, 
    error_msg varchar(155), 
    is_valid varchar(5) not null with default 'N')  
 ); 

 alter table ecos.mpay_interface add primarykey(order_id); primary_key("order_id"); 
 </code> 
 </pre>