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 Name | Column Type | Column Description |
---|---|---|
CODE | VARCHAR (128) NOT NULL |
The buyer or supplier code, mutually agreed upon between buyer and supplier. For example, a DUNS number. |
CODETYPE | VARCHAR (32) NOT NULL |
Identification system used to identify an organization between supplier and buyer organizations. For example, DUNS. |
ORGCODE_ID | BIGINT NOT NULL |
Generated primary key. |
ORGENTITY_ID | BIGINT NOT NULL |
Foreign key to ORGENTITY table. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000181 | CODETYPE, CODE | Unique Index |
I0000182 | ORGENTITY_ID, CODETYPE | Unique Index |
SQL030416035025160 | ORGCODE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_553 | ORGENTITY_ID | ORGENTITY | ORGENTITY_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|