Manufacturing Component Analytical Record Type

The manufacturing component analytical record type combines fields from the transaction, transaction line, and transaction accounting 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 

        

The manufacturing component analytical record type is included in the field list on the Manufacturing Dataset. To access the record type, 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 component analytical record type, see the following table:

Field	Source Record Type	Source Field	Custom formula or feature dependency
Build Variance	Transaction Line	Build Variance	Displayed only with Work Orders feature enabled
Item	Transaction Line	Item	N/A
Line Number	Transaction Line	Line Number	N/A
Quantity	Transaction Line	Quantity	abs(Quantity)//always positive
Quantity Available	N/A - calculated	N/A - Calculated	“CASE transaction.” + TransactionTypeFragment.FieldId.TYPE + “ WHEN ‘WorkOrd’ “ + THEN get_item_avail(componentLine.” + TransactionLineCommonFragment.FieldId.ITEM + “, componentLine.” + LocationSelectFragment.FieldId.LOCATION + “) “ + “ELSE NULL END”
Quantity Back Ordered	Transaction Line	Back Ordered	N/A
Quantity On Hand	N/A - calculated	N/A - calculated	“CASE WHEN transaction.” + TransactionTypeFragment.FieldId.TYPE + “ IN (‘WorkOrd’, ‘Unbuild’) “ + “THEN get_invtitem_onhand(componentLine.” + TransactionLineCommonFragment.FieldId.ITEM + “, nvl(componentLine.” + LocationSelectFragment.FieldId.LOCATION + “, —1)) “ + “ELSE NULL END”
Quantity Used In Build	Transaction line	Quantity Shipped/Received/Picked Up OR Quantity	“CASE WHEN transaction.” + TransactionTypeFragment.FieldId.TYPE + “ = ‘WorkOrd’ “ + “THEN “+ “-sign(nvl(nullif(componentLine.” + TransactionLineQuantityFragment.FieldId.QUANTITY + “, 0), —1))” + “ * “ + “decode(“ + “componentLine.” + TransactionLineCommonFragment.FieldId.ITEM_TYPE + “, ‘Group’,NULL, “ + “nvl2(“ + “accountingLine.” + TransactionAccountingLineAccountFragment.FieldId.ACCOUNT + “, “ + “decode(“ + “componentLine.” + TransactionLineQuantityFragment.FieldId.QUANTITY + “, NULL “, “ + “componentLine.” + TransactionLine.FieldId.QUANTITY_SHIP_RECV + “)” + “, NULL)) “ + “ELSE NULL END”
Units	Transaction Line	Units	Displayed only with Multiple Unit of Measure feature enabled

Related Topics

• Manufacturing Transaction Analytical Record Type
• Manufacturing Analytical Record Types

General Notices