PAYSTATUS

Reserved for IBM internal use.

Column Descriptions:

NameTypeDescription
SETSORNBRBIGINT NOT NULLReserved for IBM internal use.
STORE_IDINTEGER NOT NULLReserved for IBM internal use.
SETSBRANDIDCHAR (40)Reserved for IBM internal use.
SETSPREQSTMPTIMESTAMPReserved for IBM internal use.
SETSTIMESTMPTIMESTAMPReserved for IBM internal use.
SETSSTATCODEINTEGERReserved for IBM internal use.
SETSNEXTSTATINTEGERReserved for IBM internal use.
SETSTIMEEXPINTEGERReserved for IBM internal use.
SETSFAILTYPEINTEGERReserved for IBM internal use.
SETSFAILCODEINTEGERReserved for IBM internal use.
SETSCURRINTEGERReserved for IBM internal use.
SETSCURREXPINTEGERReserved for IBM internal use.
SETSACTAMTDOUBLEReserved for IBM internal use.
SETSRESPREASONINTEGERReserved for IBM internal use.
SETSAUTHCODEINTEGERReserved for IBM internal use.
SETSAUTHCHARINDINTEGERReserved for IBM internal use.
SETSAPPROVALCODECHAR (6)Reserved for IBM internal use.
SETSAUTHRETNUMINTEGERReserved for IBM internal use.
SETSLOGREFIDVARCHAR (32)Reserved for IBM internal use.
SETSPANVARCHAR (19)Reserved for IBM internal use.
SETSCARDEXPIRYCHAR (6)Reserved for IBM internal use.
SETSAUTHREVCODEINTEGERReserved for IBM internal use.
SETSCAPCODEINTEGERReserved for IBM internal use.
SETSCAPREVCODEINTEGERReserved for IBM internal use.
SETSCREDCODEINTEGERReserved for IBM internal use.
SETSCREDREVCODEINTEGERReserved for IBM internal use.
SETSAVSRESULTINTEGERReserved for IBM internal use.
SETSAUTHAMTINTEGERReserved for IBM internal use.
SETSCAPAMTINTEGERReserved for IBM internal use.
SETSSETTLEAMTINTEGERReserved for IBM internal use.
SETSCREDAMTINTEGERReserved for IBM internal use.
SETSWAKEUPMSGVARCHAR (4000)Reserved for IBM internal use.
SETSFAILCODE2INTEGERReserved for IBM internal use.
PENDINGINTEGERReserved for IBM internal use.
PROFILENAMEVARCHAR (64)Reserved for IBM internal use.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>SETSORNBR+STORE_IDPrimary Key
I0000685STORE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_578STORE_IDSTORESTORE_IDCascade
F_579SETSORNBRORDERSORDERS_IDCascade