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