BUYSUPSEC

This table is deprecated and is provided for backward compatibility only.

Column Descriptions:

NameTypeDescription
BUYORG_IDBIGINT NOT NULLReserved for HCL internal use.
SUPORG_IDBIGINT NOT NULLReserved for HCL internal use.
BUYERLOGONIDVARCHAR (254) NOT NULLReserved for HCL internal use.
BUYERLOGONPASSWORDBINARY NOT NULLReserved for HCL internal use.
SUPLOGONIDTYPEVARCHAR (64)Reserved for HCL internal use.
SUPLOGONIDVARCHAR (254)Reserved for HCL internal use.
SUPLOGONPASSWORDBINARYReserved for HCL internal use.
AUTHLEVELINTEGER NOT NULLReserved for HCL internal use.
EXPIRYDATETIMESTAMPReserved for HCL internal use.
STATUSINTEGERReserved for HCL internal use.
FIELD1VARCHAR (64)Reserved for HCL internal use.
FIELD2VARCHAR (64)Reserved for HCL internal use.
FIELD3VARCHAR (64)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>BUYORG_ID+SUPORG_IDPrimary Key
I0000494SUPORG_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_144SUPORG_IDORGENTITYORGENTITY_IDCascade
F_145BUYORG_IDORGENTITYORGENTITY_IDCascade