PAYSTATUS

Reserved for HCL internal use.

Column Descriptions:

NameTypeDescription
SETSORNBRBIGINT NOT NULLReserved for HCL internal use.
STORE_IDINTEGER NOT NULLReserved for HCL internal use.
SETSBRANDIDCHAR (40)Reserved for HCL internal use.
SETSPREQSTMPTIMESTAMPReserved for HCL internal use.
SETSTIMESTMPTIMESTAMPReserved for HCL internal use.
SETSSTATCODEINTEGERReserved for HCL internal use.
SETSNEXTSTATINTEGERReserved for HCL internal use.
SETSTIMEEXPINTEGERReserved for HCL internal use.
SETSFAILTYPEINTEGERReserved for HCL internal use.
SETSFAILCODEINTEGERReserved for HCL internal use.
SETSCURRINTEGERReserved for HCL internal use.
SETSCURREXPINTEGERReserved for HCL internal use.
SETSACTAMTDOUBLEReserved for HCL internal use.
SETSRESPREASONINTEGERReserved for HCL internal use.
SETSAUTHCODEINTEGERReserved for HCL internal use.
SETSAUTHCHARINDINTEGERReserved for HCL internal use.
SETSAPPROVALCODECHAR (6)Reserved for HCL internal use.
SETSAUTHRETNUMINTEGERReserved for HCL internal use.
SETSLOGREFIDVARCHAR (32)Reserved for HCL internal use.
SETSPANVARCHAR (19)Reserved for HCL internal use.
SETSCARDEXPIRYCHAR (6)Reserved for HCL internal use.
SETSAUTHREVCODEINTEGERReserved for HCL internal use.
SETSCAPCODEINTEGERReserved for HCL internal use.
SETSCAPREVCODEINTEGERReserved for HCL internal use.
SETSCREDCODEINTEGERReserved for HCL internal use.
SETSCREDREVCODEINTEGERReserved for HCL internal use.
SETSAVSRESULTINTEGERReserved for HCL internal use.
SETSAUTHAMTINTEGERReserved for HCL internal use.
SETSCAPAMTINTEGERReserved for HCL internal use.
SETSSETTLEAMTINTEGERReserved for HCL internal use.
SETSCREDAMTINTEGERReserved for HCL internal use.
SETSWAKEUPMSGVARCHAR (4000)Reserved for HCL internal use.
SETSFAILCODE2INTEGERReserved for HCL internal use.
PENDINGINTEGERReserved for HCL internal use.
PROFILENAMEVARCHAR (64)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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