Manufacturing Transaction Analytical Record Type

The manufacturing transaction analytical record type combines fields from the transaction and transaction line record types. This record type includes data for transactions that meet the following criteria:

          Transaction type is one of WorkOrd, Build, Unbuild, WOCompl, WOIssue, WOClose
AND
Transaction line ID is 0 

        

This record type is the root record type on the Manufacturing Dataset. To access the record type or the dataset, you must have the Assembly Items feature enabled. Some fields in the record type are also feature dependent, or display values based on custom formula definitions.

For more information about the fields included in the manufacturing transaction analytical record type, see the following table:

Field	Source Record Type	Source Field	Custom formula or feature dependency
Actual Production Start Date	Transaction	Date	N/A
Actual Production End Date	Transaction	Date	N/A
Assembly	Transaction Line	Item	N/A
Bill of Materials	Transaction	Bill of Materials	Displayed only with the Advanced BOM feature enabled
Bill of Materials Revision	Transaction	Bill of Materials Revision	Displayed only with the Advanced BOM feature enabled
Buildable	Transaction Line	Buildable	Displayed only with the Work Orders feature enabled
Built	Transaction Line	Quantity Shipped/Received/Picked Up	CASE WHEN TransactionLINE.QUANTITY IS NULL THEN NULL ELSE TransactionLine.QUANTITY_SHIP_RECV
Class	Transaction Line	Class	Displayed only with the Classes feature enabled
Date	Transaction	Date	N/A
Department	Transaction Line	Department	Displayed only with the Departments feature enabled
End Date	Transaction	End Date	Displayed only with the Manufacturing Routing and Work Center, Demand Planning, or MRP features enabled.
Location	Transaction Line	Location	Displayed only with the Locations feature enabled
Memo	Transaction	Memo	N/A
Posting Period	Transaction	Posting Period	Displayed only with the Accounting Periods feature enabled Note: This field displays no values for work orders.
Quantity	Transaction Line	Quantity	N/A
Reference	Transaction	Document Number	N/A
Routing	Transaction	Manufacturing Routing	Displayed only with the Manufacturing Routing and Work Center feature enabled
Start Date	Transaction	Start Date	Displayed only with the Manufacturing Routing and Work Center OR Demand Planning or MRP features enabled.
Subsidiary	Transaction Line	Subsidiary	Displayed only with NetSuite OneWorld where subsidiaries are defined
Transaction	Transaction	Internal ID	Note: This field displays the Transaction Display Name instead of the internal field ID.
Transaction Type	Transaction	Type	N/A
Units	Transaction Line	Units	Displayed only with the Multiple Units of Measure feature enabled
WIP	Transaction	WIP	Displayed only with the Manufacturing Work In Process feature enabled

Related Topics

Manufacturing Component Analytical Record Type

Manufacturing Analytical Record Types

General Notices