Database Table: ORGCODE

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000181 CODETYPE, CODE Unique Index
I0000182 ORGENTITY_ID, CODETYPE Unique Index
SQL030416035025160 ORGCODE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_553 ORGENTITY_ID ORGENTITY ORGENTITY_ID Cascade

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