Payables Invoice Detail measures

Measure Source and/or calculation
PID Accrued Tax Amount PayablesInvoiceDetail.AccruedTaxAmount
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 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 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