Customer

Namespace: urn:relationships.lists.webservices.netsuite.com

Fields

NameTypeCardinalityLabelRequiredHelp
accessRole RecordRef 0..1 Role F References a value in a user-defined list at Setup > Users/Roles > Manage Roles. This value sets the role assigned to this customer. To retrieve a list of available values for this field, use the GetSelectValue operation. For more information, see getSelectValue of the Platform Guide.
accountNumber string 0..1 Account F Assigned account number for this customer. Required when ...
addressbookList CustomerAddressbookList 0..1
aging double 0..1 Current F The overdue A/R balance is shown here with the balance totals for each aging period.
aging1 double 0..1 1-30 Days F The overdue A/R balance is shown here.
aging2 double 0..1 31-60 Days F The overdue A/R balance is shown here.
aging3 double 0..1 61-90 Days F The overdue A/R balance is shown here.
aging4 double 0..1 Over 90 Days F The overdue A/R balance is shown here.
alcoholRecipientType AlcoholRecipientType 0..1 Alcohol Recipient Type F FedEx requires that all packages containing alcohol are declared with the intended recipient type on the shipping note. This preference sets the default type for this customer.
altEmail string 0..1 Alt. Email F Enter an alternative email address for this person.
altName string 0..1 Customer F This is the name of this person or company.
altPhone string 0..1 Alt. Phone F Phone numbers can be entered in the following formats: 99...
assignedWebSite RecordRef 0..1 Assigned Web Site F Use this list to select the web site where you want to assign access to a customer account. The customer will be restricted to using the customer account associated with the web site you select here. If you leave this field blank, then the customer has access to all your web sites. If you use OneWorld, customers have access to all web sites under the same subsidiary.
balance double 0..1 Balance F 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.
billPay boolean 0..1 Enable Online Bill Pay F When enabled, the companyName, phone, accountNumber field...
buyingReason RecordRef 0..1 Buying Reason F Choose the prospect or customer's reason for buying from your company. You can create additional options for this field at Setup > Sales > CRM Lists.
buyingTimeFrame RecordRef 0..1 Buying Time Frame F Select the time frame for the prospect or customer to purchase. You can create additional options for this field at Setup > Sales > CRM Lists.
campaignCategory RecordRef 0..1 Campaign Category F References a value in a user defined list at Setup > Marketing > Campaign Categories. 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.
category RecordRef 0..1 Category F References a value in a user defined list at Setup > Acco...
clickStream string 0..1 Click-Stream (1st Visit) F Read-only field that returns the click stream for this customer on first visit.
comments string 0..1 Comments F Enter any other information you wish to track for this customer.
companyName string 0..1 Company Name F The name of the customer. Required when billPay is enable...
consolAging double 0..1 Consolidated Current F The overdue consolidated A/R balance is shown here with the balance totals for each aging period. These totals include the balance from all the customers and subcustomers in this hierarchy.
consolAging1 double 0..1 1-30 Days F The overdue consolidated A/R balance is shown here with the balance totals for each aging period. These totals include the balance from all the customers and subcustomers in this hierarchy.
consolAging2 double 0..1 31-60 Days F The overdue consolidated A/R balance is shown here with the balance totals for each aging period. These totals include the balance from all the customers and subcustomers in this hierarchy.
consolAging3 double 0..1 61-90 Days F The overdue consolidated A/R balance is shown here with the balance totals for each aging period. These totals include the balance from all the customers and subcustomers in this hierarchy.
consolAging4 double 0..1 Over 90 Days F The overdue consolidated A/R balance is shown here with the balance totals for each aging period. These totals include the balance from all the customers and subcustomers in this hierarchy.
consolBalance double 0..1 Consolidated F The current accounts receivable balance due for the customer-subcustomer hierarchy this customer is a part of is shown here.
consolDaysOverdue long 0..1 Consolidated F This field shows the number of days overdue the consolidated overdue balance is.
consolDepositBalance double 0..1 Consolidated F This field displays the total amount of unapplied deposits for the customer-subcustomer hierarchy this customer is a member of. Deposits are recorded in the general ledger, as a liability, when the customer makes an advance payment before delivery of goods or services. A deposit balance exists until the goods or services are delivered. Deposits do not affect the customer's accounts receivable balance.
consolOverdueBalance double 0..1 Consolidated F This field shows the consolidated total owed for open transactions for this customer-subcustomer hierarchy that are past their due date based on the invoice terms. Note: For open transactions that do not have a due date, the transaction date is used as the due date to calculate this total.
consolUnbilledOrders double 0..1 Consolidated F This field displays the total amount of orders that have been entered but not yet billed for the customer-subcustomer hierarchy this customer is a part of. If you have enabled the preference Customer Credit Limit Includes Orders, then this total is included in credit limit calculations. Set this preference at Setup > Accounting > Preferences > Accounting Preferences > General.
contactRolesList ContactAccessRolesList 0..1
contribPct string 0..1 Contribution Percentage F
creditCardsList CustomerCreditCardsList 0..1
creditHoldOverride CustomerCreditHoldOverride 0..1 Credit Hold F This is a read-only field. Possible values include _auto, _on, and _off.
creditLimit double 0..1 Credit Limit F A credit limit for this customer. If set, and depending on preferences, a warning is generated when this customer's limit is exceeded during a transaction addition.
currency RecordRef 0..1 Currency T References a value in a user-defined list at Lists > Acco...
currencyList CustomerCurrencyList 0..1 Currencies F
customFieldList CustomFieldList 0..1
customForm RecordRef 0..1 Custom Form F References an existing custom form for this record type. ...
dateCreated dateTime 0..1 Date Created F When adding a record, this field defaults to the current system date and time. This field cannot be overwritten. Note: In search, this field respects search criteria down to the second.
daysOverdue long 0..1 Days F The number of days overdue this balance is overdue is shown here.
defaultAddress string 0..1 Default Address F Read-only field that returns the default Billing address ...
defaultAllocationStrategy RecordRef 0..1 Default Allocation Strategy F This field indicates the default allocation strategy that this entity uses.
defaultOrderPriority double 0..1 Default Order Priority F Enter a number to designate the priority for this customer.
defaultTaxReg RecordRef 0..1 Default Tax Reg. Number F Select the default tax registration number for this entity.
depositBalance double 0..1 Deposit Balance F 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
displaySymbol string 0..1 Currency Symbol F Enter a currency symbol and text to use for this currency. Include spaces if you want to separate the symbol from the currency value. For example, $ USD or $CAD. Use the Symbol Placement field to select where the symbol appears.
downloadList CustomerDownloadList 0..1
drAccount RecordRef 0..1 Deferred Revenue Reclassification Account F Select the deferred revenue account to use by default to post revenue reclassification amounts generated by revenue reclassification journal entries for this customer. You can override this account on a sales order for this customer.
email string 0..1 Email F Sets the email address for the customer. If giveAccess is...
emailPreference EmailPreference 0..1 Email Preference F Reference to a value in a system list. Values: _PDF, _HTM...
emailTransactions boolean 0..1 Email Transactions F Set a preferred transaction delivery method for this customer. Choose to send transactions by regular mail, by email, by fax, or by a combination of the three. Then, when you select the customer on a transaction, their preferred delivery method is marked by default. * Email – Check this box to check the To Be Emailed box by default on transactions when this customer is selected. * Print – Check this box to check the To Be Printed box by default on transactions when this customer is selected. * Fax – Check this box to check the To Be Faxed box by default on transactions when this customer is selected. Once you enter these settings on the customer record, these boxes are checked by default for transactions created from the customer record or for transactions that are copied or converted. Note: These settings override any customized settings on transaction forms you use. There are also preferences to set default values for new customer records at Setup > Company > Preferences > Printing, Fax,& Email Preferences. On the Print subtab, Fax subtab, or Email subtab, check Customers Default to [Print/Fax/Email] Transactions. You can also set these fields using the Mass Update function. Go to Lists > Mass Updates > Mass Updates > General and click Customer.
endDate dateTime 0..1 End Date F Projected end date for this customer (used in the case of...
entityId string 0..1 Entity ID T The name of the customer record. Required on add and upda...
entityStatus RecordRef 0..1 Status F Select the status of this customer or potential customer. A lead status creates a lead record. A prospect status creates a prospect record. A customer status creates a customer record. If this is a job record, select the status of this job's progress: Awarded, Not Awarded, Closed, In Progress or Pending.
estimatedBudget double 0..1 Estimated Budget F Enter the estimated budget the prospect or customer has for this opportunity.
fax string 0..1 Fax F Sets the fax number for the customer.
faxTransactions boolean 0..1 Fax Transactions F Set a preferred transaction delivery method for this customer. Choose to send transactions by regular mail, by email, by fax, or by a combination of the three. Then, when you select the customer on a transaction, their preferred delivery method is marked by default. * Email – Check this box to check the To Be Emailed box by default on transactions when this customer is selected. * Print – Check this box to check the To Be Printed box by default on transactions when this customer is selected. * Fax – Check this box to check the To Be Faxed box by default on transactions when this customer is selected. Once you enter these settings on the customer record, these boxes are checked by default for transactions created from the customer record or for transactions that are copied or converted. Note: These settings override any customized settings on transaction forms you use. There are also preferences to set default values for new customer records at Setup > Company > Preferences > Printing, Fax,& Email Preferences. On the Print subtab, Fax subtab, or Email subtab, check Customers Default to [Print/Fax/Email] Transactions. You can also set these fields using the Mass Update function. Go to Lists > Mass Updates > Mass Updates > General and click Customer.
firstName string 0..1 First Name F Required when the isPerson field is set as TRUE designati...
firstVisit dateTime 0..1 First Visit F Read-only field that returns the date the customer first ...
fxAccount RecordRef 0..1 Foreign Currency Adjustment Revenue Account F Select the revenue account to use by default to post foreign currency adjustments that result when exchange rates are different for billing and revenue postings for this customer. You must select an income account. You can override this account on a sales order for this customer.
giveAccess boolean 0..1 Login Access F Enables access to your NetSuite account for the customer.
globalSubscriptionStatus GlobalSubscriptionStatus 0..1 Global Subscription Status F Email recipients can have one of four subscription statuses: * Confirmed Opt-In - When an email recipient has indicated that they want to receive your campaign and bulk merge email, they are assigned this subscription status. Only a recipient can set his or her subscription status to Confirmed Opt-In. * Soft Opt-In - Recipients with this status can receive opt-in messages that enable them to confirm whether or not they want to receive your email campaigns as well as bulk email. You can set a recipient’s status to Soft Opt-In manually or through a mass update. * Soft Opt-Out - Recipients with this status cannot receive campaign or bulk email messages but can receive opt-in messages. You can change this subscription status to Soft Opt-In manually or through a mass update. * Confirmed Opt-Out - Only the recipient can set their subscription status to Confirmed Opt-Out. Recipients with this status cannot receive email campaigns, bulk email, or opt-in messages. Recipients with this status can only opt in again through the Customer Center or by clicking the link in an email message they have received prior to opting out.
groupPricingList CustomerGroupPricingList 0..1
homePhone string 0..1 Home Phone F Only settable when isPerson is set to TRUE defining this ...
image RecordRef 0..1 Image F References an image file that has already been uploaded t...
isBudgetApproved boolean 0..1 Budget Approved F Check this box if the customer's budget has been approved.
isInactive boolean 0..1 Inactive F This field is false by default.
isPerson boolean 0..1 Is Individual F By default, this is set to True which specifies the type ...
itemPricingList CustomerItemPricingList 0..1
keywords string 0..1 Search Engine Keywords (1st Visit) F This is a read-only field that returns the search engine ...
language Language 0..1 Language F References a value in the Language system list.
lastModifiedDate dateTime 0..1 Last Modified Date F Returns the date on which the customer record was last modified.
lastName string 0..1 Last Name F Required when the isPerson field is set as TRUE designating this customer as an Individual.
lastPageVisited string 0..1 Last Page Visited F This field displays the last page this customer viewed on his or her most recent visit to your Web site.
lastVisit dateTime 0..1 Last Visit F Read-only field that returns the date the customer first visited the account website.
leadSource RecordRef 0..1 Lead Source F If the Marketing Automation feature is not enabled, references a value in a user-defined list created by going to Setup > Sales > CRM Lists. Sets how this customer was referred to the organization. For details on how to modify this list via Web services, see LeadSource in the Records Guide. (Note: If the Marketing Automation feature is enabled, the lead source list originates from your list of campaigns.) 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.
middleName string 0..1 Middle Name F Returns the customer's middle name or initial, if one is entered on the customer record.
mobilePhone string 0..1 Mobile Phone F Only settable when isPerson is set to TRUE defining this customer as an individual.
monthlyClosing CustomerMonthlyClosing 0..1 Closing Date T
negativeNumberFormat CustomerNegativeNumberFormat 0..1 Negative Number Format F Select the customer’s negative number format preference, if any. The format controls whether the negative number is preceded by the minus sign (-) or is enclosed in parentheses ( ).
numberFormat CustomerNumberFormat 0..1 Number Format F Select the customer’s positive number format preference, if any. The format controls the thousands separator and decimals display.
openingBalance double 0..1 Opening Balance F Enter the opening balance of this customer's account.
openingBalanceAccount RecordRef 0..1 Opening Balance Account F Select the account this opening balance is applied to.
openingBalanceDate dateTime 0..1 Opening Balance Date F Enter the date of the balance entered in the Opening Balance field.
overdueBalance double 0..1 Overdue F 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 overdue balance of all transactions in foreign currencies to your preferred currency using the exchange rate for the current date.
overrideCurrencyFormat boolean 0..1 Override Currency Format F Check this box to customize the currency format.
parent RecordRef 0..1 Parent F If this customer is subcustomer of another customer or a smaller entity of another customer, select the larger parent customer. If you select a parent customer in this field, this record shows indented under the parent customer in the Customers list.
partner RecordRef 0..1 Partner F 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.
partnersList CustomerPartnersList 0..1
password string 0..1 Password F Sets the password assigned to allow this customer access to NetSuite.
password2 string 0..1 Confirm Password F Sets the password confirmation field.
phone string 0..1 Phone F Enter a phone number for your customer. It will appear on the Customer List report.
phoneticName string 0..1 Furigana F Enter the furigana character you want to use to sort this record.
prefCCProcessor RecordRef 0..1 Preferred Payment Processing Profile F References a record at Setup > Company > Credit Card Processors. Sets the credit card processor used to process orders. 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.
priceLevel RecordRef 0..1 Price Level F References a value in a user-defined list at Setup > Accounting > Setup Tasks > Accounting Lists > Price Level. This value sets the price level for selling to 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.
printOnCheckAs string 0..1 Print on Check As F What you enter here prints on the Pay to the Order of line of a check instead of what you entered in the Customer field.
printTransactions boolean 0..1 Print Transactions F Set a preferred transaction delivery method for this customer. Choose to send transactions by regular mail, by email, by fax, or by a combination of the three. Then, when you select the customer on a transaction, their preferred delivery method is marked by default. * Email – Check this box to check the To Be Emailed box by default on transactions when this customer is selected. * Print – Check this box to check the To Be Printed box by default on transactions when this customer is selected. * Fax – Check this box to check the To Be Faxed box by default on transactions when this customer is selected. Once you enter these settings on the customer record, these boxes are checked by default for transactions created from the customer record or for transactions that are copied or converted. Note: These settings override any customized settings on transaction forms you use. There are also preferences to set default values for new customer records at Setup > Company > Preferences > Printing, Fax,& Email Preferences. On the Print subtab, Fax subtab, or Email subtab, check Customers Default to [Print/Fax/Email] Transactions. You can also set these fields using the Mass Update function. Go to Lists > Mass Updates > Mass Updates > General and click Customer.
receivablesAccount RecordRef 0..1 Default Receivables Account F Choose the A/R account to use by default on receivable transactions for this customer. If you select Use System Preference, the account selected at Setup > Accounting > Preferences > Accounting Preferences > Items/Transactions in the Default Receivables Account field is used as this customer's default.
referrer string 0..1 Referrer (1st Visit) F Read-only field that returns the site that referred the customer to the NetSuite account website.
reminderDays long 0..1 Reminder Days F Sets the number of days before the end date that a reminder should be sent for renewing a customer's contract or project.
representingSubsidiary RecordRef 0..1 Represents Subsidiary T Indicates that this entity is an intercompany customer. Select the subsidiary this customer represents as a buyer in intercompany transactions.
requirePwdChange boolean 0..1 Require Password Change On Next Login F
resaleNumber string 0..1 Resale Number F Customer's tax license number for cases where you do not collect sales tax from this customer because the merchandise will be resold.
salesGroup RecordRef 0..1 Choose Team F When team selling is enabled, this references a user defined sales team group at Lists > Relationships > Groups. 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.
salesReadiness RecordRef 0..1 Sales Readiness F Choose how close the prospect or customer is to purchasing. You can create additional options for this field at Setup > Sales > CRM Lists.
salesRep RecordRef 0..1 Sales Rep F References an employee record. 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.
salesTeamList CustomerSalesTeamList 0..1
salutation string 0..1 Mr./Ms... F Enter the title of this person, such as Mr., Mrs., Ms., Dr., Rev., etc.
sendEmail boolean 0..1 Send New Access Notification Email F If true, the customer is automatically sent an email notification when access to NetSuite is provided.
shipComplete boolean 0..1 Ship Complete F Check this box if you only want to ship orders to this customer when they are completely fulfilled.
shippingItem RecordRef 0..1 Shipping Item F References a value in a user-defined list at Lists > Accounting > Shipping Items. This value sets the default shipping method for 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.
sourceWebSite RecordRef 0..1 Source Web Site F This field is read-only. It shows the web site where the customer registered for a customer account.
stage CustomerStage 0..1 F
startDate dateTime 0..1 Start Date F Enter the date this person or company became a customer, lead or prospect. If this person or company has a contract with you, enter the start date of the contract. If you enter an estimate or an opportunity for this customer, this field will be updated with the date of that transaction.
subscriptionsList SubscriptionsList 0..1
subsidiary RecordRef 0..1 Subsidiary F 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.
symbolPlacement CurrencySymbolPlacement 0..1 Symbol Placement F Select whether the symbol appears before or after the number.
syncPartnerTeams boolean 0..1 Update Transactions F Check this box if you want to update this customer's transactions to reflect the changes you make to the partner team.
taxable boolean 0..1 Taxable F 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 boolean 0..1 PST Exempt F
taxItem RecordRef 0..1 Tax Code F References a value in a user-defined list at Setup > Accounting > Taxes > Tax Codes. This value provides the standard tax rate associated with 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.
taxRegistrationList CustomerTaxRegistrationList 0..1
terms RecordRef 0..1 Terms F 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 RecordRef 0..1 Territory F 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 string 0..1 3rd Party Billing Account Number F Enter this customer’s FedEx® or UPS® account number in the 3rd Party Billing Account Number field. This account number is used if you select Consignee Billing on item fulfillments using UPS or select Bill Recipient on item fulfillments using FedEx.
thirdPartyCountry Country 0..1 3rd Party Billing Country F Select the country associated with the customer’s UPS or FedEx account number.
thirdPartyZipcode string 0..1 3rd Party Billing Zip F Enter the zip code associated with the customer’s UPS or FedEx account number.
title string 0..1 Job Title F Enter the job title for this person's position at his or her company.
unbilledOrders double 0..1 Unbilled Orders F This field displays the total amount of orders that have been entered but not yet billed. If you have enabled the preference Customer Credit Limit Includes Orders, then this total is included in credit limit calculations. Set this preference at Setup > Accounting > Preferences > Accounting Preferences > General. If you use the Multiple Currencies feature, the amount in this field is shown in the customer's currency.
url string 0..1 URL F Sets the URL associated with the customer.
vatRegNumber string 0..1 VAT Registration No. F For the UK edition only. Note that this field is not validated when submitted via Web services.
visits long 0..1 Number of Visits F 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 string 0..1 Web Lead F This is a read-only hidden field that defines whether a customer registered via a NetSuite website. It returns a string of either Yes or No.

Attributes

NameType
externalId string
internalId string

Related Searches

Name
CustomerSearch
CustomerSearchAdvanced
CustomerSearchBasic
CustomerSearchRow
CustomerSearchRowBasic