Match Detail
Analyze by Dates:
- Create Date
- Distribution Date
- Invoice Date
- Match Update Date
- Purchase Order Date
| Measure | Source and/or calculation |
|---|---|
| PID Accrued Tax Amount | AccruedTaxAmount |
| PID Chargeback Match Amount | (MatchedQuantity * MatchUnitCost) of related chargeback record |
| PID Chargeback Match Unit Cost |
MatchUnitCost of related cost adjustment chargeback record |
| PID Contract Cost | IF Contract is populated on related PO Line THEN PurchaseOrderLine.EnteredUnitCost |
| PID Contract Line Base Cost | BaseCost |
| PID Discount Rate | DiscountRate |
| PID Entered Quantity | EnteredQuantity |
| PID Entered Unit Cost | EnteredUnitCost |
| PID Entered UOM Multiplier | EnteredUOMMultiplier |
| PID Extended Match Amount | MatchedQuantity * MatchUnitCost |
| PID Invoice Extended Amount | EnteredQuantity * EnteredUnitCost |
| PID Invoiced Tax Amount | InvoicedTaxAmount |
| PID Late Receipt Duration | IF PO receipt was released after the invoice was created THEN days between Invoice.CreateDate and ReceiptLine.UpdateDate |
| PID Match Cost Variance |
IF Suffix <> (111,888,999) THEN For Purchase Order Match Invoices: IF ItemType <> Service OR ServiceCode = Quantity THEN IF MatchUnitCost <> POLineAttributes.EnteredUnitCost THEN (MatchedQuantity * MatchUnitCost) - (MatchedQuantity * POLineAttributes.EnteredUnit- Cost) For Service Contract Invoices: IF ServiceCode = Quantity THEN IF MatchUnitCost <> ContractLine.MatchBaseCost THEN (MatchedQuantity * MatchUnitCost) - (MatchedQuantity * ContractLine.MatchBaseCost) |
| PID Match Cost Variance Percent |
IF Suffix <> (111,888,999) THEN For Purchase Order Match Invoices: IF ItemType <> Service OR ServiceCode = Quantity THEN IF MatchUnitCost <> POLineAttributes.EnteredUnitCost THEN ((MatchedQuantity * MatchUnitCost) - (MatchedQuantity * POLineAttributes.EnteredUnit- Cost)) / (MatchedQuantity * POLineAttributes.Entere- dUnitCost) For Service Contract Invoices: IF ServiceCode = Quantity THEN IF MatchUnitCost <> ContractLine.MatchBaseCost THEN ((MatchedQuantity * MatchUnitCost) - (MatchedQuantity * ContractLine.MatchBaseCost)) / (MatchedQuantity * ContractLine.MatchBaseCost) |
| PID Match Total Cost | MatchedQuantity * MatchUnitCost |
| PID Match Unit Cost | MatchUnitCost |
| PID Matched Quantity | MatchedQuantity |
| PID Net Match Amount | (MatchedQuantity * MatchUnitCost) of detail records + any related chargeback |
| PID Net Match Cost Variance | Match Cost Variance of detail records + related cost adjustment chargeback |
| PID Net Match Cost Variance Percent | Match Cost Variance Percent of detail records + related cost adjustment chargeback |
| PID Net Match Unit Cost | MatchUnitCost of detail records + related cost adjustment chargeback |
| PID No Contract Line Count |
Count IF ContractKey = NULL AND CostCode <> Punchout AND ItemOnContract = false |
| PID No Contract Quantity |
IF ContractKey = NULL AND CostCode <> Punchout AND ItemOnContract = false THEN EnteredQuantity |
| PID No Contract Value |
IF ContractKey = NULL AND CostCode <> Punchout AND ItemOnContract = false THEN EnteredQuantity * EnteredUnitCost |
| PID Off Contract Line Count | Count IF ContractKey = NULL AND CostCode <> Punchout AND ItemOnContract = true |
| PID Off Contract Quantity |
IF ContractKey = NULL AND CostCode <> Punchout AND ItemOnContract = true THEN EnteredQuantity |
| PID Off Contract Value |
IF ContractKey = NULL AND CostCode <> Punchout AND ItemOnContract = true THEN EnteredQuantity * EnteredUnitCost |
| PID On Contract Line Count | Count IF ContractKey <> NULL OR CostCode = Punchout |
| PID On Contract Quantity | IF ContractKey <> NULL OR CostCode = Punchout THEN EnteredQuantity |
| PID On Contract Value | IF ContractKey <> NULL OR CostCode = Punchout THEN EnteredQuantity * EnteredUnitCost |
| PID Payables Invoice Detail Cost | PayablesInvoiceDetail record count |
| PID Tax Amount | TaxAmount |
| PID Taxable Unit Cost | TaxableUnitCost |
| PID Total Base Amount | TotalBaseAmount |
| PID Total Contract Matched Cost | MatchedQuantity * ContractLine.DerivedMatchBaseCost |
| PID Total Distribution Amount | TotalDistributionAmount |
| PID Total PO Matched Cost | MatchedQuantity * PurchaseOrderLine.EnteredUnitCost |
| PID Vendor Buy UOM Multiplier | VendorBuyUOMMultiplier |
| PID Vendor Price UOM Multiplier | VendorPriceUOMMultiplier |