Specification » History » Revision 3
Revision 2 (chin-yeh, 10/10/2011 04:30 PM) → Revision 3/4 (chin-yeh, 10/17/2011 05:08 PM)
{{toc}} h1. Specification h2. Payment Flow !payment_flow.png! h2. Interface Table Used *NMI_INTERFACE* <pre> <code class="SQL"> create table nmi_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, modify_datetime timestamp, error_msg varchar(155), is_valid varchar(5) default 'n' not null ); alter table nmi_interface add primary key (order_id); </code> </pre>