BUYSUPSEC

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

Column Descriptions:

NameTypeDescription
BUYORG_IDBIGINT NOT NULLReserved for IBM internal use.
SUPORG_IDBIGINT NOT NULLReserved for IBM internal use.
BUYERLOGONIDVARCHAR (254) NOT NULLReserved for IBM internal use.
BUYERLOGONPASSWORDBINARY NOT NULLReserved for IBM internal use.
SUPLOGONIDTYPEVARCHAR (64)Reserved for IBM internal use.
SUPLOGONIDVARCHAR (254)Reserved for IBM internal use.
SUPLOGONPASSWORDBINARYReserved for IBM internal use.
AUTHLEVELINTEGER NOT NULLReserved for IBM internal use.
EXPIRYDATETIMESTAMPReserved for IBM internal use.
STATUSINTEGERReserved for IBM internal use.
FIELD1VARCHAR (64)Reserved for IBM internal use.
FIELD2VARCHAR (64)Reserved for IBM internal use.
FIELD3VARCHAR (64)Reserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM 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