# DW_NS_entity_D

This table contains information about all the entities like Customer, Vendor, Employee, Partner etc.

## Details

Module:

## Key Columns

id

## Columns

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 |  |  |  |  |  |
email | 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

Copyright © 2019, 2025, Oracle and/or its affiliates.