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. This is source record id column.    
company NUMBER 38 0   Company DW_NS_entity_D id
datecreated TIMESTAMP       Date Created    
defaultbillingaddress NUMBER 38 0   Default Billing Address DW_NS_EntityAddress_D nkey
defaultshippingaddress NUMBER 38 0   Default Shipping Address DW_NS_EntityAddress_D nkey
email VARCHAR2 512     Email    
entityid VARCHAR2 256     Entity ID    
entitytitle VARCHAR2 512     Vendor ID    
firstname VARCHAR2 64     First Name    
isinactive VARCHAR2 16     Inactive    
isprivate VARCHAR2 16     Private    
lastmodifieddate TIMESTAMP       Last Modified    
lastname VARCHAR2 64     Last Name    
phone VARCHAR2 128     Phone    
salutation VARCHAR2 32     Mr./Ms...    
supervisor NUMBER 38 0   Supervisor DW_NS_Contact_D id
supervisorphone VARCHAR2 128     Sup. Phone    
title VARCHAR2 256     Job Title    
altemail VARCHAR2 256     Alternate Email    
assistant NUMBER 38 0   Assistant DW_NS_Contact_D id
assistantphone VARCHAR2 128     Assistant Phone Number    
fax VARCHAR2 128     Fax    
homephone VARCHAR2 128     Homephone    
mobilephone VARCHAR2 128     Mobilephone    
officephone VARCHAR2 128     Officephone    
middlename VARCHAR2 64     Middle Name    

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