Contacts

The Entity Fields custom field is available for the Contacts table.

Columns

Name	Type	Length	Precision	Scale	References	In	Description
address	VARCHAR2	999					Address
altemail	VARCHAR2	254					Alternate email
assistant_id	NUMBER		39	0			Assistant
assistantphone	VARCHAR2	100					Assistant phone
city	VARCHAR2	50					City
comments	VARCHAR2	4000					Comments
company_id	NUMBER		39	0			Company ID
contact_extid	VARCHAR2	255					Contact external ID
contact_id	NUMBER		39	0			Contact ID
country	VARCHAR2	50					Country
create_date	TIMESTAMP						Create date (GMT)
date_last_modified	TIMESTAMP						Date last modified
email	VARCHAR2	254					Email
fax	VARCHAR2	100					Fax
firstname	VARCHAR2	32					First name
full_name	VARCHAR2	1800					Full name
homephone	VARCHAR2	100					Home phone
is_private	VARCHAR2	3					Private
isemailhtml	VARCHAR2	3					Email as HTML
isemailpdf	VARCHAR2	3					Email as PDF
isinactive	VARCHAR2	3					Contact is inactive
last_modified_date	TIMESTAMP						Date last modified
lastname	VARCHAR2	32					Last name
line1	VARCHAR2	150					Address line 1
line2	VARCHAR2	150					Address line 2
line3	VARCHAR2	150					Address line 3
loginaccess	VARCHAR2	3					Whether contact has login access to NetSuite
middlename	VARCHAR2	32					Middle name
mobilephone	VARCHAR2	100					Mobile phone
name	VARCHAR2	83					Name
officephone	VARCHAR2	100					Office phone
phone	VARCHAR2	100					Phone
salutation	VARCHAR2	30					Salutation
state	VARCHAR2	50					State
subsidiary	NUMBER		39	0			Subsidiary
supervisior_id	NUMBER		39	0			Supervisor ID
supervisorphone	VARCHAR2	100					Supervisor phone
title	VARCHAR2	99					Job title
zipcode	VARCHAR2	36					Zip code

Primary key

PK Column Name
contact_id

Foreign keys referencing this table

FK Name	PK Column Name	FK Table Name	FK Column Name	Key Seq
Campaignresponse_contacts_fk	contact_id	Campaignresponse	contact_id	1
Customers_contacts_fk	contact_id	Customers	primary_contact_id	1
Customers_contacts_fk_2	contact_id	Customers	alternate_contact_id	1
Entity_role_map_contacts_fk	contact_id	Entity_role_map	contact_id	1
Support_incidents_contacts_fk	contact_id	Support_incidents	contact_id	1