Purchase Order Line
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 |