Database Table: BUYSUPSEC

Reserved for IBM internal use.

Column Name Column Type Column Description
AUTHLEVEL INTEGER
NOT NULL
Reserved for IBM internal use.
BUYERLOGONID VARCHAR (254)
NOT NULL
Reserved for IBM internal use.
BUYERLOGONPASSWORD CHARACTER (128)
NOT NULL
Reserved for IBM internal use.
BUYORG_ID BIGINT
NOT NULL
Reserved for IBM internal use.
EXPIRYDATE TIMESTAMP
NULL
Reserved for IBM internal use.
FIELD1 VARCHAR (64)
NULL
Reserved for IBM internal use.
FIELD2 VARCHAR (64)
NULL
Reserved for IBM internal use.
FIELD3 VARCHAR (64)
NULL
Reserved for IBM internal use.
STATUS INTEGER
NULL
Reserved for IBM internal use.
SUPLOGONID VARCHAR (254)
NULL
Reserved for IBM internal use.
SUPLOGONIDTYPE VARCHAR (64)
NULL
Reserved for IBM internal use.
SUPLOGONPASSWORD CHARACTER (128)
NULL
Reserved for IBM internal use.
SUPORG_ID BIGINT
NOT NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034847810 BUYORG_ID, SUPORG_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_144 SUPORG_ID ORGENTITY ORGENTITY_ID Cascade
F_145 BUYORG_ID ORGENTITY ORGENTITY_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable