Purchase Order Line

Purchase Order Line Fact

Source: Purchase Order Line

Analyze By Date: Purchase Order Date

Measure Source and/or calculation
Archived Quantity ArchivedQuantity
Cancel Quantity CancelQuantity
Canceled Line Count
Entered Unit Cost EnteredUnitCost
Entered Unit Cost Per Stock UOM EnteredUnitCostPerStockUOM
Extended Receipt Value ExtendedReceiptValue
Extended Rejected Value ExtendedRejectedValue
Invoiced PO Line Count InvoicedPOLineCount
Landed Unit Cost LandedUnitCost
Lines Not Shipped Complete LinesNotShippedComplete
Lines Shipped Complete LinesShippedComplete
Matched Amount MatchedAmount
Matched Line Value Matched Quantity * Entered Unit Cost
Matched PO Line Count Matched Quantity < (Quantity Cancel Quantity)
Matched Quantity MatchedQuantity
Matched Quantity In Stock UOM MatchedQuantityInStockUOM
Matched Unit Cost MatchedUnitCost
No Contract Line Count Count IF ContractKey = NULL AND CostCode <> Punchout AND ItemOnContract = false
No Contract Quantity IF ContractKey = NULL AND CostCode <> Punchout AND ItemOnContract = false THEN EnteredQuantity
No Contract Value IF ContractKey = NULL AND CostCode <> Punchout AND ItemOnContract = false THEN EnteredQuantity
Off Contract Line Count Count IF ContractKey = NULL AND CostCode <> Punchout AND ItemOnContract = true
Off Contract Quantity IF ContractKey = NULL AND CostCode <> Punchout AND ItemOnContract = true THEN EnteredQuantity
Off Contract Value IF ContractKey = NULL AND CostCode <> Punchout AND ItemOnContract = true
On Contract Line Count Count IF ContractKey <> NULL OR CostCode = Pun- chout
On Contract Quantity IF ContractKey <> NULL OR CostCode = Punchout THEN EnteredQuantity
On Contract Value IF ContractKey <> NULL OR CostCode = Punchout THEN EnteredQuantity * EnteredUnitCost
On Order Quantity (Quantity - Cancel Qty - Receipt Qty)
Open Order Quantity (Quantity - Cancel Qty - Receipt Qty)
Open PO Line Count Life Cycle State <> 'Closed'
Open Purchase Amount OpenPurchaseAmount
Open Quantity (Qty - Cancel Qty) and Line <> Closed
Open To Match Qty - (Received Quantity + Matched Quantity +Archived Quantity) * Entered Unit Cost
PLI Matched Not Received Quantity MatchedNotReceivedQuantity
PLI Quantity Quantity
PO Line Count Distinct Count of records
PO Line Extended Amount ExtendedAmount
PO Lines Delivered To Correct Location POLinesDeliveredToCorrectLocation
PO Lines Over Received POLinesOverReceived
PO Lines Received POLinesReceived
PO Lines Unreceived POLinesUnreceived
Quantity In Stock UOM Entered Buy UOM Multiplier * Quantity
Quantity Received On Time Received Quantity where Receiving Activity Date is <= Late Delivery Date
Quantity Shipped Complete Quantity Shipped Complete
Quantity To Process Quantity To Process
Received Late IF PO Receiving Activity Date >= than late delivery date
Received On Time IF Receiving Activity Date is <= to early delivery date
Received Quantity ReceivedQuantity
Rejected Quantity RejectedQuantity
Service Cancel Amount ServiceCancelAmount
Unmatched PO Line Count Line Count Where Matched Quantity < (Quantity - Cancel Quantity)
Unmatched Quantity (Quantity - Matched Quantity - Cancel Quantity)
Write Off Quantity WriteOffQuantity