Users define filters for fields in the following locations:

Data Filters
page of the
Synchronization
Task wizard
Query options in a Source transformation in the Mapping Designer
Query options in the
Sources
page of the
Mapping
Task wizard when the source object is parameterized

NetSuite SearchBasic search records contain the field names used for filtering. When a field name in a NetSuite record matches the related field name in the corresponding SearchBasic search record, users can define a filter for the field in tasks. When a field name in a record does not match the related search record field name, users cannot define a filter for the field in tasks.

You can check the NetSuite schema to see if a field name in a NetSuite record matches the related field name in the SearchBasic search record. NetSuite records are represented as schema types in the NetSuite schema. To view NetSuite field names in the NetSuite schema, you can open the appropriate schema definition file (XSD). You can find a list of XSDs in the following location:

https://webservices.netsuite.com/wsdl/v2019_2_0/netsuite.wsdl

For example, a user wants to define a filter for account name. You review the Account record in NetSuite's browser, which is defined in NetSuite's

accounting.xsd

file.

The schema contains the field,

acctName

, as shown in the following sample:

You also see that the corresponding SearchBasic field name in the NetSuite's

common.xsd

file is called

name

, as shown in the following sample:

Because the field name is

acctName

in the Account record and the field name is

name

in the corresponding SearchBasic record, you map the two field names. The following example shows how you map

acctName

to

name

in the connection properties:

Use the same syntax if you resolve the issue in the

RecordToFieldsMap.ini

file.