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 | Canceled Line Count = Where CancelQuantity = Quantity |
| 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 |
| Matched Not Received Quantity | MatchedNotReceivedQuantity |
| Quantity | Quantity |
| 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 |