Purchasing measures

PO Receipt Line Aggregate by PO Line


Measure	Source and/or calculation
PRLA Matched Quantity	SUM([PO Purchase Order Receipt Line.Matched Quantity])
PRLA Open To Match Quantity	SUM([PO Purchase Order Receipt Line.Open To Match Quantity])

Purchase Order Buyer Message


Measure	Source and/or calculation
POM Buyer Message Count	PurchaseOrderBuyerMessage.PurchaseOrderBuyerMessageKey
POM Manual Buyer Message Count	if((BuyerMessageType = 'M'),1,0)
POM Receiving Buyer Message Count	if((BuyerMessageType = 'R'),1,0)
POM Return Quantity	PurchaseOrderBuyerMessage.ReturnQuantity

Purchase Order Fact


Measure	Source and/or calculation
Add On Charge Total	PurchaseOrder.AddOnChargeTotal
Calendar Julian Date	PurchaseOrder.GeneralLedgerCalendarPeriodXrefRel.GeneralLedgerCalendarPeriod
Open PO Count	IF ([PO Purchase Order.Closed] = 'Yes') THEN [Open PO Count] = 0 ELSE [Open PO Count] = 1 END IF
PO Count	PurchaseOrder.TotalOrderAmount
POs Issued EDI	if(IssueMethod = 'E', 1,0)
POs Transmitted Electronically	IF ([PO Purchase Order.Issue Method Code] IN ('E','I','F') OR [PO Purchase Order.Issue Method Code] IS NULL) THEN [POs Transmitted Electronically] = 1 ELSE [POs Transmitted Electronically] = 0 END IF
Receipt Header Count	PurchaseOrder.ReceiptHeaderCount
Total Order Amount	PurchaseOrder.TotalOrderAmount
Total Product Amount	PurchaseOrder.TotalProductAmount
Total Tax Amount	PurchaseOrder.TotalTaxAmount
Total Taxable Amount	PurchaseOrder.TotalTaxableAmount

Purchase Order Line Distribution


Measure	Source and/or calculation
Distribution Percent	PurchaseOrderLineDistribution.DistributionPercent
Distribution Quantity	PurchaseOrderLineDistribution.DistributionQuantity

Purchase Order Line Fact


Measure	Source and/or calculation
Archived Quantity	PurchaseOrderLine.ArchivedQuantity
Cancel Quantity	PurchaseOrderLine.CancelQuantity
Canceled Line Count	IF [Purchase Order Line.Cancel Quantity] = [Purchase Order Line.Quantity] THEN [Canceled Line Count] = 1 ELSE [Canceled Line Count] = 0 END IF
Entered Unit Cost	PurchaseOrderLine.EnteredUnitCost
Entered Unit Cost Per Stock UOM	PurchaseOrderLine.EnteredUnitCostPerStockUOM
Extended Receipt Value	PurchaseOrderLine.ExtendedReceiptValue
Extended Rejected Value	PurchaseOrderLine.ExtendedRejectedValue
Invoiced PO Line Count	PurchaseOrderLine.InvoicedPOLineCount
Landed Unit Cost	PurchaseOrderLine.LandedUnitCost
Lines Not Shipped Complete	PurchaseOrderLine.LinesNotShippedComplete
Lines Shipped Complete	PurchaseOrderLine.LinesShippedComplete
Matched Amount	PurchaseOrderLine.MatchedAmount
Matched Line Value	([Purchase Order Line.Matched Quantity]) * [Purchase Order Line.Entered Unit Cost]
Matched PO Line Count	IF ([Purchase Order Line.Matched Quantity] < ([Purchase Order Line.Quantity] - [Purchase Order Line.Cancel Quantity])) THEN [Unmatched PO Line Count] = 1 ELSE [Unmatched PO Line Count] = 0 END IF
Matched Quantity	PurchaseOrderLine.MatchedQuantity
Matched Quantity In Stock UOM	PurchaseOrderLine.MatchedQuantityInStockUOM
Matched Unit Cost	PurchaseOrderLine.MatchedUnitCost
No Contract Line Count	IF [PO Purchase Order Line.Spend Category Code] = 1 THEN [On Contract Value] = [PO Purchase Order Line.Extended Amount] [On Contract Line Count] = 1 [On Contract Quantity] = [PO Purchase Order Line.Quantity] [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 2 THEN [Off Contract Value] = [PO Purchase Order Line.Extended Amount] [Off Contract Line Count] = 1 [Off Contract Quantity] = [PO Purchase Order Line.Quantity] [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 3 THEN [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = [PO Purchase Order Line.Extended Amount] [No Contract Quantity] = [PO Purchase Order Line.Quantity] [No Contract Line Count] = 1 END IF
No Contract Quantity	IF [PO Purchase Order Line.Spend Category Code] = 1 THEN [On Contract Value] = [PO Purchase Order Line.Extended Amount] [On Contract Line Count] = 1 [On Contract Quantity] = [PO Purchase Order Line.Quantity] [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 2 THEN [Off Contract Value] = [PO Purchase Order Line.Extended Amount] [Off Contract Line Count] = 1 [Off Contract Quantity] = [PO Purchase Order Line.Quantity] [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 3 THEN [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = [PO Purchase Order Line.Extended Amount] [No Contract Quantity] = [PO Purchase Order Line.Quantity] [No Contract Line Count] = 1 END IF
No Contract Value	IF [PO Purchase Order Line.Spend Category Code] = 1 THEN [On Contract Value] = [PO Purchase Order Line.Extended Amount] [On Contract Line Count] = 1 [On Contract Quantity] = [PO Purchase Order Line.Quantity] [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 2 THEN [Off Contract Value] = [PO Purchase Order Line.Extended Amount] [Off Contract Line Count] = 1 [Off Contract Quantity] = [PO Purchase Order Line.Quantity] [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 3 THEN [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = [PO Purchase Order Line.Extended Amount] [No Contract Quantity] = [PO Purchase Order Line.Quantity] [No Contract Line Count] = 1 END IF
Off Contract Line Count	IF [PO Purchase Order Line.Spend Category Code] = 1 THEN [On Contract Value] = [PO Purchase Order Line.Extended Amount] [On Contract Line Count] = 1 [On Contract Quantity] = [PO Purchase Order Line.Quantity] [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 2 THEN [Off Contract Value] = [PO Purchase Order Line.Extended Amount] [Off Contract Line Count] = 1 [Off Contract Quantity] = [PO Purchase Order Line.Quantity] [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 3 THEN [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = [PO Purchase Order Line.Extended Amount] [No Contract Quantity] = [PO Purchase Order Line.Quantity] [No Contract Line Count] = 1 END IF
Off Contract Quantity	IF [PO Purchase Order Line.Spend Category Code] = 1 THEN [On Contract Value] = [PO Purchase Order Line.Extended Amount] [On Contract Line Count] = 1 [On Contract Quantity] = [PO Purchase Order Line.Quantity] [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 2 THEN [Off Contract Value] = [PO Purchase Order Line.Extended Amount] [Off Contract Line Count] = 1 [Off Contract Quantity] = [PO Purchase Order Line.Quantity] [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 3 THEN [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = [PO Purchase Order Line.Extended Amount] [No Contract Quantity] = [PO Purchase Order Line.Quantity] [No Contract Line Count] = 1 END IF
Off Contract Value	IF [PO Purchase Order Line.Spend Category Code] = 1 THEN [On Contract Value] = [PO Purchase Order Line.Extended Amount] [On Contract Line Count] = 1 [On Contract Quantity] = [PO Purchase Order Line.Quantity] [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 2 THEN [Off Contract Value] = [PO Purchase Order Line.Extended Amount] [Off Contract Line Count] = 1 [Off Contract Quantity] = [PO Purchase Order Line.Quantity] [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 3 THEN [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = [PO Purchase Order Line.Extended Amount] [No Contract Quantity] = [PO Purchase Order Line.Quantity] [No Contract Line Count] = 1 END IF
On Contract Line Count	IF [PO Purchase Order Line.Spend Category Code] = 1 THEN [On Contract Value] = [PO Purchase Order Line.Extended Amount] [On Contract Line Count] = 1 [On Contract Quantity] = [PO Purchase Order Line.Quantity] [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 2 THEN [Off Contract Value] = [PO Purchase Order Line.Extended Amount] [Off Contract Line Count] = 1 [Off Contract Quantity] = [PO Purchase Order Line.Quantity] [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 3 THEN [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = [PO Purchase Order Line.Extended Amount] [No Contract Quantity] = [PO Purchase Order Line.Quantity] [No Contract Line Count] = 1 END IF
On Contract Quantity	IF [PO Purchase Order Line.Spend Category Code] = 1 THEN [On Contract Value] = [PO Purchase Order Line.Extended Amount] [On Contract Line Count] = 1 [On Contract Quantity] = [PO Purchase Order Line.Quantity] [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 2 THEN [Off Contract Value] = [PO Purchase Order Line.Extended Amount] [Off Contract Line Count] = 1 [Off Contract Quantity] = [PO Purchase Order Line.Quantity] [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 3 THEN [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = [PO Purchase Order Line.Extended Amount] [No Contract Quantity] = [PO Purchase Order Line.Quantity] [No Contract Line Count] = 1 END IF
On Contract Value	IF [PO Purchase Order Line.Spend Category Code] = 1 THEN [On Contract Value] = [PO Purchase Order Line.Extended Amount] [On Contract Line Count] = 1 [On Contract Quantity] = [PO Purchase Order Line.Quantity] [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 2 THEN [Off Contract Value] = [PO Purchase Order Line.Extended Amount] [Off Contract Line Count] = 1 [Off Contract Quantity] = [PO Purchase Order Line.Quantity] [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 3 THEN [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = [PO Purchase Order Line.Extended Amount] [No Contract Quantity] = [PO Purchase Order Line.Quantity] [No Contract Line Count] = 1 END IF
On Order Quantity	IF [PO Purchase Order Line.Spend Category Code] = 1 THEN [On Contract Value] = [PO Purchase Order Line.Extended Amount] [On Contract Line Count] = 1 [On Contract Quantity] = [PO Purchase Order Line.Quantity] [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 2 THEN [Off Contract Value] = [PO Purchase Order Line.Extended Amount] [Off Contract Line Count] = 1 [Off Contract Quantity] = [PO Purchase Order Line.Quantity] [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 3 THEN [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = [PO Purchase Order Line.Extended Amount] [No Contract Quantity] = [PO Purchase Order Line.Quantity] [No Contract Line Count] = 1 END IF
On Order Value	IF [PO Purchase Order Line.Spend Category Code] = 1 THEN [On Contract Value] = [PO Purchase Order Line.Extended Amount] [On Contract Line Count] = 1 [On Contract Quantity] = [PO Purchase Order Line.Quantity] [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 2 THEN [Off Contract Value] = [PO Purchase Order Line.Extended Amount] [Off Contract Line Count] = 1 [Off Contract Quantity] = [PO Purchase Order Line.Quantity] [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = 0 [No Contract Quantity] = 0 [No Contract Line Count] = 0 ELSEIF [PO Purchase Order Line.Spend Category Code] = 3 THEN [Off Contract Value] = 0 [Off Contract Line Count] = 0 [Off Contract Quantity] = 0 [On Contract Value] = 0 [On Contract Line Count] = 0 [On Contract Quantity] = 0 [No Contract Value] = [PO Purchase Order Line.Extended Amount] [No Contract Quantity] = [PO Purchase Order Line.Quantity] [No Contract Line Count] = 1 END IF
Open Order Quantity	IF [PO Purchase Order Line.Purchase Order Line Life Cycle State] = 'Closed' THEN [Open Order Quantity] = 0 ELSE [Open Order Quantity] = [PO Purchase Order Line.Quantity] END IF
Open PO Line Count	IF [PO Purchase Order Line.Purchase Order Line Life Cycle State] = 'Closed' THEN [Open PO Line Count] = 0 ELSE [Open PO Line Count] = 1 END IF
Open Purchase Amount	PurchaseOrderLine.OpenPurchaseAmount
Open Quantity	[Purchase Order Line.Quantity To Process] - [Purchase Order Line.Received Quantity]
Open To Match	DIM [v_Sum_MAD_MatchQuantity] AS FLOAT = 0.0 DIM [v_Sum_MAD_MatchUnitCost] AS FLOAT = 0.0 DIM [v_Sum_MAD_MatchAmount] AS FLOAT = 0.0 [v_Sum_MAD_MatchQuantity] = IFNULL([Level(Payables Invoice Detail Aggregate by PO Line.Payables Invoice Detail Aggregate by PO Line).Matched Quantity], 0.0) [v_Sum_MAD_MatchUnitCost] = IFNULL([Level(Payables Invoice Detail Aggregate by PO Line.Payables Invoice Detail Aggregate by PO Line).Match Unit Cost], 0.0) [v_Sum_MAD_MatchAmount] = [v_Sum_MAD_MatchQuantity] * [v_Sum_MAD_MatchUnitCost] IF [PO Purchase Order Line.Item Type Code] = 'S' THEN [Open To Match] = ([PO Purchase Order Line.Quantity] * [PO Purchase Order Line.Entered Unit Cost]) - [v_Sum_MAD_MatchAmount] - [PO Purchase Order Line.Service Cancel Amount] ELSE IF ([PO Purchase Order Line.Received Quantity] - [PO Purchase Order Line.Matched Quantity] - [PO Purchase Order Line.Archived Quantity]) < 1 THEN [Open To Match] = 0 ELSE [Open To Match] = ([PO Purchase Order Line.Received Quantity] - [PO Purchase Order Line.Matched Quantity] - [PO Purchase Order Line.Archived Quantity]) * [PO Purchase Order Line.Entered Unit Cost] END IF
PLI Matched Not Received Quantity	PurchaseOrderLine.MatchedNotReceivedQuantity
PLI Quantity	PurchaseOrderLine.Quantity
PO Line Count	PurchaseOrderLine.UniqueID
PO Line Extended Amount	PurchaseOrderLine.ExtendedAmount
PO Lines Delivered To Correct Location	PurchaseOrderLine.POLinesDeliveredToCorrectLocation
PO Lines Over Received	PurchaseOrderLine.POLinesOverReceived
PO Lines Received	PurchaseOrderLine.POLinesReceived
PO Lines Unreceived	PurchaseOrderLine.POLinesUnreceived
Quantity In Stock UOM	IF [PO Purchase Order Line.Entered Buy UOM Multiplier] <> NULL THEN [Quantity In Stock UOM] = [PO Purchase Order Line.Entered Buy UOM Multiplier] * [PO Purchase Order Line.Quantity] ELSE [Quantity In Stock UOM] = 0 END IF
Quantity Received On Time	IF [PO Purchase Order Line.Late Delivery Date] <> NULL AND [PO Purchase Order Line.Receiving Activity Date] <> NULL THEN IF [PO Purchase Order Line.Receiving Activity Date] <= [PO Purchase Order Line.Late Delivery Date] THEN [Quantity Received On Time] = [PO Purchase Order Line.Received Quantity] ELSE [Quantity Received On Time] = 0 END IF ELSEIF [PO Purchase Order Line.Receiving Activity Date] <= [PO Purchase Order Line.Early Delivery Date] AND [PO Purchase Order Line.Receiving Activity Date] <> NULL THEN [Quantity Received On Time] = [PO Purchase Order Line.Received Quantity] ELSE [Quantity Received On Time] = 0 END IF
Quantity Shipped Complete	PurchaseOrderLine.QuantityShippedComplete
Quantity To Process	PurchaseOrderLine.QuantityToProcess
Received Late	IF [PO Purchase Order Line.Late Delivery Date] <> NULL AND [PO Purchase Order Line.Receiving Activity Date] <> NULL THEN IF [PO Purchase Order Line.Receiving Activity Date] > [PO Purchase Order Line.Late Delivery Date] THEN [Received Late] = 1 ELSE [Received Late] = 0 END IF ELSEIF [PO Purchase Order Line.Receiving Activity Date] > [PO Purchase Order Line.Early Delivery Date] AND [PO Purchase Order Line.Receiving Activity Date] <> NULL THEN [Received Late] = 1 ELSE [Received Late] = 0 END IF
Received On Time	IF [PO Purchase Order Line.Late Delivery Date] <> NULL AND [PO Purchase Order Line.Receiving Activity Date] <> NULL THEN IF [PO Purchase Order Line.Receiving Activity Date] <= [PO Purchase Order Line.Late Delivery Date] THEN [Received On Time] = 1 ELSE [Received On Time] = 0 END IF ELSEIF [PO Purchase Order Line.Receiving Activity Date] <= [PO Purchase Order Line.Early Delivery Date] AND [PO Purchase Order Line.Receiving Activity Date] <> NULL THEN [Received On Time] = 1 ELSE [Received On Time] = 0 END IF
Received Quantity	PurchaseOrderLine.ReceivedQuantity
Rejected Quantity	PurchaseOrderLine.RejectedQuantity
Service Cancel Amount	PurchaseOrderLine.ServiceCancelAmount
Unmatched PO Line Count	IF ([PO Purchase Order Line.Matched Quantity] < ([PO Purchase Order Line.Quantity] - [PO Purchase Order Line.Cancel Quantity])) THEN [Unmatched PO Line Count] = 1 ELSE [Unmatched PO Line Count] = 0 END IF
Unmatched Quantity	IF ([PO Purchase Order Line.Quantity] - [PO Purchase Order Line.Matched Quantity] - [PO Purchase Order Line.Cancel Quantity]) > 0 THEN [Unmatched Quantity] = [PO Purchase Order Line.Quantity] - [PO Purchase Order Line.Matched Quantity] - [PO Purchase Order Line.Cancel Quantity] ELSE [Unmatched Quantity] = 0 END IF
Write Off Quantity	PurchaseOrderLine.WriteOffQuantity

Purchase Order Line Source Fact


Measure	Source and/or calculation
PLS Billing Invoice Quantity	PurchaseOrderLineSource.BillingInvoiceQuantity
PLS Billing Unit Cost	PurchaseOrderLineSource.BillingUnitCost
PLS Delivered Quantity	PurchaseOrderLineSource.DeliveredQuantity
PLS Entered UOM Multiplier	PurchaseOrderLineSource.EnteredUOMMultiplier
PLS Processed Quantity	PurchaseOrderLineSource.ProcessedQuantity
PLS Quantity	PurchaseOrderLineSource.Quantity
PLS Requisition Unit Cost	PurchaseOrderLineSource.RequisitionUnitCost

Purchase Order Receipt


Measure	Source and/or calculation
Operator	PurchaseOrderReceipt.OperatorID
POR Add On Charge Total	PurchaseOrderReceipt.AddOnChargeTotal
POR Customs Total	PurchaseOrderReceipt.CustomsTotal
POR Freight Total	PurchaseOrderReceipt.FreightTotal
POR Hash Quantity	PurchaseOrderReceipt.HashQuantity
POR Hash Quantity Matched	PurchaseOrderReceipt.HashQuantityMatched
POR Insurance Total	PurchaseOrderReceipt.InsuranceTotal
POR Matched Amount	PurchaseOrderReceipt.MatchedAmount
POR Other Add On Charges Total	PurchaseOrderReceipt.OtherAddOnChargesTotal
POR Receipt Amount	PurchaseOrderReceipt.ReceiptAmount
POR Receipt Count	PurchaseOrderReceipt.PurchaseOrderReceiptKey
POR Receipt Currency Conversion Rate	PurchaseOrderReceipt.ReceiptCurrencyConversionRate

Purchase Order Receipt Line


Measure	Source and/or calculation
PRL Archived Quantity	PurchaseOrderReceiptLine.ArchivedQuantity
PRL Archived Write Off Quantity	PurchaseOrderReceiptLine.ArchivedWriteOffQuantity
PRL Buy UOM Quantity	PurchaseOrderReceiptLine.BuyUOMQuantity
PRL Catch Weight Cost	PurchaseOrderReceiptLine.CatchWeightCost
PRL Catch Weight Quantity	PurchaseOrderReceiptLine.CatchWeightQuantity
PRL Charge Quantity	PurchaseOrderReceiptLine.ChargeQuantity
PRL Chargeback Quantity	PurchaseOrderReceiptLine.ChargebackQuantity
PRL Entered Received Quantity	PurchaseOrderReceiptLine.EnteredReceivedQuantity
PRL Extended Amount	PurchaseOrderReceiptLine.ExtendedAmount
PRL Match Unit Cost	PurchaseOrderReceiptLine.MatchUnitCost
PRL Matched Quantity	PurchaseOrderReceiptLine.MatchedQuantity
PRL Open To Match Quantity	PurchaseOrderReceiptLine.OpenToMatchQuantity
PRL Original Received Quantity	PurchaseOrderReceiptLine.OriginalReceivedQuantity
PRL Original Unit Cost	PurchaseOrderReceiptLine.OriginalUnitCost
PRL Receipt Line Count	PurchaseOrderReceiptLine.UniqueID
PRL Received Allocated Quantity	PurchaseOrderReceiptLine.ReceivedAllocatedQuantity
PRL Received UOM Multiplier	PurchaseOrderReceiptLine.ReceivedUOMMultiplier
PRL Rejected Quantity	PurchaseOrderReceiptLine.RejectedQuantity
PRL Taxable Unit Cost	PurchaseOrderReceiptLine.TaxableUnitCost
PRL Vendor Buy UOM Multiplier	PurchaseOrderReceiptLine.VendorBuyUOMMultiplier
PRL Vendor Price UOM Multiplier	PurchaseOrderReceiptLine.VendorPriceUOMMultiplier
PRL Vendor Price UOM Quantity	PurchaseOrderReceiptLine.VendorPriceUOMQuantity
PRL Write Off Quantity	PurchaseOrderReceiptLine.WriteOffQuantity

Purchase Order Revision


Measure	Source and/or calculation
Purchase Order Revision Count	PurchaseOrderRevision.PurchaseOrderRevisionCount

Vendor Return Line


Measure	Source and/or calculation
Return Cancel Quantity	VendorReturnLine.CancelQuantity
Return Entered UOM Mult	VendorReturnLine.EnteredUOMMultiplier
Return Line Count	VendorReturnLine.UniqueID
Return Line Extended Amount	if((UnitCost !='' and ReturnQuantity != '' ),(ReturnQuantity * UnitCost),0)
Return Qty Instock UOM	if((EnteredUOMMultiplier != ''), (ReturnQuantity * EnteredUOMMultiplier),0)
Return Unit Cost	VendorReturnLine.UnitCost
Return Unit Cost Per Stock UOM	if((EnteredUOMMultiplier != 0 and EnteredUOMMultiplier != ''), (UnitCost/EnteredUOMMultiplier),0)
Vendor Return Quantity	VendorReturnLine.ReturnQuantity

Vendor Return Line Distribution


Measure	Source and/or calculation
Distribution Percent	VendorReturnLineDistribution.DistributionPercent
Distribution Quantity	VendorReturnLineDistribution.DistributionQuantity