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>