• Table of contents
• Specification
  • Table Used
    • SP_INTERFACE

Specification¶

Table Used¶

SP_INTERFACE¶

This table keeps those transaction that needed to or going to submit to SP web services.

create table sp_interface (
    id int not null generated always as identity,
    process_code varchar(30),
    trx_id varchar(30) not null,
    trx_type varchar(15),
    country_code varchar(10),
    member_id varchar(20),
    trx_date varchar(8),
    status varchar(15),
    last_updated timestamp,
    error_code varchar(10),
    error_message varchar(255),
    primary key (id)
);

create unique index idx_sp_id_type on sp_interface(trx_id,trx_type);
create index idx_sp_status on sp_interface(status);
create index idx_sp_err_code on sp_interface(error_code);