Customer

customer

Fields

Label ID Type UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
3rd Party Billing Account Number thirdpartyacct text Yes Yes Yes
3rd Party Billing Carrier thirdpartycarrier select Yes Yes Yes
3rd Party Billing Country thirdpartycountry select Yes Yes Yes
3rd Party Billing Zip thirdpartyzipcode text Yes Yes Yes
Account accountnumber text Yes Yes Yes
Address Book addressbook sublist Yes Yes Yes
Alcohol Recipient Type alcoholrecipienttype select Yes Yes Yes
Alt. Email altemail email Yes Yes Yes
Alt. Phone altphone phone Yes Yes Yes
Assigned Web Site assignedwebsite select Yes Yes Yes
Balance balancesearch currency Yes Yes Yes
Billing Rate Card billingratecard select Yes Yes Yes
Billing Schedule billingschedule select Yes Yes Yes
Billing Transaction Form billingtransactionform select Yes Yes Yes
Billing Transaction Type billingtransactiontype select Yes Yes Yes
Budget Approved isbudgetapproved checkbox Yes Yes Yes
Bulk Merge bulkmerge sublist Yes Yes Yes
Buying Reason buyingreason select Yes Yes Yes
Buying Time Frame buyingtimeframe select Yes Yes Yes
Campaign Event campaignevent select Yes Yes Yes
Campaigns campaigns sublist Yes Yes Yes
Carrier shippingcarrier select Yes Yes Yes
Category category select Yes Yes Yes
Click-Stream (1st Visit) clickstream text Yes Yes Yes
Comments comments textarea Yes Yes Yes
Company Name companyname text Yes Yes Yes
Consolidated Balance consolbalancesearch currency Yes Yes Yes
Consolidated Days Overdue consoldaysoverduesearch integer Yes Yes Yes
Consolidated Overdue Balance consoloverduebalancesearch currency Yes Yes Yes
Consolidated Unbilled Orders consolunbilledorderssearch currency Yes Yes Yes
Contacts contactlist multiselect Yes Yes Yes
Contacts contactroles sublist Yes Yes Yes
Credit Cards creditcards sublist Yes Yes Yes
Credit Hold creditholdoverride select Yes Yes Yes
Credit Limit creditlimit poscurrency Yes Yes Yes
Currencies currencylist sublist Yes Yes Yes
Currency currency select Yes Yes Yes
Currency Symbol displaysymbol text Yes Yes Yes
Customer altname text Yes Yes Yes
Customer ID entitytitle text Yes Yes Yes
Date Created datecreated datetime Yes Yes Yes
Default Allocation Strategy defaultallocationstrategy select Yes Yes Yes
Default Bank Account defaultbankaccount select Yes Yes Yes
Default Billing Address defaultbillingaddress select Yes Yes Yes
Default Order Priority defaultorderpriority float Yes Yes Yes
Default Receivables Account receivablesaccount select Yes Yes Yes
Default Shipping Address defaultshippingaddress select Yes Yes Yes
Default Tax Reg. Number defaulttaxreg select Yes Yes Yes
Deferred Revenue Reclassification Account draccount select Yes Yes Yes
Downloads download sublist Yes Yes Yes
Duplicate duplicate checkbox Yes Yes Yes
EFT eftacct sublist Yes Yes Yes
Email email email Yes Yes Yes
Email Preference emailpreference select Yes Yes Yes
Email Transactions emailtransactions checkbox Yes Yes Yes
Enable Online Bill Pay billpay checkbox Yes Yes Yes
End Date enddate date Yes Yes Yes
Entity ID entityid text Yes Yes Yes
Estimated Budget estimatedbudget currency Yes Yes Yes
External ID externalid text Yes Yes Yes
Fax fax phone Yes Yes Yes
Fax Transactions faxtransactions checkbox Yes Yes Yes
First Name firstname text Yes Yes Yes
First Sale Date firstsaledate date Yes Yes Yes
First Sales Order Date firstorderdate date Yes Yes Yes
First Visit firstvisit datetime Yes Yes Yes
Foreign Currency Adjustment Revenue Account fxaccount select Yes Yes Yes
Furigana phoneticname text Yes Yes Yes
Global Subscription Status globalsubscriptionstatus select Yes Yes Yes
Group Invoices groupinvoices checkbox Yes Yes Yes
Group Pricing grouppricing sublist Yes Yes Yes
Home Phone homephone phone Yes Yes Yes
Inactive isinactive checkbox Yes Yes Yes
Internal ID id integer Yes Yes Yes
Is Individual isperson checkbox Yes Yes Yes
Item Pricing itempricing sublist Yes Yes Yes
Job Title title text Yes Yes Yes
Language language select Yes Yes Yes
Last Modified Date lastmodifieddate datetime Yes Yes Yes
Last Name lastname text Yes Yes Yes
Last Page Visited lastpagevisited text Yes Yes Yes
Last Sales Date lastsaledate date Yes Yes Yes
Last Sales Order Date lastorderdate date Yes Yes Yes
Last Visit lastvisit datetime Yes Yes Yes
Lead Source leadsource select Yes Yes Yes
Login Access giveaccess checkbox Yes Yes Yes
Middle Name middlename text Yes Yes Yes
Mobile Phone mobilephone phone Yes Yes Yes
Mr./Ms... salutation text Yes Yes Yes
Negative Number Format negativenumberformat select Yes Yes Yes
Number entitynumber integer Yes Yes Yes
Number Format numberformat select Yes Yes Yes
Number of Visits visits integer Yes Yes Yes
On Credit Hold oncredithold checkbox Yes Yes Yes
Overdue overduebalancesearch currency Yes Yes Yes
Override Currency Format overridecurrencyformat checkbox Yes Yes Yes
Parent parent select Yes Yes Yes
Partner partner select Yes Yes Yes
Partners partners sublist Yes Yes Yes
Payment Instrument paymentoption select Yes Yes Yes
Payment Instruments paymentinstruments sublist Yes Yes Yes
Phone phone phone Yes Yes Yes
Preferred Payment Processing Profile prefccprocessor select Yes Yes Yes
Price Level pricelevel select Yes Yes Yes
Primary Contact contact select Yes Yes Yes
Print on Check As printoncheckas text Yes Yes Yes
Print Transactions printtransactions checkbox Yes Yes Yes
Probability probability percent Yes Yes Yes
Referrer (1st Visit) referrer text Yes Yes Yes
Reminder Days reminderdays posinteger Yes Yes Yes
Represents Subsidiary representingsubsidiary select Yes Yes Yes
Resale Number resalenumber text Yes Yes Yes
Sales Readiness salesreadiness select Yes Yes Yes
Sales Rep salesrep select Yes Yes Yes
Sales Team salesteam sublist Yes Yes Yes
Ship Complete shipcomplete checkbox Yes Yes Yes
Shipping Item shippingitem select Yes Yes Yes
Source Web Site sourcewebsite select Yes Yes Yes
Stage searchstage text Yes Yes Yes
Start Date startdate date Yes Yes Yes
Status entitystatus select Yes Yes Yes
Subscription Message History subscriptionmessagehistory sublist Yes Yes Yes
Subscriptions subscriptions sublist Yes Yes Yes
Symbol Placement symbolplacement select Yes Yes Yes
Tax Registrations taxregistration sublist Yes Yes Yes
Terms terms select Yes Yes Yes
Territory territory select Yes Yes Yes
Unbilled Orders unbilledorderssearch currency Yes Yes Yes
Upsell upsell sublist Yes Yes Yes
URL url url Yes Yes Yes
Web Lead weblead checkbox Yes Yes Yes

Joins

Join Target Record UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Address to Address (customerAddressbookEntityAddress.nkey) address (customeraddressbook, customeraddressbook.addressbookaddress) No Yes Yes
File to Downloads (CustomerDownload.file) file (file, file.id) No Yes Yes
Tax Registrations to Address (customerAddressbook.internalid) tax registrations (customertaxregistration, customertaxregistration.address) No Yes Yes
Tax Registrations to Nexus (Nexus.id) tax registrations (customertaxregistration, customertaxregistration.nexus) No Yes Yes
Customer to Role (role.id) customer (customer, customer.accessrole) No Yes Yes
Address to Customer (customer.id) address (customeraddressbook, customeraddressbook.entity) No Yes Yes
Bulk Merge to Customer (customer.id) bulk merge (customerbulkmerge, customerbulkmerge.entity) No Yes Yes
Customer to Campaign Category (campaignCategory.id) customer (customer, customer.campaigncategory) No Yes Yes
Campaigns to Customer (customer.id) campaigns (customercampaigns, customercampaigns.entity) No Yes Yes
Customer to Contact (Contact.id) customer (customer, customer.contact) No Yes Yes
Customer to Currency (currency.id) customer (customer, customer.currency) No Yes Yes
Customer to Order Allocation Strategy (orderAllocationStrategy.id) customer (customer, customer.defaultallocationstrategy) No Yes Yes
Customer to Address (EntityAddress.nkey) customer (customer, customer.defaultbillingaddress) No Yes Yes
Downloads to Customer (customer.id) downloads (customerdownload, customerdownload.customer) No Yes Yes
EFT to Customer (customer.id) eft (customereftacct, customereftacct.customer) No Yes Yes
Customer to Email Preference Type (EmailPreferenceType.id) customer (customer, customer.emailpreference) Yes Yes Yes
Customer to Account (account.id) customer (customer, customer.openingbalanceaccount) No Yes Yes
Customer to Customer (customer.id) customer (customer, customer.parent) No Yes Yes
Customer to Partner (Partner.id) customer (customer, customer.partner) No Yes Yes
Partners to Customer (customer.id) partners (customerpartner, customerpartner.customer) No Yes Yes
Customer to Price Level (priceLevel.id) customer (customer, customer.pricelevel) No Yes Yes
Customer to Subsidiary (subsidiary.id) customer (customer, customer.representingsubsidiary) No Yes Yes
Customer to Group (entityGroup.id) customer (customer, customer.salesgroup) No Yes Yes
Sales Team to Customer (customer.id) sales team (customersalesteam, customersalesteam.customer) No Yes Yes
Subscription Message History to Customer (customer.id) subscription message history (customersubscriptionmessagehistory, customersubscriptionmessagehistory.recipient) No Yes Yes
Subscription to Customer (customer.id) subscription (customersubscriptions, customersubscriptions.entity) No Yes Yes
Customer to Symbol Placement (CurrencySymbolPlacement.key) customer (customer, customer.symbolplacement) Yes Yes Yes
Tax Registrations to Customer (customer.id) tax registrations (customertaxregistration, customertaxregistration.entity) No Yes Yes
Upsell to Customer (customer.id) upsell (upsellitem, upsellitem.customer) No Yes Yes