Field Declarations

Before you reference NetSuite or SuiteProjects Pro field names to set filter or field mapping definitions using the advanced mapping and filter notation, you must first declare these fields.

Field declaration statements must:

Use the correct syntax. See Field Declaration Syntax.
Specify the field type. See Field Types Used for Field Declaration.
Specify at least one field name.
Be used between an integration point opening and closing tags if you are using the Advanced Settings text box on the legacy NetSuite integration form in SuiteProjects Pro to set filters and field mapping definitions.

Field Declaration Syntax

Use the following syntax for field declaration statements.

            FIELD_TYPE field_name_1, field_name_2, Field_name_3

Field declaration statements include the field type followed by at least one space or blank line and a comma-separated list of field names.
The field type must be specified using uppercase
The case for NetSuite and SuiteProjects Pro field names must follow the case used in the application. Refer to the NetSuite SOAP schema browser and SuiteProjects Pro Data Dictionary.
The list of field names must not include line breaks. Only commas and spaces can be used.
Field declaration statements do not use opening and closing tags.

Single field declaration example:

            OA_FIELDS project_stage_id

Multiple field declaration example:

            OA_FIELDS address1, address2, address3, city, state, zip

Field Types Used for Field Declaration

The following table lists the different field types used for field declaration and their usage. Note that fields must be declared more than one time if they fall under different field types.

Field type (notation)	Field Type (plain)	Usage
`NS_FIELDS`	NetSuite fields	Used to declare all NetSuite fields, both standard and custom fields.
`NS_CUSTOM_FIELDS`	NetSuite custom fields	Used to declare all NetSuite custom fields. NetSuite custom fields must also be declared using `NS_FIELDS`.
`OA_FIELDS`	SuiteProjects Pro fields	Used to declare all SuiteProjects Pro fields, both standard and custom fields.
`OA_CUSTOM_FIELDS`	SuiteProjects Pro custom fields	Used to declare all SuiteProjects Pro custom fields. SuiteProjects Pro custom fields must also be declared using `OA_FIELDS`.
`OA_FIELDS_INITIAL_ONLY`	SuiteProjects Pro fields for the initial import only	Used to declare SuiteProjects Pro fields for which a value should be set only the first time the record is imported into SuiteProjects Pro (when the SuiteProjects Pro record is created). These SuiteProjects Pro fields must also be declared using `OA_FIELDS`.
`OA_CUSTOM_FIELDS_INITIAL_ONLY`	SuiteProjects Pro custom fields for the initial import only	Used to declare SuiteProjects Pro custom fields for which a value should be set only the first time the record is imported into SuiteProjects Pro (when the SuiteProjects Pro record is created). These SuiteProjects Pro custom fields must also be declared using `OA_FIELDS`, `OA_FIELDS_INITIAL_ONLY` and `OA_CUSTOM_FIELDS`.
`OA_FIELDS_GROUP_BY`	Group by SuiteProjects Pro fields	Important: Supported only in the following mapping groups (integration points) when used in conjunction with the Customer POs (Sales Order) import integration workflow. Invoices (Invoices) export workflow Group by Time ( `INVOICE_LINE_TIME_GROUP_BY`) Group by Other ( `INVOICE_LINE_OTHER_TIME_GROUP_BY`) Group by Fee ( `INVOICE_LINE_FIXED_FEE_GROUP_BY`) Used to declare the SuiteProjects Pro fields used to group charges by when exporting SuiteProjects Pro charges to description line items on NetSuite invoices. All charges with the same values for the declared fields will be grouped and exported as one description line item on the NetSuite invoice. Can be used to declare SuiteProjects Pro charge (`slip`) fields only. Declared fields must also be declared using `OA_FIELDS` and, for custom fields, `OA_CUSTOM_FIELDS`.
`OA_FIELDS_SORT_BY`	Sort by SuiteProjects Pro fields	Important: Supported only in the following mapping groups (integration points) when used in conjunction with the Customer POs (Sales Order) import integration workflow. Invoices (Invoices) export workflow Group by Time ( `INVOICE_LINE_TIME_GROUP_BY`) Group by Other ( `INVOICE_LINE_OTHER_TIME_GROUP_BY`) Group by Fee ( `INVOICE_LINE_FIXED_FEE_GROUP_BY`) Used to declare the SuiteProjects Pro fields used to sort charges by when exporting SuiteProjects Pro charges to description line items on NetSuite invoices. Description line items on the NetSuite invoice will be sorted in ascending order of values for each declared field. Can be used to declare SuiteProjects Pro charge (`slip`) fields and related record type fields only. Use the following format to declare fields from related record types: `table_name.field_name`. For example charge fields include `user_id`, you can use `OA_FIELDS_SORT_BY user.name` to sort by the name of the employees instead of their internal ID. Declared fields, or the foreign key (if the declared field is from a related record type) must also be declared using `OA_FIELDS` and, for custom fields, `OA_CUSTOM_FIELDS`.
`NS_CUSTOM_FIELDS_FROM_SO_INVOICE_HEADER`	—	Note: Supported only in the following mapping group when used in conjunction with the Customer POs (Sales Order) import integration workflow, and with the Initialize invoices from corresponding sales orders when exporting invoices to NetSuite workflow setting enabled. Invoices (Invoices) export workflow Invoice ( `INVOICE_TO_INVOICE`) Used to declare custom fields from header information in NetSuite sales orders that should be set explicitly in the header information of the NetSuite invoice when exporting invoices from SuiteProjects Pro to NetSuite. Should only be used if the default value on the NetSuite sales order can be overridden.
`NS_CUSTOM_FIELDS_FROM_SO_INVOICE_LINE_ITEM`	—	Note: Supported only in the following mapping group when used in conjunction with the Customer POs (Sales Order) import integration workflow, and with the Initialize invoices from corresponding sales orders when exporting invoices to NetSuite workflow setting enabled. Invoices (Invoices) export workflow Invoice Line ( `INVOICE_LINE`) Used to declare custom fields from items lines on NetSuite sales orders that should be set explicitly on the items lines of the NetSuite invoice when exporting invoices from SuiteProjects Pro to NetSuite. Should only be used if the default value on the NetSuite sales order can be overridden.

Field type (notation)

Field Type (plain)

Usage

NS_FIELDS

NetSuite fields

Used to declare all NetSuite fields, both standard and custom fields.

NS_CUSTOM_FIELDS

NetSuite custom fields

Used to declare all NetSuite custom fields. NetSuite custom fields must also be declared using NS_FIELDS.

OA_FIELDS

SuiteProjects Pro fields

Used to declare all SuiteProjects Pro fields, both standard and custom fields.

OA_CUSTOM_FIELDS

SuiteProjects Pro custom fields

Used to declare all SuiteProjects Pro custom fields. SuiteProjects Pro custom fields must also be declared using OA_FIELDS.

OA_FIELDS_INITIAL_ONLY

SuiteProjects Pro fields for the initial import only

Used to declare SuiteProjects Pro fields for which a value should be set only the first time the record is imported into SuiteProjects Pro (when the SuiteProjects Pro record is created). These SuiteProjects Pro fields must also be declared using OA_FIELDS.

OA_CUSTOM_FIELDS_INITIAL_ONLY

SuiteProjects Pro custom fields for the initial import only

Used to declare SuiteProjects Pro custom fields for which a value should be set only the first time the record is imported into SuiteProjects Pro (when the SuiteProjects Pro record is created). These SuiteProjects Pro custom fields must also be declared using OA_FIELDS, OA_FIELDS_INITIAL_ONLY and OA_CUSTOM_FIELDS.

OA_FIELDS_GROUP_BY

Group by SuiteProjects Pro fields

Important:

Supported only in the following mapping groups (integration points) when used in conjunction with the Customer POs (Sales Order) import integration workflow.

Invoices (Invoices) export workflow

Group by Time ( INVOICE_LINE_TIME_GROUP_BY)
Group by Other ( INVOICE_LINE_OTHER_TIME_GROUP_BY)
Group by Fee ( INVOICE_LINE_FIXED_FEE_GROUP_BY)

Used to declare the SuiteProjects Pro fields used to group charges by when exporting SuiteProjects Pro charges to description line items on NetSuite invoices. All charges with the same values for the declared fields will be grouped and exported as one description line item on the NetSuite invoice.

Can be used to declare SuiteProjects Pro charge (slip) fields only.

Declared fields must also be declared using OA_FIELDS and, for custom fields, OA_CUSTOM_FIELDS.

OA_FIELDS_SORT_BY

Sort by SuiteProjects Pro fields

Important:

Supported only in the following mapping groups (integration points) when used in conjunction with the Customer POs (Sales Order) import integration workflow.

Invoices (Invoices) export workflow

Group by Time ( INVOICE_LINE_TIME_GROUP_BY)
Group by Other ( INVOICE_LINE_OTHER_TIME_GROUP_BY)
Group by Fee ( INVOICE_LINE_FIXED_FEE_GROUP_BY)

Used to declare the SuiteProjects Pro fields used to sort charges by when exporting SuiteProjects Pro charges to description line items on NetSuite invoices. Description line items on the NetSuite invoice will be sorted in ascending order of values for each declared field.

Can be used to declare SuiteProjects Pro charge (slip) fields and related record type fields only. Use the following format to declare fields from related record types: table_name.field_name. For example charge fields include user_id, you can use OA_FIELDS_SORT_BY user.name to sort by the name of the employees instead of their internal ID.

Declared fields, or the foreign key (if the declared field is from a related record type) must also be declared using OA_FIELDS and, for custom fields, OA_CUSTOM_FIELDS.

NS_CUSTOM_FIELDS_FROM_SO_INVOICE_HEADER

—

Note:

Supported only in the following mapping group when used in conjunction with the Customer POs (Sales Order) import integration workflow, and with the Initialize invoices from corresponding sales orders when exporting invoices to NetSuite workflow setting enabled.

Invoices (Invoices) export workflow

Invoice ( INVOICE_TO_INVOICE)

Used to declare custom fields from header information in NetSuite sales orders that should be set explicitly in the header information of the NetSuite invoice when exporting invoices from SuiteProjects Pro to NetSuite. Should only be used if the default value on the NetSuite sales order can be overridden.

NS_CUSTOM_FIELDS_FROM_SO_INVOICE_LINE_ITEM

—

Note:

Invoices (Invoices) export workflow

Invoice Line ( INVOICE_LINE)

Used to declare custom fields from items lines on NetSuite sales orders that should be set explicitly on the items lines of the NetSuite invoice when exporting invoices from SuiteProjects Pro to NetSuite. Should only be used if the default value on the NetSuite sales order can be overridden.