This table contains the unique identification of an OrgEntity under different identification systems or domains. This can be used to identify buyer organizations and supplier organizations to each other in procurement systems.
Column Description(s):
Column Name | Column Type | Description |
ORGCODE_ID |
BIGINT NOT NULL |
Generated primary key. |
ORGENTITY_ID |
BIGINT NOT NULL |
Foreign key to ORGENTITY table. |
CODETYPE |
VARCHAR(32) NOT NULL |
Identification system used to identify an organization between supplier and buyer organizations. For example, DUNS. |
CODE |
VARCHAR(128) NOT NULL |
The buyer or supplier code, mutually agreed upon between buyer and supplier. For example, a DUNS number. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000181 |
CODETYPE+CODE |
Unique Index |
I0000182 |
ORGENTITY_ID+CODETYPE |
Unique Index |
SQL050212031251500 |
ORGCODE_ID |
Primary Key |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_553 |
ORGENTITY_ID |
ORGENTITY |
ORGENTITY_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.