Rules and Guidelines for NetSuite Objects
Consider the following rules and guidelines for NetSuite objects used as sources, targets, and lookups in data synchronization tasks:
- •Informatica Cloud supports NetSuite Entity fields, Item fields, CRM fields, Transaction Body/Column/Item fields, and other custom fields. Item Number data is not supported.
- •NetSuite does not support multiple filters on a field. If you configure multiple filters for a field, Informatica Cloud uses the last-defined filter for the field.
- •You cannot perform a NetSuite search on customized fields that reference another record.
- •Filters for NetSuite Multi-Select and Standard Record custom fields are not supported.
- •You cannot use advanced data filters for NetSuite sources in data synchronization tasks.
- •You cannot use parameters defined in a parameter file in data filters for NetSuite sources in data synchronization tasks.
- •You can remove mapped source fields from a NetSuite source. The data synchronization task will not fail as a result.
- •The WSDL version 2014_2 does not include the isBookSpecific column for new book account objects. Consequently, you cannot see the isBookSpecific column with connections that use WSDL version 2014_2.
- •NetSuite returns both the date and time using the following format for all date or time data types: yyyy-mm-ddThh:mm:ss <AM/PM>. For the TimeOfDay data type, the date defaults to 1970-01-01.
- •Field metadata information such as primary key or not-null does not display in Informatica Cloud.