WebSphere Commerce database table: PAYSTATUS

Reserved for IBM internal use.

Column Descriptions

Column Name	Column Type	Description
SETSORNBR	BIGINT NOT NULL	Reserved for IBM internal use.
STORE_ID	INTEGER NOT NULL	Reserved for IBM internal use.
SETSBRANDID	CHAR(40)	Reserved for IBM internal use.
SETSPREQSTMP	TIMESTAMP	Reserved for IBM internal use.
SETSTIMESTMP	TIMESTAMP	Reserved for IBM internal use.
SETSSTATCODE	INTEGER	Reserved for IBM internal use.
SETSNEXTSTAT	INTEGER	Reserved for IBM internal use.
SETSTIMEEXP	INTEGER	Reserved for IBM internal use.
SETSFAILTYPE	INTEGER	Reserved for IBM internal use.
SETSFAILCODE	INTEGER	Reserved for IBM internal use.
SETSCURR	INTEGER	Reserved for IBM internal use.
SETSCURREXP	INTEGER	Reserved for IBM internal use.
SETSACTAMT	DOUBLE	Reserved for IBM internal use.
SETSRESPREASON	INTEGER	Reserved for IBM internal use.
SETSAUTHCODE	INTEGER	Reserved for IBM internal use.
SETSAUTHCHARIND	INTEGER	Reserved for IBM internal use.
SETSAPPROVALCODE	CHAR(6)	Reserved for IBM internal use.
SETSAUTHRETNUM	INTEGER	Reserved for IBM internal use.
SETSLOGREFID	VARCHAR(32)	Reserved for IBM internal use.
SETSPAN	VARCHAR(19)	Reserved for IBM internal use.
SETSCARDEXPIRY	CHAR(6)	Reserved for IBM internal use.
SETSAUTHREVCODE	INTEGER	Reserved for IBM internal use.
SETSCAPCODE	INTEGER	Reserved for IBM internal use.
SETSCAPREVCODE	INTEGER	Reserved for IBM internal use.
SETSCREDCODE	INTEGER	Reserved for IBM internal use.
SETSCREDREVCODE	INTEGER	Reserved for IBM internal use.
SETSAVSRESULT	INTEGER	Reserved for IBM internal use.
SETSAUTHAMT	INTEGER	Reserved for IBM internal use.
SETSCAPAMT	INTEGER	Reserved for IBM internal use.
SETSSETTLEAMT	INTEGER	Reserved for IBM internal use.
SETSCREDAMT	INTEGER	Reserved for IBM internal use.
SETSWAKEUPMSG	VARCHAR(4000)	Reserved for IBM internal use.
SETSFAILCODE2	INTEGER	Reserved for IBM internal use.
PENDING	INTEGER	Reserved for IBM internal use.
PROFILENAME	VARCHAR(64)	Reserved for IBM internal use.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235227100	SETSORNBR+STORE_ID	Primary Key
I0000685	STORE_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_579	SETSORNBR	ORDERS	ORDERS_ID	Cascade
F_578	STORE_ID	STORE	STORE_ID	Cascade