Map Custom Attributes

Import custom attributes for transactions, transaction line, transaction accounting lines, and dimension entities using the Custom Attributes Mapper.

Determine the source attributes in NetSuite you want to import before starting this procedure to simplify the mapping process. For the source transaction types or entities that you want to import, NetSuite Analytics Warehouse displays the business names, IDs, data types, and size of the associated custom attributes.

Note:

Custom attributes that reference other transaction internal IDs aren't supported in the Custom Attributes Mapper. Use the Data Augmentation capability to bring these into NetSuite Analytics Warehouse.

The attributes that you can select have a default limit of 4000 characters for all data types. If the source transaction has unsupported attributes such as attributes with more characters than the default limit, invalid characters, or reserved keywords, the system displays these unsupported attributes indicating why the columns are marked as invalid. If you want to use these unsupported attributes, you must either change them in the data source or request the administrator for support.

1. In NetSuite Analytics Warehouse Console, click Data Configuration.
2. On the Data Configuration page, under Applications, click Custom Attributes Mapper.
3. On the Custom Attribute Map List page, click Create.
4. Select the type of attribute you want to create, and the source transaction type or entity you want to import.
5. Select the attributes you want to associate with the source transaction type.
6. Click Save.
7. Click Publish to make the attribute map available to users.