WebSphere Commerce 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 Description(s):
Column NameColumn TypeDescription
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 Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000181 CODETYPE+CODE Unique Index
I0000182 ORGENTITY_ID+CODETYPE Unique Index
SQL050212031251500 ORGCODE_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_553 ORGENTITY_ID ORGENTITY ORGENTITY_ID Cascade

Feedback