• Table of contents
• Specification
  • Suggested Payment Flow
  • Table(s) Used

Specification¶

Suggested Payment Flow¶

Table(s) Used¶

• MPAY_INTERFACE:
  

  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);