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 Descriptions:
Name | 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | ORGCODE_ID | Primary Key |
I0000181 | CODETYPE+CODE | Unique Index |
I0000182 | ORGENTITY_ID+CODETYPE | Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_553 | ORGENTITY_ID | ORGENTITY | ORGENTITY_ID | Cascade |