Customer

Internal ID: customer

Fields

Internal IDTypenlapiSubmitFieldLabelRequiredHelp
accessrole select false Role false
accountnumber text true Account false
altemail email true Alt. E-mail false
altphone phone true Alt. Phone false
autoname checkbox false Auto false
balance currency false Balance false Customer's current accounts receivable balance. This field is returned in an advanced search only. It is not returned when using the CustomerSearchBasic search object. Note that in your advanced search you must set the BodyFieldsOnly flag to false. This field is a read-only field. NetSuite converts the balance of all transactions in foreign currencies to your preferred currency using the exchange rate for the current date.
billaddr1 text false false
billaddr2 text false false
billaddr3 text false false
billcity text false false
billcountry text false false
billpay checkbox false Enable Online Bill Pay false
billstate text false false
billzip text false false
buyingreason select true Buying Reason false
buyingtimeframe select true Buying Time Frame false
campaigncategory select false Campaign Category false
category select true Category false References a value in a user defined list at Setup > Acco...
clickstream text false Clickstream (1st Visit) false
comments textarea true Comments false Enter any other information you wish to track for this customer.
companyname text true Company Name false
consolbalance currency false Consolidated false
consoldaysoverdue integer false Consolidated false
consoldepositbalance currency false Consolidated false
consoloverduebalance currency false Consolidated false
consolunbilledorders currency false Consolidated false
contact select false Primary Contact false
creditholdoverride select false Hold false
creditlimit poscurrency false Credit Limit false
currency select true Currency true References a value in a user-defined list at Lists > Acco...
currencyprecision text false Currency Precision false
customform select false Custom Form true
datecreated datetime false Date Created false
daysoverdue integer false Days Overdue false
defaultaddress address false Address false
defaultbankaccount select false Bank Account false
defaultorderpriority float false Default Order Priority false
depositbalance currency false Deposit Balance false
draccount select false Deferred Revenue Reclassification Account false
email email false E-Mail false
emailpreference select true E-Mail Preference false
emailtransactions checkbox true Email false
enddate date true End Date false
entityid text true Customer ID true
entitystatus select true Status true
estimatedbudget currency true Estimated Budget false
externalid text false ExternalId false
fax phone true Fax false Sets the fax number for the customer.
faxtransactions checkbox true Fax false
firstname text false Name false
firstvisit datetime false Date of First Visit false
fxaccount select false Foreign Currency Adjustment Revenue Account false
giveaccess checkbox false Give Access false
globalsubscriptionstatus select false Global Subscription Status false
homephone phone true Home Phone false
image select false Image false References an image file that has already been uploaded t...
isbudgetapproved checkbox true Budget Approved false
isinactive checkbox true Inactive false
isjob text false false
isperson radio true Company false
keywords text false Search Engine Keywords (1st Visit) false This is a read-only field that returns the search engine ...
language select false Language false References a value in the Language system list.
lastmodifieddate datetime false Last Modified Date false
lastname text false false
lastpagevisited text false Last Page Visited false
lastvisit datetime false Date of Last Visit false
leadsource select false Lead Source false
middlename text false false
mobilephone phone false Mobile Phone false
monthlyclosing select true Monthly Closing Date true
negativenumberformat select false Negative Number Format false
numberformat select false Number Format false
openingbalance currency false Opening Balance false
openingbalanceaccount select false Opening Balance Account false
openingbalancedate date false Opening Balance Date false
overduebalance currency false Overdue Balance false
parent select false Child Of false If this customer is subcustomer of another customer or a smaller entity of another customer, select the larger parent customer here. If you select a parent customer in this field, this record will show indented under the parent customer in the Customers list.
partner select false Partner false References a partner record. This value sets the partner responsible for referring this customer. In order to retrieve a list of available values for this field, use the GetSelectValue operation. For more information, see getSelectValue of the Platform Guide.
password password false Password false Sets the password assigned to allow this customer access to NetSuite. As of Version 2014 Release 1, the password must be at least 6 characters long. See the topic NetSuite Password Requirements in the NetSuite Help Center for more information.
password2 password false Confirm Password false Sets the password confirmation field.
phone phone true Phone false
phoneticname text false Furigana false
prefccprocessor select false Pref. CC Processor false
pricelevel select false Price Level false
printoncheckas text false Print on Check As false
printtransactions checkbox true Print false
receivablesaccount select false Default Receivables Account false
referrer text false Referrer (1st Visit) false Read-only field that returns the site that referred the customer to the NetSuite account website.
reminderdays posinteger false Reminder Days false
representingsubsidiary select false Represents Subsidiary false
resalenumber text false Resale Number false
salesgroup select false Choose Team false
salesreadiness select true Sales Readiness false
salesrep select false Sales Rep false
salutation text true Mr./Ms... false Enter the title of this person, such as Mr., Mrs., Ms., Dr., Rev., etc.
sendemail checkbox false Send Notification E-mail false
shipcomplete checkbox false Ship Complete false
shippingcarrier select false Carrier false
shippingitem select true Shipping Item false
stage text false false This is a read only field that references a value in a system list. Possible values include LEAD, PROSPECT or CUSTOMER. This value refers to the stage of customer that is being created and are the values that should be submitted as the internal ID values when performing a search. NetSuite automatically updates the customer stage when certain customer status (entityStatus field) changes occur. For more information, see the section Understanding Customer Stages in the SuiteTalk (Web Services) Records Guide.
startdate date true Start Date false
strength text false Password Strength false
subsidiary select false Subsidiary true Select the subsidiary to associate with this entity or job. You cannot enter transactions for this entity or job unless a subsidiary is assigned. If you select this entity on a transaction, the transaction is associated with this subsidiary. The entity is able to access only information associated with this subsidiary. Note: Once a transaction has posted for the entity or job, you are not able to change the subsidiary selected on the entity or job record.
syncpartnerteams checkbox false Update Transactions false
syncsalesteams checkbox false Update Transactions false
taxable checkbox false Taxable false True indicates that this customer pays sales tax according to the rate defined in the tax Item field. False indicates that this customer does not pay sales tax, but only if Tax Item field is empty.
taxexempt checkbox false PST Exempt false
taxfractionunit select false Tax Rounding Precision false
taxitem select false Tax Item false
taxrounding select false Tax Rounding Method false
terms select false Terms false References a value in a user-defined list at Setup > Accounting > Setup Tasks > Accounting Lists > Term. In order to retrieve a list of available values for this field, use the GetSelectValue operation. For more information, see getSelectValue of the Platform Guide.
territory select false Territory false References a value in a user-defined list at Setup > Sales > Sales Management > Sales Territories. This value sets the sales territory this customer belongs in. In order to retrieve a list of available values for this field, use the GetSelectValue operation. For more information, see getSelectValue of the Platform Guide.
thirdpartyacct text false 3rd Party Billing Account Number false
thirdpartycarrier select false 3rd Party Billing Carrier false
thirdpartycountry select false 3rd Party Billing Country false
thirdpartyzipcode text false 3rd Party Billing Zip false
title text false Job Title false Enter the job title for this person's position at his or her company.
unbilledorders currency false Unbilled Orders false
unsubscribe select false Unsubscribe from Campaigns false
url url true Web Address false Sets the URL associated with the customer.
vatregnumber text false Tax Reg. Number false
visits integer false Number of Visits false This field displays the total number of visits this customer has made to your Web site. A new visit is counted after the customer leaves your site and returns.
weblead text false Web Lead false

Sublists

addressbook - Address

Internal IDTypeLabelRequired
addr1 text Address 1 false
addr2 text Address 2 false
addr3 text false
addressbookaddress summary Edit false
addressee text Addressee false
addressid text false
addrtext address Address false
attention text Attention false
city text City false
country select Country false
defaultbilling checkbox Default Billing false
defaultshipping checkbox Default Shipping false
displaystate text State/Province false
id integer ID false
internalid integer false
isresidential checkbox Residential Address false
label text Label false
override checkbox Override false
phone phone Phone false
state text State/Province false
zip text Zip false

contactroles - Contacts

Internal IDTypeLabelRequired
contact select Contact false
email email Email false
giveaccess checkbox Access false
passwordconfirm password Confirm Password false
role select Role false
sendemail checkbox Notify false
strength text Password Strength false

creditcards - Credit Cards

Internal IDTypeLabelRequired
cardstate select Card State false
ccdefault checkbox Default Credit Card false
ccexpiredate mmyydate Expiration Date false
ccmemo text Memo false
ccname text Cardholder Name false
ccnumber ccnumber Credit Card Number true
customercode text Customer Code false
debitcardissueno text Issue No. false
internalid integer ID false
paymentmethod select Credit Card Type true
statefrom datetime State From false
validfrom ccvalidfrom Valid From / Start Date (MM/YYYY) false

currency - Currencies

Internal IDTypeLabelRequired
balance currency Balance false
consolbalance currency Consolidated false
consoldepositbalance currency Consolidated false
consoloverduebalance currency Consolidated false
consolunbilledorders currency Consolidated false
currency select Currency true
currencyformatsample text Format Sample false
depositbalance currency Deposit Balance false
displaysymbol text Symbol false
overduebalance currency Overdue Balance false
overridecurrencyformat checkbox Override Currency Format false
symbolplacement select Symbol Placement false
unbilledorders currency Unbilled Orders false

download - Downloads

Internal IDTypeLabelRequired
expiration date Expiration Date false
file select Attach File false
licensecode textarea License Code false
remainingdownloads integer Remaining Downloads false

grouppricing - Group Pricing

Internal IDTypeLabelRequired
group select Pricing Group true
level select Price Level true

itempricing - Item Pricing

Internal IDTypeLabelRequired
currency select Currency false
item select Item true
level select Price Level true
price currency2 Unit Price false

partners - Partners

Internal IDTypeLabelRequired
contribution percent Contribution % true
customer text false
id text false
isprimary checkbox Primary false
partner select Partner true
partnerrole select Partner Role false

salesteam - Sales Team

Internal IDTypeLabelRequired
contribution percent Contribution % true
customer text false
employee select Employee true
id text false
isprimary checkbox Primary false
issalesrep text false
salesrole select Sales Role true

subscriptions - Subscriptions

Internal IDTypeLabelRequired
lastmodifieddate datetime Last Modified false
subscribed checkbox Subscribed false
subscription select Subscription false

Tabs

NameLabel
access Access
address Address
custom Custom
financial Financial
general General
info Info
marketing Marketing
qualification Qualification
sales Sales
support Support
workflow Workflow

Search Joins

Join IDJoin DescriptionActual Join Name
billingschedule Billing Schedule Billing Schedule
campaignresponse Campaign Response Campaign
contact Contact Contact
contactprimary Contact (Primary) Contact
job Job Job
leadsource Lead Source Campaign
messages Messages Message
messagesfrom Messages From Message
messagesto Messages To Message
parentcustomer Parent Customer Customer
partner Partner Partner
salesrep Sales Rep Employee
subcustomer Sub Customer Customer
task Task Task
toplevelparent Top Level Parent Customer
websitecategory Web Site Category Presentation Category

Search Filters

Internal IDTypeLabel
accountnumber text Account
address textarea Address
addressee text Addressee
addresslabel text Address Label
addressphone phone Address Phone
attention text Attention
availableoffline checkbox Always Available Offline
balance currency Balance
billaddress textarea Billing Address
boughtamount currency Total Amount Purchased
boughtdate date Purchase Dates
buyingreason select Buying Reason
buyingtimeframe select Buying Time Frame
category select Category
cccustomercode text CC Customer Code
ccdefault checkbox Default Credit Card
ccexpdate date CC Expire Date
ccholdername text Credit Cardholder Name
ccnumber ccnumber Credit Card Number
cctype select Credit Card Type
city text City
classbought multiselect Class
comments textarea Comments
companyname text Company Name
consolbalance currency Consolidated Balance
consoldaysoverdue integer Consolidated Days Overdue
consoldepositbalance currency Consolidated Deposit Balance
consoloverduebalance currency Consolidated Overdue Balance
consolunbilledorders currency Consolidated Unbilled Orders
contact text Contact
contribution integer Contribution %
conversiondate date Conversion Date
country select Country
county text County/State
credithold select Credit Hold
creditholdoverride checkbox Override Credit Hold Off
creditlimit currency Credit Limit
currency select Currency
custstage select Parent Stage
custstatus select Parent Status
dateclosed datetime Date Closed
datecreated datetime Date Created
daysoverdue integer Days Overdue
defaultorderpriority text Default Order Priority
depositbalance currency Deposit Balance
deptbought multiselect Department
draccount select Deferred Revenue Reclassification Account
email text Email
emailpreference select Email Preference
emailtransactions checkbox Email Transactions
enddate date End Date
entityid text Name/ID
entitystatus select Status
estimatedbudget currency Estimated Budget
explicitconversion checkbox Explicit Conversion
externalid select External ID
externalidstring text External ID (Text)
fax phone Fax
faxtransactions checkbox Fax Transactions
firstname text First Name
firstorderdate date Date of First Order
firstsaledate date Date of First Sale
formuladate date Formula (Date)
formulanumeric float Formula (Numeric)
formulatext text Formula (Text)
fxaccount select Foreign Currency Adjustment Revenue Account
fxbalance currency Balance (Foreign Currency)
fxconsolbalance currency Consolidated Balance (Foreign Currency)
fxconsolunbilledorders currency Consolidated Unbilled Orders (Foreign Currency)
fxunbilledorders currency Unbilled Orders (Foreign Currency)
giveaccess checkbox Login Access
globalsubscriptionstatus select Global Subscription Status
group multiselect Group
grouppricinglevel select Group Pricing Level
hasduplicates checkbox Duplicate
image image Image
internalid select Internal ID
internalidnumber integer Internal ID (Number)
isbudgetapproved checkbox Budget Approved
isdefaultbilling checkbox Default Billing Address
isdefaultshipping checkbox Default Shipping Address
isinactive checkbox Inactive
isjob checkbox Is Job
isperson checkbox Is Individual
isreportedlead checkbox Included in Lead Reports
isshipaddress checkbox Residential Address
itempricinglevel select Item Pricing Level
itempricingunitprice currency Item Pricing Unit Price
itemsbought multiselect Items Purchased
itemsordered multiselect Items Ordered
jobenddate date Actual End Date
jobestcost currency Estimated Cost
jobestenddate date Projected End Date
jobestrevenue currency Estimated Revenue
jobpctcomplete integer Percent Complete
jobstartdate date Start Date
jobstatus select Job Status
jobtype select Job Type
language select Language
lastmodifieddate datetime Last Modified
lastname text Last Name
lastorderdate date Date of Last Order
lastsaledate date Date of Last Sale
leaddate datetime Lead Date
leadsource select Lead Source
level select Level
locationbought multiselect Location
manualcredithold checkbox Override Credit Hold On
merchantaccount select Credit Card Processor
middlename text Middle Name
monthlyclosing select Monthly Closing Date
oncredithold checkbox On Credit Hold
onlineformdate date Online Form History - Form Date
onlineformleadsource select Online Form History - Lead Source
onlineformname select Online Form History - Form Name
orderedamount currency Total Amount Ordered
ordereddate date Order Dates
otherrelationships multiselect Other Relationships
overduebalance currency Overdue Balance
parent select Sub of
parentitemsbought multiselect Items or Sub-Items Purchased
parentitemsordered multiselect Items or Sub-Items Ordered
partner select Partner
partnercontribution integer Partner Contribution %
partnerrole select Partner Role
partnerteammember select Partner Team Member
pec text PEC
permission select Permission
phone phone Phone
phoneticname text Phonetic Name
pricelevel select Price Level
pricinggroup select Pricing Group
pricingitem select Pricing Item
printtransactions checkbox Print Transactions
prospectdate datetime Prospect Date
pstexempt checkbox PST Exempt
receivablesaccount select Default Receivables Account
reminderdate date Renewal Reminder Date
representingsubsidiary select Represents Subsidiary
resalenumber text Resale Number
role select Role
salesreadiness select Sales Readiness
salesrep select Sales Rep
salesteammember select Sales Team Member
salesteamrole select Sales Team Role
salutation text Mr./Mrs...
shipaddress textarea Shipping Address
shipcomplete checkbox Ship Complete
shippingcarrier select Shipping Carrier
shippingitem select Shipping Item
stage select Stage
startdate date Start Date
state select State/Province
subsidbought multiselect Subsidiaries Bought
subsidiary select Subsidiary
taxable checkbox Taxable
terms select Terms
territory select Territory
title text Job Title
type select Entity Type
unbilledorders currency Unbilled Orders
url url Web Address
vatregnumber text Tax Number
weblead checkbox Web Lead
zipcode text Zip

Search Columns

Internal IDTypeLabel
accountnumber text Account
address text Address
address1 text Address 1
address2 text Address 2
address3 text Address 3
addressee text Addressee
addressinternalid text Address Internal ID
addresslabel text Address Label
addressphone text Address Phone
altcontact text Alt. Contact
altemail email Alt. Email
altname text Name
altphone phone Office Phone
attention text Attention
availableoffline checkbox Always Available Offline
balance currency Balance
billaddress text Billing Address
billaddress1 text Billing Address 1
billaddress2 text Billing Address 2
billaddress3 text Billing Address 3
billaddressee text Billing Addressee
billattention text Billing Attention
billcity text Billing City
billcountry select Billing Country
billcountrycode text Billing Country Code
billphone text Billing Phone
billstate select Billing State/Province
billzipcode text Billing Zip
buyingreason text Buying Reason
buyingtimeframe text Buying Time Frame
category select Category
cccustomercode text CC Customer Code
ccdefault checkbox Default Credit Card
ccexpdate mmyydate CC Expire Date
ccholdername text Credit Cardholder Name
ccinternalid text Credit Card Internal ID
ccnumber ccnumber Credit Card Number
cctype select Credit Card Type
city text City
comments text Comments
companyname text Company Name
consolbalance currency Consolidated Balance
consoldaysoverdue integer Consolidated Days Overdue
consoldepositbalance currency Consolidated Deposit Balance
consoloverduebalance currency Consolidated Overdue Balance
consolunbilledorders currency Consolidated Unbilled Orders
contact select Primary Contact
contribution percent Contribution %
contributionprimary percent Primary Sales Rep Contribution %
conversiondate date Conversion Date
country select Country
countrycode text Country Code
credithold select Credit Hold
creditholdoverride checkbox Override Credit Hold Off
creditlimit currency Credit Limit
currency select Currency
dateclosed datetime Date Closed
datecreated datetime Date Created
daysoverdue integer Days Overdue
defaultorderpriority text Default Order Priority
depositbalance currency Deposit Balance
draccount text Deferred Revenue Reclassification Account
email email Email
emailpreference select Email Preference
emailtransactions checkbox Email Transactions
enddate date End Date
entityid text Name
entitynumber integer Number
entitystatus select Status
estimatedbudget currency Estimated Budget
explicitconversion checkbox Explicit Conversion
externalid select External ID
fax text Fax
faxtransactions checkbox Fax Transactions
firstname text First Name
firstorderdate date Date of First Order
firstsaledate date Date of First Sale
formulacurrency currency Formula (Currency)
formuladate date Formula (Date)
formuladatetime datetime Formula (Date/Time)
formulanumeric float Formula (Numeric)
formulapercent percent Formula (Percent)
formulatext text Formula (Text)
fxaccount text Foreign Currency Adjustment Revenue Account
fxbalance currency Balance (Foreign Currency)
fxconsolbalance currency Consolidated Balance (Foreign Currency)
fxconsolunbilledorders currency Consolidated Unbilled Orders (Foreign Currency)
fxunbilledorders currency Unbilled Orders (Foreign Currency)
giveaccess checkbox Login Access
globalsubscriptionstatus select Global Subscription Status
grouppricinglevel text Group Pricing Level
hasduplicates checkbox Duplicate
homephone phone Home Phone
image select Image
internalid select Internal ID
isbudgetapproved checkbox Budget Approved
isdefaultbilling checkbox Default Billing Address
isdefaultshipping checkbox Default Shipping Address
isinactive checkbox Inactive
isperson checkbox Is Individual
isshipaddress checkbox Residential Address
itempricinglevel text Item Pricing Level
itempricingunitprice currency Item Pricing Unit Price
jobenddate date Job Actual End
jobprojectedend date Job Projected End
jobstartdate date Job Start
jobtype select Job Type
language select Language
lastmodifieddate datetime Last Modified
lastname text Last Name
lastorderdate date Date of Last Order
lastsaledate date Date of Last Sale
lastviewed datetime Last Viewed
leaddate datetime Lead Date
leadsource select Lead Source
level select Level
manualcredithold checkbox Override Credit Hold On
middlename text Middle Name
mobilephone phone Mobile Phone
monthlyclosing select Monthly Closing Date
oncredithold checkbox On Credit Hold
onlineformdate text Online Form History - Date
onlineformleadsource text Online Form History - Lead Source
onlineformname text Online Form History - Form Name
overduebalance currency Overdue Balance
parent select Top Level Parent
partner select Partner
partnercontribution percent Partner Contribution %
partnerrole text Partner Role
partnerteammember select Partner Team Member
pec text PEC
permission select Permission
phone phone Phone
phoneticname text Phonetic Name
prefccprocessor select Credit Card Processor
pricelevel select Price Level
pricinggroup text Pricing Group
pricingitem text Pricing Item
printtransactions checkbox Print Transactions
prospectdate datetime Prospect Date
receivablesaccount text Default Receivables Account
reminderdays integer Reminder Days
representingsubsidiary select Represents Subsidiary
resalenumber text Resale Number
role text Role
salesreadiness text Sales Readiness
salesrep select Sales Rep
salesteammember select Sales Team Member
salesteamrole select Sales Team Role
salutation text Mr./Mrs...
shipaddress text Shipping Address
shipaddress1 text Shipping Address 1
shipaddress2 text Shipping Address 2
shipaddress3 text Shipping Address 3
shipaddressee text Shipping Addressee
shipattention text Shipping Attention
shipcity text Shipping City
shipcomplete checkbox Ship Complete
shipcountry select Shipping Country
shipcountrycode text Shipping Country Code
shipphone text Shipping Phone
shippingcarrier select Shipping Carrier
shippingitem select Shipping Item
shipstate text Shipping State/Province
shipzip text Shipping Zip
stage select Stage
startdate date Start Date
state select State/Province
statedisplayname select State/Province Display Name
subscription select Subscription
subscriptiondate datetime Subscription Date
subscriptionstatus checkbox Subscription Status
subsidiary select Subsidiary
subsidiarynohierarchy select Subsidiary (no hierarchy)
taxable checkbox Taxable
taxitem select Tax Item
terms select Terms
territory select Territory
title text Job Title
type select Type
unbilledorders currency Unbilled Orders
url text Web Address
vatregnumber text Tax Number
weblead checkbox Web Lead
zipcode text Zip Code

Transform Types

Target Record TypeField Defaults
cashsalecustomform,billdate
customerpaymentcustomform
estimatecustomform
invoicecustomform,billdate
opportunitycustomform
salesordercustomform