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 |