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 Descriptions Column Name Column 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 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000181 CODETYPE+CODE Unique Index I0000182 ORGENTITY_ID+CODETYPE Unique Index SQL060903235224210 ORGCODE_ID Primary Key Related reference
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_553 ORGENTITY_ID ORGENTITY ORGENTITY_ID Cascade