# DW_NS_Contact_D

This table provides contact details for transactions which includes name of the contact, email, telephone number etc. There is one primary contact for each transaction.

## 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 | 128 |  |  | This column is for Oracle Internal use only. |  |
company | NUMBER | 38 | 0 |  |  | DW_NS_entity_D | id
datecreated | TIMESTAMP |  |  |  |  |  |
defaultbillingaddress | NUMBER | 38 | 0 |  |  | DW_NS_EntityAddress_D | nkey
defaultshippingaddress | NUMBER | 38 | 0 |  |  | DW_NS_EntityAddress_D | nkey
email | VARCHAR2 | 512 |  |  |  |  |
entityid | VARCHAR2 | 256 |  |  |  |  |
entitytitle | VARCHAR2 | 512 |  |  |  |  |
firstname | VARCHAR2 | 64 |  |  |  |  |
isinactive | VARCHAR2 | 16 |  |  |  |  |
isprivate | VARCHAR2 | 16 |  |  |  |  |
lastmodifieddate | TIMESTAMP |  |  |  |  |  |
lastname | VARCHAR2 | 64 |  |  |  |  |
phone | VARCHAR2 | 128 |  |  |  |  |
salutation | VARCHAR2 | 32 |  |  |  |  |
supervisor | NUMBER | 38 | 0 |  |  | DW_NS_Contact_D | id
supervisorphone | VARCHAR2 | 128 |  |  |  |  |
title | VARCHAR2 | 256 |  |  |  |  |
altemail | VARCHAR2 | 256 |  |  |  |  |
assistant | NUMBER | 38 | 0 |  |  | DW_NS_Contact_D | id
assistantphone | VARCHAR2 | 128 |  |  |  |  |
fax | VARCHAR2 | 128 |  |  |  |  |
homephone | VARCHAR2 | 128 |  |  |  |  |
mobilephone | VARCHAR2 | 128 |  |  |  |  |
officephone | VARCHAR2 | 128 |  |  |  |  |
middlename | VARCHAR2 | 64 |  |  |  |  |

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