Best Of

Custom Field on T-Type 

A custom field defined on a transaction type “t-type” such as purchase, sales, opportunity, journal etc. 

NetSuite Definitions are found under: Customization >Lists, Records, & Fields >Transaction Body Fields and Transaction line fields

·      Body Fields names start with custbody_

·      Line Fields names start with custcol_

Steps:

1.     Determine all T-Types relevant to the field

a.     In NetSuite the field will be defined at a higher grouping such as SALES

b.     However, in NSAW it is required to define at the t-type level such as Sales Order, Purchase Order, Item Receipt etc.

2.     Map the field to each relevant T-Type at Transaction (body) or Line level

a.     Custom Attribute Mapper creates an extension table. The custom field is created in the extension table as a column with the same name as the custom field. The extension table joins back to the t-type fact table. Body extensions join with ID. Line extensions join with TRANSACTION AND ID.

Custom List/Record/Segment on T-Type 

Same as above but based on a Custom List/Record/Segment. 

Upon completion the Custom List is visible in the Subject Area in its own folder at the bottom of the model

The Custom List is visible in the Subject Area in its own folder at the bottom of the model.

Custom Field on Entity

Custom Fields assigned to Entities such as Customer, Vendor, Item.

NetSuite Definitions found under: Customization -> Lists, Records, & Fields -> Entity Fields and item Fields

·      Entity Fields star with custentity_

·      Item Fields start with custitem_

Upon completion entity fields are found under the corresponding entity folder

Custom List/Record/Segment on Entity

Same as above but based on a Custom List/Record/Segment. 

Upon completion the field based on the Custom List is visible in respective Entity folder

Customization on Standard Record 

A Standard Record in NetSuite that is neither an entity nor a t-type. Example Classification or Account.

These can be defined in Custom Attributes Mapper, Attribute Type -> Other Record            

Configuring Custom Attributes Mapper

1.     Click Data Configuration on NetSuite Analytics Warehouse Console >Custom Attributes > Create

2.     Select attribute and source

3.     Save and publish

4.     Monitor queue by going into Request History on the NetSuite Analytics Warehouse console