1. SCM (Supply Chain Management)
  2. Manufacturing
  3. SuiteAnalytics Manufacturing Workbook
  4. Manufacturing Analytical Record Types
  5. Manufacturing Component Analytical Record Type

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

General Notices