Inventory measures
| Measure name | Table name | Source business class and fields |
|---|---|---|
| Inventory Transaction | ||
| ICTRANS.QUANTITY | ICTRANS | ICT Quantity |
| ICTRANS.UNIT_COST | ICTRANS | ICT Unit Cost |
| TRANSACTION_COUNT | ICTRANS | ICT Trans Count |
| ICT Trans Value | ICTRANS |
Case when ICTRANS.SYSTEM_CD= 'IC' and IC-TRANS.DOC_TYPE = '' then ICTRANS.OPEN_QTY * IC-TRANS.UNIT_COST else ICTRANS.QUANTITY *ICTRANS.UNIT_COST |
| Inventory On Hand | ITEMLOC | ALLOC_QTY |
| Allocated Quantity | ||
| Unallocated Quantity | ITEMLOC | UNALLOC_QTY |
| Average Cost | ITEMLOC | AVERAGE_COST |
| Average Stock On Hand Quantity | ITEMLOC | AVG_SOH_QTY |
| Backordered Quantity | ITEMLOC | BACKORD_QTY |
| Current Inventory Value | ITEMLOC |
CASE WHEN ICCOMPANY.COST_METHOD = 'STD' THEN SOH_QTY * STD_COST WHEN ICCOMPANY.COST_METHOD = 'LIFO' THEN SOH_QTY * LAST_REC_COST WHEN ICCOMPANY.COST_METHOD = 'FIFO' THEN SOH_QTY * LAST_ISS_COST ELSE SOH_QTY * AVERAGE_COST END |
| In Process Quantity | ITEMLOC | IN_PROC_QTY |
| Inspection Hold Quantity | ITEMLOC | HOLD_QTY |
| Intransit Quantity | ITEMLOC | NTRANS_QTY |
| Last Leadtime | ITEMLOC | LAST_LEADTIME |
| Last Receipt Cost | ITEMLOC | LAST_REC_COST |
| Leadtime Days | ITEMLOC | LEADTIME |
| On Order Quantity | ITEMLOC | ONORDER_QTY |
| On Order Value | ITEMLOC |
CASE WHEN ICCOMPANY.COST_METHOD = 'STD' THEN STD_COST * ONORDER_QTY ELSE AVERAGE_COST * ONORDER_QTY END |
| Stock On Hand Quantity | ITEMLOC | SOH_QTY |
| Inventory History | ||
| Adjust In Qty | ICHISTORY | ADJ_IN_QTY |
| Adjust Out Cost | ICHISTORY | ADJ_OUT_COST |
| Adjust Out Qty | ICHISTORY | ADJ_OUT_QTY |
| Average Inventory Value | ICHISTORY | (PER_END_QTY + CLOSE_COST+ BEG_CLOSE_CST + BEG_SOH_QTY )/ 2 |
| Average Stock On Hand Quantity | ICHISTORY | AVG_SOH_QTY |
| Inventory Turn Rate | ICHISTORY | IIF(( [Sum: Issue Quantity] + [Sum: Sales Quantity] + [Sum: Adjust Out Qty] + [Sum: Transfer Out Qty]) <> 0 AND (([Sum: Period Begin Qty] + [Sum: Period End Qty]) / 2) = 0, 0, ( [Sum: Issue Quantity] + [Sum: Sales Quantity] + [Sum: Adjust Out Qty] + [Sum: Transfer Out Qty]) / (([Sum: Period Begin Qty] + [Sum: Period End Qty]) / 2)) |
| Issue Cost | ICHISTORY | ISSUE_COST |
| Issue Quantity | ICHISTORY | ISSUE_QTY |
| Net Transactions | ICHISTORY | ADJ_IN_QTY + ADJ_OUT_QTY + SALES_QTY + TRAN_IN_QTY + TRAN_OUT_QTY + RECEIPT_QTY |
| Period Begin Qty | ICHISTORY | BEG_SOH_QTY |
| Period Close Cost | ICHISTORY | CLOSE_COST |
| Period End Qty | ICHISTORY | PER_END_QTY |
| Period End Value | ICHISTORY | PER_END_QTY + CLOSE_COST |
| Period Open Value | ICHISTORY | BEG_CLOSE_CST + BEG_SOH_QTY |
| Receipt Qty | ICHISTORY | RECEIPT_QTY |
| Sales Cost | ICHISTORY | SALES_COST |
| Sales Quantity | ICHISTORY | SALES_QTY |
| Transfer In Qty | ICHISTORY | TRAN_IN_QTY |
| Transfer Out Cost | ICHISTORY | TRAN_OUT_COST |
| Transfer Out Qty | ICHISTORY | TRAN_OUT_QTY |