WebSphere Commerce database table: ORGENTITY

This table contains information on organizational entities (OrgEntities). An OrgEntity is either an organization or an organization unit.

Column Descriptions
Column Name Column Type Description
ORGENTITY_ID BIGINT NOT NULL Foreign key to MEMBER table for this organization or organization unit.
LEGALID VARCHAR(128) The registered organization identifier, given to the organization (such as assigned by the government). This may be null for an organization unit. This is not the name of the organization, which should be stored in the ORGENTITYNAME table.
ORGENTITYTYPE CHAR(3) NOT NULL Type of OrgEntity. Valid values are as follows:
O = organization
OU = organization unit
ORGENTITYNAME VARCHAR(128) NOT NULL Short name for organization (O) or organization unit (OU). Not null is a requirement since it will be mapped to O or OU which are required attributes in LDAP.
BUSINESSCATEGORY VARCHAR(128) The business category, which describes the kind of business performed by an OrgEntity.
DESCRIPTION VARCHAR(512) A description of the OrgEntity.
ADMINFIRSTNAME VARCHAR(128) First name of the administrator of this OrgEntity.
ADMINLASTNAME VARCHAR(128) Last name of the administrator of this OrgEntity.
ADMINMIDDLENAME VARCHAR(128) Middle name of the administrator of this OrgEntity.
PREFERREDDELIVERY VARCHAR(1000) Preferred delivery method.
FIELD1 VARCHAR(64) Customizable.
FIELD2 VARCHAR(64) Customizable.
TAXPAYERID VARCHAR(254) A string used to identify the OrgEntity for taxation purpose. Addition of this column triggered by Taxware integration, but presumably this column is useful even outside of Taxware.
DN VARCHAR(1000) Distinguished name (DN) of the OrgEntity. If LDAP is used, contains the DN of the OrgEntity in the LDAP server. If database is used as member repository, contains a unique name as defined by the membership hierarchy. DNs for all OrgEntities are unique.
FIELD3 VARCHAR(64) Customizable.
STATUS INTEGER NOT NULL DEFAULT 0 The STATUS column in ORGENTITY table indicates whether or not the organization is locked. Valid values are as follows:
0 = not locked
-1 = locked
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235224360 ORGENTITY_ID Primary Key
I0000970 DN Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_555 ORGENTITY_ID MEMBER MEMBER_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1013 ORGENTITY_ID ACPLGPSUBS ORGENTITY_ID Cascade
F_132 ORG_ID BUSPROF ORGENTITY_ID Cascade
F_133 ORGUNIT_ID BUSPROF ORGENTITY_ID Cascade
F_142 BUYORGUNIT_ID BUYSUPMAP ORGENTITY_ID Cascade
F_143 SUPORG_ID BUYSUPMAP ORGENTITY_ID Cascade
F_144 SUPORG_ID BUYSUPSEC ORGENTITY_ID Cascade
F_145 BUYORG_ID BUYSUPSEC ORGENTITY_ID Cascade
F_1162 AUTHDOMAIN CCOMMENT ORGENTITY_ID Cascade
F_326 ORGENTITY_ID FLOWADMIN ORGENTITY_ID Cascade
F_452 ORGENTITY_ID MBRROLE ORGENTITY_ID Cascade
F_513 ORGENTITY_ID ORDERS ORGENTITY_ID Cascade
F_553 ORGENTITY_ID ORGCODE ORGENTITY_ID Cascade
F_615 ORGENTITY_ID PROCBUYPRF ORGENTITY_ID Cascade
F_617 ORGENTITY_ID PROCMSGVW ORGENTITY_ID Cascade
F_694 ORGENTITY_ID RMA ORGENTITY_ID Cascade
F_1214 ORGENTITY_ID ROLEASNPRM ORGENTITY_ID Cascade
Related reference