Customer

Customer records allow you to track all the following types of information about your customers in one place, depending on the features you have enabled.

For help working with this record in the user interface, see Customers.

The internal ID for this record is customer.

See the SuiteScript Records Browser for all internal IDs associated with this record.

Note:

For information about using the SuiteScript Records Browser, see Working with the SuiteScript Records Browser in the NetSuite Help Center.

For information about scripting with this record in SuiteScript, see the following:

Supported Script Types

The customer record is scriptable in both client and server SuiteScript.

Note:

The customer center role does not support scripting capabilities. You must log into a valid account role to write and deploy SuiteScripts.

Supported Functions

The customer record is fully scriptable — it can be created, updated, copied, deleted, and searched using SuiteScript. It can also be transformed.

Usage Notes

Notes on Scripting Customer Fields

The following table provides usage notes for specific fields on this record.

Field Internal ID

Field UI Label

Note

Body Fields

datecreated

Date Created

This is a system-generated field that marks the date the record was created in NetSuite. You cannot change or override this field.

Tip: If you need to capture “date created” information that is not related to the date the record was created in NetSuite, create a custom field and set it to auto-default to today's date.

password

Password

To prevent users from accessing sensitive information such as password and credit card data, this field cannot be read in beforeSubmit user event scripts for external role users (for example, shoppers, online form users (anonymous users), customer center).

password2

Confirm Password

To prevent users from accessing sensitive information such as password and credit card data, this field cannot be read in beforeSubmit user event scripts for external role users (for example, shoppers, online form users (anonymous users), customer center).

Search Filters and Search Columns

ccnumber

Credit Card Number

To prevent users from accessing sensitive information such as password and credit card data, this field cannot be read in beforeSubmit user event scripts for external role users (for example, shoppers, online form users (anonymous users), customer center).

The Multi-Partner Management feature must be enabled in your account for the Partners sublist to appear.

The Access / contactroles sublist is included in the customer record on the Access subtab. It is an inline editor subtab. The Access / contract roles sublist is related to the Contact / contactroles sublist. For details, see the contactroles sublist in the SuiteScript Records Browser.

The Time Tracking sublist is included with the customer record. It is an inline editor sublist.

Important:

If any case, task, or event record has more than 9500 time entries in the Time Tracking sublist, all cases include a static list of time entries. These static lists are not accessible to scripting. Attempts to script on Time Tracking sublists that are static lists of time entries will not return accurate results.

Notes on Scripting Customer Sublists

You can update the contactaccessroles sublist to provide Customer Center access to contacts. You can provide access to contacts that already exist in NetSuite and that have already been attached to a customer that already exists in NetSuite. The workflow is as follows: 1) Add customer. 2) Add contacts. 3) Attach contacts to customer. 4) Update customer with contact access information.

The fields in this sublist map to the fields on the Access subtab in the UI. These fields include: a boolean field that indicates whether a contact has access to NetSuite, contact name key field, email address used to log in to NetSuite, password used to log in to NetSuite, NetSuite role (Customer Center), and a boolean field that indicates whether the contact should receive a notification email when access changes are made. If this Notify field is set to true, an email is sent.

Transform Types

In the NetSuite Help Center, see record.transform(options) for examples on how to transform records.

Target Record Type

Target Record Internal ID

Field Defaults

Cash Sale

cashsale

billdate

Customer Payment

customerpayment

 

Quote

estimate

 

Invoice

invoice

billdate

Opportunity

opportunity

 

Sales Order

salesorder

 

Related Topics

Customers
Working with the SuiteScript Records Browser
SuiteScript Supported Records
Entities

General Notices