Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PAYSTATUS
Reserved for IBM internal use.
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 SQL100520030408460 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 _vcc_freeselect_bottom_