Requisition Line Fact
Source: Requisition Line
Analyze By Date: Creation Date
| Measure | Source |
|---|---|
| Days From Req Approval To PO Creation | Days span between Requisition Approval Date and PO Creation |
| Days From Req Creation To Approval | Days span between Requisition Creation and Requisition Approval |
| Entered UOM Multiplier | EnteredUOMMultiplier |
| Killed Line Count | Distinct Line Count where KilledQuantity = Quantity |
| Killed Quantity | KilledQuantity |
| Killed Value | KilledQuantity * Unit Cost |
| Lines to Sourcing Count | Distinct line count where Sourcing Event Required= Y |
| Lines to Sourcing Value | IF SourcingEventRequired= Y THEN (Quantity) *(UnitCost) |
| No Contract Line Count | Count IF ContractKey = NULL AND CostCode <>Punchout AND ItemOnContract = false |
| No Contract Quantity | IF ContractKey = NULL AND CostCode <> PunchoutAND ItemOnContract = false THEN EnteredQuantity |
| No Contract Value | IF ContractKey = NULL AND CostCode <> PunchoutAND ItemOnContract = false THEN EnteredQuantity* EnteredUnitCost |
| Off Contract Line Count | Count IF ContractKey = NULL AND CostCode <>Punchout AND ItemOnContract = true |
| Off Contract Quantity | IF ContractKey = NULL AND CostCode <> PunchoutAND ItemOnContract = true Then EnteredQuantity |
| Off Contract Value | IF ContractKey = NULL AND CostCode <> PunchoutAND ItemOnContract = true |
| On Contract Line Count | IF ContractKey = NULL AND CostCode <> PunchoutAND ItemOnContract = true |
| On Contract Quantity | IF ContractKey <> NULL OR CostCode = PunchoutTHEN EnteredQuantity |
| On Contract Value | IF ContractKey <> NULL OR CostCode = PunchoutTHEN EnteredQuantity * EnteredUnitCost |
| PCard | UseProcurementCard=True |
| Quantity | Quantity |
| Req Quantity | Quantity |
| Requisition Line Count | Distinct count of RequisitionLine |
| Requisition Line Value | Quantity * UnitCost |
| Return Quantity | ReturnQuantity |
| Return Value | ReturnQuantity * UnitCost |
| Taxable | PurchaseTaxable = 'true' |
| Unit Cost | UnitCost |