About Data Mappings Table Columns

The available mappings of the selected sync are displayed on the Data Mappings table. Each row on the table is a data mapping. When in Edit mode, you can do the following:

Add or remove mappings - Click Add Row to create a new mapping. To remove mappings, go to the Action column of the row you want to delete, click the three-dots menu, then click Remove.
Update mappings - In the Action column, click the three-dots menu then click update to edit a mapping

Mapping Levels

Mappings can be header-level or line-item level. Use the Mapping Level filter to display only the mapping level you want to view or edit.

For the syncs where mapping level is applicable, see Mapping Level.

Mapping Types

Mappings can either be Default or User-Added. Default mappings can't be edited or deleted.

The following are the available mapping types:

Field-to-field - This is the commonly used mapping where a source field is mapped to a destination field.
Value-to-field - In this type of mapping, a fixed value from the source is assigned to the destination field.

Note:

Translation Mapping and Logic Mapping is currently not supported. If you need create mappings that use Translation or Logic type, contact NetSuite Customer Support.

Source and Destination Fields

For value-to-field mappings and field-to-field mappings, the source values and field types against destination field types can be any of the following:

Destination Field Type	Expected Source Value Format	Supported Source Types
Boolean	True/false.	Boolean
Date	Date value. MM-DD-YYYY.	Date, Date Time
Date Time	Date and time value. MM-DD-YYYY HH:MM:SS.	Date Time, Date
Decimal	Numeric value.	Decimal, String, Double
Double	Numeric value up to 17 digits.	Double, String, Integer
String	Text value.	String, Integer, Boolean, Double, Decimal, Date Time
RecordReference	Used to refer to record internal IDs.	Record Reference, Integer, String

Destination Field Type

Expected Source Value Format

Supported Source Types

Boolean

True/false.

Boolean

Date

Date value. MM-DD-YYYY.

Date, Date Time

Date Time

Date and time value. MM-DD-YYYY HH:MM:SS.

Date Time, Date

Decimal

Numeric value.

Decimal, String, Double

Double

Numeric value up to 17 digits.

Double, String, Integer

String

Text value.

String, Integer, Boolean, Double, Decimal, Date Time

RecordReference

Used to refer to record internal IDs.

Record Reference, Integer, String

Action Column

You can access row-level actions for mappings on the vertical three-dots menu of the Action column.

General Notices