Entity Name | Entity Type | Entity Attribute Name | Entity Attribute Required | Entity Attribute Is PK | Entity Attribute Is FK | Entity Attribute Domain Name |
---|---|---|---|---|---|---|
AGENT | Dependent | PARTY ID | Yes | Yes | Yes | ID |
AGENT | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
ASSOCIATION | Dependent | PARTY ID | Yes | Yes | Yes | ID |
ASSOCIATION | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
BILL TO CUSTOMER | Dependent | PARTY ID | Yes | Yes | Yes | ID |
BILL TO CUSTOMER | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
COMPETITOR | Dependent | PARTY ID | Yes | Yes | Yes | ID |
COMPETITOR | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
CONTACT | Dependent | PARTY ID | Yes | Yes | Yes | ID |
CONTACT | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
CONTRACTOR | Dependent | PARTY ID | Yes | Yes | Yes | ID |
CONTRACTOR | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
CUSTOMER | Dependent | PARTY ID | Yes | Yes | Yes | ID |
CUSTOMER | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
CUSTOMER RELATIONSHIP | Dependent | PARTY ID FROM | Yes | Yes | Yes | ID |
CUSTOMER RELATIONSHIP | Dependent | PARTY ID TO | Yes | Yes | Yes | ID |
CUSTOMER RELATIONSHIP | Dependent | FROM DATE | Yes | Yes | Yes | Datetime |
CUSTOMER RELATIONSHIP | Dependent | ROLE TYPE ID FROM | Yes | Yes | Yes | ID |
CUSTOMER RELATIONSHIP | Dependent | ROLE TYPE ID TO | Yes | Yes | Yes | ID |
DEPARTMENT | Dependent | PARTY ID | Yes | Yes | Yes | ID |
DEPARTMENT | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
DISTRIBUTION CHANNEL | Dependent | PARTY ID | Yes | Yes | Yes | ID |
DISTRIBUTION CHANNEL | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
DISTRIBUTION CHANNEL RELATIONSHIP | Dependent | PARTY ID TO | Yes | Yes | Yes | ID |
DISTRIBUTION CHANNEL RELATIONSHIP | Dependent | PARTY ID FROM | Yes | Yes | Yes | ID |
DISTRIBUTION CHANNEL RELATIONSHIP | Dependent | FROM DATE | Yes | Yes | Yes | Datetime |
DISTRIBUTION CHANNEL RELATIONSHIP | Dependent | ROLE TYPE ID FROM | Yes | Yes | Yes | ID |
DISTRIBUTION CHANNEL RELATIONSHIP | Dependent | ROLE TYPE ID TO | Yes | Yes | Yes | ID |
DISTRIBUTOR | Dependent | PARTY ID | Yes | Yes | Yes | ID |
DISTRIBUTOR | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
DIVISION | Dependent | PARTY ID | Yes | Yes | Yes | ID |
DIVISION | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
EMPLOYEE | Dependent | PARTY ID | Yes | Yes | Yes | ID |
EMPLOYEE | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
EMPLOYMENT | Dependent | PARTY ID FROM | Yes | Yes | Yes | ID |
EMPLOYMENT | Dependent | PARTY ID TO | Yes | Yes | Yes | ID |
EMPLOYMENT | Dependent | FROM DATE | Yes | Yes | Yes | Datetime |
EMPLOYMENT | Dependent | ROLE TYPE ID TO | Yes | Yes | Yes | ID |
EMPLOYMENT | Dependent | ROLE TYPE ID FROM | Yes | Yes | Yes | ID |
EMPLOYMENT | Dependent | TERMINATION REASON ID | No | No | Yes | ID |
EMPLOYMENT | Dependent | TERMINATION TYPE ID | No | No | Yes | ID |
END USER CUSTOMER | Dependent | PARTY ID | Yes | Yes | Yes | ID |
END USER CUSTOMER | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
FAMILY MEMBER | Dependent | PARTY ID | Yes | Yes | Yes | ID |
FAMILY MEMBER | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
HOUSEHOLD | Dependent | PARTY ID | Yes | Yes | Yes | ID |
HOUSEHOLD | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
INTERNAL ORGANIZATION | Dependent | PARTY ID | Yes | Yes | Yes | ID |
INTERNAL ORGANIZATION | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
ORGANIZATION | Dependent | PARTY ID | Yes | Yes | Yes | ID |
ORGANIZATION | Dependent | NAME | Yes | No | No | Name |
ORGANIZATION CONTACT RELATIONSHIP | Dependent | PARTY ID FROM | Yes | Yes | Yes | ID |
ORGANIZATION CONTACT RELATIONSHIP | Dependent | PARTY ID TO | Yes | Yes | Yes | ID |
ORGANIZATION CONTACT RELATIONSHIP | Dependent | FROM DATE | Yes | Yes | Yes | Datetime |
ORGANIZATION CONTACT RELATIONSHIP | Dependent | ROLE TYPE ID TO | Yes | Yes | Yes | ID |
ORGANIZATION CONTACT RELATIONSHIP | Dependent | ROLE TYPE ID FROM | Yes | Yes | Yes | ID |
ORGANIZATION ROLE | Dependent | PARTY ID | Yes | Yes | Yes | ID |
ORGANIZATION ROLE | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
ORGANIZATION ROLLUP | Dependent | PARTY ID TO | Yes | Yes | Yes | ID |
ORGANIZATION ROLLUP | Dependent | PARTY ID FROM | Yes | Yes | Yes | ID |
ORGANIZATION ROLLUP | Dependent | FROM DATE | Yes | Yes | Yes | Datetime |
ORGANIZATION ROLLUP | Dependent | ROLE TYPE ID FROM | Yes | Yes | Yes | ID |
ORGANIZATION ROLLUP | Dependent | ROLE TYPE ID TO | Yes | Yes | Yes | ID |
ORGANIZATION UNIT | Dependent | PARTY ID | Yes | Yes | Yes | ID |
ORGANIZATION UNIT | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
OTHER ORGANIZATION UNIT | Dependent | PARTY ID | Yes | Yes | Yes | ID |
OTHER ORGANIZATION UNIT | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
PARENT ORGANIZATION | Dependent | PARTY ID | Yes | Yes | Yes | ID |
PARENT ORGANIZATION | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
PARTNER | Dependent | PARTY ID | Yes | Yes | Yes | ID |
PARTNER | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
PARTNERSHIP | Dependent | PARTY ID TO | Yes | Yes | Yes | ID |
PARTNERSHIP | Dependent | PARTY ID FROM | Yes | Yes | Yes | ID |
PARTNERSHIP | Dependent | FROM DATE | Yes | Yes | Yes | Datetime |
PARTNERSHIP | Dependent | ROLE TYPE ID FROM | Yes | Yes | Yes | ID |
PARTNERSHIP | Dependent | ROLE TYPE ID TO | Yes | Yes | Yes | ID |
PARTY | Independent | PARTY ID | Yes | Yes | No | ID |
PARTY RELATIONSHIP | Dependent | PARTY ID FROM | Yes | Yes | Yes | ID |
PARTY RELATIONSHIP | Dependent | PARTY ID TO | Yes | Yes | Yes | ID |
PARTY RELATIONSHIP | Dependent | FROM DATE | Yes | Yes | No | Datetime |
PARTY RELATIONSHIP | Dependent | ROLE TYPE ID TO | Yes | Yes | Yes | ID |
PARTY RELATIONSHIP | Dependent | ROLE TYPE ID FROM | Yes | Yes | Yes | ID |
PARTY RELATIONSHIP | Dependent | STATUS TYPE ID | Yes | No | Yes | ID |
PARTY RELATIONSHIP | Dependent | PRIORITY TYPE ID | Yes | No | Yes | ID |
PARTY RELATIONSHIP | Dependent | PARTY RELATIONSHIP TYPE ID | Yes | No | Yes | ID |
PARTY RELATIONSHIP | Dependent | THRU DATE | No | No | No | Datetime |
PARTY RELATIONSHIP | Dependent | COMMENTS | No | No | No | Comment |
PARTY RELATIONSHIP TYPE | Independent | PARTY RELATIONSHIP TYPE ID | Yes | Yes | No | ID |
PARTY RELATIONSHIP TYPE | Independent | ROLE TYPE ID VALID TO | Yes | No | Yes | ID |
PARTY RELATIONSHIP TYPE | Independent | ROLE TYPE ID VALID FROM | Yes | No | Yes | ID |
PARTY RELATIONSHIP TYPE | Independent | DESCRIPTION | Yes | No | No | Description |
PARTY RELATIONSHIP TYPE | Independent | NAME | Yes | No | No | Name |
PARTY ROLE | Dependent | PARTY ID | Yes | Yes | Yes | ID |
PARTY ROLE | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
PARTY ROLE | Dependent | PARTY ROLE ID | Yes | No | No | ID |
PARTY ROLE TYPE | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
PERSON | Dependent | PARTY ID | Yes | Yes | Yes | ID |
PERSON | Dependent | CURRENT LAST NAME | No | No | No | Name |
PERSON | Dependent | CURRENT FIRST NAME | No | No | No | Name |
PERSON | Dependent | CURRENT MIDDLE NAME | No | No | No | Name |
PERSON | Dependent | CURRENT PERSONAL TITLE | No | No | No | Name |
PERSON | Dependent | CURRENT SUFFIX | No | No | No | Name |
PERSON | Dependent | CURRENT NICKNAME | No | No | No | Name |
PERSON | Dependent | GENDER | No | No | No | Indicator |
PERSON | Dependent | BIRTH DATE | No | No | No | Datetime |
PERSON | Dependent | HEIGHT | No | No | No | Numeric |
PERSON | Dependent | WEIGHT | No | No | No | Numeric |
PERSON | Dependent | MOTHERS MADIEN NAME | No | No | No | Name |
PERSON | Dependent | MARTIAL STATUS | No | No | No | Indicator |
PERSON | Dependent | SOCIAL SECURITY NUMBER | No | No | No | Numeric |
PERSON | Dependent | CURRENT PASSPORT NUMBER | No | No | No | Numeric |
PERSON | Dependent | CURRENT PASSPORT EXPIRE DATE | No | No | No | Datetime |
PERSON | Dependent | TOTAL YEARS WORK EXPERIENCE | No | No | No | Numeric |
PERSON | Dependent | COMMENTS | No | No | No | Comment |
PERSON ROLE | Dependent | PARTY ID | Yes | Yes | Yes | ID |
PERSON ROLE | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
PROSPECT | Dependent | PARTY ID | Yes | Yes | Yes | ID |
PROSPECT | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
REGULATORY AGENCY | Dependent | PARTY ID | Yes | Yes | Yes | ID |
REGULATORY AGENCY | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
ROLE TYPE | Independent | ROLE TYPE ID | Yes | Yes | No | ID |
ROLE TYPE | Independent | DESCRIPTION | Yes | No | No | Description |
SHAREHOLDER | Dependent | PARTY ID | Yes | Yes | Yes | ID |
SHAREHOLDER | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
SHIP TO CUSTOMER | Dependent | PARTY ID | Yes | Yes | Yes | ID |
SHIP TO CUSTOMER | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
SUBSIDIARY | Dependent | PARTY ID | Yes | Yes | Yes | ID |
SUBSIDIARY | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
SUPPLIER | Dependent | PARTY ID | Yes | Yes | Yes | ID |
SUPPLIER | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
SUPPLIER RELATIONSHIP | Dependent | PARTY ID TO | Yes | Yes | Yes | ID |
SUPPLIER RELATIONSHIP | Dependent | PARTY ID FROM | Yes | Yes | Yes | ID |
SUPPLIER RELATIONSHIP | Dependent | FROM DATE | Yes | Yes | Yes | Datetime |
SUPPLIER RELATIONSHIP | Dependent | ROLE TYPE ID FROM | Yes | Yes | Yes | ID |
SUPPLIER RELATIONSHIP | Dependent | ROLE TYPE ID TO | Yes | Yes | Yes | ID |