Procurement

Procurement - Accrual Balances at Period End (Preview)

These metrics are used in the Analytics Currency (AC) and Ledger Currency fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Period End Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Accrued Amount	This metric shows Amount Accrued due to receiving.
Accrued Quantity	This metric shows Accrued Quantity in Primary Unit of Measure.
Invoiced Amount	This metric shows Amount Invoiced in payables.
Invoiced Quantity	This metric shows Invoiced Quantity in Primary Unit of Measure.
Uninvoiced Quantity	This metric shows Net Accrued Amount in Primary Unit of Measure.
Uninvoiced Receipt Accruals	This metric shows Net Accrual Amount to be Invoiced.

Procurement - Accrual Balances at Receipt (Preview)

These metrics are used in the Analytics Currency (AC) and Ledger Currency fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Event Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Accrued Amount	This metric shows Amount Accrued due to receiving.
Accrued Quantity	This metric shows Accrued Quantity in Primary Unit of Measure.
Invoiced Amount	This metric shows Amount Invoiced in payables.
Invoiced Quantity	This metric shows Invoiced Quantity in Primary Unit of Measure.
Open Accrual Balance	This metric shows Net Accrual Amount to be Invoiced.

Procurement - Agreements

These metrics are used in the Analytics Currency (AC) and Document Currency (DC) fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Purchase Order Agreement Submitted Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Agreement Approval Cycle Time	This metric is calculated as average difference between agreement approval date for version zero and creation date.
Agreement Header Count	This metric shows Count of distinct agreement headers.
Agreement Line Primary Quantity	This metric is calculated as sum of agreement line quantity in primary UOM.
Agreement Line Quantity	This metric is calculated as sum of agreement line quantity in primary and transaction UOM.
Agreement Lines Count	This metric shows Count of distinct blanket agreement lines.
Amendments Count	This metric is calculated as average amendments done for an agreement.
Approvers Count	This metric is calculated as average approvers for version zero of an agreement.
Average Number of Revisions	This metric is calculated as average of agreement versions.
Average Unit Price	This metric shows Average of unit price at lines.
Average Unit Price (Primary UOM)	Average of unit price at lines in primary UOM.
Buyers Count	Count of distinct buyers.
Count by Release 0 - 20%	Count of Agreement Header that release % is under 20%
Count by Release 20% - 40%	Count of Agreement Header that release % is between 20% and 40%
Count by Release 40% - 60%	Count of Agreement Header that release % is between 40% and 60%
Count by Release 60% - 80%	Count of Agreement Header that release % is between 60% and 80%
Count by Release 80% - 100%	Count of Agreement Header that release % is between 80% and 100%
Count by Release Over 100%	Count of Agreement Header that release % is over 100%
Count Expired in Next 7 Days	Count of Agreement Header which will expire in the next 7 days
Count Expired in Next 8 - 30 Days	Count of Agreement Header which will expire in the next 8 days to 30 days
Expired Header Released %	This metric is calculated as header released amount divided by header agreed amount where agreement amount is not null and considering headers are expired.
Expired Line Released %	This metric is calculated as line released amount divided by line agreed amount where agreement amount is not null and considering lines which are expired.
Header Agreed Amount	This metric is calculated as sum of header agreed amount.
Header Expiring Days	This metric is calculated as average difference between end date and system date where agreement header end date is not null.
Header Released %	This metric is calculated as total agreement released amount divided by agreement amount.
Header Released Amount	This metric is calculated as sum of header released amount.
Internal Amendments Count	This metric is calculated as average number of internal amendments for an agreement.
Item Count	This metric shows Count of distinct items.
Line Agreed Amount	This metric is calculated as sum of line agreed amount.
Line Expiring Days	This metric is calculated as average difference between expiration date and system date where either of agreement lines expiration date is not null or header end date is not null.
Line Released Amount	This metric is calculated as sum of line released amount.
Line Released Amount %	This metric is calculated as sum of line released amount divided by line agreed amount.
Negotiation to Agreement Approval Cycle Time	This metric is calculated as average difference between agreement approval date for version zero and negotiation line creation date.
Remaining Header Amount	This metric is calculated as header agreed amount minus header released amount where agreement amount is not null and agreed amount is greater than released amount.
Remaining Header Amount %	This metric is calculated as remaining header amount divided by total header agreed amount.
Remaining Line Amount	This metric is calculated as sum of agreed line amount minus sum of line released amount where agreement line agreed amount is not null and agreed amount is greater than released amount.
Remaining Line Amount %	This metric is calculated as sum of remaining line amount divided by sum of agreed amount.
Supplier Amendments Count	This metric is calculated as average number of supplier initiated amendments for an agreement.
Supplier Count	This metric shows Count of distinct suppliers.
Supplier Site Count	Count of distinct supplier sites.

Procurement - Agreement Change Orders (Preview)

The fact folders in this subject area shows the metrics details below.

Metric	Metric Definition
Agreement Amount Changed	Shows the difference between the agreement amount between change orders at agreement level.
Count of Change Orders	Shows the Average count of change order per agreement.

Procurement - Enterprise Contracts - Contracts (Preview)

These metrics are used in the Analytics Currency (AC) and Document Currency (DC) fact folder in the subject area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Contract Creation Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Contract Amount	This metric is calculated as the sum of contract amount.
Contract Agreed Amount	This metric is calculated as the sum of contract agreed amount.
Contract Line Amount	This metric is calculated as the sum of contract line amount.
Contract Line Agreed Amount	This metric is calculated as the sum of contract line agreed amount.
Fulfillment Amount	This metric is calculated as the sum of fulfillment amount.
Fulfillment Agreed Amount	This metric is calculated as the sum of fulfillment agreed amount.
Contract Count	This metric is calculated as the count of distinct contract headers.
Contract Line Quantity	This metric is calculated as the sum of contract line quantity and shows quantity in primary and transaction UOM.
Contract Line Committed Quantity	This metric is calculated as the sum of contract line committed quantity and shows quantity in primary and transaction UOM.
Fulfillment Quantity	This metric is calculated as the sum of fulfillment quantity and shows quantity in primary and transaction UOM.
Fulfillment Agreed Quantity	This metric is calculated as the sum of fulfillment agreed quantity and shows quantity in primary and transaction UOM.
Days to Expiration	This metric is calculated as average difference between system date and header contract end date.
Contract Cycle Time (Days)	This metric is calculated as average difference between contract signed date and contract creation date for latest version with active status.
Non-Standard Clauses Contract Count	This metric is calculated as the count of contracts where clauses are modified.
% Contracts with Non-Standard Clauses	This metric is calculated as the count of contracts where clauses are modified divided by the count of contract headers.

Procurement - Purchase Orders

These metrics are used in the Analytics Currency (AC) and Document Currency (DC) fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Purchase Order Submitted Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
% Change Average Unit Price (Primary UOM) Last Quarter	Percentage Change of Average Unit Price (Primary UOM) from last quarter.
Accepted Amount	This metric is calculated as sum of accepted amount at schedule level.
Accepted Quantity	This metric is calculated as sum of accepted quantity at schedule level in primary and transaction UOM.
Accepted Rate	This metric is calculated as sum of accepted amount divided by sum of received amount at schedule level.
Amendments Count	This metric is calculated as average amendments done for a purchase order.
Approval Cycle Time	This metric is calculated as average difference between purchase order approval date and purchase order submitted date for version zero.
Approvers Count	This metric is calculated as average number of approvers in a purchase order.
Average Amount Per PO	This metric is calculated as sum of ordered amount divided by count of distinct purchase orders.
Average Number of Revisions	This metric is calculated as average of revision numbers of a purchase order.
Avg Unit Price	This metric is calculated as sum of ordered amount excluding inclusive taxes divided by sum of ordered quantity.
Avg Unit Price (Primary UOM)	This metric is calculated as sum of ordered amount excluding inclusive taxes divided by sum of ordered quantity in primary UOM.
Billed Amount	This metric is calculated as sum of billed amount at distribution level.
Billed Quantity	This metric is calculated as sum of billed quantity at distribution level in primary and transaction UOM.
Buyers Count	This metric shows Count of distinct buyers.
Cancelled Amount	This metric is calculated as sum of cancelled amount at distribution level.
Cancelled Quantity	This metric is calculated as sum of cancelled quantity at distribution level in primary and transaction UOM.
Cancelled Quantity %	This metric shows Cancelled Quantity percentage to overall Ordered Quantity for a given period.
Closed PO Amount	This metric shows the sum of ordered amount at distribution level inclusive of inclusive taxes with status equal to Closed for Invoicing, Closed, and Finally Closed. This metric is deprecated in 23.R2. Please use the Closed Purchase Order Amount metric.
Closed PO Count	This metric shows Count of purchase order header status equal to Closed for Invoicing, Closed, and Finally Closed. This metric is deprecated in 23.R2. Please use the Closed Purchase Order Count metric.
Closed Purchase Order Amount	This metric shows the sum of ordered amount at distribution level inclusive of inclusive taxes with status equal to Closed, and Finally Closed.
Closed Purchase Order Count	Count of purchase order header status equal to Closed, and Finally Closed.
Consignment Quantity	This metric is calculated as sum of consigned quantity at distribution level in primary and transaction UOM.
Delivered Amount	This metric is calculated as sum of delivered amount at distribution level.
Delivered Quantity	This metric is calculated as sum of delivered quantity at distribution level in primary and transaction UOM.
Internal Amendments Count	This metric is calculated as average number of internal amendments for a purchase order.
Max Unit Price	This metric is calculated as maximum of ordered amount excluding inclusive taxes divided by sum of ordered quantity at distribution level.
Max Unit Price (Primary UOM)	This metric is calculated as maximum of ordered amount excluding inclusive taxes divided by sum of ordered quantity at distribution level in primary UOM.
Min Unit Price	This metric is calculated as minimum of ordered amount excluding inclusive taxes divided by sum of ordered quantity at distribution level.
Min Unit Price (Primary UOM)	This metric is calculated as minimum of ordered amount excluding inclusive taxes divided by sum of ordered quantity at distribution level in primary UOM.
Negotiated Amount	This metric shows amount of the purchase order lines which has negotiated indicator as Y.
Negotiation to PO Cycle Time	This metric is calculated as average difference between purchase order approval date for version zero and negotiation line creation date for purchase orders created from negotiations.
Non Recoverable Inclusive Tax Amount	This metric is calculated as sum of non recoverable inclusive tax amount at distribution level.
Non Recoverable Tax Amount	This metric is calculated as sum of non recoverable tax amount at distribution level.
Open PO Amount	This metric shows the sum of ordered amount at distribution level inclusive of inclusive taxes with status equal to Open and Closed for Receiving. This metric is deprecated in 23.R2. Please use the Open Purchase Order Amount metric.
Open PO Count	This metric shows Count of purchase order header status equal to Open and Closed for Receiving. This metric is deprecated in 23.R2. Please use the Open Purchase Order Count metric.
Open Purchase Order Amount	This metric shows the sum of ordered amount at distribution level inclusive of inclusive taxes with status equal to Open, Closed for Receiving, and Closed for Invoicing.
Open Purchase Order Count	Count of purchase order header status equal to Open, Closed for Receiving, and Closed for Invoicing.
Ordered Amount	This metric is calculated as sum of ordered amount at distribution level inclusive of inclusive taxes.
Ordered Quantity	This metric is calculated as sum of quantity net of cancelled quantity at distribution level in primary and transaction UOM.
Original Ordered Quantity	This metric is calculated as sum of quantity including cancelled quantity at distribution level in primary and transaction UOM.
Over Receipt Amount	This metric shows amount that is received more than purchase order quantity at schedule level.
Over Receipt Quantity	This metric shows quantity that is received more that purchase order quantity in primary and transaction UOM.
Over Receipt Quantity %	This metric shows Over Receipt Quantity percentage to overall Receipt Quantity for a given period.
Payment Terms Count	This metric shows Count of distinct payment terms.
PO Close Cycle Time	This metric is calculated as average difference between purchase order close date and purchase order creation date.
PO Open Cycle Time	This metric is calculated as average difference between purchase order implement date for version zero and purchase order creation date.
Pre Processing Lead Time	This metric is calculated as average difference between purchase order approval date and purchase order creation date for version zero.
PR to PO Cycle Time	This metric is calculated as average difference between purchase order creation date and requisition line approval date.
Purchase Order Count	This metric shows Count of distinct purchase order headers.
Purchase Order Lines Count	This metric shows Count of distinct purchase order lines.
Purchase Orders Amount - Open Only	This metric shows the sum of ordered amount at distribution level inclusive of inclusive taxes with status equal to Open.
Purchase Orders Count - Open Only	Count of purchase orders status equal to Open.
Purchase Orders Lines Count - Open Only	Count of purchase orders line status equal to Open.
Received Amount	This metric is calculated as sum of received amount at schedule level.
Received Quantity	This metric is calculated as sum of received quantity at schedule level in primary and transaction UOM.
Recoverable Inclusive Tax Amount	This metric is calculated as sum of recoverable inclusive tax amount at distribution level.
Recoverable Tax Amount	This metric is calculated as sum of recoverable tax amount at distribution level.
Rejected Quantity	This metric is calculated as sum of rejected quantity at schedule level in primary and transaction UOM.
Rejected Quantity %	This metric shows Rejected Quantity percentage to overall Receipt Quantity for a given period.
Requisition Based PO %	This metric is calculated as count of distribution with requisition references divided by count of total distributions.
Requisition Lines Count	This metric shows Count of distinct requisition lines associated in purchase order distributions.
Shipped Amount	This metric is calculated as sum of shipped amount at schedule level.
Shipped Quantity	This metric is calculated as sum of shipped quantity at schedule level in primary and transaction UOM.
Supplier Amendments Count	This metric is calculated as average number of supplier initiated amendments for a purchase order.
Suppliers Count	This metric shows Count of distinct Supplier.
Total Amount	This metric is calculated as sum of total amount at distribution level.
Total Exclusive Tax Amount	This metric is calculated as sum of total exclusive tax amount at distribution level.

Procurement - Purchase Order Change Orders (Preview)

The fact folders in this subject area shows the metrics details below.

Metric	Metric Definition
Count of Change Orders	Shows the Average count of change order per purchase order.
Ordered Amount Changed	Shows the difference between the ordered amount between change orders at distribution level inclusive of inclusive taxes.
Total Amount Changed	Shows the difference between the total amount between change orders at distribution level.
Total Tax Changed	Shows the difference between the total tax amount between change orders at distribution level inclusive of inclusive taxes.

Procurement - Receipt Accounting (Preview)

These metrics are used in the Analytics Currency (AC), Document Currency (DC), and Ledger Currency fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Receipt Accounting Transaction Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metrics

Metric	Metric Definition
Accounted Credit Amount	Shows the Accounted Credit Amount in Analytics Currency for each Receipt Accounting Distribution.
Accounted Debit Amount	Shows the Accounted Debit Amount in Analytics Currency for each Receipt Accounting Distribution.
Accounted Net Amount	Shows the difference of Debit and credit Amount entries that is accounted.
Credit Amount	This metric displays the Credit Amount for each Receipt Accounting Distribution.
Debit Amount	This metric displays the Debit Amount for each Receipt Accounting Distribution.
Net Amount	Shows the difference of Debit and credit Amount entries.
Quantity in Primary UOM	This metric displays the Receipt Accounting Transaction level Quantity in Primary Unit of Measure.
Quantity in Secondary UOM	This metric displays the Receipt Accounting Transaction level Quantity in Secondary Unit of Measure.
Transaction Quantity	This metric displays the Receipt Accounting Transaction level Quantity.

Procurement - Receipts

The fact folders in this subject area show the metrics details described in the table.

Metrics

Metric	Metric Definition
Accepted Amount	This metric is calculated as sum of accepted quantity multiplied by unit price from purchase order in primary UOM.
Accepted Quantity	This metric is calculated as sum of accepted quantity in primary and transaction UOM.
ASN Receipts %	This metric is calculated as count of advanced shipment notice-based receipts divided by count of receipt headers.
Avg Unit Price (Primary UOM)	Average of unit price at purchase order schedule in primary UOM.
Consumed Quantity	This metric is calculated as sum of consumed quantity in primary and transaction UOM.
Delivered Amount	This metric is calculated as sum of delivered quantity multiplied by unit price from purchase order schedule in primary UOM.
Delivered Quantity	This metric is calculated as sum of delivered quantity in primary and transaction UOM.
Post Processing Time	This metric is calculated as average difference between deliver date and receipt date.
Processing Time	This metric is calculated as average difference between receipt date and purchase order approval date for version zero.
Purchase Order Count	Count of distinct purchase orders.
Purchase Order schedule Count	Count of distinct purchase order schedule.
Receipt Headers Count	Count of distinct receipt headers.
Receipt Lines Accepted %	This metric is calculated as receipt accepted count divided by receipt lines count.
Receipt Lines Accepted Count	This metric is calculated as count of receipt lines with accepted quantity greater than zero.
Receipt Lines Count	Count of receipt lines.
Receipt Lines Rejected %	This metric is calculated as receipt rejected count divided by receipt lines count.
Receipt Lines Rejected Count	This metric is calculated as count of receipt lines with rejected quantity greater than zero.
Receipt Lines Returned %	This metric is calculated as receipt returned count divided by receipt lines count.
Receipt Lines Returned Count	This metric is calculated as count of receipt lines with returned quantity greater than zero.
Receipt Lines with Correction %	This metric is calculated as receipt corrected count divided by receipt line count.
Receipt Lines with Correction Count	This metric is calculated as count of receipt lines with atleast one correction transaction.
Received Amount	This metric is calculated as sum of received quantity multiplied by unit price from purchase order in primary UOM.
Received Lines Early %	This metric is calculated as count of lines received early divided by count of receipt lines.
Received Lines Late %	This metric is calculated as count of lines received late divided by count of receipt lines.
Received Lines On Time %	This metric is calculated as count of lines received on time divided by count of receipt lines.
Received Quantity	This metric is calculated as sum of received quantity in primary and transaction UOM.
Rejected Amount	This metric is calculated as sum of rejected quantity multiplied by unit price from purchase order in primary UOM.
Rejected Quantity	This metric is calculated as sum of rejected quantity in primary and transaction UOM.
Returned Amount	This metric is calculated as sum of returned quantity multiplied by unit price from purchase order in primary UOM.
Returned Quantity	This metric is calculated as sum of returned quantity in primary and transaction UOM.
Shipped Quantity	This metric is calculated as sum of shipped quantity in primary and transaction UOM.
Transportation Days	This metric is calculated as average difference between receipt header creation date and shipment date for advance shipment notice-based receipts.

Procurement - Requisitions

These metrics will be used in the Analytics Currency (AC) and Document Currency (DC) fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Requisition Creation Date to convert to the analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Approved Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with approved status. This metric excludes reinstate, split, and replaced line status.
Approved Requisition Lines Count	Count of requisition lines with approved status and excludes reinstate, split, and replaced line status.
Fulfilled Cycle Time Days	This metric is calculated as average difference between purchase order line fulfill date and requisition line last submitted date. The fulfilled date is maximum of the schedule receipt dates or invoice dates. This metric excludes internal requisition and reinstate, split, and replaced line status.
Fulfilled Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with fulfilled status. The fulfilled status requisition lines are those that have purchase order line fulfilled flag value as Y. The purchase order line fulfilled flag will have value as Y only when all the schedule lines for that purchase order line is closed for receiving or invoicing. The fulfilled date is maximum of the schedule receipt dates or invoice dates. This metric excludes internal requisition and reinstate, split, and replaced line status.
Fulfilled Requisition Lines Count	Count of requisition lines for which purchase order got processed and has purchase order line fulfilled flag value as Y. The purchase order line fulfilled flag will have value as Y only when all the schedule lines for that purchase order line is closed for receiving or invoicing. The fulfilled date is maximum of the schedule receipt dates or invoice dates. This metric excludes internal requisition and reinstate, split, and replaced line status.
Pending Approval Requisition Lines Count	Count of requisition lines with pending approval status and excludes reinstate, split, and replaced line status.
PR to PO Cycle Time	This metric is calculated as average difference between purchase order creation date and requisition line approval date. This metric excludes internal requisition and reinstate, split, and replaced line status.
Processed Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with processed status. The processed status requisition lines are those that got converted to purchase order and purchase order header having processed date (version 0). This metric excludes internal requisition and reinstate, split, and replaced line status.
Processed Requisition Lines Count	Count of requisition lines which got converted to purchase order and purchase order header having processed date (version 0). This metric excludes internal requisition and reinstate, split, and replaced line status.
Rejected Requisition Count	Count of distinct requisition with rejected status.
Rejected Requisition Lines Count	Count of requisition lines with rejected status and excludes reinstate, split, and replaced line status.
Requisition Amount	This metric is calculated as sum of amount at distribution level and excludes reinstate, split, and replaced line status.
Requisition Amount – Without cancelled	This metric is calculated as sum of amount at distribution level and excludes cancelled, reinstate, split, and replaced line status.
Requisition Approval Cycle Time Days	This metric is calculated as average difference between requisition approval date and requisition submitted date for version zero.
Requisition Approval to PO Fulfillment Time	This metric is calculated as average difference between purchase order line fulfill date and requisition line last approval date. And fulfilled date is maximum of the schedule receipt dates or invoice dates. This metric excludes internal requisition and reinstate, split and replaced line status.
Requisition Count	Count of distinct requisitions.
Requisition Line Count	Count of requisition lines excluding reinstate, split, and replaced line status.
Requisition Primary Quantity	This metric is calculated as sum of quantity at distribution level and excludes reinstate, split and replaced line status. This shows quantity in primary UOM.
Requisition Quantity	This metric is calculated as sum of quantity at distribution level and excludes reinstate, split, and replaced line status. This shows quantity in primary and transaction UOM.
Unfulfilled overdue Requisition %	This metric shows Unfulfilled overdue requisition amount percentage of the overall requisition amount for a given period.
Unfulfilled overdue Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with unfulfilled status and crossed the requested delivery date. The unfulfilled status requisition lines are those purchase orders that got processed and has purchase order line fulfilled flag value as N. This metric excludes internal requisition and reinstate, split, and replaced line status.
Unfulfilled Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with unfulfilled status. The unfulfilled status requisition lines are those purchase orders that got processed and have purchase order line fulfilled flag value as N. This metric excludes internal requisition and reinstate, split, and replaced line status.
Unfulfilled Requisition Lines Count	Count of requisition lines for which purchase order got processed and has purchase order line fulfilled flag value as N. This metric excludes internal requisition and reinstate, split, and replaced line status.
Unprocessed Average Aging Days	This metric is calculated as average difference between system date and requisition line last approval date for requisition lines which are yet to get converted to purchase order or purchase order header without processed date (version 0). This metric excludes internal requisition and reinstate, split, and replaced line status.
Unprocessed overdue Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with unprocessed status and crossed the requested delivery date and the unprocessed status requisition lines which are yet to get converted to purchase order or purchase order header without processed date (version 0). This metric excludes internal requisition and reinstate, split, and replaced line status.
Unprocessed Requisition Lines Count	Count of requisition lines which are yet to get converted to purchase order or purchase order header without processed date (version 0). This metric excludes internal requisition and reinstate, split, and replaced line status.
Requisition Amount - Parent Reinstate Line	This metric is calculated as sum of amount at distribution level and includes parent reinstate and excludes cancelled, split, and replaced line status.
Requisition Quantity - With Reinstate Line	This metric is calculated as sum of quantity at distribution level and includes parent reinstate and cancelled, but excludes split and replaced line status.
Requisition Line Count - With Reinstate Line	Count of requisition lines excluding split and replaced line status.
Requisition Quantity - Without Cancelled	This metric is calculated as sum of quantity at distribution level and excludes Cancelled , reinstate, split and replaced line status.

Procurement - Spend

These metrics are used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder, and Document Currency (DC) fact folder in the Subject Areas.

Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Expense Distribution accounting date to convert to the analytics currency. Metrics in these folders show amounts in their respective currencies. Currently only accounted invoices are supported.

Metric	Metric Definition
Addressable Spend	This metric is calculated as Sum of 'Spend' where Invoice Distribution Types are Accrual, Item, Exchange Rate Variance, Invoice Price Variance, Retainage and Retro Active Price Accrual.
Addressable Spend %	This metric is calculated as percentage of Addressable Spend over Spend.
Agreement Leakage Spend	This metric is calculated as the sum of spend where invoice distributions has a purchase order reference, and the purchase order line does not have an agreement associated with it, although an open blanket agreement is available for the item in purchase order. This metric works only for inventory Item-based purchase orders.
Agreement Leakage Spend %	This metric is calculated as percentage of agreement leakage spend over spend.
Agreement Spend	This metric is calculated as the sum of spend, where invoice distributions has a purchase order reference, and the corresponding purchase order line has a blanket purchase agreement or contract purchase agreement reference.
Agreement Spend %	This metric is calculated as percentage of agreement spend over spend.
Average Spend Per invoice	This metric is calculated as the sum of spend divided by the count of spend invoices.
Avg Invoice Unit Price	This metric is calculated as sum of invoice amounts divided by sum of invoiced quantity where quantity invoiced is not zero. This metric is calculated for invoice distributions conforming as addressable spend.
Avg Invoice Unit Price (Primary UOM)	This metric is calculated as sum of invoice amounts divided by sum of invoiced quantity where quantity invoiced is not zero. This metric is calculated for invoice distributions conforming as addressable spend in primary UOM.
Buyer Count	This metric is calculated as distinct buyers on invoice headers.
Category Non Agreement Spend %	This metric is calculated as percentage of Non Agreement Spend over Non Agreement Spend across all categories. This metric is used to analyze individual category Non Agreement Spend against Non Agreement Spend across all categories.
Category Spend %	This metric is calculated as percentage of spend over spend across all categories. This metric is used to analyze individual category spend against spend across all categories.
Electronic Invoices Count	This metric is calculated as the count of distinct invoice headers where invoice header source is not equal to manual invoice Entry.
Invoice Amount	This metric is calculated as sum of amounts from the invoice accounting distribution lines for an invoice distribution.
Invoice Lines Count	This metric is calculated as the count of distinct invoice lines.
Invoice Price Variance	This metric is calculated as sum of amounts from invoice distribution for distribution line status invoice price variance.
Invoices Before PO Creation Count	This metric is calculated as the count of invoice headers where invoice date is greater than the purchase order creation date.
Invoices Count	This metric is calculated as the count of distinct invoice headers.
Invoices with IPV Count	This metric is calculated as count of distinct invoice headers where invoices have more than one distribution line status in invoice price variance or tax invoice price variance.
Item Based Purchases %	This metric is calculated as the percentage of distinct count of item-based purchase order lines over distinct count of purchase order lines.
Manual Invoices Count	This metric is calculated as the count of distinct invoice headers where invoice header source is equal to manual invoice Entry.
Max Invoice Unit Price	This metric is calculated as maximum of invoice amounts divided by invoiced quantity where quantity invoiced is not zero. This metric is calculated for invoice distributions conforming as addressable spend.
Max Invoice Unit Price (Primary UOM)	This metric is calculated as maximum of invoice amounts divided by invoiced quantity where quantity invoiced is not zero. This metric is calculated for invoice distributions conforming as addressable spend in primary UOM.
Min Invoice Unit Price	This metric is calculated as minimum of invoice amounts divided by invoiced quantity where quantity invoiced is not zero. This metric is calculated for invoice distributions conforming as addressable spend.
Min Invoice Unit Price (Primary UOM)	This metric is calculated as minimum of invoice amounts divided by invoiced quantity where quantity invoiced is not zero. This metric is calculated for invoice distributions conforming as addressable spend in primary UOM.
Negotiated Spend	This metric is calculated as PO matched spend where the negotiated Flag is checked for the corresponding purchase orders lines.
Negotiated Spend %	This metric is calculated as percentage of negotiated spend over spend.
Non Agreement Spend	This metric is calculated as the sum of spend where invoice distributions has a purchase order reference, and purchase order line does not have a blanket purchase agreement or contract purchase agreement reference.
Non Agreement Spend %	This metric is calculated as percentage of non-agreement spend over spend.
Non Negotiated Spend	This metric is calculated as PO matched spend where the negotiated Flag is not checked for the corresponding purchase orders lines.
Non PO Matched Spend %	This metric is calculated as percentage of non-PO matched spend over spend.
Open Invoices Count	This metric is calculated as count of distinct invoice headers where invoice header is not paid yet.
Other Non Agreement Spend	This metric is calculated as non-agreement spend minus agreement leakage spend.
Paid Invoices Count	This metric is calculated as count of distinct invoice headers where invoice header is already paid.
Payables Invoicing Business Unit Count	This metric is calculated as distinct count of payables invoicing business units on invoice headers.
Payment Terms Count	This metric is calculated as count of distinct payment terms on invoice headers.
Perfect Invoices Count	This metric is calculated as count of distinct invoice headers where invoice header is partially or fully matched to purchase order with no price variance.
PO Matched Invoices Count	This metric is calculated as the count of distinct invoices headers which are fully or partially matched to the purchase order.
PO Matched Spend	This metric is calculated as the sum of invoice amounts, where invoice distributions has a purchase order Reference.
PO Matched Spend %	This metric is calculated as percentage of PO matched spend over spend.
Primary Quantity Invoiced	This metric is calculated as sum of quantity invoiced from invoice distributions in primary UOM.
Purchase Order Lines Count	This metric is calculated as the count of distinct purchase order lines referenced in invoice distributions.
Purchase Orders Count	This metric is calculated as the count of distinct purchase order headers referenced in invoice distributions.
Purchasing Category Count	This metric is calculated as count of distinct Purchasing category on invoice lines.
Quantity Invoiced	This metric is calculated as the sum of quantity invoiced from invoice distributions in primary and transaction UOM.
Spend	This metric is calculated as sum of invoice amounts where invoice is approved and invoice distribution is validated. This metric excludes invoice distributions for withholding tax invoices and lines, prepayment invoices, and prepayment application lines.
Supplier Site Count	This metric is calculated as count of distinct supplier sites on invoice headers.
Supplier Spend %	This metric is calculated as percentage of spend over spend across all suppliers. This metric is used to analyze individual supplier spend against spend across all suppliers.
Suppliers Count	This metric is calculated as the count of distinct suppliers on invoice headers.
Agreement Leakage to PO Spend %	This metric is calculated as the percentage of agreement leakage amount over PO matched spend amount.
Non Agreement to PO Spend %	This metric is calculated as the percentage of non agreement amount over PO matched spend amount.