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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035025480 | ORGENTITY_ID | Primary Key |
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 |
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 |