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


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

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