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 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