Payment Gateway » mPay

{{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 primary_key("order_id");

</code>

</pre>