This table is deprecated and is provided for
backward compatibility only.
Column Descriptions:
Name | Type | Description |
BUYORG_ID | BIGINT NOT NULL | Reserved for IBM internal use. |
SUPORG_ID | BIGINT NOT NULL | Reserved for IBM internal use. |
BUYERLOGONID | VARCHAR (254) NOT NULL | Reserved for IBM internal use. |
BUYERLOGONPASSWORD | BINARY NOT NULL | Reserved for IBM internal use. |
SUPLOGONIDTYPE | VARCHAR (64) | Reserved for IBM internal use. |
SUPLOGONID | VARCHAR (254) | Reserved for IBM internal use. |
SUPLOGONPASSWORD | BINARY | Reserved for IBM internal use. |
AUTHLEVEL | INTEGER NOT NULL | Reserved for IBM internal use. |
EXPIRYDATE | TIMESTAMP | Reserved for IBM internal use. |
STATUS | INTEGER | Reserved for IBM internal use. |
FIELD1 | VARCHAR (64) | Reserved for IBM internal use. |
FIELD2 | VARCHAR (64) | Reserved for IBM internal use. |
FIELD3 | VARCHAR (64) | Reserved for IBM internal use. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | BUYORG_ID+SUPORG_ID | Primary Key |
I0000494 | SUPORG_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_144 | SUPORG_ID | ORGENTITY | ORGENTITY_ID | Cascade |
F_145 | BUYORG_ID | ORGENTITY | ORGENTITY_ID | Cascade |