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:

NameTypeDescription
ORGCODE_IDBIGINT NOT NULLGenerated primary key.
ORGENTITY_IDBIGINT NOT NULLForeign key to ORGENTITY table.
CODETYPEVARCHAR (32) NOT NULLIdentification system used to identify an organization between supplier and buyer organizations. For example, DUNS.
CODEVARCHAR (128) NOT NULLThe buyer or supplier code, mutually agreed upon between buyer and supplier. For example, a DUNS number.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORGCODE_IDPrimary Key
I0000181CODETYPE+CODEUnique Index
I0000182ORGENTITY_ID+CODETYPEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_553ORGENTITY_IDORGENTITYORGENTITY_IDCascade