Taiwan Services » SP Client

{{toc}}

h1. Specification

h2. Table Used

h3. SP_INTERFACE

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

<pre>

<code class="SQL">

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

</code>

</pre>