Payables Invoice Detail measures

Analyze by Dates:
  • Distribution Date
  • Invoice Date
  • Match Update Date
  • Purchase Order Date
Measure Source and/or calculation
PID Accrued Tax Amount PayablesInvoiceDetail.AccruedTaxAmount
PID Chargeback Match Amount Match amount of chargeback record if it exists
PID Chargeback Match Unit Cost Match unit cost of chargeback record if it exists
PID Contract Cost Contract entered unit cost if related purchase order line has contract populated
PID Contract Line Base Cost PayablesInvoiceDetail.BaseCost
PID Discount Rate PayablesInvoiceDetail.DiscountRate
PID Entered Quantity PayablesInvoiceDetail.EnteredQuantity
PID Entered Unit Cost PayablesInvoiceDetail.EnteredUnitCost
PID Entered UOM Multiplier PayablesInvoiceDetail.EnteredUOMMultiplier
PID Extended Match Amount Matched Quantity * Match Unit Cost
PID Invoice Extended Amount Entered Quantity * Entered Unit Cost
PID Invoiced Tax Amount PayablesInvoiceDetail.InvoicedTaxAmount
PID Match Cost Variance 
IF Purchase Order <> 0 AND Item Type <> Service OR Servece Code = Quantity THEN (Matched Quantity * Match Unit Cost) - (Matched Quantity * PO Line Attributes.Entered Unit Cost) OR IF Purchase Order <> 0 AND Item Type <> Service OR Servece Code = Quantity AND Suffix = 111 THEN Matched Quantity * Match Unit Cost OR IF Purchase Order = 0 AND Item Type <> Service OR Servece Code = Quantity THEN (Matched Quantity * Match Unit Cost) - (Matched Quantity * Contract Line.Match Base Cost) OR IF Purchase Order = 0 AND Item Type <> Service OR Servece Code = Quantity AND Suffix = 111 THEN Matched Quantity * Match Unit Cost
PID Match Cost Variance Percent 
IF Purchase Order <> 0 AND Item Type <> Service OR Servece Code = Quantity THEN ((Matched Quantity * Match Unit Cost) - (Matched Quantity * PO Line Attributes.Entered Unit Cost)) / (Matched Quantity * PO Line Attributes.Entered Unit Cost) OR IF Purchase Order <> 0 AND Item Type <> Service OR Servece Code = Quantity AND Suffix = 111 THEN Matched (Quantity * Match Unit Cost) / (Matched Quantity * PO Line Attributes.Entered Unit Cost) OR IF Purchase Order = 0 AND Item Type <> Service OR Servece Code = Quantity THEN ((Matched Quantity * Match Unit Cost) - (Matched Quantity * Contract Line.Match Base Cost)) / (Matched Quantity * Contract Line.Match Base Cost) OR IF Purchase Order = 0 AND Item Type <> Service OR Servece Code = Quantity AND Suffix = 111 THEN Matched (Quantity * Match Unit Cost) / (Matched Quantity * Contract Line.Match Base Cost)
PID Match Total Cost Matched Quantity * Match Unit Cost
PID Match Unit Cost PayablesInvoiceDetail.MatchUnitCost
PID Matched Quantity PayablesInvoiceDetail.MatchedQuantity
PID Net Match Amount Net match amount if detail record has a related chargeback else current match amount
PID Net Match Unit Cost Net match unit cost if detail record has a related chargeback else current match unit cost
PID No Contract Line Count 
COUNT IF ContractKey IS NULL AND Cost Code <> Punchout AND Item On Contract <> Yes
PID No Contract Quantity 
IF ContractKey IS NULL AND Cost Code <> Punchout AND Item On Contract <> Yes THEN Entered Quantity
PID No Contract Value 
IF ContractKey IS NULL AND Cost Code <> Punchout AND Item On Contract <> Yes THEN Entered Unit Cost * Entered Quantity
PID Off Contract Line Count 
COUNT IF ContractKey IS NULL AND Cost Code <> Punchout AND Item On Contract = Yes
PID Off Contract Quantity 
IF ContractKey IS NULL AND Cost Code <> Punchout AND Item On Contract = Yes THEN Entered Quantity
PID Off Contract Value 
IF ContractKey IS NULL AND Cost Code <> Punchout AND Item On Contract = Yes THEN Entered Unit Cost * Entered Quantity
PID On Contract Line Count 
COUNT IF ContractKey IS NULL AND Cost Code = Punchout OR COUNT IF ContractKey IS NOT NULL
PID On Contract Quantity 
IF ContractKey IS NULL AND Cost Code = Punchout THEN Entered Quantity OR IF ContractKey IS NOT NULL THEN Entered Quantity
PID On Contract Value 
IF ContractKey IS NULL AND Cost Code = Punchout THEN Entered Unit Cost * Entered Quantity OR IF ContractKey IS NOT NULL THEN Entered Unit Cost * Entered Quantity
PID Payables Invoice Detail Cost PayablesInvoiceDetail record count
PID Tax Amount PayablesInvoiceDetail.TaxAmount
PID Taxable Unit Cost PayablesInvoiceDetail.TaxableUnitCost
PID Total Base Amount PayablesInvoiceDetail.TotalBaseAmount
PID Total Distribution Amount PayablesInvoiceDetail.TotalDistributionAmount
PID Vendor Buy UOM Multiplier PayablesInvoiceDetail.VendorBuyUOMMultiplier
PID Vendor Price UOM Multiplier PayablesInvoiceDetail.VendorPriceUOMMultiplier