Standard Lists on T-Types refer to a List on a T-Type that is not custom. The list can be determined as Custom if it can’t be found defined in Custom List, Records, or Segments. Additionally, the name will be recognizable as a NetSuite entity such as Customer, Contact, Vendor, Item etc.
You can create data augmentations for standard lists by using the Data Augmentation tool in a two-step approach—first using the tool to create a dimension for the standard list and then using the tool again to extend the T-Type, setting the custom field to a dimension. Please see below for detailed steps and tips :
Tips:
· Only create the Dimension once. It can be shared with multiple extensions.
· Repeat the extension for each T-Type required.
· All Standard lists display only one field such as item.itemid or Customer.entityid.
· Body and Line fields are defined here:
NetSuite -> Customizations -> Lists, Records & Fields, either Transaction Body Fields or Transaction Line
· Take a note of the Label, ID, and the name of the Standard List the field is based on (ie. Item)
DA Step 1 – Create a Custom Dimension Data Augmentation for the Standard List
1. Use either Source Table Type = Customer Provided (entire UMD) or System Provided (NSAW Stage table).
2. In Dim Data Augmentation, select standard list (in the example select/add itemid
3. Set primary key
4. Save and schedule your data augmentation
DA Step 2 – Create T-Type Extension – referencing the Standard List
1. Extend Entity on the Body or Line
2. Add the Custom Field
3. Set “Treat As” to Dimension
4. Link the extension back to the actual entity
5. Link to the Dimension / Standard List
6. Save and schedule your data augmentation
