• Table of contents
• Specification
  • Payment Flow
  • Interface Table Used

Specification¶

Payment Flow¶

Interface Table Used¶

NMI_INTERFACE

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