Database Table: ORGENTITY

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

Column Name Column Type Column Description
ADMINFIRSTNAME VARCHAR (128)
NULL
First name of the administrator of this OrgEntity.
ADMINLASTNAME VARCHAR (128)
NULL
Last name of the administrator of this OrgEntity.
ADMINMIDDLENAME VARCHAR (128)
NULL
Middle name of the administrator of this OrgEntity.
BUSINESSCATEGORY VARCHAR (128)
NULL
The business category, which describes the kind of business performed by an OrgEntity.
DESCRIPTION VARCHAR (512)
NULL
A description of the OrgEntity.
DN VARCHAR (1000)
NULL
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.
FIELD1 VARCHAR (64)
NULL
Customizable.
FIELD2 VARCHAR (64)
NULL
Customizable.
FIELD3 VARCHAR (64)
NULL
Customizable.
LEGALID VARCHAR (128)
NULL
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.
MEMBER_ID BIGINT
NULL
This column contains the member ID of the parent OrgEntity for this OrgEntity. This column is deprecated and is provided for backward compatibility only.
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.
ORGENTITYTYPE CHARACTER (3)
NOT NULL
Type of OrgEntity. Valid values are as follows:
O - organization
OU - organization unit
ORGENTITY_ID BIGINT
NOT NULL
Foreign key to MEMBER table for this organization or organization unit.
PREFERREDDELIVERY VARCHAR (1000)
NULL
Preferred delivery method.
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
TAXPAYERID VARCHAR (254)
NULL
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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035025480 ORGENTITY_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_554 MEMBER_ID MEMBER MEMBER_ID Cascade
F_555 ORGENTITY_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1013 ORGENTITY_ID ACPLGPSUBS ORGENTITY_ID Cascade
F_132 ORGENTITY_ID BUSPROF ORG_ID Cascade
F_133 ORGENTITY_ID BUSPROF ORGUNIT_ID Cascade
F_142 ORGENTITY_ID BUYSUPMAP BUYORGUNIT_ID Cascade
F_143 ORGENTITY_ID BUYSUPMAP SUPORG_ID Cascade
F_144 ORGENTITY_ID BUYSUPSEC SUPORG_ID Cascade
F_145 ORGENTITY_ID BUYSUPSEC BUYORG_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