Inventory Management measures
Inventory History
History Analyze by Date: Current
| Measure | Source and/or calculation |
|---|---|
| Adjust In Qty | InventoryUsageHistory.AdjustmentInQuantity13 |
| Adjust Out Cost | InventoryUsageHistory.AdjustmentOutExtendedCost13 |
| Adjust Out Qty | InventoryUsageHistory.AdjustmentOutQuantity13 |
| Issue Cost | InventoryUsageHistory.IssueExtendedCost13 |
| Issue Quantity | InventoryUsageHistory.IssueQuantity13 |
| Net Transactions | [Inventory Usage History.AdjustmentInQuantity13] - ABS(Inventory Usage History.AdjustmentOutQuantity13]) + [Inventory Usage History.SalesQuantity13] - ABS([Inventory Usage History.IssueQuantity13]) + [Inventory Usage History.TransferInQuantity13] - ABS([Inventory Usage History.TransferOutQuantity13]) + [Inventory Usage History.ReceiptQty13] |
| Period Begin Qty | InventoryUsageHistory.PeriodEndQuantity11 |
| Period Close Cost | InventoryUsageHistory.PeriodEndExtendedCost11 |
| Period End Qty | InventoryUsageHistory.PeriodEndQuantity10 |
| Period End Value | [Inventory Usage History.PeriodEndQuantity09] * [Inventory Usage History.PeriodEndExtendedCost09] |
| Period Open Value | [Inventory Usage History.PeriodEndQuantity08] * [Inventory Usage History.PeriodEndExtendedCost08 |
| Receipt Qty | InventoryUsageHistory.ReceiptQty08 |
| Sales Cost | InventoryUsageHistory.SalesExtendedCost08 |
| Sales Quantity | InventoryUsageHistory.SalesQuantity08 |
| Transfer In Qty | InventoryUsageHistory.TransferInQuantity08 |
| Transfer Out Cost | InventoryUsageHistory.TransferOutExtendedCost08 |
| Transfer Out Qty | InventoryUsageHistory.TransferOutQuantity08 |
Inventory Transaction Line
Analyze by Date:
- Load Date
- Transaction Date
- Update Date
| Measure | Source and/or calculation |
|---|---|
| AddOnChargeUnitCost | InventoryTransactionLine.AddOnChargeUnitCost |
| DerivedAfterQuantity | InventoryTransactionLine.DerivedAfterQuantity |
| BaseCost | InventoryTransactionLine.BaseCost |
| DerivedBeforeQuantity | InventoryTransactionLine.DerivedBeforeQuantity |
| CurrentCost | InventoryTransactionLine.CurrentCost |
| OpenQuantity | InventoryTransactionLine.OpenQuantity |
| OriginalQuantity | InventoryTransactionLine.OriginalQuantity |
| Quantity | InventoryTransactionLine.Quantity |
| SecondaryQuantity | InventoryTransactionLine.SecondaryQuantity |
| SecondaryUOMMultiplier | InventoryTransactionLine.SecondaryUOMMultiplier |
| StockOnHandQuantity | InventoryTransactionLine.StockOnHandQuantity |
| UnitPrice | InventoryTransactionLine.UnitPrice |
| TransactionValue | InventoryTransactionLine.TransactionValue |
| UnitCost | InventoryTransactionLine.UnitCost |
Inventory Transaction Line Detail
Analyze by Date:
- Load Date
- Transaction Date
- Update Date
| Measure | Source and/or calculation |
|---|---|
| Quantity | InventoryTransactionLineDetail.Quantity |
| OpenQuantity | InventoryTransactionLineDetail.OpenQuantity |
| OriginalQuantity | InventoryTransactionLineDetail.OriginalQuantity |
| SecondaryQuantity | InventoryTransactionLineDetail.SecondaryQuantity |
| GLTransactionDetailRel.UnitsAmount | InventoryTransactionLineDistribution.GLTransactionDetailRel.UnitsAmount |
| GLTransactionDetailRel.TransactionAmount | InventoryTransactionLineDistribution.GLTransactionDetailRel.TransactionAmount |
Inventory Location Fact
Analyze by Dates: This subject area does not use an analyze by date. It uses the date of the extraction.
| Measure | Source and/or calculation |
|---|---|
| AllocatedQuantity | ItemLocation.AllocatedQuantity |
| AvailableQuantity | ItemLocation.AvailableQuantity |
| AverageAddOnCost | ItemLocation.AverageAddOnCost |
| AverageCost | ItemLocation.AverageCost |
| AverageStockOnHandQuantity | ItemLocation.AverageStockOnHandQuantity |
| BackorderedQuantity | ItemLocation.BackorderedQuantity |
| CountAccuracy | ItemLocation.CountAccuracy |
| CurrentInventoryValue | ItemLocation.CurrentInventoryValue |
| EconomicOrderQuantity | ItemLocation.EconomicOrderQuantity |
| FutureStandardCost | ItemLocation.FutureStandardCost |
| InProcessQuantity | ItemLocation.InProcessQuantity |
| InspectionHoldQuantity | ItemLocation.InspectionHoldQuantity |
| IntransitQuantity | ItemLocation.IntransitQuantity |
|
IF [Item Location.ItemKey] IS NOT NULL THEN [Item Count] = 1 ELSE [Item Count] = NULL END IF |
|
| UniqueID | ItemLocation.UniqueID |
| OnOrderQuantity | ItemLocation.OnOrderQuantity |
| OnOrderValue | ItemLocation.OnOrderValue |
| SecondaryQuantity | ItemLocation.SecondaryQuantity |
| TransactionCount | ItemLocation.TransactionCount |
| TransactionCounter | ItemLocation.TransactionCounter |
| LastIssueCost | ItemLocation.LastIssueCost |
| LastLeadtime | ItemLocation.LastLeadtime |
| LastReceiptCost | ItemLocation.LastReceiptCost |
| LeadtimeDays | ItemLocation.LeadtimeDays |
| MarketPrice | ItemLocation.MarketPrice |
| MaximumOrderQuantity | ItemLocation.MaximumOrderQuantity |
| MaximumRequisitionQuantity | ItemLocation.MaximumRequisitionQuantity |
| MaximumSaleQuantity | ItemLocation.MaximumSaleQuantity |
| MinimumOrderQuantity | ItemLocation.MinimumOrderQuantity |
| MinimumSaleQuantity | ItemLocation.MinimumSaleQuantity |
| MovementRank | ItemLocation.MovementRank |
| OrderMultiple | ItemLocation.OrderMultiple |
| OverheadUnitCost | ItemLocation.OverheadUnitCost |
| PreviousLeadtime | ItemLocation.PreviousLeadtime |
| ReceivingDays | ItemLocation.ReceivingDays |
| ReorderPoint | ItemLocation.ReorderPoint |
| ReorderQuantity | ItemLocation.ReorderQuantity |
| SafetyStock | ItemLocation.SafetyStock |
| StandardCost | ItemLocation.StandardCost |
| StockOnHandQuantity | ItemLocation.StockOnHandQuantity |
| SuggestedReorderPoint | ItemLocation.SuggestedReorderPoint |
| TurnoverRate | ItemLocation.TurnoverRate |
| UnallocatedQuantity | ItemLocation.UnallocatedQuantity |
| WorkInProgressQuantity | ItemLocation.WorkInProgressQuantity |
Item Replenishment Source
| Measure | Source and/or calculation |
|---|---|
| Item Replenishment Priority | ItemReplenishmentSource.ItemReplenishmentPriority |
| Item Replenishment Source Count | ItemReplenishmentSource.ItemReplenishmentSourceCount |