DW_NS_entity_D
This table contains information about all the entities like Customer, Vendor, Employee, Partner etc.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | |||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. | ||||
| altemail | VARCHAR2 | 256 | |||||
| altname | VARCHAR2 | 999 | |||||
| altphone | VARCHAR2 | 128 | |||||
| comments | VARCHAR2 | 999 | |||||
| contact | NUMBER | 38 | 0 | DW_NS_Contact_D | id | ||
| customer | NUMBER | 38 | 0 | DW_NS_customer_D | id | ||
| datecreated | TIMESTAMP | ||||||
| VARCHAR2 | 512 | ||||||
| employee | NUMBER | 38 | 0 | DW_NS_employee_D | id | ||
| entityid | VARCHAR2 | 256 | |||||
| entitynumber | NUMBER | 38 | 0 | ||||
| entitytitle | VARCHAR2 | 512 | |||||
| externalid | VARCHAR2 | 512 | |||||
| fax | VARCHAR2 | 128 | |||||
| firstname | VARCHAR2 | 64 | |||||
| homephone | VARCHAR2 | 128 | |||||
| isinactive | VARCHAR2 | 16 | |||||
| isperson | VARCHAR2 | 16 | |||||
| lastmodifieddate | TIMESTAMP | ||||||
| lastname | VARCHAR2 | 64 | |||||
| middlename | VARCHAR2 | 64 | |||||
| mobilephone | VARCHAR2 | 128 | |||||
| parent | NUMBER | 38 | 0 | DW_NS_entity_D | id | ||
| phone | VARCHAR2 | 128 | |||||
| salutation | VARCHAR2 | 32 | |||||
| title | VARCHAR2 | 256 | |||||
| toplevelparent | NUMBER | 38 | 0 | DW_NS_entity_D | id | ||
| type | VARCHAR2 | 999 | |||||
| vendor | NUMBER | 38 | 0 | DW_NS_vendor_D | id | ||
| partner | NUMBER | 38 | 0 | DW_NS_Partner_D | id | ||
| project | NUMBER | 38 | 0 | DW_NS_job_D | id | ||
| entity_group | NUMBER | 38 | 0 | DW_NS_entityGroup_D | id | ||
| is_contact | VARCHAR2 | 16 | |||||
| is_customer | VARCHAR2 | 16 | |||||
| is_employee | VARCHAR2 | 16 | |||||
| is_project | VARCHAR2 | 16 | |||||
| is_partner | VARCHAR2 | 16 | |||||
| is_vendor | VARCHAR2 | 16 | |||||
| is_entity_group | VARCHAR2 | 16 | |||||
| is_generic_resource | VARCHAR2 | 16 | |||||
| generic_resource | NUMBER | 38 | 0 | DW_NS_GenericResource_D | id |