7 Subject Areas

Subject Areas

Overview

This chapter provides information on the subject areas with data you maintain in Oracle Fusion ERP Analytics.

These subject areas, with their corresponding data, are available for you to use when creating and editing analyses and reports. The information for each subject area includes:

• Description of the subject area.

• Business questions that can be answered by data in the subject area, with a link to more detailed information about each business question.

• Job roles and duty roles that can be used to secure access to the subject area, with a link to more detailed information about each job role and duty role.

• Primary navigation to the work area that is represented by the subject area.

• Time reporting considerations in using the subject area, such as whether the subject area reports historical data or only the current data. Historical reporting refers to reporting on historical transactional data in a subject area. With a few exceptions, all dimensional data are current as of the primary transaction dates or system date.

• The lowest grain of transactional data in a subject area. The lowest transactional data grain determines how data are joined in a report.

• Special considerations, tips, and things to look out for in using the subject area to create analyses and reports.

Financials—AP Holds

Description

This subject area provides the ability to analyze key metrics associated with AP Holds at Invoices Header and Line level. These metrics can be analyzed by Ledger, Business Units, CoA Segments, Supplier, Invoices Holds, and Releases.

Business Questions

This subject area can answer the following business questions:

• What is the summary of invoices (count and amount) by various release reasons and released by user?

• What is the outstanding AP amount for AP Invoices on Holds?

• What is the current AP amount out of outstanding AP amount for Invoices on Hold?

• What is the overdue AP amount out of outstanding AP amount for Invoices on Hold?

• What is the count and amount of AP Invoices on Hold due to PO matching variances?

• What is the summary of invoices (count and amount) by various hold reasons and hold by user?

• What is the count and amount of AP Invoices on Hold due to distribution variances?

• What is the split of invoices on Hold by manual holds vs system holds?

• What is the average number of days for invoices on hold and the trend for past six quarters?

• What is the count and amount of AP Invoices that have either Header Level Hold, Line Level Hold, or combination?

• What is the count and amount of AP Invoices on Hold due to supplier site limits?

Job Roles

The following job roles secure access to this subject area:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to this subject area:

• Accounts Payable Holds Analysis Duty

Primary Navigation

Home > Payables

Time Reporting

This subject area supports historic analysis on holds along with current holds.

Time dimension is linked to Hold Date.

Transactional Grain

The grain is at the AP Hold level

Special Considerations

None.

Financials—AP Aging

Description

This subject area enables the analysis of open AP Invoices, including Debit and Credit memos with respect to aging details, current and overdue positions. Also, this enables the analysis of the historic trend of AP balances at an aggregate level over time. You can split the invoice details and AP balances by Time, Supplier Details, Business Units, Invoice Details, GL Account, GL Balancing Segments, GL Cost Center, and Non-Qualifying GL Segments of chart of accounts.

Business Questions

This subject area can answer the following business questions:

• What is the average time available to pay off the outstanding AP invoices?

• What are the top 10 suppliers with maximum AP outstanding?

• What is the count and value of AP invoices overdue?

• What is the summary of AP invoices across aging buckets, count, and value?

• How are AP balances trending for a particular supplier over last 8 quarters?

• What is the trend of outstanding AP Balances at consolidated level, supplier level, and Business Unit level?

Job Roles

The following job roles secure access to this subject area:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to this subject area:

• Accounts Payable Aging Analysis Duty

Primary Navigation

Home > Payables

Time Reporting

This subject area supports historical reporting of payables invoice aging. Historic aging snapshots for 24 months prior to the current date will be available.

Time dimension is linked to Snapshot Captured Date.

Transactional Grain

The grain is at the AP payment Installment level.

Special Considerations

None.

Financials—AP Expenses

Description

This subject area provides the ability to analyze the key metrics related to AP Expenses sourced from distribution details for the invoices. These metrics can be analyzed by Invoice Details, Business Units, Supplier Details, CoA Segments, Expense related Financial Categories, and so on.

Business Questions

This subject area can answer the following business questions:

• What is the amount of AP Expenses by each Business Unit?

• What is the distribution of AP Expenses by top 10 suppliers?

• What is the distribution of AP Expenses by the top five Natural Accounts or Financial Categories?

• What is the distribution of AP Expenses by each of the cost center?

• What is the trend of AP Expenses for the past six quarters?

Job Roles

The following job roles secure access to this subject area:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to this subject area:

• Accounts Payable Expenses Analysis Duty

Primary Navigation

Home > Payables

Time Reporting

This subject area supports historic analysis of expense distributions.

Time dimension is linked to Expense Distribution Accounting Date.

Transactional Grain

The grain is at the AP invoice expense distribution level.

Special Considerations

None.

Financials—AP Invoices

Description

This subject area enables the analysis of AP Invoices transaction activity and the associated details at the most granular level. You can split the AP Invoices transaction by Time, Supplier Details, Business Units, Invoice Details, GL Account, GL Balancing Segments, GL Cost Center, and Non-Qualifying GL Segments of CoA.

Business Questions

This subject area can answer the following business questions:

• What is the count and amount of invoices processed for the period by business units and trend comparison?

• What is the validation, approval and accounting status of invoices processed during the period?

• What are the invoice types processed by AP department and the payment methods used to understand the downstream activities?

• No. of invoices paid vs unpaid including partly paid with amount?

• Analysis around payment terms by transaction type, transaction source for the invoices processed?

Job Roles

The following job roles secure access to this subject area:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to this subject area:

• Accounts Payable Invoices Analysis Duty

Primary Navigation

Home > Payables

Time Reporting

This subject area supports invoice payment installment history.

Time dimension is linked to Invoice Date.

Transactional Grain

The grain is at the AP payment Installment level.

Special Considerations

None.

Financials—AP Liabilities

Description

This subject area enables the analysis of AP liability distribution details for invoices and payments. You can split the details by Time, Supplier Details, Business Units, Invoice Details, GL Account, GL Balancing Segments, GL Cost Center, and Non-Qualifying GL Segments of CoA.

Business Questions

This subject area can answer the following business questions:

• What are the liabilities distribution details of AP Balances?

• What is the accounting status of liability distributions by invoices?

Job Roles

The following job roles secure access to this subject area:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to this subject area:

• Accounts Payable Liabilities Analysis Duty

Primary Navigation

Home > Payables

Time Reporting

This subject area supports historic analysis of liabilities distributions.

Time dimension is linked to Invoice Accounting Date.

Transactional Grain

The grain is at the AP invoice liabilities distribution level.

Special Considerations

None.

Financials—AP Payments

Description

This subject area enables the analysis of AP Payments activity and all the key AP payment metrics. You can split the AP Payments by Time, Supplier Details, Business Units, Payment Details, GL Account, GL Balancing Segments, GL Cost Center, and Non-Qualifying GL Segments.

Business Questions

This subject area can answer the following business questions:

• What is the count and amount of payments processed for the period by business units and trend comparison?
• What is the average supplier payment days by BU's?
• What is the ratio of on-time payment performance?
• What is the count and amount of overdue payments?
• What are the interest penalties paid by amount and percentage?

Job Roles

The following job roles secure access to this subject area:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to this subject area:

• Accounts Payable Payments Analysis Duty

Primary Navigation

Home > Payables

Time Reporting

This subject area supports historic analysis of payment details.

Time dimension is linked to Payment Date.

Transactional Grain

The grain is at the AP payment distribution level.

Special Considerations

None.

Financials—AR Adjustments

Description

This subject area provides the details of all the top metrics for AR adjustment transactions. All these metrics can be analyzed on the basis of Time, Customer Details, Business Units, AR Transaction Details in addition to GL Account, GL Balancing Segments, and Non Qualifying GL Segments of CoA.

Business Questions

This subject area can answer the following business questions:

• What is the ratio of AR Adjustments applications to Invoice %?
• What is the count and amount of AR Adjustments processed during the period?
• What is the analysis of AR Adjustments by Business Unit, Time Period, Customers, GL Accounts, and so on?
• What is the status of AR Adjustments?

Job Roles

The following job roles secure access to this subject area:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to this subject area:

• Accounts Receivable Adjustments Analysis Duty

Primary Navigation

Home > Receivables

Time Reporting

This subject area supports receivables transaction adjustments history.

Time dimension is linked to Adjustment Date .

Transactional Grain

The grain is at the AR distributions line level.

Special Considerations

None.

Financials—AR Aging

Description

This subject area provides the ability to analyze all the open AR transactions with respect to aging details and current and overdue positions. Also, this enables the analysis of the historic trend of AR balances at an aggregate level over time. You can slice and dice details by Time, Customer Details, Business Units, AR Transaction Details in addition to GL Account, GL Balancing Segments, and Non Qualifying GL Segments of chart of accounts.

Business Questions

This subject area can answer the following business questions:

• What is the trend of outstanding AR Balances by Customer or Business Unit?
• What is the count and value of AR Invoices Current?
• What is the summary of AR invoices across aging buckets, count and value?
• What is the AR account activity for the period and balance amount by Business Unit?
• What are the top 10 customers with maximum AR outstanding?
• What is the summary of AR invoices overdue with respect to their aging buckets and payment terms?
• What is the count and value of AR invoices Overdue?
• How are AR balances trending for a particular customer over the last eight quarters?

Job Roles

The following job roles secure access to this subject area:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to this subject area:

• Accounts Receivable Aging Analysis Duty

Primary Navigation

Home > Receivables

Time Reporting

This subject area supports historical reporting of receivables invoice aging. Historic aging snapshots for 24 months prior to the current date will be available.

Time dimension is linked to Snapshot Captured Date.

Transactional Grain

The grain is at the AR payment schedules level.

Special Considerations

None.

Financials—AR Credit Memo Applications

Description

This subject area details the analysis for all the top metrics related to AR Credit Memo Applications against AR Invoices. The information here can be sliced by Time, Customer Details, Business Units in addition to GL Account, GL Balancing Segments, and Non Qualifying GL Segments of CoA.

Business Questions

This subject area can answer the following business questions:

• What is the count and amount of credit memo applications during the period?
• What is the analysis of credit memo applications by Business Unit, Time Period, Customers, GL Accounts, and so on?
• What is the status of CM application transactions?

Job Roles

The following job roles secure access to this subject area:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to this subject area:

• Accounts Receivable Credit Memo Applications Analysis Duty

Primary Navigation

Home > Receivables

Time Reporting

This subject area supports receivables credit memos history.

Time dimension is linked to Credit Memo Application Date .

Transactional Grain

The grain is at the AR distributions line level.

Special Considerations

None.

Financials—AR Receipts and Applications

Description

This subject area details the analysis for all the top metrics related to AR Receipts and its applications against AR Invoices. The information here can be sliced by Time, Customer Details, Business Units in addition to GL Account, GL Balancing Segments, and Non Qualifying GL Segments of CoA.

Business Questions

This subject area can answer the following business questions:

• What is the count and amount of unapplied receipts?
• What is the trend for Average Receipt Days?
• What is the count and amount of applied receipts?
• What is the count and amount of receipts processed over the period of time?
• What is the analysis of due and overdue receipts?
• What is the amount of discount Taken vs Lost?

Job Roles

The following job roles secure access to this subject area:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to this subject area:

• Accounts Receivable Receipts and Applications Analysis Duty

Primary Navigation

Home > Receivables

Time Reporting

This subject area supports receivables transactions receipts and application history.

Time dimension is linked to Receipt Date.

Transactional Grain

The grain is at the AR distributions line level.

Special Considerations

None.

Financials—AR Revenue

Description

This subject area provides details for the key metrics related to revenue sourced from AR transaction distribution and revenue recognition. These metrics can be analyzed by Transaction Details, Business Units, Customer Accounts, chart of account Segments, etc.

Business Questions

This subject area can answer the following business questions:

• What is the revenue mix by geography, business units, product lines, SKU, key customers, transaction source, transaction type?
• What is the contribution of non operating revenue and trend for past quarters?
• What is the amount of deferred revenue further classified by long term and short term deferred revenue?
• What is the revenue recognition for the fiscal period in comparison to billings in prior periods (Bill in Advance) or billing in future (Bill in Arrears)?
• What is the distribution of Revenue by top 10 customer accounts?
• What is the summary as well as detailed analysis of revenue vs billed amount (including taxes) in Transaction Currency, Ledger Currency, Analytics Currency?
• What is the distribution of revenue by top 5 revenue accounts?
• What is the Revenue mix from services, subscription fees, material installation, merchant fees, sale of goods, etc?
• What is the trend for operating revenue for past 6 quarters by Ledger, Legal Entity, Billing BU, etc?
• What is the breakdown of inter company revenue vs external revenue based on AR transaction type, transaction source?

Job Roles

The following job roles secure access to this subject area:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to this subject area:

• Accounts Receivable Revenue Analysis Duty

Primary Navigation

Home > Receivables

Time Reporting

This subject area supports AR Revenue transactions including history.

Time dimension is linked to AR Distributions Accounting Date.

Transactional Grain

The grain is at the AR Revenue distribution level.

Special Considerations

None.

Financials—AR Transactions

Description

This subject area provides the ability to analyze AR transactions activity for Invoices, Debit Memos, Credit Memos, Charge-back Invoices, etc. All the key associated metrics to these transactions can be seen on the basis of Time, Customer Details, Business Units, AR Transaction Details in addition to GL Account, GL Balancing Segments, and Non Qualifying GL Segments of CoA.

Business Questions

This subject area can answer the following business questions:

• What are the payment terms and receipt methods associated with the transactions?
• What is the classification of transactions processed during the period by Transaction Type and Source?
• What is the count and amount of transactions processed over the period of time?
• What is the summary of Transactions by statuses?

Job Roles

The following job roles secure access to this subject area:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to this subject area:

• Accounts Receivable Transactions Analysis Duty

Primary Navigation

Home > Receivables

Time Reporting

This subject area supports receivables transactions history.

Time dimension is linked to Transaction Date .

Transactional Grain

The grain is at the AR payment schedules level.

Special Considerations

None.

Financials — Assets Analysis

Description

This subject area provides the ability to analyze fixed asset details, asset health and lifecycle tracking over a period of time at the asset book level with associated attibute details and key metrics.

Business Questions

This subject area can answer the following business questions:

• What is the period active asset unit details for particular asset category and trend details?

• What are the period wise last active asset employee assignment details?

• How to track asset book health, lifecycle tracking with historic data?

• What is the period active asset mix across various asset categories?

• What is the average life of asset by asset category?

• What is the overall net book value for PP&E assets and trend over multiple periods by entity, asset book,etc?

• What is the asset mix across various asset types CIP, Capitalized, Expensed?

• What is summary of assets which has exceeded economic life or nearby end of life?

• Summary of assets by original cost, salvage value, net book value by entity, category, time historic, etc.

Job Roles

The following job roles secure access to this subject area:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to this subject area:

• Fixed Asset Transactions Analysis Duty

Primary Navigation

Home > Assets

Time Reporting

This subject area supports historic analysis of assets.

Time dimension is linked to Asset Calendar (Transaction Date).

Transactional Grain

The grain is at the asset depreciation details.

Special Considerations

None.

Financials — Assets Transactions

Description

This subject area provides the ability to analyze key metrics around assets adjustment transactions and associated accounting details.

Business Questions

This subject area can answer the following business questions:

• What is the summary of asset addition/ CapEx for a particular entity, asset book, asset category?

• What is the average cost of removal per unit for retired assets?

• What is the amount of assets revalued during past 6 quarters?

• What is the amount and quantity of assets adjusted by transaction type and GL accounts, segments?

• What is the trend of asset retirement over a period of time in terms of cost retired, NBV retired?

• What is the amount and quantity of assets reclassified during the period?

• What are the details of asset retired by various asset categories?

• What are the source document details for asset additions?

Job Roles

The following job roles secure access to this subject area:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to this subject area:

• Fixed Asset Transactions Analysis Duty

Primary Navigation

Home > Assets

Time Reporting

This subject area supports historic analysis of asset adjustment transactions and accounting details.

Time dimension is linked to Asset Calendar Period (Transaction Date) and Fiscal Period (Subledger Accounting Date).

Transactional Grain

The grain is at assets transactions and accounting distributions.

Special Considerations

None.

Financials—EXM Employee Expenses

This subject area is regarding employee expenses.

Description

This subject area provides ability to analyse employee spend of an organization across company, cost center, expense types, expense categories, and associated dimensions.

Business Questions

This subject area can answer the following business questions:

• Which are top cost centers by employee expenses?
• What is the expense breakdown by expense type?
• What is the employee expense Spend by Business Units?
• What is the trend in Credit vs Cash expense?
• Which are the top cost centers and organizations with Audit violations for expense reports which are paid?
• What is the Total Expense Trend for last few quarters?
• Who are the top managers by expenses?
• What is the number of expenses which are filed late?
• What is the percentage of reports which are Auto approved?
• What are the top expense reports which are paid?
• What is the total expenses by number of expense reports for employee, manager, organization, cost centers?
• What are the cycle times for report submission, filing, approvals?

Job Roles

The following job roles secure access to this subject area:

• Expense Manager

Duty Roles

The following duty roles secure access to this subject area:

• Employee Expense Analysis Duty

Primary Navigation

Home -> Employee Expense

Time Reporting

This subject area supports historic analysis of employee expense distributions.

Time dimension is linked to Expense Report Date.

Transactional Grain

The grain is at the Employee Expense distribution level

Special Considerations

None.

Financials—GL Account Analysis

Description

This subject area provides single analysis that gives composite view of GL account activity and corresponding subledger transaction details across sources supported in Fusion ERP Analytics.

Business Questions

This subject area can answer the following business questions:

• How to monitor GL accounts with respect to accounting and posting activity for all contributing transactions during an accounting period?
• How to reconcile GL Balances/Journals and all contributing subledger transactions including manual journals in GL with post SLA accounting details in a single consolidate report?
• How to get consolidated abstract view of GL account activity for a period and associated subledger transaction activity?
• How to facilitate intuitive drill to details for GL Balances, Journals or subledger transactions for detailed analysis with minimum number of clicks?
• How to analyze GL Balances/Journals with the ability to get the extended details of subledger transaction attributes and accounting events?
• How to support account analysis across multi period, multi ledger at detailed or roll up account levels across Chart of Account Segments?

Job Roles

The following job roles secure access to this subject area:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor
• Accounts Receivable Manager
• Accounts Receivable Specialist
• Financial Analyst
• General Accountant
• General Accounting Manager

Duty Roles

The following duty roles secure access to this subject area:

• General Ledger Account Analysis Duty

Primary Navigation

Home > General Accounting

Time Reporting

This subject area supports accounting details history for four fiscal periods.

Time dimension is linked to Subledger Accounting Date for subledger transactions and GL Accounting Date for other Journals..

Transactional Grain

The grain is at the accounting distribution level.

Special Considerations

None.

Financials—GL Balance Sheet

Description

This subject area provides the consolidated details of all top-level balance sheet metrics for the enterprise. It identifies the components that contribute to the company's assets and liabilities, and reveals the exact amount of money they are worth. It lets you split the GL balances by Ledger, Legal Entity, CoA Segments, and associated hierarchies.

Business Questions

This subject area can answer the following business questions:

• What is the trend of AP for last 8 quarters?
• How are my asset balances tracking across regions (COA) for last 2 years?
• How is debt equity mix structured at present, and is it actionable for improved financial gearing?
• What is the working capital position and trend for past x quarters?
• What are the CapEx requirements in near future? Will PPE hold up, or will an early capital infusion be needed?

Job Roles

The following job roles secure access to this subject area:

• Financial Analyst
• General Accountant
• General Accounting Manager

Duty Roles

The following duty roles secure access to this subject area:

• General Ledger Balance Sheet Analysis Duty

Primary Navigation

Home > General Accounting

Time Reporting

This subject area supports general ledger balances history.

Time dimension is linked to Fiscal Period (Basis GL Journal Date).

Transactional Grain

This subject area returns the GL balances data at the grain of ledger, GL account combination, currency code of ledger, fiscal period, and translation status.

Special Considerations

None.

Financials—GL Budgets

Description

This subject area provides the ability to analyze the top budget related metrics around profitability and balance sheet statement, compare them with actuals, and perform variance analysis. These metrics can be analyzed by Time, Ledger, Legal Entity, CoA segments, and associated hierarchies.

Business Questions

This subject area can answer the following business questions:

• What is the split of budgeted receivables by entity or ledgers?
• How is the actual performance vs the budgeted performance of top Balance Sheet metrics for the last quarter or year?
• What is the budgeted revenue activity on monthly or quarterly basis?
• What is the target revenue for next quarter in best case and worst case scenario?
• Is higher than anticipated OPEX a one-off case or how is the trend for past eight quarters?
• What is the trend for profitability metrics actual vs budget and direction of variance?
• Whether the company was able to meet the guided revenue growth for past quarters or years?

Job Roles

The following job roles secure access to this subject area:

• Financial Analyst
• General Accountant
• General Accounting Manager

Duty Roles

The following duty roles secure access to this subject area:

• General Ledger Budget Analysis Duty

Primary Navigation

Home > General Accounting

Time Reporting

This subject area supports general ledger budget balances history.

Time dimension is linked to Fiscal Period.

Transactional Grain

This subject area returns the GL balances data at the grain of ledger, GL account combination, currency, and fiscal period.

Special Considerations

None.

Financials—GL Detail Transactions

Description

This subject area provides the journal-level details of all the account balances and metrics in other GL subject areas. It lets you split the GL journal by Ledger, Legal Entity, CoA Segments, and associated hierarchies.

Business Questions

This subject area can answer the following business questions:

• What is the pattern of bookings in tax sensitive GL accounts in comparison to revenue and cost?
• What is the QoQ, YoY trend for accrual bookings due for reversal in next accounting period?
• How is the trend analysis for journals from subledger sources against manual GL journals, both in terms of amount and volume?
• What are the details of entries booked in GL for reclassification from expense to assets and vice versa?

Job Roles

The following job roles secure access to this subject area:

• Financial Analyst
• General Accountant
• General Accounting Manager

Duty Roles

The following duty roles secure access to this subject area:

• General Ledger Detail Transactions Analysis Duty

Primary Navigation

Home > General Accounting

Time Reporting

This subject area supports general ledger journals history.

Time dimension is linked to GL Accounting Date .

Transactional Grain

The grain is at the journal line level.

Special Considerations

None.

Financials—GL Profitability

Description

This subject area provides the details of all the base profitability metrics associated with income and expense accounts, and the derived metrics that support the income statement. It lets you split the GL balances by Ledger, Legal Entity, CoA Segments, and associated hierarchies.

Business Questions

This subject area can answer the following business questions:

• What is the trend around operating and net margins for past 2 years?
• What is the trend of Gross Margins for past 2 years across business units?
• What is the composition of fixed cost elements vs variable cost elements for past 2 years?
• What is the proportion of operating profits taken up by interest and financing cost?

Job Roles

The following job roles secure access to this subject area:

• Financial Analyst
• General Accountant
• General Accounting Manager

Duty Roles

The following duty roles secure access to this subject area:

• Profitability Analysis Duty

Primary Navigation

Home > General Accounting

Time Reporting

This subject area supports general ledger balances history and period level activities history.

Time dimension is linked to Fiscal Period (Basis GL Journal Date).

Transactional Grain

This subject area returns the GL balances data at the grain of ledger, GL account combination, currency code of ledger, fiscal period, and translation status.

Special Considerations

None.

PPM — Project Costs

Description

This subject area provides ability to report on actual Cost (Burdened Cost), Raw Cost, Burden Cost for the past and current periods including inception-to-date, year-to-date comparisons across projects, tasks, organizations, resources, suppliers and associated hierarchies. It provides the ability to analyze all accounted project cost distributions by GL Account.

Business Questions

This subject area can answer the following business questions:

• What is the actual cost by GL Account for a specific period?

• What are the expenditures that contributed to the actual costs?

• What are the costs by expenditure type and category?

• What % of costs have been Capitalized?

• What is the total project cost by Project Organization, Project Type, Expenditure type, Expenditure Category, Expenditure Organization?

• What is the actual cost by Project Type?

• What are the ITD, YTD and PTD actual costs?

• What is the actual cost by Project and Task?

• What is the actual cost by Project Organization?

• What is the actual cost by Project Class codes?

• What is the trend of cost?

• What is the trend of Project Cost by Organization, Project type etc?

• What % of cost have been billed?

• What is the Labor cost and effort breakup by Employee, Job?

Job Roles

The following job roles secure access to this subject area:

• Project Accountant

• Project Administrator

• Project Manager

Duty Roles

The following duty roles secure access to this subject area:

• Project Costing Costs Analysis Duty

Primary Navigation

Home > Projects

Time Reporting

This subject area supports historic analysis of Project actual costs.

Time dimension is linked to Provider Fiscal Date and Receiver Fiscal Date.

Transactional Grain

The grain is at the project cost distribution line level for unaccounted lines and XLA distribution lines for accounted lines.

Special Considerations

None.

Procurement—Agreements

Description

This is a detailed subject area that provides the ability to report on purchasing agreement measures like consumed amount, count of agreements, day to expire analyzed by supplier, procurement item and business units.

Business Questions

This subject area can answer the following business questions:

• What are my cycle times for agreement approvals?

• What are the agreements utilization rates?

• Which agreements are utilized before expiry?

• What are the creation sources for agreements?

• What are my products and services for which we have agreements?

• Which agreements are under utilized?

• How many times are we amending agreements and whether amendment initiation is internal or external?

• How many approvers on a average are approving agreements?

• What are my negotiation to agreement approval cycle times?

Job Roles

The following job roles secure access to this subject area:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager

Duty Roles

The following duty roles secure access to this subject area:

• Procurement Purchase Agreement Analysis Duty

Primary Navigation

Home > Procurement

Time Reporting

This subject area supports historic analysis of agreements.

Time dimension is linked to Document Date for version zero.

Transactional Grain

The grain is at the agreement price break level.

Special Considerations

None.

Procurement—Purchase Orders

Description

This is a detailed subject area that combines the information from purchase orders, purchase order costs and purchase schedules with the ability to report on committed amounts, contract spend and purchase orders of the suppliers of an organization across suppliers, company, products, item categories and associated hierarchies at purchase order line level.

Business Questions

This subject area can answer the following business questions:

• Is a company using strategic suppliers and contracts effectively?
• What are my purchase volume across business units?
• How is purchase distributed across suppliers?
• What are my lead time standard and variances in purchase cycles?
• How many approvers on a average are approving purchase orders?
• What are cycle times in terms of PR and PO Approval, PR to PO conversion?
• What is my contract vs off contract spend?
• What are purchase orders creation sources and corresponding requisition sources?
• What commodities and services have been purchased, in what volume and price?
• How many times are we amending purchase orders and whether amendment initiation is internal or external?

Job Roles

The following job roles secure access to this subject area:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis

Duty Roles

The following duty roles secure access to this subject area:

• Procurement Purchase Order Analysis Duty

Primary Navigation

Home > Procurement

Time Reporting

This subject area supports historic analysis of purchase orders.

Time dimension is linked to Purchase Order Document Date for version zero (Implement Date for version zero).

Transactional Grain

The grain is at the purchase order distribution level.

Special Considerations

None.

Procurement—Receipts

Description

This is a detailed subject area that provides the ability to report on actual spend and purchase receipts of the suppliers of an organization across suppliers, company, location, products, item categories and associated hierarchies at purchase receipt line level, including reporting based on receiving time.

Business Questions

This subject area can answer the following business questions:

• What are return rates for suppliers?
• What are my processing and post processing lead time standards and variances for an Item?
• Which suppliers deliver consistently on time?
• What is accepted and rejected rates for commodities, by suppliers?
• What receipts are created manually or through ASNs?
• When were products shipped and what is the average delivery times?

Job Roles

The following job roles secure access to this subject area:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis
• Warehouse Manager

Duty Roles

The following duty roles secure access to this subject area:

• Procurement Purchase Receipts Analysis Duty

Primary Navigation

Home > Procurement

Time Reporting

This subject area supports historic analysis of receipts.

Time dimension is linked to Receipt Header Creation Date.

Transactional Grain

The grain is at the receipt lines level.

Special Considerations

None.

Procurement — Requisitions

Description

This is a detailed subject area that provides the ability to analyze key metrics on requested spend and purchase requisitions for the enterprise across suppliers, company, business units, products, item categories and associated hierarchies at purchase requisition line level.

Business Questions

This subject area can answer the following business questions:

• What is the classification of purchase requisitions by status, type, source of created for a period and associated purchase order details?

• How many non-catalog purchase requisitions are created by volume, item, and amount?

• How long does it take for purchase requisitions to get approved?

• What is the centralized view of all procurement requests for purchasing department?

Job Roles

The following job roles secure access to this subject area:

• Buyer

• Category Manager

• Procurement Contract Administrator

• Procurement Manager

• Purchase Analysis

Duty Roles

The following duty roles secure access to this subject area:

• Procurement Requisitions Analysis Duty

Primary Navigation

Home > Procurement

Time Reporting

This subject area supports historic analysis of requisitions.

Time dimension is linked to Requisition Header Date.

Transactional Grain

The grain is at the purchase requisition distribution.

Special Considerations

None.

Procurement—Spend

Description

This detailed subject area provides the ability to report on total spending of an organization across suppliers, products, item categories, business units, cost centers, buying locations, supplier locations, and associated hierarchy.

Business Questions

This subject area can answer the following business questions:

• How much did the organization spend with suppliers, commodities, buyers, cost center, contracts vs non contracts, leakage etc.?
• Identify items and categories with cost-saving potential in procurement operations based on prices.
• Identify the key areas for improving process efficiencies.
• Identify items, categories, and suppliers with compliance issues in their purchase agreements.

Job Roles

The following job roles secure access to this subject area:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor
• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis

Duty Roles

The following duty roles secure access to this subject area:

• Procurement Spend Analysis Duty

Primary Navigation

Home > Procurement

Time Reporting

This subject area supports historic analysis of expense distributions.

Time dimension is linked to Invoice Date.

Transactional Grain

The grain is at the AP invoice expense distribution level.

Special Considerations

None.

Business Questions

Overview

For each business question in this chapter, links are provided for more detailed information about the subject areas, job roles, and duty roles associated with the business question.

What is the trend of AP for last 8 quarters?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Balance Sheet

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst

• General Accountant

• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Balance Sheet Analysis Duty

How are my asset balances tracking across regions (COA) for last 2 years?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Balance Sheet

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst

• General Accountant

• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Balance Sheet Analysis Duty

What are the CapEx requirements in near future? Will PPE hold up, or will an early capital infusion be needed?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Balance Sheet

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst

• General Accountant

• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Balance Sheet Analysis Duty

What is the working capital position and trend for past x quarters?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Balance Sheet

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst

• General Accountant

• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Balance Sheet Analysis Duty

How is debt equity mix structured at present, and is it actionable for improved financial gearing?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Balance Sheet

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst

• General Accountant

• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Balance Sheet Analysis Duty

What is the trend of Gross Margins for past 2 years across business units?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Profitability

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst

• General Accountant

• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Profitability Analysis Duty

What is the composition of fixed cost elements vs variable cost elements for past 2 years?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Profitability

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst

• General Accountant

• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Profitability Analysis Duty

What is the proportion of operating profits taken up by interest and financing cost?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Profitability

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst

• General Accountant

• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Profitability Analysis Duty

What is the trend around operating and net margins for past 2 years?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Profitability

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst

• General Accountant

• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Profitability Analysis Duty

How is the trend analysis for journals from subledger sources against manual GL journals, both in terms of amount and volume?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Detail Transactions

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst

• General Accountant

• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Detail Transactions Analysis Duty

What is the pattern of bookings in tax sensitive GL accounts in comparison to revenue and cost?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Detail Transactions

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst

• General Accountant

• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Detail Transactions Analysis Duty

What is the QoQ, YoY trend for accrual bookings due for reversal in next accounting period?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Detail Transactions

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst

• General Accountant

• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Detail Transactions Analysis Duty

What are the details of entries booked in GL for reclassification from expense to assets and vice versa?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Detail Transactions

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst

• General Accountant

• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Detail Transactions Analysis Duty

What is the count and amount of invoices processed for the period by business units and trend comparison?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Invoices

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Invoices Analysis Duty

What are the invoice types processed by AP department and the payment methods used to understand the downstream activities?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Invoices

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Invoices Analysis Duty

What is the validation, approval and accounting status of invoices processed during the period?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Invoices

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Invoices Analysis Duty

No. of invoices paid vs unpaid including partly paid with amount?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Invoices

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Invoices Analysis Duty

Analysis around payment terms by transaction type, transaction source for the invoices processed?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Invoices

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Invoices Analysis Duty

What is the count and amount of payments processed for the period by business units and trend comparison?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Payments

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Payments Analysis Duty

What is the ratio of on-time payment performance?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Payments

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Payments Analysis Duty

What is the count and amount of overdue payments?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Payments

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Payments Analysis Duty

What is the average supplier payment days by BU's?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Payments

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Payments Analysis Duty

What are the interest penalties paid by amount and percentage?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Payments

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Payments Analysis Duty

What are the liabilities distribution details of AP Balances?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Liabilities

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Liabilities Analysis Duty

What is the accounting status of liability distributions by invoices?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Liabilities

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Liabilities Analysis Duty

What is the average time available to pay off the outstanding AP invoices?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Aging

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Aging Analysis Duty

What is the count and value of AP invoices overdue?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Aging

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Aging Analysis Duty

What is the summary of AP invoices across aging buckets, count, and value?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Aging

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Aging Analysis Duty

What is the trend of outstanding AP Balances at consolidated level, supplier level, and Business Unit level?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Aging

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Aging Analysis Duty

How are AP balances trending for a particular supplier over last 8 quarters?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Aging

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Aging Analysis Duty

What are the top 10 suppliers with maximum AP outstanding?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Aging

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Aging Analysis Duty

Whether the company was able to meet the guided revenue growth for past quarters or years?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Budgets

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst

• General Accountant

• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Budget Analysis Duty

How is the actual performance vs the budgeted performance of top Balance Sheet metrics for the last quarter or year?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Budgets

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst
• General Accountant
• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Budget Analysis Duty

What is the trend for profitability metrics actual vs budget and direction of variance?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Budgets

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst
• General Accountant
• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Budget Analysis Duty

Is higher than anticipated OPEX a one-off case or how is the trend for past eight quarters?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Budgets

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst
• General Accountant
• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Budget Analysis Duty

What is the split of budgeted receivables by entity or ledgers?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Budgets

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst
• General Accountant
• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Budget Analysis Duty

What is the budgeted revenue activity on monthly or quarterly basis?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Budgets

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst
• General Accountant
• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Budget Analysis Duty

What is the target revenue for next quarter in best case and worst case scenario?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—GL Budgets

Job Roles

The following job roles secure access to the data related to this business question:

• Financial Analyst
• General Accountant
• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Budget Analysis Duty

What is the count and amount of AP Invoices that have either Header Level Hold, Line Level Hold, or combination?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Holds

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Holds Analysis Duty

What is the outstanding AP amount for AP Invoices on Holds?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Holds

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Holds Analysis Duty

What is the current AP amount out of outstanding AP amount for Invoices on Hold?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Holds

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Holds Analysis Duty

What is the overdue AP amount out of outstanding AP amount for Invoices on Hold?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Holds

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Holds Analysis Duty

What is the average number of days for invoices on hold and the trend for past six quarters?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Holds

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Holds Analysis Duty

What is the count and amount of AP Invoices on Hold due to distribution variances?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Holds

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Holds Analysis Duty

What is the count and amount of AP Invoices on Hold due to PO matching variances?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Holds

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Holds Analysis Duty

What is the count and amount of AP Invoices on Hold due to supplier site limits?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Holds

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Holds Analysis Duty

What is the split of invoices on Hold by manual holds vs system holds?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Holds

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Holds Analysis Duty

What is the summary of invoices (count and amount) by various hold reasons and hold by user?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Holds

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Holds Analysis Duty

What is the summary of invoices (count and amount) by various release reasons and released by user?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Holds

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Holds Analysis Duty

What is the amount of AP Expenses by each Business Unit?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Expenses

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Expenses Analysis Duty

What is the trend of AP Expenses for the past six quarters?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Expenses

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist

• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Expenses Analysis Duty

What is the distribution of AP Expenses by top 10 suppliers?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Expenses

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Expenses Analysis Duty

What is the distribution of AP Expenses by the top five Natural Accounts or Financial Categories?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Expenses

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Expenses Analysis Duty

What is the distribution of AP Expenses by each of the cost center?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AP Expenses

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Payable Expenses Analysis Duty

What is the count and amount of transactions processed over the period of time?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AR Transactions

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Transactions Analysis Duty

What is the classification of transactions processed during the period by Transaction Type and Source?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AR Transactions

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Transactions Analysis Duty

What are the payment terms and receipt methods associated with the transactions?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AR Transactions

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Transactions Analysis Duty

What is the summary of Transactions by statuses?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AR Transactions

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Transactions Analysis Duty

What is the count and amount of receipts processed over the period of time?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AR Receipts and Applications

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Receipts and Applications Analysis Duty

What is the count and amount of applied receipts?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AR Receipts and Applications

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Receipts and Applications Analysis Duty

What is the count and amount of unapplied receipts?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AR Receipts and Applications

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Receipts and Applications Analysis Duty

What is the trend for Average Receipt Days?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AR Receipts and Applications

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Receipts and Applications Analysis Duty

What is the analysis of due and overdue receipts?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AR Receipts and Applications

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Receipts and Applications Analysis Duty

What is the amount of discount Taken vs Lost?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AR Receipts and Applications

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Receipts and Applications Analysis Duty

What is the count and amount of credit memo applications during the period?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—AR Credit Memo Applications

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Credit Memo Applications Analysis Duty

What is the analysis of credit memo applications by Business Unit, Time Period, Customers, GL Accounts, and so on?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Credit Memo Applications

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Credit Memo Applications Analysis Duty

What is the status of CM application transactions?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Credit Memo Applications

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Credit Memo Applications Analysis Duty

What is the count and amount of AR Adjustments processed during the period?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Adjustments

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Adjustments Analysis Duty

What is the analysis of AR Adjustments by Business Unit, Time Period, Customers, GL Accounts, and so on?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Adjustments

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Adjustments Analysis Duty

What is the ratio of AR Adjustments applications to Invoice %?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Adjustments

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Adjustments Analysis Duty

What is the status of AR Adjustments?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Adjustments

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Adjustments Analysis Duty

What is the count and value of AR invoices Overdue?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Aging

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Aging Analysis Duty

What is the count and value of AR Invoices Current?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Aging

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Aging Analysis Duty

What is the summary of AR invoices across aging buckets, count and value?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Aging

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Aging Analysis Duty

What is the summary of AR invoices overdue with respect to their aging buckets and payment terms?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Aging

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Aging Analysis Duty

What is the trend of outstanding AR Balances by Customer or Business Unit?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Aging

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Aging Analysis Duty

What is the AR account activity for the period and balance amount by Business Unit?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Aging

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Aging Analysis Duty

How are AR balances trending for a particular customer over the last eight quarters?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Aging

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Aging Analysis Duty

What are the top 10 customers with maximum AR outstanding?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Aging

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Aging Analysis Duty

What is the trend for operating revenue for past 6 quarters by Ledger, Legal Entity, Billing BU, etc?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Revenue

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Revenue Analysis Duty

What is the revenue mix by geography, business units, product lines, SKU, key customers, transaction source, transaction type?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Revenue

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Revenue Analysis Duty

What is the distribution of Revenue by top 10 customer accounts?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Revenue

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Revenue Analysis Duty

What is the contribution of non operating revenue and trend for past quarters?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Revenue

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Revenue Analysis Duty

What is the distribution of revenue by top 5 revenue accounts?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Revenue

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Revenue Analysis Duty

What is the amount of deferred revenue further classified by long term and short term deferred revenue?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Revenue

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Revenue Analysis Duty

What is the revenue recognition for the fiscal period in comparison to billings in prior periods (Bill in Advance) or billing in future (Bill in Arrears)?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Revenue

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Revenue Analysis Duty

What is the breakdown of inter company revenue vs external revenue based on AR transaction type, transaction source?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Revenue

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Revenue Analysis Duty

What is the Revenue mix from services, subscription fees, material installation, merchant fees, sale of goods, etc?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Revenue

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Revenue Analysis Duty

What is the summary as well as detailed analysis of revenue vs billed amount (including taxes) in Transaction Currency, Ledger Currency, Analytics Currency?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - AR Revenue

Job Roles

The following job roles secure access to the data related to this business question:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Duty Roles

The following duty roles secure access to the data related to this business question:

• Accounts Receivable Revenue Analysis Duty

How to reconcile GL Balances/Journals and all contributing subledger transactions including manual journals in GL with post SLA accounting details in a single consolidate report?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - GL Account Analysis

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor
• Accounts Receivable Manager
• Accounts Receivable Specialist
• Financial Analyst
• General Accountant
• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Account Analysis Duty

How to analyze GL Balances/Journals with the ability to get the extended details of subledger transaction attributes and accounting events?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - GL Account Analysis

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor
• Accounts Receivable Manager
• Accounts Receivable Specialist
• Financial Analyst
• General Accountant
• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Account Analysis Duty

How to get consolidated abstract view of GL account activity for a period and associated subledger transaction activity?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - GL Account Analysis

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor
• Accounts Receivable Manager
• Accounts Receivable Specialist
• Financial Analyst
• General Accountant
• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Account Analysis Duty

How to facilitate intuitive drill to details for GL Balances, Journals or subledger transactions for detailed analysis with minimum number of clicks?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - GL Account Analysis

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor
• Accounts Receivable Manager
• Accounts Receivable Specialist
• Financial Analyst
• General Accountant
• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Account Analysis Duty

How to support account analysis across multi period, multi ledger at detailed or roll up account levels across Chart of Account Segments?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - GL Account Analysis

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor
• Accounts Receivable Manager
• Accounts Receivable Specialist
• Financial Analyst
• General Accountant
• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Account Analysis Duty

How to monitor GL accounts with respect to accounting and posting activity for all contributing transactions during an accounting period?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials - GL Account Analysis

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor
• Accounts Receivable Manager
• Accounts Receivable Specialist
• Financial Analyst
• General Accountant
• General Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• General Ledger Account Analysis Duty

How much did the organization spend with suppliers, commodities, buyers, cost center, contracts vs non contracts, leakage etc.?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement - Spend

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor
• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Spend Analysis Duty

Identify items and categories with cost-saving potential in procurement operations based on prices.

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement - Spend

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor
• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Spend Analysis Duty

Identify the key areas for improving process efficiencies.

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement - Spend

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor
• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Spend Analysis Duty

Identify items, categories, and suppliers with compliance issues in their purchase agreements.

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement - Spend

Job Roles

The following job roles secure access to the data related to this business question:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor
• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Spend Analysis Duty

What is the employee expense Spend by Business Units?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—EXM Employee Expenses

Job Roles

The following job roles secure access to the data related to this business question:

• Expense Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Employee Expense Analysis Duty

What are the top expense reports which are paid?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—EXM Employee Expenses

Job Roles

The following job roles secure access to the data related to this business question:

• Expense Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Employee Expense Analysis Duty

What is the total expenses by number of expense reports for employee, manager, organization, cost centers?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—EXM Employee Expenses

Job Roles

The following job roles secure access to the data related to this business question:

• Expense Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Employee Expense Analysis Duty

What is the Total Expense Trend for last few quarters?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—EXM Employee Expenses

Job Roles

The following job roles secure access to the data related to this business question:

• Expense Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Employee Expense Analysis Duty

Which are top cost centers by employee expenses?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—EXM Employee Expenses

Job Roles

The following job roles secure access to the data related to this business question:

• Expense Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Employee Expense Analysis Duty

What is the expense breakdown by expense type?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—EXM Employee Expenses

Job Roles

The following job roles secure access to the data related to this business question:

• Expense Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Employee Expense Analysis Duty

What is the number of expenses which are filed late?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—EXM Employee Expenses

Job Roles

The following job roles secure access to the data related to this business question:

• Expense Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Employee Expense Analysis Duty

Who are the top managers by expenses?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—EXM Employee Expenses

Job Roles

The following job roles secure access to the data related to this business question:

• Expense Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Employee Expense Analysis Duty

Which are the top cost centers and organizations with Audit violations for expense reports which are paid?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—EXM Employee Expenses

Job Roles

The following job roles secure access to the data related to this business question:

• Expense Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Employee Expense Analysis Duty

What is the percentage of reports which are Auto approved?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—EXM Employee Expenses

Job Roles

The following job roles secure access to the data related to this business question:

• Expense Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Employee Expense Analysis Duty

What is the trend in Credit vs Cash expense?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—EXM Employee Expenses

Job Roles

The following job roles secure access to the data related to this business question:

• Expense Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Employee Expense Analysis Duty

What are the cycle times for report submission, filing, approvals?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials—EXM Employee Expenses

Job Roles

The following job roles secure access to the data related to this business question:

• Expense Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Employee Expense Analysis Duty

What commodities and services have been purchased, in what volume and price?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Purchase Orders

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Order Analysis Duty

How is purchase distributed across suppliers?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Purchase Orders

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer

• Category Manager

• Procurement Contract Administrator

• Procurement Manager

• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Order Analysis Duty

Is a company using strategic suppliers and contracts effectively?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Purchase Orders

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Order Analysis Duty

What are my purchase volume across business units?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Purchase Orders

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Order Analysis Duty

What is my contract vs off contract spend?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Purchase Orders

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Order Analysis Duty

What are cycle times in terms of PR and PO Approval, PR to PO conversion?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Purchase Orders

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Order Analysis Duty

How many times are we amending purchase orders and whether amendment initiation is internal or external?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Purchase Orders

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Order Analysis Duty

How many approvers on a average are approving purchase orders?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Purchase Orders

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Procurement Manager
• Category Manager
• Procurement Contract Administrator
• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Order Analysis Duty

What are my lead time standard and variances in purchase cycles?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Purchase Orders

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Procurement Manager
• Category Manager
• Procurement Contract Administrator
• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Order Analysis Duty

What are purchase orders creation sources and corresponding requisition sources?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Purchase Orders

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Order Analysis Duty

When were products shipped and what is the average delivery times?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Receipts

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis
• Warehouse Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Receipts Analysis Duty

Which suppliers deliver consistently on time?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Receipts

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis
• Warehouse Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Receipts Analysis Duty

What is accepted and rejected rates for commodities, by suppliers?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Receipts

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis
• Warehouse Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Receipts Analysis Duty

What are return rates for suppliers?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Receipts

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis
• Warehouse Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Receipts Analysis Duty

What receipts are created manually or through ASNs?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Receipts

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis
• Warehouse Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Receipts Analysis Duty

What are my processing and post processing lead time standards and variances for an Item?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Receipts

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis
• Warehouse Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Receipts Analysis Duty

What are my products and services for which we have agreements?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Agreements

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Agreement Analysis Duty

What are the agreements utilization rates?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Agreements

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Agreement Analysis Duty

Which agreements are under utilized?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Agreements

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Agreement Analysis Duty

Which agreements are utilized before expiry?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Agreements

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Agreement Analysis Duty

What are the creation sources for agreements?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Agreements

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Agreement Analysis Duty

What are my cycle times for agreement approvals?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Agreements

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Agreement Analysis Duty

What are my negotiation to agreement approval cycle times?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Agreements

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Agreement Analysis Duty

How many times are we amending agreements and whether amendment initiation is internal or external?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Agreements

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer
• Procurement Manager
• Category Manager
• Procurement Contract Administrator

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Agreement Analysis Duty

How many approvers on a average are approving agreements?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement—Agreements

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer

• Category Manager

• Procurement Contract Administrator

• Procurement Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Purchase Agreement Analysis

How long does it take for purchase requisitions to get approved?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement — Requisitions

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer

• Category Manager

• Procurement Contract Administrator

• Procurement Manager

• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Requisitions Analysis Duty

What is the centralized view of all procurement requests for purchasing department?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement — Requisitions

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer

• Category Manager

• Procurement Contract Administrator

• Procurement Manager

• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Requisitions Analysis Duty

What is the classification of purchase requisitions by status, type, source of created for a period and associated purchase order details?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement — Requisitions

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer

• Category Manager

• Procurement Contract Administrator

• Procurement Manager

• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Requisitions Analysis Duty

How many non-catalog purchase requisitions are created by volume, item, and amount?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Procurement — Requisitions

Job Roles

The following job roles secure access to the data related to this business question:

• Buyer

• Category Manager

• Procurement Contract Administrator

• Procurement Manager

• Purchase Analysis

Duty Roles

The following duty roles secure access to the data related to this business question:

• Procurement Requisitions Analysis Duty

What is the actual cost by Project and Task?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• PPM — Project Costs

Job Roles

The following job roles secure access to the data related to this business question:

• Project Accountant

• Project Administrator

• Project Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Project Costing Costs Analysis Duty

What is the actual cost by Project Type?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• PPM — Project Costs

Job Roles

The following job roles secure access to the data related to this business question:

• Project Accountant

• Project Administrator

• Project Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Project Costing Costs Analysis Duty

What is the actual cost by Project Organization?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• PPM — Project Costs

Job Roles

The following job roles secure access to the data related to this business question:

• Project Accountant

• Project Administrator

• Project Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Project Costing Costs Analysis Duty

What is the actual cost by GL Account for a specific period?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• PPM — Project Costs

Job Roles

The following job roles secure access to the data related to this business question:

• Project Accountant

• Project Administrator

• Project Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Project Costing Costs Analysis Duty

What are the expenditures that contributed to the actual costs?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• PPM — Project Costs

Job Roles

The following job roles secure access to the data related to this business question:

• Project Accountant

• Project Administrator

• Project Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Project Costing Costs Analysis Duty

What are the costs by expenditure type and category?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• PPM — Project Costs

Job Roles

The following job roles secure access to the data related to this business question:

• Project Accountant

• Project Administrator

• Project Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Project Costing Costs Analysis Duty

What % of costs have been Capitalized?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• PPM — Project Costs

Job Roles

The following job roles secure access to the data related to this business question:

• Project Accountant

• Project Administrator

• Project Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Project Costing Costs Analysis Duty

What % of cost have been billed?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• PPM — Project Costs

Job Roles

The following job roles secure access to the data related to this business question:

• Project Accountant

• Project Administrator

• Project Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Project Costing Costs Analysis Duty

What is the actual cost by Project Class codes?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• PPM — Project Costs

Job Roles

The following job roles secure access to the data related to this business question:

• Project Accountant

• Project Administrator

• Project Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Project Costing Costs Analysis Duty

What are the ITD, YTD and PTD actual costs?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• PPM — Project Costs

Job Roles

The following job roles secure access to the data related to this business question:

• Project Accountant

• Project Administrator

• Project Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Project Costing Costs Analysis Duty

What is the Labor cost and effort breakup by Employee, Job?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• PPM — Project Costs

Job Roles

The following job roles secure access to the data related to this business question:

• Project Accountant

• Project Administrator

• Project Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Project Costing Costs Analysis Duty

What is the trend of cost?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• PPM — Project Costs

Job Roles

The following job roles secure access to the data related to this business question:

• Project Accountant

• Project Administrator

• Project Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Project Costing Costs Analysis Duty

What is the total project cost by Project Organization, Project Type, Expenditure type, Expenditure Category, Expenditure Organization?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• PPM — Project Costs

Job Roles

The following job roles secure access to the data related to this business question:

• Project Accountant

• Project Administrator

• Project Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Project Costing Costs Analysis Duty

What is the trend of Project Cost by Organization, Project type etc?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• PPM — Project Costs

Job Roles

The following job roles secure access to the data related to this business question:

• Project Accountant

• Project Administrator

• Project Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Project Costing Costs Analysis Duty

What is the overall net book value for PP&E assets and trend over multiple periods by entity, asset book,etc?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials — Assets Analysis

Job Roles

The following job roles secure access to the data related to this business question:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Fixed Asset Analysis Duty

What is the period active asset unit details for particular asset category and trend details?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials — Assets Analysis

Job Roles

The following job roles secure access to the data related to this business question:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Fixed Asset Analysis Duty

What is the period active asset mix across various asset categories?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials — Assets Analysis

Job Roles

The following job roles secure access to the data related to this business question:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Fixed Asset Analysis Duty

What is the asset mix across various asset types CIP, Capitalized, Expensed?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials — Assets Analysis

Job Roles

The following job roles secure access to the data related to this business question:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Fixed Asset Analysis Duty

What are the period wise last active asset employee assignment details?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials — Assets Analysis

Job Roles

The following job roles secure access to the data related to this business question:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Fixed Asset Analysis Duty

Summary of assets by original cost, salvage value, net book value by entity, category, time historic, etc.

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials — Assets Analysis

Job Roles

The following job roles secure access to the data related to this business question:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Fixed Asset Analysis Duty

What is the average life of asset by asset category?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials — Assets Analysis

Job Roles

The following job roles secure access to the data related to this business question:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Fixed Asset Analysis Duty

What is summary of assets which has exceeded economic life or nearby end of life?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials — Assets Analysis

Job Roles

The following job roles secure access to the data related to this business question:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Fixed Asset Analysis Duty

How to track asset book health, lifecycle tracking with historic data?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials — Assets Analysis

Job Roles

The following job roles secure access to the data related to this business question:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Fixed Asset Analysis Duty

What is the summary of asset addition/ CapEx for a particular entity, asset book, asset category?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials — Assets Transactions

Job Roles

The following job roles secure access to the data related to this business question:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Fixed Asset Transactions Analysis Duty

What are the source document details for asset additions?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials — Assets Transactions

Job Roles

The following job roles secure access to the data related to this business question:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Fixed Asset Transactions Analysis Duty

What is the trend of asset retirement over a period of time in terms of cost retired, NBV retired?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials — Assets Transactions

Job Roles

The following job roles secure access to the data related to this business question:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Fixed Asset Transactions Analysis Duty

What are the details of asset retired by various asset categories?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials — Assets Transactions

Job Roles

The following job roles secure access to the data related to this business question:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Fixed Asset Analysis Duty

What is the average cost of removal per unit for retired assets?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials — Assets Transactions

Job Roles

The following job roles secure access to the data related to this business question:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Fixed Asset Transactions Analysis Duty

What is the amount of assets revalued during past 6 quarters?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials — Assets Transactions

Job Roles

The following job roles secure access to the data related to this business question:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Fixed Asset Transactions Analysis Duty

What is the amount and quantity of assets reclassified during the period?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials — Assets Transactions

Job Roles

The following job roles secure access to the data related to this business question:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Fixed Asset Transactions Analysis Duty

What is the amount and quantity of assets adjusted by transaction type and GL accounts, segments?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

• Financials — Assets Transactions

Job Roles

The following job roles secure access to the data related to this business question:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to the data related to this business question:

• Fixed Asset Transactions Analysis Duty

Job Roles

Overview

For each job role in this chapter, links are provided for more detailed information about the duty roles, subject areas, and business questions associated with the job role.

Account Payable Invoice Supervisor

Code Name

ORA_AP_ACCOUNTS_PAYABLE_INVOICE_SUPERVISOR_JOB

Duty Roles

This job role is related to the following duty roles:

• Accounts Payable Aging Analysis Duty

• Accounts Payable Expenses Analysis Duty

• Accounts Payable Holds Analysis Duty

• Accounts Payable Invoices Analysis Duty

• Accounts Payable Liabilities Analysis Duty

• Accounts Payable Payments Analysis Duty

• General Ledger Account Analysis Duty

• Procurement Spend Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Financials—AP Holds

• Financials—AP Aging

• Financials—AP Expenses

• Financials—AP Invoices

• Financials—AP Liabilities

• Financials—AP Payments

• Financials—GL Account Analysis

• Procurement—Spend

Business Questions

This job role secures access to data that can answer the following business questions:

• What are the liabilities distribution details of AP Balances?

• What is the accounting status of liability distributions by invoices?

• What is the average time available to pay off the outstanding AP invoices?

• What are the top 10 suppliers with maximum AP outstanding?

• What is the summary of invoices (count and amount) by various release reasons and released by user?

• What is the amount of AP Expenses by each Business Unit?

• How much did the organization spend with suppliers, commodities, buyers, cost center, contracts vs non contracts, leakage etc.?

• Identify items and categories with cost-saving potential in procurement operations based on prices.

• What is the count and value of AP invoices overdue?

• How to monitor GL accounts with respect to accounting and posting activity for all contributing transactions during an accounting period?

• What is the summary of AP invoices across aging buckets, count, and value?

• How are AP balances trending for a particular supplier over last 8 quarters?

• What is the outstanding AP amount for AP Invoices on Holds?

• How to reconcile GL Balances/Journals and all contributing subledger transactions including manual journals in GL with post SLA accounting details in a single consolidate report?

• How to get consolidated abstract view of GL account activity for a period and associated subledger transaction activity?

• What is the count and amount of invoices processed for the period by business units and trend comparison?

• What is the validation, approval and accounting status of invoices processed during the period?

• What is the count and amount of payments processed for the period by business units and trend comparison?

• What is the average supplier payment days by BU's?

• What is the trend of outstanding AP Balances at consolidated level, supplier level, and Business Unit level?

• What is the current AP amount out of outstanding AP amount for Invoices on Hold?

• What is the overdue AP amount out of outstanding AP amount for Invoices on Hold?

• What is the count and amount of AP Invoices on Hold due to PO matching variances?

• What is the summary of invoices (count and amount) by various hold reasons and hold by user?

• What is the distribution of AP Expenses by top 10 suppliers?

• How to facilitate intuitive drill to details for GL Balances, Journals or subledger transactions for detailed analysis with minimum number of clicks?

• Identify the key areas for improving process efficiencies.

• What are the invoice types processed by AP department and the payment methods used to understand the downstream activities?

• No. of invoices paid vs unpaid including partly paid with amount?

• What is the ratio of on-time payment performance?

• What is the count and amount of overdue payments?

• What are the interest penalties paid by amount and percentage?

• What is the count and amount of AP Invoices on Hold due to distribution variances?

• What is the split of invoices on Hold by manual holds vs system holds?

• What is the distribution of AP Expenses by the top five Natural Accounts or Financial Categories?

• How to analyze GL Balances/Journals with the ability to get the extended details of subledger transaction attributes and accounting events?

• What is the average number of days for invoices on hold and the trend for past six quarters?

• What is the distribution of AP Expenses by each of the cost center?

• How to support account analysis across multi period, multi ledger at detailed or roll up account levels across Chart of Account Segments?

• Identify items, categories, and suppliers with compliance issues in their purchase agreements.

• Analysis around payment terms by transaction type, transaction source for the invoices processed?

• What is the count and amount of AP Invoices that have either Header Level Hold, Line Level Hold, or combination?

• What is the count and amount of AP Invoices on Hold due to supplier site limits?

• What is the trend of AP Expenses for the past six quarters?

Account Payable Payment Supervisor

Code Name

ORA_AP_ACCOUNTS_PAYABLE_PAYMENT_SUPERVISOR_JOB

Duty Roles

This job role is related to the following duty roles:

• Accounts Payable Aging Analysis Duty

• Accounts Payable Expenses Analysis Duty

• Accounts Payable Holds Analysis Duty

• Accounts Payable Invoices Analysis Duty

• Accounts Payable Liabilities Analysis Duty

• Accounts Payable Payments Analysis Duty

• General Ledger Account Analysis Duty

• Procurement Spend Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Financials—AP Holds

• Financials—AP Aging

• Financials—AP Expenses

• Financials—AP Invoices

• Financials—AP Liabilities

• Financials—AP Payments

• Financials—GL Account Analysis

• Procurement—Spend

Business Questions

This job role secures access to data that can answer the following business questions:

• What are the liabilities distribution details of AP Balances?

• What is the accounting status of liability distributions by invoices?

• What is the average time available to pay off the outstanding AP invoices?

• What are the top 10 suppliers with maximum AP outstanding?

• What is the summary of invoices (count and amount) by various release reasons and released by user?

• What is the amount of AP Expenses by each Business Unit?

• How much did the organization spend with suppliers, commodities, buyers, cost center, contracts vs non contracts, leakage etc.?

• Identify items and categories with cost-saving potential in procurement operations based on prices.

• What is the count and value of AP invoices overdue?

• How to monitor GL accounts with respect to accounting and posting activity for all contributing transactions during an accounting period?

• What is the summary of AP invoices across aging buckets, count, and value?

• How are AP balances trending for a particular supplier over last 8 quarters?

• What is the outstanding AP amount for AP Invoices on Holds?

• How to reconcile GL Balances/Journals and all contributing subledger transactions including manual journals in GL with post SLA accounting details in a single consolidate report?

• How to get consolidated abstract view of GL account activity for a period and associated subledger transaction activity?

• What is the count and amount of invoices processed for the period by business units and trend comparison?

• What is the validation, approval and accounting status of invoices processed during the period?

• What is the count and amount of payments processed for the period by business units and trend comparison?

• What is the average supplier payment days by BU's?

• What is the trend of outstanding AP Balances at consolidated level, supplier level, and Business Unit level?

• What is the current AP amount out of outstanding AP amount for Invoices on Hold?

• What is the overdue AP amount out of outstanding AP amount for Invoices on Hold?

• What is the count and amount of AP Invoices on Hold due to PO matching variances?

• What is the summary of invoices (count and amount) by various hold reasons and hold by user?

• What is the distribution of AP Expenses by top 10 suppliers?

• How to facilitate intuitive drill to details for GL Balances, Journals or subledger transactions for detailed analysis with minimum number of clicks?

• Identify the key areas for improving process efficiencies.

• What are the invoice types processed by AP department and the payment methods used to understand the downstream activities?

• No. of invoices paid vs unpaid including partly paid with amount?

• What is the ratio of on-time payment performance?

• What is the count and amount of overdue payments?

• What are the interest penalties paid by amount and percentage?

• What is the count and amount of AP Invoices on Hold due to distribution variances?

• What is the split of invoices on Hold by manual holds vs system holds?

• What is the distribution of AP Expenses by the top five Natural Accounts or Financial Categories?

• How to analyze GL Balances/Journals with the ability to get the extended details of subledger transaction attributes and accounting events?

• What is the average number of days for invoices on hold and the trend for past six quarters?

• What is the distribution of AP Expenses by each of the cost center?

• How to support account analysis across multi period, multi ledger at detailed or roll up account levels across Chart of Account Segments?

• Identify items, categories, and suppliers with compliance issues in their purchase agreements.

• Analysis around payment terms by transaction type, transaction source for the invoices processed?

• What is the count and amount of AP Invoices that have either Header Level Hold, Line Level Hold, or combination?

• What is the count and amount of AP Invoices on Hold due to supplier site limits?

• What is the trend of AP Expenses for the past six quarters?

Accounts Payable Manager

Code Name

ORA_AP_ACCOUNTS_PAYABLE_MANAGER_JOB

Duty Roles

This job role is related to the following duty roles:

• Accounts Payable Aging Analysis Duty

• Accounts Payable Expenses Analysis Duty

• Accounts Payable Holds Analysis Duty

• Accounts Payable Invoices Analysis Duty

• Accounts Payable Liabilities Analysis Duty

• Accounts Payable Payments Analysis Duty

• General Ledger Account Analysis Duty

• Procurement Spend Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Financials—AP Holds

• Financials—AP Aging

• Financials—AP Expenses

• Financials—AP Invoices

• Financials—AP Liabilities

• Financials—AP Payments

• Financials—GL Account Analysis

• Procurement—Spend

Business Questions

This job role secures access to data that can answer the following business questions:

• What are the liabilities distribution details of AP Balances?

• What is the accounting status of liability distributions by invoices?

• What is the average time available to pay off the outstanding AP invoices?

• What are the top 10 suppliers with maximum AP outstanding?

• What is the summary of invoices (count and amount) by various release reasons and released by user?

• What is the amount of AP Expenses by each Business Unit?

• How much did the organization spend with suppliers, commodities, buyers, cost center, contracts vs non contracts, leakage etc.?

• Identify items and categories with cost-saving potential in procurement operations based on prices.

• What is the count and value of AP invoices overdue?

• How to monitor GL accounts with respect to accounting and posting activity for all contributing transactions during an accounting period?

• What is the summary of AP invoices across aging buckets, count, and value?

• How are AP balances trending for a particular supplier over last 8 quarters?

• What is the outstanding AP amount for AP Invoices on Holds?

• How to reconcile GL Balances/Journals and all contributing subledger transactions including manual journals in GL with post SLA accounting details in a single consolidate report?

• How to get consolidated abstract view of GL account activity for a period and associated subledger transaction activity?

• What is the count and amount of invoices processed for the period by business units and trend comparison?

• What is the validation, approval and accounting status of invoices processed during the period?

• What is the count and amount of payments processed for the period by business units and trend comparison?

• What is the average supplier payment days by BU's?

• What is the trend of outstanding AP Balances at consolidated level, supplier level, and Business Unit level?

• What is the current AP amount out of outstanding AP amount for Invoices on Hold?

• What is the overdue AP amount out of outstanding AP amount for Invoices on Hold?

• What is the count and amount of AP Invoices on Hold due to PO matching variances?

• What is the summary of invoices (count and amount) by various hold reasons and hold by user?

• What is the distribution of AP Expenses by top 10 suppliers?

• How to facilitate intuitive drill to details for GL Balances, Journals or subledger transactions for detailed analysis with minimum number of clicks?

• Identify the key areas for improving process efficiencies.

• What are the invoice types processed by AP department and the payment methods used to understand the downstream activities?

• No. of invoices paid vs unpaid including partly paid with amount?

• What is the ratio of on-time payment performance?

• What is the count and amount of overdue payments?

• What are the interest penalties paid by amount and percentage?

• What is the count and amount of AP Invoices on Hold due to distribution variances?

• What is the split of invoices on Hold by manual holds vs system holds?

• What is the distribution of AP Expenses by the top five Natural Accounts or Financial Categories?

• How to analyze GL Balances/Journals with the ability to get the extended details of subledger transaction attributes and accounting events?

• What is the average number of days for invoices on hold and the trend for past six quarters?

• What is the distribution of AP Expenses by each of the cost center?

• How to support account analysis across multi period, multi ledger at detailed or roll up account levels across Chart of Account Segments?

• Identify items, categories, and suppliers with compliance issues in their purchase agreements.

• Analysis around payment terms by transaction type, transaction source for the invoices processed?

• What is the count and amount of AP Invoices that have either Header Level Hold, Line Level Hold, or combination?

• What is the count and amount of AP Invoices on Hold due to supplier site limits?

• What is the trend of AP Expenses for the past six quarters?

Accounts Payable Specialist

Code Name

ORA_AP_ACCOUNTS_PAYABLE_SPECIALIST_JOB

Duty Roles

This job role is related to the following duty roles:

• Accounts Payable Aging Analysis Duty

• Accounts Payable Expenses Analysis Duty

• Accounts Payable Holds Analysis Duty

• Accounts Payable Invoices Analysis Duty

• Accounts Payable Liabilities Analysis Duty

• Accounts Payable Payments Analysis Duty

• General Ledger Account Analysis Duty

• Procurement Spend Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Financials—AP Holds

• Financials—AP Aging

• Financials—AP Expenses

• Financials—AP Invoices

• Financials—AP Liabilities

• Financials—AP Payments

• Financials—GL Account Analysis

• Procurement—Spend

Business Questions

This job role secures access to data that can answer the following business questions:

• What are the liabilities distribution details of AP Balances?

• What is the accounting status of liability distributions by invoices?

• What is the average time available to pay off the outstanding AP invoices?

• What are the top 10 suppliers with maximum AP outstanding?

• What is the summary of invoices (count and amount) by various release reasons and released by user?

• What is the amount of AP Expenses by each Business Unit?

• How much did the organization spend with suppliers, commodities, buyers, cost center, contracts vs non contracts, leakage etc.?

• Identify items and categories with cost-saving potential in procurement operations based on prices.

• What is the count and value of AP invoices overdue?

• How to monitor GL accounts with respect to accounting and posting activity for all contributing transactions during an accounting period?

• What is the summary of AP invoices across aging buckets, count, and value?

• How are AP balances trending for a particular supplier over last 8 quarters?

• What is the outstanding AP amount for AP Invoices on Holds?

• How to reconcile GL Balances/Journals and all contributing subledger transactions including manual journals in GL with post SLA accounting details in a single consolidate report?

• How to get consolidated abstract view of GL account activity for a period and associated subledger transaction activity?

• What is the count and amount of invoices processed for the period by business units and trend comparison?

• What is the validation, approval and accounting status of invoices processed during the period?

• What is the count and amount of payments processed for the period by business units and trend comparison?

• What is the average supplier payment days by BU's?

• What is the trend of outstanding AP Balances at consolidated level, supplier level, and Business Unit level?

• What is the current AP amount out of outstanding AP amount for Invoices on Hold?

• What is the overdue AP amount out of outstanding AP amount for Invoices on Hold?

• What is the count and amount of AP Invoices on Hold due to PO matching variances?

• What is the summary of invoices (count and amount) by various hold reasons and hold by user?

• What is the distribution of AP Expenses by top 10 suppliers?

• How to facilitate intuitive drill to details for GL Balances, Journals or subledger transactions for detailed analysis with minimum number of clicks?

• Identify the key areas for improving process efficiencies.

• What are the invoice types processed by AP department and the payment methods used to understand the downstream activities?

• No. of invoices paid vs unpaid including partly paid with amount?

• What is the ratio of on-time payment performance?

• What is the count and amount of overdue payments?

• What are the interest penalties paid by amount and percentage?

• What is the count and amount of AP Invoices on Hold due to distribution variances?

• What is the split of invoices on Hold by manual holds vs system holds?

• What is the distribution of AP Expenses by the top five Natural Accounts or Financial Categories?

• How to analyze GL Balances/Journals with the ability to get the extended details of subledger transaction attributes and accounting events?

• What is the average number of days for invoices on hold and the trend for past six quarters?

• What is the distribution of AP Expenses by each of the cost center?

• How to support account analysis across multi period, multi ledger at detailed or roll up account levels across Chart of Account Segments?

• Identify items, categories, and suppliers with compliance issues in their purchase agreements.

• Analysis around payment terms by transaction type, transaction source for the invoices processed?

• What is the count and amount of AP Invoices that have either Header Level Hold, Line Level Hold, or combination?

• What is the count and amount of AP Invoices on Hold due to supplier site limits?

• What is the trend of AP Expenses for the past six quarters?

Accounts Payable Supervisor

Code Name

ORA_AP_ACCOUNTS_PAYABLE_SUPERVISOR_JOB

Duty Roles

This job role is related to the following duty roles:

• Accounts Payable Aging Analysis Duty
• Accounts Payable Expenses Analysis Duty
• Accounts Payable Holds Analysis Duty
• Accounts Payable Invoices Analysis Duty
• Accounts Payable Liabilities Analysis Duty
• Accounts Payable Payments Analysis Duty
• General Ledger Account Analysis Duty
• Procurement Spend Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Financials—AP Holds
• Financials—AP Aging
• Financials—AP Expenses
• Financials—AP Invoices
• Financials—AP Liabilities
• Financials—AP Payments
• Financials—GL Account Analysis
• Procurement—Spend

Business Questions

This job role secures access to data that can answer the following business questions:

• What are the liabilities distribution details of AP Balances?
• What is the accounting status of liability distributions by invoices?
• What is the average time available to pay off the outstanding AP invoices?
• What are the top 10 suppliers with maximum AP outstanding?

• What is the summary of invoices (count and amount) by various release reasons and released by user?

• What is the amount of AP Expenses by each Business Unit?

• How much did the organization spend with suppliers, commodities, buyers, cost center, contracts vs non contracts, leakage etc.?
• Identify items and categories with cost-saving potential in procurement operations based on prices.
• What is the count and value of AP invoices overdue?
• How to monitor GL accounts with respect to accounting and posting activity for all contributing transactions during an accounting period?
• What is the summary of AP invoices across aging buckets, count, and value?
• How are AP balances trending for a particular supplier over last 8 quarters?
• What is the outstanding AP amount for AP Invoices on Holds?
• How to reconcile GL Balances/Journals and all contributing subledger transactions including manual journals in GL with post SLA accounting details in a single consolidate report?
• How to get consolidated abstract view of GL account activity for a period and associated subledger transaction activity?
• What is the count and amount of invoices processed for the period by business units and trend comparison?
• What is the validation, approval and accounting status of invoices processed during the period?
• What is the count and amount of payments processed for the period by business units and trend comparison?
• What is the average supplier payment days by BU's?
• What is the trend of outstanding AP Balances at consolidated level, supplier level, and Business Unit level?
• What is the current AP amount out of outstanding AP amount for Invoices on Hold?
• What is the overdue AP amount out of outstanding AP amount for Invoices on Hold?
• What is the count and amount of AP Invoices on Hold due to PO matching variances?
• What is the summary of invoices (count and amount) by various hold reasons and hold by user?
• What is the distribution of AP Expenses by top 10 suppliers?
• How to facilitate intuitive drill to details for GL Balances, Journals or subledger transactions for detailed analysis with minimum number of clicks?
• Identify the key areas for improving process efficiencies.
• What are the invoice types processed by AP department and the payment methods used to understand the downstream activities?
• No. of invoices paid vs unpaid including partly paid with amount?
• What is the ratio of on-time payment performance?
• What is the count and amount of overdue payments?
• What are the interest penalties paid by amount and percentage?
• What is the count and amount of AP Invoices on Hold due to distribution variances?
• What is the split of invoices on Hold by manual holds vs system holds?
• What is the distribution of AP Expenses by the top five Natural Accounts or Financial Categories?
• How to analyze GL Balances/Journals with the ability to get the extended details of subledger transaction attributes and accounting events?
• What is the average number of days for invoices on hold and the trend for past six quarters?
• What is the distribution of AP Expenses by each of the cost center?
• How to support account analysis across multi period, multi ledger at detailed or roll up account levels across Chart of Account Segments?
• Identify items, categories, and suppliers with compliance issues in their purchase agreements.
• Analysis around payment terms by transaction type, transaction source for the invoices processed?
• What is the count and amount of AP Invoices that have either Header Level Hold, Line Level Hold, or combination?
• What is the count and amount of AP Invoices on Hold due to supplier site limits?
• What is the trend of AP Expenses for the past six quarters?

Accounts Receivable Manager

Code Name

ORA_AR_ACCOUNTS_RECEIVABLE_MANAGER_JOB

Duty Roles

This job role is related to the following duty roles:

• Accounts Receivable Adjustments Analysis Duty
• Accounts Receivable Aging Analysis Duty
• Accounts Receivable Credit Memo Applications Analysis Duty
• Accounts Receivable Receipts and Applications Analysis Duty
• Accounts Receivable Revenue Analysis Duty
• Accounts Receivable Transactions Analysis Duty
• General Ledger Account Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Financials—AR Adjustments
• Financials—AR Aging
• Financials—AR Credit Memo Applications
• Financials—AR Receipts and Applications
• Financials—AR Revenue
• Financials—AR Transactions
• Financials—GL Account Analysis

Business Questions

This job role secures access to data that can answer the following business questions:

• What is the count and amount of unapplied receipts?
• What is the ratio of AR Adjustments applications to Invoice %?
• What is the revenue mix by geography, business units, product lines, SKU, key customers, transaction source, transaction type?
• What is the contribution of non operating revenue and trend for past quarters?
• What is the amount of deferred revenue further classified by long term and short term deferred revenue?
• What are the payment terms and receipt methods associated with the transactions?
• What is the count and amount of credit memo applications during the period?
• What is the trend of outstanding AR Balances by Customer or Business Unit?
• What is the revenue recognition for the fiscal period in comparison to billings in prior periods (Bill in Advance) or billing in future (Bill in Arrears)?
• What is the classification of transactions processed during the period by Transaction Type and Source?
• What is the trend for Average Receipt Days?
• What is the count and value of AR Invoices Current?
• What is the summary of AR invoices across aging buckets, count and value?
• What is the distribution of Revenue by top 10 customer accounts?
• How to monitor GL accounts with respect to accounting and posting activity for all contributing transactions during an accounting period?
• What is the count and amount of transactions processed over the period of time?
• What is the count and amount of applied receipts?
• What is the AR account activity for the period and balance amount by Business Unit?
• How to reconcile GL Balances/Journals and all contributing subledger transactions including manual journals in GL with post SLA accounting details in a single consolidate report?
• How to get consolidated abstract view of GL account activity for a period and associated subledger transaction activity?
• What is the count and amount of receipts processed over the period of time?
• What is the count and amount of AR Adjustments processed during the period?
• What are the top 10 customers with maximum AR outstanding?
• What is the summary as well as detailed analysis of revenue vs billed amount (including taxes) in Transaction Currency, Ledger Currency, Analytics Currency?
• How to facilitate intuitive drill to details for GL Balances, Journals or subledger transactions for detailed analysis with minimum number of clicks?
• What is the analysis of due and overdue receipts?
• What is the analysis of AR Adjustments by Business Unit, Time Period, Customers, GL Accounts, and so on?
• What is the summary of AR invoices overdue with respect to their aging buckets and payment terms?
• What is the distribution of revenue by top 5 revenue accounts?
• What is the Revenue mix from services, subscription fees, material installation, merchant fees, sale of goods, etc?
• How to analyze GL Balances/Journals with the ability to get the extended details of subledger transaction attributes and accounting events?
• What is the analysis of credit memo applications by Business Unit, Time Period, Customers, GL Accounts, and so on?
• What is the status of CM application transactions?
• What is the status of AR Adjustments?
• What is the count and value of AR invoices Overdue?
• How to support account analysis across multi period, multi ledger at detailed or roll up account levels across Chart of Account Segments?
• What is the summary of Transactions by statuses?
• What is the amount of discount Taken vs Lost?
• How are AR balances trending for a particular customer over the last eight quarters?
• What is the trend for operating revenue for past 6 quarters by Ledger, Legal Entity, Billing BU, etc?
• What is the breakdown of inter company revenue vs external revenue based on AR transaction type, transaction source?

Accounts Receivable Specialist

Code Name

ORA_AR_ACCOUNTS_RECEIVABLE_SPECIALIST_JOB

Duty Roles

This job role is related to the following duty roles:

• Accounts Receivable Adjustments Analysis Duty
• Accounts Receivable Aging Analysis Duty
• Accounts Receivable Credit Memo Applications Analysis Duty
• Accounts Receivable Receipts and Applications Analysis Duty
• Accounts Receivable Revenue Analysis Duty
• Accounts Receivable Transactions Analysis Duty
• General Ledger Account Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Financials—AR Adjustments
• Financials—AR Aging
• Financials—AR Credit Memo Applications
• Financials—AR Receipts and Applications
• Financials—AR Revenue
• Financials—AR Transactions
• Financials—GL Account Analysis

Business Questions

This job role secures access to data that can answer the following business questions:

• What is the count and amount of unapplied receipts?
• What is the ratio of AR Adjustments applications to Invoice %?
• What is the revenue mix by geography, business units, product lines, SKU, key customers, transaction source, transaction type?
• What is the contribution of non operating revenue and trend for past quarters?
• What is the amount of deferred revenue further classified by long term and short term deferred revenue?
• What are the payment terms and receipt methods associated with the transactions?
• What is the count and amount of credit memo applications during the period?
• What is the trend of outstanding AR Balances by Customer or Business Unit?
• What is the revenue recognition for the fiscal period in comparison to billings in prior periods (Bill in Advance) or billing in future (Bill in Arrears)?
• What is the classification of transactions processed during the period by Transaction Type and Source?
• What is the trend for Average Receipt Days?
• What is the count and value of AR Invoices Current?
• What is the summary of AR invoices across aging buckets, count and value?
• What is the distribution of Revenue by top 10 customer accounts?
• How to monitor GL accounts with respect to accounting and posting activity for all contributing transactions during an accounting period?
• What is the count and amount of transactions processed over the period of time?
• What is the count and amount of applied receipts?
• What is the AR account activity for the period and balance amount by Business Unit?
• How to reconcile GL Balances/Journals and all contributing subledger transactions including manual journals in GL with post SLA accounting details in a single consolidate report?
• How to get consolidated abstract view of GL account activity for a period and associated subledger transaction activity?
• What is the count and amount of receipts processed over the period of time?
• What is the count and amount of AR Adjustments processed during the period?
• What are the top 10 customers with maximum AR outstanding?
• What is the summary as well as detailed analysis of revenue vs billed amount (including taxes) in Transaction Currency, Ledger Currency, Analytics Currency?
• How to facilitate intuitive drill to details for GL Balances, Journals or subledger transactions for detailed analysis with minimum number of clicks?
• What is the analysis of due and overdue receipts?
• What is the analysis of AR Adjustments by Business Unit, Time Period, Customers, GL Accounts, and so on?
• What is the summary of AR invoices overdue with respect to their aging buckets and payment terms?
• What is the distribution of revenue by top 5 revenue accounts?
• What is the Revenue mix from services, subscription fees, material installation, merchant fees, sale of goods, etc?
• How to analyze GL Balances/Journals with the ability to get the extended details of subledger transaction attributes and accounting events?
• What is the analysis of credit memo applications by Business Unit, Time Period, Customers, GL Accounts, and so on?
• What is the status of CM application transactions?
• What is the status of AR Adjustments?
• What is the count and value of AR invoices Overdue?
• How to support account analysis across multi period, multi ledger at detailed or roll up account levels across Chart of Account Segments?
• What is the summary of Transactions by statuses?
• What is the amount of discount Taken vs Lost?
• How are AR balances trending for a particular customer over the last eight quarters?
• What is the trend for operating revenue for past 6 quarters by Ledger, Legal Entity, Billing BU, etc?
• What is the breakdown of inter company revenue vs external revenue based on AR transaction type, transaction source?

Asset Accountant

Code Name

ORA_FA_ASSET_ACCOUNTANT_JOB

Duty Roles

This job role is related to the following duty roles:

• Fixed Asset Analysis Duty

• Fixed Asset Transactions Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Financials — Assets Analysis

• Financials — Assets Transactions

Business Questions

This job role secures access to data that can answer the following business questions:

• What is the summary of asset addition/ CapEx for a particular entity, asset book, asset category?

• What is the period active asset unit details for particular asset category and trend details?

• What are the period wise last active asset employee assignment details?

• What is the average cost of removal per unit for retired assets?

• How to track asset book health, lifecycle tracking with historic data?

• What is the amount of assets revalued during past 6 quarters?

• What is the amount and quantity of assets adjusted by transaction type and GL accounts, segments?

• What is the period active asset mix across various asset categories?

• What is the trend of asset retirement over a period of time in terms of cost retired, NBV retired?

• What is the amount and quantity of assets reclassified during the period?

• What is the average life of asset by asset category?

• What is the overall net book value for PP&E assets and trend over multiple periods by entity, asset book,etc?

• What is the asset mix across various asset types CIP, Capitalized, Expensed?

• What is summary of assets which has exceeded economic life or nearby end of life?

• What are the details of asset retired by various asset categories?

• Summary of assets by original cost, salvage value, net book value by entity, category, time historic, etc.

• What are the source document details for asset additions?

Asset Accounting Manager

Code Name

ORA_FA_ASSET_ACCOUNTING_MANAGE_JOB

Duty Roles

This job role is related to the following duty roles:

• Fixed Asset Analysis Duty

• Fixed Asset Transactions Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Financials — Assets Analysis

• Financials — Assets Transactions

Business Questions

This job role secures access to data that can answer the following business questions:

• What is the summary of asset addition/ CapEx for a particular entity, asset book, asset category?

• What is the period active asset unit details for particular asset category and trend details?

• What are the period wise last active asset employee assignment details?

• What is the average cost of removal per unit for retired assets?

• How to track asset book health, lifecycle tracking with historic data?

• What is the amount of assets revalued during past 6 quarters?

• What is the amount and quantity of assets adjusted by transaction type and GL accounts, segments?

• What is the period active asset mix across various asset categories?

• What is the trend of asset retirement over a period of time in terms of cost retired, NBV retired?

• What is the amount and quantity of assets reclassified during the period?

• What is the average life of asset by asset category?

• What is the overall net book value for PP&E assets and trend over multiple periods by entity, asset book,etc?

• What is the asset mix across various asset types CIP, Capitalized, Expensed?

• What is summary of assets which has exceeded economic life or nearby end of life?

• What are the details of asset retired by various asset categories?

• Summary of assets by original cost, salvage value, net book value by entity, category, time historic, etc.

• What are the source document details for asset additions?

Buyer

Code Name

ORA_PO_BUYER_JOB

Duty Roles

This job role is related to the following duty roles:

• Procurement Purchase Agreement Analysis Duty
• Procurement Purchase Order Analysis Duty
• Procurement Purchase Receipts Analysis Duty
• Procurement Requisitions Analysis Duty
• Procurement Spend Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Procurement - Agreements
• Procurement - Purchase Orders
• Procurement - Receipts

• Procurement — Requisitions

• Procurement—Spend

Business Questions

This job role secures access to data that can answer the following business questions:

• Is a company using strategic suppliers and contracts effectively?

• What are my purchase volume across business units?

• What are return rates for suppliers?

• What are my processing and post processing lead time standards and variances for an Item?

• What are my cycle times for agreement approvals?

• How much did the organization spend with suppliers, commodities, buyers, cost center, contracts vs non contracts, leakage etc.?

• Identify items and categories with cost-saving potential in procurement operations based on prices.

• Which suppliers deliver consistently on time?

• What are the agreements utilization rates?

• Which agreements are utilized before expiry?

• What are the creation sources for agreements?

• What is accepted and rejected rates for commodities, by suppliers?

• What is the classification of purchase requisitions by status, type, source of created for a period and associated purchase order details?

• How many non-catalog purchase requisitions are created by volume, item, and amount?

• How is purchase distributed across suppliers?

• What are my lead time standard and variances in purchase cycles?

• What receipts are created manually or through ASNs?

• Identify the key areas for improving process efficiencies.

• How many approvers on a average are approving purchase orders?

• What are my products and services for which we have agreements?

• How long does it take for purchase requisitions to get approved?

• What is the centralized view of all procurement requests for purchasing department?

• What are cycle times in terms of PR and PO Approval, PR to PO conversion?

• When were products shipped and what is the average delivery times?

• Identify items, categories, and suppliers with compliance issues in their purchase agreements.

• What is my contract vs off contract spend?

• What are purchase orders creation sources and corresponding requisition sources?

• Which agreements are under utilized?

• How many times are we amending agreements and whether amendment initiation is internal or external?

• How many approvers on a average are approving agreements?

• What commodities and services have been purchased, in what volume and price?

• How many times are we amending purchase orders and whether amendment initiation is internal or external?

• What are my negotiation to agreement approval cycle times?

Category Manager

Code Name

ORA_PON_CATEGORY_MANAGER_JOB

Duty Roles

This job role is related to the following duty roles:

• Procurement Purchase Agreement Analysis Duty
• Procurement Purchase Order Analysis Duty
• Procurement Purchase Receipts Analysis Duty
• Procurement Requisitions Analysis Duty
• Procurement Spend Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Procurement - Agreements
• Procurement - Purchase Orders
• Procurement - Receipts
• Procurement — Requisitions
• Procurement—Spend

Business Questions

This job role secures access to data that can answer the following business questions:

• Is a company using strategic suppliers and contracts effectively?

• What are my purchase volume across business units?

• What are return rates for suppliers?

• What are my processing and post processing lead time standards and variances for an Item?

• What are my cycle times for agreement approvals?

• How much did the organization spend with suppliers, commodities, buyers, cost center, contracts vs non contracts, leakage etc.?

• Identify items and categories with cost-saving potential in procurement operations based on prices.

• Which suppliers deliver consistently on time?

• What are the agreements utilization rates?

• Which agreements are utilized before expiry?

• What are the creation sources for agreements?

• What is accepted and rejected rates for commodities, by suppliers?

• What is the classification of purchase requisitions by status, type, source of created for a period and associated purchase order details?

• How many non-catalog purchase requisitions are created by volume, item, and amount?

• How is purchase distributed across suppliers?

• What are my lead time standard and variances in purchase cycles?

• What receipts are created manually or through ASNs?

• Identify the key areas for improving process efficiencies.

• How many approvers on a average are approving purchase orders?

• What are my products and services for which we have agreements?

• How long does it take for purchase requisitions to get approved?

• What is the centralized view of all procurement requests for purchasing department?

• What are cycle times in terms of PR and PO Approval, PR to PO conversion?

• When were products shipped and what is the average delivery times?

• Identify items, categories, and suppliers with compliance issues in their purchase agreements.

• What is my contract vs off contract spend?

• What are purchase orders creation sources and corresponding requisition sources?

• Which agreements are under utilized?

• How many times are we amending agreements and whether amendment initiation is internal or external?

• How many approvers on a average are approving agreements?

• What commodities and services have been purchased, in what volume and price?

• How many times are we amending purchase orders and whether amendment initiation is internal or external?

• What are my negotiation to agreement approval cycle times?

Expense Manager

Code Name

ORA_EXM_EXPENSE_MANAGER_JOB

Duty Roles

This job role is related to the following duty roles:

• Employee Expense Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Financials - EXM Employee Expenses

Business Questions

This job role secures access to the data that can answer the following business questions:

• Which are top cost centers by employee expenses?

• What is the expense breakdown by expense type?

• What is the employee expense Spend by Business Units?

• What is the trend in Credit vs Cash expense?

• Which are the top cost centers and organizations with Audit violations for expense reports which are paid?

• What is the Total Expense Trend for last few quarters?

• Who are the top managers by expenses?

• What is the number of expenses which are filed late?

• What is the percentage of reports which are Auto approved?

• What are the top expense reports which are paid?

• What is the total expenses by number of expense reports for employee, manager, organization, cost centers?

• What are the cycle times for report submission, filing, approvals?

Financial Analyst

Code Name

ORA_GL_FINANCIAL_ANALYST_JOB

Duty Roles

This job role is related to the following duty roles:

• General Ledger Account Analysis Duty
• General Ledger Balance Sheet Analysis Duty
• General Ledger Budget Analysis Duty
• General Ledger Detail Transactions Analysis Duty
• Profitability Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Financials—GL Account Analysis
• Financials—GL Balance Sheet
• Financials—GL Budgets
• Financials—GL Detail Transactions
• Financials—GL Profitability

Business Questions

This job role secures access to data that can answer the following business questions:

• What is the trend of AP for last 8 quarters?
• What is the pattern of bookings in tax sensitive GL accounts in comparison to revenue and cost?
• How are my asset balances tracking across regions (COA) for last 2 years?
• What is the trend around operating and net margins for past 2 years?
• What is the split of budgeted receivables by entity or ledgers?
• How is debt equity mix structured at present, and is it actionable for improved financial gearing?
• How to monitor GL accounts with respect to accounting and posting activity for all contributing transactions during an accounting period?
• What is the trend of Gross Margins for past 2 years across business units?
• How is the actual performance vs the budgeted performance of top Balance Sheet metrics for the last quarter or year?
• What is the budgeted revenue activity on monthly or quarterly basis?
• How to reconcile GL Balances/Journals and all contributing subledger transactions including manual journals in GL with post SLA accounting details in a single consolidate report?
• How to get consolidated abstract view of GL account activity for a period and associated subledger transaction activity?
• What is the working capital position and trend for past x quarters?
• What is the target revenue for next quarter in best case and worst case scenario?
• How to facilitate intuitive drill to details for GL Balances, Journals or subledger transactions for detailed analysis with minimum number of clicks?
• What are the CapEx requirements in near future? Will PPE hold up, or will an early capital infusion be needed?
• What is the composition of fixed cost elements vs variable cost elements for past 2 years?
• What is the QoQ, YoY trend for accrual bookings due for reversal in next accounting period?
• Is higher than anticipated OPEX a one-off case or how is the trend for past eight quarters?
• How to analyze GL Balances/Journals with the ability to get the extended details of subledger transaction attributes and accounting events?
• What is the proportion of operating profits taken up by interest and financing cost?
• How is the trend analysis for journals from subledger sources against manual GL journals, both in terms of amount and volume?
• What are the details of entries booked in GL for reclassification from expense to assets and vice versa?
• What is the trend for profitability metrics actual vs budget and direction of variance?
• How to support account analysis across multi period, multi ledger at detailed or roll up account levels across Chart of Account Segments?
• Whether the company was able to meet the guided revenue growth for past quarters or years?

General Accountant

Code Name

ORA_GL_GENERAL_ACCOUNTANT_JOB

Duty Roles

This job role is related to the following duty roles:

• General Ledger Account Analysis Duty
• General Ledger Balance Sheet Analysis Duty
• General Ledger Budget Analysis Duty
• General Ledger Detail Transactions Analysis Duty
• Profitability Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Financials - GL Account Analysis
• Financials - GL Balance Sheet
• Financials - GL Budgets
• Financials - GL Detail Transactions
• Financials - GL Profitability

Business Questions

This job role secures access to data that can answer the following business questions:

• What is the trend of AP for last 8 quarters?
• What is the pattern of bookings in tax sensitive GL accounts in comparison to revenue and cost?
• How are my asset balances tracking across regions (COA) for last 2 years?
• What is the trend around operating and net margins for past 2 years?
• What is the split of budgeted receivables by entity or ledgers?
• How is debt equity mix structured at present, and is it actionable for improved financial gearing?
• How to monitor GL accounts with respect to accounting and posting activity for all contributing transactions during an accounting period?
• What is the trend of Gross Margins for past 2 years across business units?
• How is the actual performance vs the budgeted performance of top Balance Sheet metrics for the last quarter or year?
• What is the budgeted revenue activity on monthly or quarterly basis?
• How to reconcile GL Balances/Journals and all contributing subledger transactions including manual journals in GL with post SLA accounting details in a single consolidate report?
• How to get consolidated abstract view of GL account activity for a period and associated subledger transaction activity?
• What is the working capital position and trend for past x quarters?
• What is the target revenue for next quarter in best case and worst case scenario?
• How to facilitate intuitive drill to details for GL Balances, Journals or subledger transactions for detailed analysis with minimum number of clicks?
• What are the CapEx requirements in near future? Will PPE hold up, or will an early capital infusion be needed?
• What is the composition of fixed cost elements vs variable cost elements for past 2 years?
• What is the QoQ, YoY trend for accrual bookings due for reversal in next accounting period?
• Is higher than anticipated OPEX a one-off case or how is the trend for past eight quarters?
• How to analyze GL Balances/Journals with the ability to get the extended details of subledger transaction attributes and accounting events?
• What is the proportion of operating profits taken up by interest and financing cost?
• How is the trend analysis for journals from subledger sources against manual GL journals, both in terms of amount and volume?
• What are the details of entries booked in GL for reclassification from expense to assets and vice versa?
• What is the trend for profitability metrics actual vs budget and direction of variance?
• How to support account analysis across multi period, multi ledger at detailed or roll up account levels across Chart of Account Segments?
• Whether the company was able to meet the guided revenue growth for past quarters or years?

General Accounting Manager

Code Name

ORA_GL_GENERAL_ACCOUNTING_MANAGER_JOB

Duty Roles

This job role is related to the following duty roles:

• General Ledger Account Analysis Duty
• General Ledger Balance Sheet Analysis Duty
• General Ledger Budget Analysis Duty
• General Ledger Detail Transactions Analysis Duty
• Profitability Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Financials - GL Account Analysis
• Financials - GL Balance Sheet
• Financials - GL Budgets
• Financials - GL Detail Transactions
• Financials - GL Profitability

Business Questions

This job role secures access to data that can answer the following business questions:

• What is the trend of AP for last 8 quarters?
• What is the pattern of bookings in tax sensitive GL accounts in comparison to revenue and cost?
• How are my asset balances tracking across regions (COA) for last 2 years?
• What is the trend around operating and net margins for past 2 years?
• What is the split of budgeted receivables by entity or ledgers?
• How is debt equity mix structured at present, and is it actionable for improved financial gearing?
• How to monitor GL accounts with respect to accounting and posting activity for all contributing transactions during an accounting period?
• What is the trend of Gross Margins for past 2 years across business units?
• How is the actual performance vs the budgeted performance of top Balance Sheet metrics for the last quarter or year?
• What is the budgeted revenue activity on monthly or quarterly basis?
• How to reconcile GL Balances/Journals and all contributing subledger transactions including manual journals in GL with post SLA accounting details in a single consolidate report?
• How to get consolidated abstract view of GL account activity for a period and associated subledger transaction activity?
• What is the working capital position and trend for past x quarters?
• What is the target revenue for next quarter in best case and worst case scenario?
• How to facilitate intuitive drill to details for GL Balances, Journals or subledger transactions for detailed analysis with minimum number of clicks?
• What are the CapEx requirements in near future? Will PPE hold up, or will an early capital infusion be needed?
• What is the composition of fixed cost elements vs variable cost elements for past 2 years?
• What is the QoQ, YoY trend for accrual bookings due for reversal in next accounting period?
• Is higher than anticipated OPEX a one-off case or how is the trend for past eight quarters?
• How to analyze GL Balances/Journals with the ability to get the extended details of subledger transaction attributes and accounting events?
• What is the proportion of operating profits taken up by interest and financing cost?
• How is the trend analysis for journals from subledger sources against manual GL journals, both in terms of amount and volume?
• What are the details of entries booked in GL for reclassification from expense to assets and vice versa?
• What is the trend for profitability metrics actual vs budget and direction of variance?
• How to support account analysis across multi period, multi ledger at detailed or roll up account levels across Chart of Account Segments?
• Whether the company was able to meet the guided revenue growth for past quarters or years?

Procurement Contract Administrator

Code Name

ORA_PO_PROCUREMENT_CONTRACT_ADMIN_JOB

Duty Roles

This job role is related to the following duty roles:

• Procurement Purchase Agreement Analysis Duty
• Procurement Purchase Order Analysis Duty
• Procurement Purchase Receipts Analysis Duty
• Procurement Requisitions Analysis Duty
• Procurement Spend Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Procurement - Agreements
• Procurement - Purchase Orders
• Procurement - Receipts
• Procurement — Requisitions
• Procurement - Spend

Business Questions

This job role secures access to data that can answer the following business questions:

• Is a company using strategic suppliers and contracts effectively?

• What are my purchase volume across business units?

• What are return rates for suppliers?

• What are my processing and post processing lead time standards and variances for an Item?

• What are my cycle times for agreement approvals?

• How much did the organization spend with suppliers, commodities, buyers, cost center, contracts vs non contracts, leakage etc.?

• Identify items and categories with cost-saving potential in procurement operations based on prices.

• Which suppliers deliver consistently on time?

• What are the agreements utilization rates?

• Which agreements are utilized before expiry?

• What are the creation sources for agreements?

• What is accepted and rejected rates for commodities, by suppliers?

• What is the classification of purchase requisitions by status, type, source of created for a period and associated purchase order details?

• How many non-catalog purchase requisitions are created by volume, item, and amount?

• How is purchase distributed across suppliers?

• What are my lead time standard and variances in purchase cycles?

• What receipts are created manually or through ASNs?

• Identify the key areas for improving process efficiencies.

• How many approvers on a average are approving purchase orders?

• What are my products and services for which we have agreements?

• How long does it take for purchase requisitions to get approved?

• What is the centralized view of all procurement requests for purchasing department?

• What are cycle times in terms of PR and PO Approval, PR to PO conversion?

• When were products shipped and what is the average delivery times?

• Identify items, categories, and suppliers with compliance issues in their purchase agreements.

• What is my contract vs off contract spend?

• What are purchase orders creation sources and corresponding requisition sources?

• Which agreements are under utilized?

• How many times are we amending agreements and whether amendment initiation is internal or external?

• How many approvers on a average are approving agreements?

• What commodities and services have been purchased, in what volume and price?

• How many times are we amending purchase orders and whether amendment initiation is internal or external?

• What are my negotiation to agreement approval cycle times?

Procurement Manager

Code Name

ORA_PO_PROCUREMENT_MANAGER_JOB

Duty Roles

This job role is related to the following duty roles:

• Procurement Purchase Agreement Analysis Duty
• Procurement Purchase Order Analysis Duty
• Procurement Purchase Receipts Analysis Duty
• Procurement Requisitions Analysis Duty
• Procurement Spend Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Procurement - Agreements
• Procurement - Purchase Orders
• Procurement - Receipts
• Procurement — Requisitions
• Procurement - Spend

Business Questions

This job role secures access to data that can answer the following business questions:

• Is a company using strategic suppliers and contracts effectively?

• What are my purchase volume across business units?

• What are return rates for suppliers?

• What are my processing and post processing lead time standards and variances for an Item?

• What are my cycle times for agreement approvals?

• How much did the organization spend with suppliers, commodities, buyers, cost center, contracts vs non contracts, leakage etc.?

• Identify items and categories with cost-saving potential in procurement operations based on prices.

• Which suppliers deliver consistently on time?

• What are the agreements utilization rates?

• Which agreements are utilized before expiry?

• What are the creation sources for agreements?

• What is accepted and rejected rates for commodities, by suppliers?

• What is the classification of purchase requisitions by status, type, source of created for a period and associated purchase order details?

• How many non-catalog purchase requisitions are created by volume, item, and amount?

• How is purchase distributed across suppliers?

• What are my lead time standard and variances in purchase cycles?

• What receipts are created manually or through ASNs?

• Identify the key areas for improving process efficiencies.

• How many approvers on a average are approving purchase orders?

• What are my products and services for which we have agreements?

• How long does it take for purchase requisitions to get approved?

• What is the centralized view of all procurement requests for purchasing department?

• What are cycle times in terms of PR and PO Approval, PR to PO conversion?

• When were products shipped and what is the average delivery times?

• Identify items, categories, and suppliers with compliance issues in their purchase agreements.

• What is my contract vs off contract spend?

• What are purchase orders creation sources and corresponding requisition sources?

• Which agreements are under utilized?

• How many times are we amending agreements and whether amendment initiation is internal or external?

• How many approvers on a average are approving agreements?

• What commodities and services have been purchased, in what volume and price?

• How many times are we amending purchase orders and whether amendment initiation is internal or external?

• What are my negotiation to agreement approval cycle times?

Project Accountant

Code Name

ORA_PJF_PROJECT_ACCOUNTANT_JOB

Duty Roles

This job role is related to the following duty roles:

• Project Costing Costs Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• PPM — Project Costs

Business Questions

This job role secures access to data that can answer the following business questions:

• What is the actual cost by GL Account for a specific period?

• What are the expenditures that contributed to the actual costs?

• What are the costs by expenditure type and category?

• What % of costs have been Capitalized?

• What is the total project cost by Project Organization, Project Type, Expenditure type, Expenditure Category, Expenditure Organization?

• What is the actual cost by Project Type?

• What are the ITD, YTD and PTD actual costs?

• What is the actual cost by Project and Task?

• What is the actual cost by Project Organization?

• What is the actual cost by Project Class codes?

• What is the trend of cost?

• What is the trend of Project Cost by Organization, Project type etc?

• What % of cost have been billed?

• What is the Labor cost and effort breakup by Employee, Job?

Project Administrator

Code Name

ORA_PJF_PROJECT_ADMINISTRATOR_JOB

Duty Roles

This job role is related to the following duty roles:

• Project Costing Costs Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• PPM — Project Costs

Business Questions

This job role secures access to data that can answer the following business questions:

• What is the actual cost by GL Account for a specific period?

• What are the expenditures that contributed to the actual costs?

• What are the costs by expenditure type and category?

• What % of costs have been Capitalized?

• What is the total project cost by Project Organization, Project Type, Expenditure type, Expenditure Category, Expenditure Organization?

• What is the actual cost by Project Type?

• What are the ITD, YTD and PTD actual costs?

• What is the actual cost by Project and Task?

• What is the actual cost by Project Organization?

• What is the actual cost by Project Class codes?

• What is the trend of cost?

• What is the trend of Project Cost by Organization, Project type etc?

• What % of cost have been billed?

• What is the Labor cost and effort breakup by Employee, Job?

Project Manager

Code Name

ORA_PJF_PROJECT_MANAGER_JOB

Duty Roles

This job role is related to the following duty roles:

• Project Costing Costs Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• PPM — Project Costs

Business Questions

This job role secures access to data that can answer the following business questions:

• What is the actual cost by GL Account for a specific period?

• What are the expenditures that contributed to the actual costs?

• What are the costs by expenditure type and category?

• What % of costs have been Capitalized?

• What is the total project cost by Project Organization, Project Type, Expenditure type, Expenditure Category, Expenditure Organization?

• What is the actual cost by Project Type?

• What are the ITD, YTD and PTD actual costs?

• What is the actual cost by Project and Task?

• What is the actual cost by Project Organization?

• What is the actual cost by Project Class codes?

• What is the trend of cost?

• What is the trend of Project Cost by Organization, Project type etc?

• What % of cost have been billed?

• What is the Labor cost and effort breakup by Employee, Job?

Purchase Analysis

Code Name

ORA_PO_PURCHASE_ANALYSIS_ABSTRACT

Duty Roles

This job role is related to the following duty roles:

• Procurement Purchase Order Analysis Duty
• Procurement Purchase Receipts Analysis Duty

• Procurement Requisitions Analysis Duty

• Procurement Spend Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Procurement - Purchase Orders
• Procurement - Receipts

• Procurement — Requisitions

• Procurement - Spend

Business Questions

This job role secures access to data that can answer the following business questions:

• Is a company using strategic suppliers and contracts effectively?

• What are my purchase volume across business units?

• What are return rates for suppliers?

• What are my processing and post processing lead time standards and variances for an Item?

• How much did the organization spend with suppliers, commodities, buyers, cost center, contracts vs non contracts, leakage etc.?

• Identify items and categories with cost-saving potential in procurement operations based on prices.

• Which suppliers deliver consistently on time?

• What is accepted and rejected rates for commodities, by suppliers?

• What is the classification of purchase requisitions by status, type, source of created for a period and associated purchase order details?

• How many non-catalog purchase requisitions are created by volume, item, and amount?

• How is purchase distributed across suppliers?

• What are my lead time standard and variances in purchase cycles?

• What receipts are created manually or through ASNs?

• Identify the key areas for improving process efficiencies.

• How many approvers on a average are approving purchase orders?

• How long does it take for purchase requisitions to get approved?

• What is the centralized view of all procurement requests for purchasing department?

• What are cycle times in terms of PR and PO Approval, PR to PO conversion?

• When were products shipped and what is the average delivery times?

• Identify items, categories, and suppliers with compliance issues in their purchase agreements.

• What is my contract vs off contract spend?

• What are purchase orders creation sources and corresponding requisition sources?

• What commodities and services have been purchased, in what volume and price?

• How many times are we amending purchase orders and whether amendment initiation is internal or external?

Warehouse Manager

Code Name

ORA_INV_WAREHOUSE_MANAGER_JOB

Duty Roles

This job role is related to the following duty roles:

• Procurement Purchase Receipts Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Procurement - Receipts

Business Questions

This job role secures access to data that can answer the following business questions:

• What are return rates for suppliers?
• What are my processing and post processing lead time standards and variances for an Item?
• Which suppliers deliver consistently on time?
• What is accepted and rejected rates for commodities, by suppliers?
• What receipts are created manually or through ASNs?
• When were products shipped and what is the average delivery times?

Duty Roles

Overview

For each duty role in this chapter, links are provided for more detailed information about the job roles, subject areas, and business questions associated with the duty role.

Accounts Payable Aging Analysis Duty

Code Name

OA4F_FIN_AP_AGING_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Subject Areas

This duty role secures access to the following subject areas:

• Financials—AP Aging

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the average time available to pay off the outstanding AP invoices?

• What are the top 10 suppliers with maximum AP outstanding?

• What is the count and value of AP invoices overdue?

• What is the summary of AP invoices across aging buckets, count, and value?

• How are AP balances trending for a particular supplier over last 8 quarters?

• What is the trend of outstanding AP Balances at consolidated level, supplier level, and Business Unit level?

Accounts Payable Expenses Analysis Duty

Code Name

OA4F_FIN_AP_EXPENSES_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Subject Areas

This duty role secures access to the following subject areas:

• Financials—AP Expenses

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the amount of AP Expenses by each Business Unit?

• What is the distribution of AP Expenses by top 10 suppliers?

• What is the distribution of AP Expenses by the top five Natural Accounts or Financial Categories?

• What is the distribution of AP Expenses by each of the cost center?

• What is the trend of AP Expenses for the past six quarters?

Accounts Payable Holds Analysis Duty

Code Name

OA4F_FIN_AP_HOLDS_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Subject Areas

This duty role secures access to the following subject areas:

• Financials—AP Holds

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the summary of invoices (count and amount) by various release reasons and released by user?

• What is the outstanding AP amount for AP Invoices on Holds?

• What is the current AP amount out of outstanding AP amount for Invoices on Hold?

• What is the overdue AP amount out of outstanding AP amount for Invoices on Hold?

• What is the count and amount of AP Invoices on Hold due to PO matching variances?

• What is the summary of invoices (count and amount) by various hold reasons and hold by user?

• What is the count and amount of AP Invoices on Hold due to distribution variances?

• What is the split of invoices on Hold by manual holds vs system holds?

• What is the average number of days for invoices on hold and the trend for past six quarters?

• What is the count and amount of AP Invoices that have either Header Level Hold, Line Level Hold, or combination?

• What is the count and amount of AP Invoices on Hold due to supplier site limits?

Accounts Payable Invoices Analysis Duty

Code Name

OA4F_FIN_AP_INVOICES_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Account Payable Invoice Supervisor

• Account Payable Payment Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

Subject Areas

This duty role secures access to the following subject areas:

• Financials—AP Invoices

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the count and amount of invoices processed for the period by business units and trend comparison?

• What is the validation, approval and accounting status of invoices processed during the period?

• What are the invoice types processed by AP department and the payment methods used to understand the downstream activities?

• No. of invoices paid vs unpaid including partly paid with amount?

• Analysis around payment terms by transaction type, transaction source for the invoices processed?

Accounts Payable Liabilities Analysis Duty

Code Name

OA4F_FIN_AP_LIABILITIES_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Subject Areas

This duty role secures access to the following subject areas:

• Financials—AP Liabilities

Business Questions

This duty role secures access to data that can answer the following business questions:

• What are the liabilities distribution details of AP Balances?
• What is the accounting status of liability distributions by invoices?

Accounts Payable Payments Analysis Duty

Code Name

OA4F_FIN_AP_PAYMENTS_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor

Subject Areas

This duty role secures access to the following subject areas:

• Financials—AP Payments

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the count and amount of payments processed for the period by business units and trend comparison?
• What is the average supplier payment days by BU's?
• What is the ratio of on-time payment performance?
• What is the count and amount of overdue payments?
• What are the interest penalties paid by amount and percentage?

Accounts Receivable Adjustments Analysis Duty

Code Name

OA4F_FIN_AR_ADJUSTMENTS_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Subject Areas

This duty role secures access to the following subject areas:

• Financials—AR Adjustments

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the ratio of AR Adjustments applications to Invoice %?
• What is the count and amount of AR Adjustments processed during the period?
• What is the analysis of AR Adjustments by Business Unit, Time Period, Customers, GL Accounts, and so on?
• What is the status of AR Adjustments?

Accounts Receivable Aging Analysis Duty

Code Name

OA4F_FIN_AR_AGING_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Subject Areas

This duty role secures access to the following subject areas:

• Financials—AR Aging

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the trend of outstanding AR Balances by Customer or Business Unit?
• What is the count and value of AR Invoices Current?
• What is the summary of AR invoices across aging buckets, count and value?
• What is the AR account activity for the period and balance amount by Business Unit?
• What are the top 10 customers with maximum AR outstanding?
• What is the summary of AR invoices overdue with respect to their aging buckets and payment terms?
• What is the count and value of AR invoices Overdue?
• How are AR balances trending for a particular customer over the last eight quarters?

Accounts Receivable Credit Memo Applications Analysis Duty

Code Name

OA4F_FIN_AR_CREDITMEMO_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Subject Areas

This duty role secures access to the following subject areas:

• Financials—AR Credit Memo Applications

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the count and amount of credit memo applications during the period?
• What is the analysis of credit memo applications by Business Unit, Time Period, Customers, GL Accounts, and so on?
• What is the status of CM application transactions?

Accounts Receivable Receipts and Applications Analysis Duty

Code Name

OA4F_FIN_AR_APPLICATIONS_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Subject Areas

This duty role secures access to the following subject areas:

• Financials—AR Receipts and Applications

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the count and amount of unapplied receipts?
• What is the trend for Average Receipt Days?
• What is the count and amount of applied receipts?
• What is the count and amount of receipts processed over the period of time?
• What is the analysis of due and overdue receipts?
• What is the amount of discount Taken vs Lost?

Accounts Receivable Revenue Analysis Duty

Code Name

OA4F_FIN_AR_REVENUE_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Subject Areas

This duty role secures access to the following subject areas:

• Financials—AR Revenue

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the revenue mix by geography, business units, product lines, SKU, key customers, transaction source, transaction type?
• What is the contribution of non operating revenue and trend for past quarters?
• What is the amount of deferred revenue further classified by long term and short term deferred revenue?
• What is the revenue recognition for the fiscal period in comparison to billings in prior periods (Bill in Advance) or billing in future (Bill in Arrears)?
• What is the distribution of Revenue by top 10 customer accounts?
• What is the summary as well as detailed analysis of revenue vs billed amount (including taxes) in Transaction Currency, Ledger Currency, Analytics Currency?
• What is the distribution of revenue by top 5 revenue accounts?
• What is the Revenue mix from services, subscription fees, material installation, merchant fees, sale of goods, etc?
• What is the trend for operating revenue for past 6 quarters by Ledger, Legal Entity, Billing BU, etc?
• What is the breakdown of inter company revenue vs external revenue based on AR transaction type, transaction source?

Accounts Receivable Transactions Analysis Duty

Code Name

OA4F_FIN_AR_TRANSACTIONS_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Accounts Receivable Manager
• Accounts Receivable Specialist

Subject Areas

This duty role secures access to the following subject areas:

• Financials - AR Transactions

Business Questions

This duty role secures access to data that can answer the following business questions:

• What are the payment terms and receipt methods associated with the transactions?
• What is the classification of transactions processed during the period by Transaction Type and Source?
• What is the count and amount of transactions processed over the period of time?
• What is the summary of Transactions by statuses?

Employee Expense Analysis Duty

Code Name

OA4F_FIN_EXM_EMPLOYEE_EXPENSE_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Expense Manager

Subject Areas

This duty role secures access to the following subject areas:

• Financials - EXM Employee Expenses

Business Questions

This duty role secures access to data that can answer the following business questions:

• Which are top cost centers by employee expenses?
• What is the expense breakdown by expense type?
• What is the employee expense Spend by Business Units?
• What is the trend in Credit vs Cash expense?
• Which are the top cost centers and organizations with Audit violations for expense reports which are paid?
• What is the Total Expense Trend for last few quarters?
• Who are the top managers by expenses?
• What is the number of expenses which are filed late?
• What is the percentage of reports which are Auto approved?
• What are the top expense reports which are paid?
• What is the total expenses by number of expense reports for employee, manager, organization, cost centers?
• What are the cycle times for report submission, filing, approvals?

Fixed Asset Analysis Duty

Code Name

OA4F_FIN_FA_ASSETS_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Asset Accountant

• Asset Accounting Manager

Subject Areas

This duty role secures access to the following subject areas:

• Financials — Assets Analysis

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the period active asset unit details for particular asset category and trend details?

• What are the period wise last active asset employee assignment details?

• How to track asset book health, lifecycle tracking with historic data?

• What is the period active asset mix across various asset categories?

• What is the average life of asset by asset category?

• What is the overall net book value for PP&E assets and trend over multiple periods by entity, asset book,etc?

• What is the asset mix across various asset types CIP, Capitalized, Expensed?

• What is summary of assets which has exceeded economic life or nearby end of life?

• Summary of assets by original cost, salvage value, net book value by entity, category, time historic, etc.

Fixed Asset Transactions Analysis Duty

Code Name

OA4F_FIN_FA_ASSETS_TRANSACTIONS_DUTY

Job Roles

This duty role is related to the following job roles:

• Asset Accountant

• Asset Accounting Manager

Subject Areas

This duty role secures access to the following subject areas:

• Financials — Assets Analysis

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the summary of asset addition/ CapEx for a particular entity, asset book, asset category?

• What is the average cost of removal per unit for retired assets?

• What is the amount of assets revalued during past 6 quarters?

• What is the amount and quantity of assets adjusted by transaction type and GL accounts, segments?

• What is the trend of asset retirement over a period of time in terms of cost retired, NBV retired?

• What is the amount and quantity of assets reclassified during the period?

• What are the details of asset retired by various asset categories?

• What are the source document details for asset additions?

General Ledger Account Analysis Duty

Code Name

OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor
• Accounts Receivable Manager
• Accounts Receivable Specialist
• Financial Analyst
• General Accountant
• General Accounting Manager

Subject Areas

This duty role secures access to the following subject areas:

• Financials - GL Account Analysis

Business Questions

This duty role secures access to data that can answer the following business questions:

• How to monitor GL accounts with respect to accounting and posting activity for all contributing transactions during an accounting period?
• How to reconcile GL Balances/Journals and all contributing subledger transactions including manual journals in GL with post SLA accounting details in a single consolidate report?
• How to get consolidated abstract view of GL account activity for a period and associated subledger transaction activity?
• How to facilitate intuitive drill to details for GL Balances, Journals or subledger transactions for detailed analysis with minimum number of clicks?
• How to analyze GL Balances/Journals with the ability to get the extended details of subledger transaction attributes and accounting events?
• How to support account analysis across multi period, multi ledger at detailed or roll up account levels across Chart of Account Segments?

General Ledger Balance Sheet Analysis Duty

Code Name

OA4F_FIN_GL_BALANCE_SHEET_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Financial Analyst
• General Accountant
• General Accounting Manager

Subject Areas

This duty role secures access to the following subject areas:

• Financials - GL Balance Sheet

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the trend of AP for last 8 quarters?
• How are my asset balances tracking across regions (COA) for last 2 years?
• How is debt equity mix structured at present, and is it actionable for improved financial gearing?
• What is the working capital position and trend for past x quarters?
• What are the CapEx requirements in near future? Will PPE hold up, or will an early capital infusion be needed?

General Ledger Budget Analysis Duty

Code Name

OA4F_FIN_GL_BUDGETS_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Financial Analyst
• General Accountant
• General Accounting Manager

Subject Areas

This duty role secures access to the following subject areas:

• Financials - GL Budgets

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the split of budgeted receivables by entity or ledgers?
• How is the actual performance vs the budgeted performance of top Balance Sheet metrics for the last quarter or year?
• What is the budgeted revenue activity on monthly or quarterly basis?
• What is the target revenue for next quarter in best case and worst case scenario?
• Is higher than anticipated OPEX a one-off case or how is the trend for past eight quarters?
• What is the trend for profitability metrics actual vs budget and direction of variance?
• Whether the company was able to meet the guided revenue growth for past quarters or years?

General Ledger Detail Transactions Analysis Duty

Code Name

OA4F_FIN_GL_DETAIL_TRANSACTIONS_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Financial Analyst
• General Accountant
• General Accounting Manager

Subject Areas

This duty role secures access to the following subject areas:

• Financials - GL Detail Transactions

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the pattern of bookings in tax sensitive GL accounts in comparison to revenue and cost?
• What is the QoQ, YoY trend for accrual bookings due for reversal in next accounting period?
• How is the trend analysis for journals from subledger sources against manual GL journals, both in terms of amount and volume?
• What are the details of entries booked in GL for reclassification from expense to assets and vice versa?

Procurement Spend Analysis Duty

Code Name

OAX_PROC_SPEND_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Account Payable Invoice Supervisor
• Account Payable Payment Supervisor
• Accounts Payable Manager
• Accounts Payable Specialist
• Accounts Payable Supervisor
• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis

Subject Areas

This duty role secures access to the following subject areas:

• Procurement - Spend

Business Questions

This duty role secures access to data that can answer the following business questions:

• How much did the organization spend with suppliers, commodities, buyers, cost center, contracts vs non contracts, leakage etc.?
• Identify items and categories with cost-saving potential in procurement operations based on prices.
• Identify the key areas for improving process efficiencies.
• Identify items, categories, and suppliers with compliance issues in their purchase agreements.

Procurement Purchase Order Analysis Duty

Code Name

OAX_PROC_PURCHASE_ORDER_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis

Subject Areas

This duty role secures access to the following subject areas:

• Procurement - Purchase Orders

Business Questions

This duty role secures access to data that can answer the following business questions:

• Is a company using strategic suppliers and contracts effectively?
• What are my purchase volume across business units?
• How is purchase distributed across suppliers?
• What are my lead time standard and variances in purchase cycles?
• How many approvers on a average are approving purchase orders?
• What are cycle times in terms of PR and PO Approval, PR to PO conversion?
• What is my contract vs off contract spend?
• What are purchase orders creation sources and corresponding requisition sources?
• What commodities and services have been purchased, in what volume and price?
• How many times are we amending purchase orders and whether amendment initiation is internal or external?

Procurement Purchase Receipts Analysis Duty

Code Name

OAX_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager
• Purchase Analysis
• Warehouse Manager

Subject Areas

This duty role secures access to the following subject areas:

• Procurement - Receipts

Business Questions

This duty role secures access to data that can answer the following business questions:

• What are return rates for suppliers?

• What are my processing and post processing lead time standards and variances for an Item?

• Which suppliers deliver consistently on time?

• What is accepted and rejected rates for commodities, by suppliers?

• What receipts are created manually or through ASNs?

• When were products shipped and what is the average delivery times?

Procurement Purchase Agreement Analysis

Code Name

OAX_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Buyer
• Category Manager
• Procurement Contract Administrator
• Procurement Manager

Subject Areas

This duty role secures access to the following subject areas:

• Procurement - Agreements

Business Questions

This duty role secures access to data that can answer the following business questions:

• What are my cycle times for agreement approvals?

• What are the agreements utilization rates?

• Which agreements are utilized before expiry?

• What are the creation sources for agreements?

• What are my products and services for which we have agreements?

• Which agreements are under utilized?

• How many times are we amending agreements and whether amendment initiation is internal or external?

• How many approvers on a average are approving agreements?

• What are my negotiation to agreement approval cycle times?

Procurement Requisitions Analysis Duty

Code Name

OAX_PROC_REQUISITIONS_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Buyer

• Category Manager

• Procurement Contract Administrator

• Procurement Manager

• Purchase Analysis

Subject Areas

This duty role secures access to the following subject areas:

• Procurement Requisitions Analysis Duty

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the classification of purchase requisitions by status, type, source of created for a period and associated purchase order details?

• How many non-catalog purchase requisitions are created by volume, item, and amount?

• How long does it take for purchase requisitions to get approved?

• What is the centralized view of all procurement requests for purchasing department?

Profitability Analysis Duty

Code Name

OA4F_FIN_GL_PROFITABILITY_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Financial Analyst
• General Accountant
• General Accounting Manager

Subject Areas

This duty role secures access to the following subject areas:

• Financials - GL Profitability

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the trend around operating and net margins for past 2 years?
• What is the trend of Gross Margins for past 2 years across business units?
• What is the composition of fixed cost elements vs variable cost elements for past 2 years?
• What is the proportion of operating profits taken up by interest and financing cost?

Project Costing Costs Analysis Duty

Code Name

OA4F_PPM_PROJECTS_COSTS_DUTY

Job Roles

This duty role is related to the following job roles:

• Project Accountant

• Project Administrator

• Project Manager

Subject Areas

This duty role secures access to the following subject areas:

• PPM — Project Costs

Business Questions

This duty role secures access to data that can answer the following business questions:

• What is the actual cost by GL Account for a specific period?

• What are the expenditures that contributed to the actual costs?

• What are the costs by expenditure type and category?

• What % of costs have been Capitalized?

• What is the total project cost by Project Organization, Project Type, Expenditure type, Expenditure Category, Expenditure Organization?

• What is the actual cost by Project Type?

• What are the ITD, YTD and PTD actual costs?

• What is the actual cost by Project and Task?

• What is the actual cost by Project Organization?

• What is the actual cost by Project Class codes?

• What is the trend of cost?

• What is the trend of Project Cost by Organization, Project type etc?

• What % of cost have been billed?

• What is the Labor cost and effort breakup by Employee, Job?

Subject Area Metric Details

Overview

Assets

These tables describe Assets metrics.

Financials — Assets Analysis

These metrics will be used in the Analytics Currency (AC) and Ledger Currency (LC) fact folder in 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
Remaining Life in Service Date - Months	Remaining life calculated in months from In Service date available in Asset Financials Summary.
Remaining Life in Service Date - Years	Remaining life calculated in years from In Service date available in Asset Financials Summary.
Remaining Life Prorate Date - Months	Remaining life calculated in months from Prorate date available in Asset Financials Summary.
Remaining Life Prorate Date - Years	Remaining life calculated in years from Prorate date available in Asset Financials Summary.
Asset Life - Months	Total life converted in months from Asset Financials Summary.
Asset Life - Years	Total life converted in years from Asset Financials Summary.
Current Units	Current units available from Asset Assignment details.
Avg Asset Original Life (Yrs)	Calculated in years based on 'Asset Life - Months' / 'Current Units'
Avg Asset Remaining Life (Yrs)	Calculated In years based on 'Remaining Life Prorate Date - Years' / 'Current Units'
Lifespan Reached	Calculated In years as 1 - ('Remaining Life Prorate Date - Years' / 'Asset Life - Years')
Lifespan Remaining	Calculated In years as 'Remaining Life Prorate Date - Years' / 'Asset Life - Years'
Current Cost	Current Cost from Assets Inquiry
Original Cost	Original Cost from Assets Inquiry
Recoverable Cost	Recoverable Cost from Assets Inquiry
Net Book Value	Net Book Value from Assets Inquiry
Salvage Value	Salvage Value from Assets Inquiry
Depreciation Expense	Depreciation Expense from Assets Inquiry
YTD Depreciation	YTD Depreciation from Assets Inquiry
Depreciation Reserve	Depreciation Reserve from Assets Inquiry
Depreciation Reserve Ratio	Depreciation Reserve Ratio from Assets Inquiry
YTD Impairment	YTD Impairment from Assets Inquiry
Impairment Reserve	Impairment Reserve from Assets Inquiry
Revaluation Reserve	Revaluation Reserve from Assets Inquiry

Financials — Assets Transactions

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

Metric	Metric Definition
Units Assigned	Shows number of units assigned at the distribution level.
Asset Distribution Amount	Base metric to transaction amount at asset distribution level.
Cost	Sum of transaction amount where Adjustment Type = 'COST'.
Cost Clearing	Sum of transaction amount where Adjustment Type = 'COST CLEARING'
CIP Cost	Sum of transaction amount where Adjustment Type = 'CIP COST'
Bonus Depreciation Adjustment	Sum of transaction amount where Account Class Code = 'BONUS DEPRECIATION EXPENSE' and Transaction Type Code = 'Adjustment'
Bonus Depreciation Reserve	Sum of transaction amount where Account Class Code = 'BONUS DEPRECIATION RESERVE'
Depreciation Expense	Sum of transaction amount where Account Class Code = 'DEPRECIATION EXPENSE'
Adjustment Depreciation Expense	Sum of transaction amount where Account Class Code = ' 'DEPRECIATION EXPENSE' and Transaction Type Code = 'Adjustment'
Depreciation Reserve	Sum of transaction amount where Account Class Code = 'DEPRECIATION RESERVE'
Impairment Expense	Sum of transaction amount where Adjustment Type = 'IMPAIR EXPENSE'
Impairment Reserve	Sum of transaction amount where Adjustment Type = 'IMPAIR RESERVE'
Net Book Value Retired	Sum of transaction amount where Adjustment Type = ''NBV RETIRED'
Proceeds of Sale	Sum of transaction amount where Adjustment Type = 'PROCEEDS'.
Cost of Removal	Sum of transaction amount where Adjustment Type = 'REMOVALCOST'.
Revaluation Reserve	Sum of transaction amount where Adjustment Type = 'REVAL RESERVE'.
Revaluation Reserve Retired	Sum of transaction amount where Adjustment Type = 'REVAL RSV RET'.

General Ledger

Overview

These tables describe GL metrics.

Financials—GL Account Analysis

These metrics will be used in the Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in subject areas. Metrics in these folders will show amounts in their respective currencies.

Metrics

Metric	Metric Definition
Debit Amount (Accounted)	Shows the subledger debit amount for transactions with subledger details and for other journals it shows the journal debit amount.
Credit Amount (Accounted)	Shows the subledger credit amount for transactions with subledger details and for other journals it shows the journal credit amount.
Net Amount (Accounted)	Shows the activity amount of the specified accounts. Where Activity Amount = Sum of Debit Amount (Accounted) - Sum of Credit Amount (Accounted).
Journal Debit Amount (Accounted)	Shows the sum of debit journal entries amount for specified accounts.
Journal Credit Amount (Accounted)	Shows the sum of credit journal entries amount for specified accounts.
Journal Net Amount (Accounted)	Shows the activity amount of the specified accounts. Where Activity Amount = Sum of Journal Debit Amount (Accounted) - Sum of Journal Credit Amount (Accounted).

Financials—GL Balance Sheet

These metrics will be used in the Analytics Currency (AC) fact folder and Ledger Currency (LC) fact folder in Subject Areas. Analytics currency details will be configured during product implementation and will be taken from there. Metrics in the analytics currency folder will show amounts in the analytics currency and metrics in the ledger currency folder will show amounts in the ledger currency.

Use this spreadsheet to view a list of out-of-the-box Financial Categories used in GL Metrics and KPIs.

Metrics

Metric	Metric Definition
GL Balance . Balance Amount	Shows the balance of the specified accounts.
GL Balance . Activity Amount	Shows the activity amount of the specified accounts. Where Activity Amount = Sum of Debit Amount - Sum of Credit Amount.
GL Balance . Opening Amount	Shows the opening balance of the specified accounts. This metric is computed as follows : Balance Amount - Activity Amount.
GL Balance . Closing Amount	Shows the closing balance of the specified accounts. The closing amount will show zero if the balance amount is null, this is the only difference between the balance amount and closing amount.
GL Balance . Debit Amount	Shows the sum of debit entries amount for the specified accounts.
GL Balance . Credit Amount	Shows the sum of credit entries amount for specified accounts.
GL Balance . Absolute Balance Amount	Shows the absolute balance amount of the specified accounts.
GL Balance . Absolute Activity Amount	Shows the absolute activity amount of the specified accounts. Activity Amount = Sum of Debit Amount - Sum of Credit Amount.
Balance Sheet Statement . Cash	Shows the cash balance for a particular time period for the CASH financial category.
Balance Sheet Statement . Accounts Payable	Shows the Accounts Payable balance for a particular time period for the AP financial category.
Balance Sheet Statement . Accounts Receivable	Shows the Accounts Receivable balance for a particular time period for the AR financial category.
Balance Sheet Statement . Raw Material Inventory	Shows the raw material inventory balance for a particular time period for the RM INV financial category.
Balance Sheet Statement . Work in Process inventory	Shows the Work in Process inventory balance for a particular time period for the WIP INV financial category.
Balance Sheet Statement . Finished Goods inventory	Shows the Finished Goods inventory balance for a particular time period for the FG INV financial category.
Balance Sheet Statement . Inventories	The metric is computed as follows: Raw Material Inventory + Work in Process Inventory + Finished Goods Inventory.
Balance Sheet Statement . Prepaid Expenses	Shows the Prepaid Expenses balance for a particular time period for the PPAID EXP financial category.
Balance Sheet Statement . Deferred Cost of Goods Sold	Shows the Deferred Cost of Goods Sold balance for a particular time period for the DEFERRED COGS financial category.
Balance Sheet Statement . Other Current Assets	Shows the Other Current Assets balance for a particular time period for the OTHER CA financial category.
Balance Sheet Statement . Current Assets	This metric is computed as follows : Cash + Inventories + Prepaid Expenses + Other Current Assets + Accounts Receivable + Deferred Cost of Goods Sold.
Balance Sheet Statement . PPE	Shows the Property, Plant, and Equipment (PPE) for a particular time period for the PPE financial category.
Balance Sheet Statement . Accumulated Depreciation	Shows the Accumulated Depreciation for a particular time period for the ACC DEPCN financial category.
Balance Sheet Statement . Net PPE	This metric is computed as follows : PPE - Accumulated Depreciation.
Balance Sheet Statement . Goodwill	Shows the Goodwill for a particular time period for the GOODWILL financial category.
Balance Sheet Statement . Other Assets	Shows the Other Assets for a particular time period for the OTHER ASSET financial category.
Balance Sheet Statement . Long Term Assets	This metric is computed as follows : Net PPE + Goodwill + Other Asset.
Balance Sheet Statement . Total Assets	This metric is computed as follows : Long Term Assets + Current Assets.
Balance Sheet Statement . Accrued Liabilities	Shows the Accrued Liabilities for a particular time period for the ACC LIAB financial category.
Balance Sheet Statement . Short Term Borrowing	Shows the Short Term Borrowing for a particular time period for the ST BORR financial category.
Balance Sheet Statement . Tax Liabilities	Shows the Tax Liabilities for a particular time period for the TAX LIAB financial category.
Balance Sheet Statement . Deferred Revenue	Shows the Deferred Revenue for a particular time period for the DEFERRED REVENUE financial category.
Balance Sheet Statement . Current Liabilities	This metric is computed as follows : Accrued Liabilities + Short Term Borrowing + Other Current Liabilities + Accounts Payable + Deferred Revenue +Tax Liabilities.
Balance Sheet Statement . Long term Debt	Shows the Long term Debt for a particular time period for the LT DEBT financial category.
Balance Sheet Statement . Other Liabilities	Shows the Other Liabilities for a particular time period for the OTHER LIAB financial category.
Balance Sheet Statement . Long Term Liabilities	This metric is computed as follows : Long Term Debt + Other Liabilities.
Balance Sheet Statement . Preferred Stock	Shows the Preferred Stock for a particular time period for the PREF STOCK financial category.
Balance Sheet Statement . Common Stock	Shows the Common Stock for a particular time period for the CMMN STOCK financial category.
Balance Sheet Statement . Retained Earnings	Shows the Retained Earnings balance for a particular time period for the RET EARNING financial category.
Balance Sheet Statement . Other Equity	Shows the Other Equity balance for a particular time period for the OTHER EQUITY financial category.
Balance Sheet Statement . Total Shareholders Funds	This metric is computed as follows: Preferred Stock + Common Stock + Retained Earnings + Other Equity.
Balance Sheet Statement . Total Liabilities	This metric is computed as follows : Current Liabilities + Long Term Liabilities.
Balance Sheet Statement . Total Liabilities Shareholders Funds	This metric is computed as follows : Total Liabilities + Total Shareholders Funds.
Balance Sheet Statement . Net Working Capital	This metric is computed as follows : Current Assets - Current Liabilities.
Balance Sheet Ratios . Current Ratio	This metric is computed as follows : Current Assets / Current Liabilities.
Balance Sheet Ratios . Quick Ratio	This metric is computed as follows : (Cash + AR Amount + Prepaid Expenses + Deferred Cost of Goods Sold+ Other Current Assets) / Current Liabilities.
Balance Sheet Ratios . Debt To Equity	This metric is computed as follows : Total Liabilities / Total Shareholders Funds Where: Total Liabilities = Current Liabilities + Long Term Liabilities
Balance Sheet Ratios . Capex Ratio	This metric is computed as follows : Operating Cash Flow / CAPEX. Where: Operating Cash Flow = Net Income + Depreciation Expenses - Inventories - Accounts Receivable + Accounts Payable + Accrued Liabilities + Other Current Liabilities - Prepaid Expenses - Other Current Assets
Balance Sheet Ratios . CAPEX	Activities for a period range for financial category for property, plant, and equipment (PPE).
Balance Sheet Ratios . Days Cash in Hand	This metric is computed as follows : Cash / (Daily Total Operating Expenses - Daily Depreciation Expenses). Where: Daily Total Operating Expenses = Total Operating Expenses / Number for days from beginning day to till date of the fiscal year. Daily Depreciation Expenses = Depreciation Expenses / Number for days from beginning day to till date of the fiscal year.
Balance Sheet Ratios . NWC to Assets	This metric is computed as follows : (Current Assets - Current Liabilities) / Total Assets.
Balance Sheet Ratios . Times interest Earned	This metric is computed as follows : EBIT YTD / Interest Expense.
Balance Sheet Ratios . Interest Expense YTD	Activities for Year To Date for the INT EXP financial category.
Asset Turnover Ratios . Days Sales outstanding	This metric is computed as follows : Accounts Receivable / Daily Revenue. Where: Daily Revenue = Revenue YTD /Number of Cumulative Elapsed Days.
Asset Turnover Ratios . AR turnover	This metric is computed as follows : Daily Revenue for the Period * 365 / AR Amount. Where: Daily Revenue for the Period = Revenue / Number for days for the selected period.
Asset Turnover Ratios . AP turnover	This metric is computed as follows : Daily Purchases for the Period * 365 / AP Amount. Where: Daily Purchases for the Period = Purchases / Number for days for the selected period.
Asset Turnover Ratios . Operating Cycle	This metric is computed as follows : Days Sales Outstanding + Avg Inventory Days.
Asset Turnover Ratios . Cash Cycle	This metric is computed as follows : Days Sales Outstanding - YTD Revenue (+) Avg Inventory Days (-) Days Payables Outstanding - YTD Purchase. Where: Days Sales Outstanding - YTD Revenue = AR Amount / Daily Revenue. Days Payables Outstanding - YTD Purchase = AP Amount / Daily Purchases.
Asset Turnover Ratios . Avg Inventory Days	This metric is computed as follows : Inventories / Daily Cost of Revenue. Where: Daily Cost of Revenue = Cost of Revenue / Number for days from beginning day to till date of the fiscal year.
Asset Turnover Ratios . Inventory Turnover	This metric is computed as follows : Daily Cost of Revenue * 365 / Inventories. Where: Daily Cost of Revenue = Cost of Revenue / Number for days from beginning day to till date of the fiscal year.
Asset Turnover Ratios . Working Capital Turnover	This metric is computed as follows : Daily Revenue * 365 / (Current Assets - Current Liabilities).
Asset Turnover Ratios . LT Assets Turnover	This metric is computed as follows : Daily Revenue * 365 / Long Term Assets. Where: Daily Revenue = Revenue / Number for days from beginning day to till date of the fiscal year.
Asset Turnover Ratios . Total Assets Turnover	This metric is computed as follows : Daily Revenue * 365 / Total Assets.
Asset Turnover Ratios . Fixed Assets Turnover	This metric is computed as follows : Daily Revenue * 365 / Net PPE. Where: Daily Revenue = Revenue / Number for days from beginning day to till date of the fiscal year.
Opening (STAT)	Shows the opening balance of the specified accounts in STAT currency.
Debit (STAT)	Shows the sum of debit entries amount for the specified accounts in STAT currency.
Credit (STAT)	Shows the sum of credit entries amount for specified accounts in STAT currency.
Activity (STAT)	Shows the activity amount of the specified accounts in STAT currency. Where Activity (STAT) = Sum of Debit (STAT) - Sum of Credit (STAT).
Closing (STAT)	Shows the closing balance of the specified accounts in STAT currency.
Balance Sheet Ratios . EBIT YTD	This metric is computed as follows: Revenue YTD - Cost of Revenue YTD - Sales & Marketing Expenses YTD - Other Operating Expenses YTD - R&D Expenses YTD - Depreciation Expenses YTD.
Balance Sheet Statement . Other Current Liabilities	Shows the Other Current Liabilities during a particular time period for the OTHER CL financial category.
Asset Turnover Ratios . Days Payable Outstanding	This metric is computed as follows: Accounts Payable / Daily Cost Of Revenue. Where: Daily Cost of Revenue = Cost of Revenue YTD/ Cumulative Number of Days.

Financials—GL Budgets

These metrics will be used in the Analytics Currency (AC) fact folder and Ledger Currency (LC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Creation Date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies.

Metrics

Metric	Metric Definition
Budget Activity Amount	Shows the activity amount of the specified accounts. Activity Amount = Sum of Debit Amount - Sum of Credit Amount.
Budget Debit Amount	Shows the sum of debit entries amount for the specified accounts.
Budget Credit Amount	Shows sum of credit entries amount for specified accounts.
Budget Absolute Activity Amount	Shows the absolute activity amount of the specified accounts. Activity Amount=sum of Debit Amount-sum of Credit Amount.
Budget Activity (STAT)	Shows the activity amount of the specified accounts in STAT currency. Where Budget Activity (STAT) = Sum of Debit (STAT) - Sum of Credit (STAT).
Budget Debit (STAT)	Shows the sum of debit entries amount for the specified accounts in STAT currency.
Budget Credit (STAT)	Shows the sum of credit entries amount for specified accounts in STAT currency.

Financials—GL Detail Transactions

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Currency Conversion Date and if not available Accounting date will be used to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently we support only posted journal details.

Metrics

Metric	Metric Definition
GL Detail Transactions . Net Amount	Shows the net amount of the specified accounts. Where Net Amount = Sum of Debit Amount - Sum of Credit Amount.
GL Detail Transactions . Debit Amount	Shows the sum of debit entries amount for specified accounts.
GL Detail Transactions . Credit Amount	Shows the sum of credit entries amount for specified accounts.
Total (STAT)	Shows the activity amount of the specified accounts in STAT currency.. Where Total (STAT) = Sum of Debit (STAT) - Sum of Credit (STAT).
Debit (STAT)	Shows the sum of debit entries amount for the specified accounts in STAT currency.
Credit (STAT)	Shows the sum of credit entries amount for specified accounts in STAT currency.

Financials—GL Profitability

These metrics will be used in the Analytics Currency (AC) fact folder and Ledger Currency (LC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Period End Date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies.

Use this spreadsheet to view a list of out-of-the-box Financial Categories used in GL Metrics and KPIs.

Metrics

Metric	Metric Definition
GL Balance . Balance Amount	Shows the balance of the specified accounts.
GL Balance . Activity Amount	Shows the activity amount of the specified accounts. Where Activity Amount = Sum of Debit Amount - Sum of Credit Amount.
GL Balance . Opening Amount	Shows the opening balance of the specified accounts. This metric is computed as follows : Balance Amount - Activity Amount.
GL Balance . Closing Amount	Shows the closing balance of the specified accounts. The closing amount will show zero if the balance amount is null, this is the only difference between the balance amount and closing amount.
GL Balance . Debit Amount	Shows the sum of debit entries amount for specified accounts.
GL Balance . Credit Amount	Shows the sum of credit entries amount for specified accounts.
GL Balance . Absolute Balance Amount	Shows the absolute balance amount of the specified accounts.
GL Balance . Absolute Activity Amount	Shows the absolute activities amount of the specified accounts. Where Activity Amount = Sum of Debit Amount - Sum of Credit Amount.
Profit and Loss . Revenue	Activities for a period range for the REVENUE financial category.
Profit and Loss . Cost of Revenue	Activities for a period range for the COGS, PURCH, and RM CONS financial category.
Profit and Loss . Gross Profit	This metric is computed as follows : Revenue - Cost of Revenue.
Profit and Loss . EBITDA	This metric is computed as follows : Revenue - Cost of Revenue - Sales & Marketing Expenses - Other Operating Expenses - R&D Expenses.
Profit and Loss . Gross Margin %	This metric is computed as follows : (Gross Profit / Revenue) * 100.
Profit and Loss . Payroll Cost	Activities for a period range for sum of Financial Categories with these values: MKTG PAYROLL, SLS PAYROLL, R&D PAYROLL, and GEN PAYROLL.
Profit and Loss . R&D Expenses	Activities for a period range for sum of Financial Categories with these values: OTHER R&D EXP and R&D PAYROLL.
Profit and Loss . Sales & Marketing Expenses	Activities for a period range for sum of Financial Categories with these values: MKTG PAYROLL, SLS PAYROLL, OTHER MKTG EXP, FREIGHT, OTHER SLS EXP, and TRAVEL & ENT EXP.
Profit and Loss . Other Operating Expenses	Activities for a period range for sum of Financial Categories with these values: EMP BENFT, GEN PAYROLL, EMP SUPP, CONT EXP, EMP OVERTIME, VARIANCE EXP, MISC OPER EXP and OTHER OPER EXP.
Profit and Loss . Total Operating Expenses	This metric is computed as follows : R&D Expenses + Sales & Marketing Expenses + Other Operating Expenses.
Profit and Loss . Operating Profit	This metric is computed as follows : Revenue - Cost of Revenue - Total Operating Expenses.
Profit and Loss . Operating Margin %	This metric is computed as follows : (Operating Profit / Revenue) * 100.
Profit and Loss . Other Income	Activities for a period range for the OTHER INC financial category.
Profit and Loss . EBITDA Margin %	This metric is computed as follows : (EBITDA / Revenue) * 100.
Profit and Loss . Depreciation Expenses	Activities for a period range for the DEPCN financial category.
Profit and Loss . EBIT	This metric is computed as follows : Revenue - Cost of Revenue - Sales & Marketing Expenses - Other Operating Expenses - R&D Expenses - Depreciation Expenses.
Profit and Loss . EBIT Margin %	This metric is computed as follows : (EBIT / Revenue) * 100.
Profit and Loss . Interest Expense	Activities for a period range for the INT EXP financial category.
Profit and Loss . EBT	This metric is computed as follows : Revenue - Cost of Revenue - Sales & Marketing Expenses - Other Operating Expenses - R&D Expenses - Interest Expense - Depreciation Expenses.
Profit and Loss . EBT Margin %	This metric is computed as follows : (EBT / Revenue) * 100.
Profit and Loss . Income Tax Expense	Income Tax Expense metric is the activities for a period range for the INC TAX financial category.
Profit and Loss . Net Income	This metric is computed as follows : Revenue + Other Income - Cost of Revenue - Sales & Marketing Expenses - Other Operating Expenses - R&D Expenses - Interest Expense - Income Tax Expense - Depreciation Expenses .
Profit and Loss . Net Income Margin %	This metric is computed as follows : (Net Income / Revenue) * 100.
Profit and Loss YTD . Revenue YTD	YTD activities for a period range for the REVENUE financial category.
Profit and Loss YTD . Cost of Revenue YTD	YTD activities for a period range for the COGS, PURCH, and RM CONS financial category.
Profit and Loss YTD . Gross Profit YTD	This metric is computed as follows : Revenue YTD - Cost of Revenue YTD.
Profit and Loss YTD . Total Operating Expenses YTD	This metric is computed as follows : Sales & Marketing Expense YTD + R&D Expense YTD + Other Operating Expense YTD.
Profit and Loss YTD . EBITDA YTD	This metric is computed as follows : Revenue YTD - Cost of Revenue YTD - Sales & Marketing Expenses YTD - Other Operating Expenses YTD - R&D Expenses YTD.
Profit and Loss YTD . Gross Margin YTD %	This metric is computed as follows : (Gross Profit YTD / Revenue YTD) * 100.
Profit and Loss YTD . Sales & Marketing Expenses YTD	This metric is computed as follows : Marketing Payroll Expense YTD + Other Marketing Expenses YTD + Sales Payroll Expenses YTD + Freight Expenses YTD + Other Sales Expenses YTD + Travel & Entertainment Expenses YTD.
Profit and Loss YTD . R&D Expenses YTD	This metric is computed as follows : R&D Payroll Expenses YTD + Other R&D Expenses YTD.
Profit and Loss YTD . Other Operating Expenses YTD	Other Operating Expenses metric is the YTD activities for a period range for sum of Financial Categories with these values: EMP BENFT, GEN PAYROLL, EMP SUPP, CONT EXP, EMP OVERTIME, VARIANCE EXP, MISC OPER EXP and OTHER OPER EXP.
Profit and Loss YTD . Operating Profit YTD	This metric is computed as follows : Revenue YTD - Cost of Revenue YTD - Total Operating Expenses YTD.
Profit and Loss YTD . Operating Margin YTD %	This metric is computed as follows : (Operating Profit YTD / Revenue YTD) * 100.
Profit and Loss YTD . Other Income YTD	Other Income metric is the YTD activities for a period range for the OTHER INC financial category.
Profit and Loss YTD . EBITDA Margin YTD %	This metric is computed as follows : (EBITDA YTD / Revenue YTD) * 100.
Profit and Loss YTD . Depreciation Expenses YTD	Depreciation Expenses metric is the YTD activities for a period range for the DEPCN financial category.
Profit and Loss YTD . EBIT Margin YTD %	This metric is computed as follows : (EBIT YTD / Revenue YTD )* 100.
Profit and Loss YTD . Interest Expense YTD	Interest Expense metric is the YTD activities for a period range for the INT EXP financial category.
Profit and Loss YTD . EBT YTD	This metric is computed as follows : Revenue YTD - Cost of Revenue YTD - Sales & Marketing Expenses YTD - Other Operating Expenses YTD - R&D Expenses YTD - Interest Expense YTD - Depreciation Expenses YTD.
Profit and Loss YTD . EBT Margin YTD %	This metric is computed as follows : (EBT YTD / Revenue YTD) * 100.
Profit and Loss YTD . Income Tax Expense YTD	Income Tax Expense metric is the YTD activities for a period range for the INC TAX financial category.
Profit and Loss YTD . Net Income YTD	This metric is computed as follows : Revenue YTD + Other Income YTD - Cost of Revenue YTD - Sales & Marketing Expenses YTD - Other Operating Expenses YTD - R&D Expenses YTD - Interest Expense YTD - Income Tax Expense YTD.
Profit and Loss YTD . Net Income Margin YTD %	This metric is computed as follows : (Net Income YTD / Revenue YTD) * 100.
Return on Investment . ROE (Pre-Interest)	This metric is computed as follows : (((Daily Net Income + Interest Expense ) * 365) / (Common Stock + Retained Earning + Other Equity)) * 100. Where: Common Stock = Ending Balance for the CMMN STOCK financial category. Retained Earning = Ending Balance for the RET EARNING financial category. Other Equity = Ending Balance for the OTHER EQUITY financial category.
Return on Investment . ROA (Pre-Interest)	This metric is computed as follows : (((Daily Net Income + Daily Interest Expense) * 365) / Total Assets) * 100.
Return on Investment . ROA	This metric is computed as follows : (Daily Net Income * 365 / Total Assets) * 100.
Return on Investment . ROCE (Pre-Interest)	This metric is computed as follows : (Daily Net Income + Daily Interest Expense) * 365 / (Common Stock + Long Term Debt + Retained Earnings + Preferred Stock + Other Equity + Other Liabilities) * 100.
Return on Investment . ROCE (EBIT Basis)	This metric is computed as follows : (Daily Net Income + Daily Interest Expense + Daily Income Tax Expense) * 365 / (Common Stock + Long Term Debt + Retained Earnings + Preferred Stock + Other Equity + Other Liabilities) * 100.
Return on Investment . ROE	This metric is computed as follows : Daily Net Income * 365 / (Common Stock + Retained Earnings + Other Equity) * 100.
Return on Investment . Current Assets	This metric is computed as follows : Cash + Inventories + Prepaid Expenses + Other Current Assets + Accounts Receivable + Deferred Cost of Goods Sold.
Return on Investment . Total Assets	This metric is computed as follows : Long Term Assets + Current Assets.
Return on Investment . Current Liabilities	This metric is computed as follows : Accrued Liabilities + Short Term Borrowing + Other Current Liabilities + Accounts Payable + Deferred Revenue +Tax Liabilities.
Return on Investment . Total Liabilities	This metric is computed as follows : Current Liabilities + Long Term Liabilities.
Return on Investment . Retained Earnings	Shows the Retained Earnings balance for a particular time period for the RET EARNING financial category.
Return on Investment . Total Shareholders Funds	This metric is computed as follows : Preferred Stock + Common Stock + Retained Earnings + Other Equity.
Cost Details . Cost Ratios . Cost of revenue to Revenue %	This metric is computed as follows : (Cost of Revenue / Revenue) * 100.
Cost Details . Cost Ratios . Sales & Marketing Expenses to Revenue %	This metric is computed as follows : (Sales & Marketing Expense / Revenue) * 100.
Cost Details . Cost Ratios . R&D Expenses to Revenue %	This metric is computed as follows : (R&D Expenses / Revenue) * 100.
Cost Details . Cost Ratios . Interest Expenses to Revenue %	This metric is computed as follows : (Interest Expense / Revenue) * 100.
Cost Details . Cost Ratios . Other Operating Expenses to Revenue %	This metric is computed as follows : (Other Operating Expenses / Revenue) * 100.
Cost Details . Cost Ratios . Total Operating Expenses to Revenue %	This metric is computed as follows : (Total Operating Expenses / Revenue) * 100.
Cost Details . Sales and Marketing Expenses . Marketing Payroll Expenses	Activities for a period range for the MKTG PAYROLL financial category.
Cost Details . Sales and Marketing Expenses . Other Marketing Expenses	Activities for a period range for the OTHER MKTG EXP financial category.
Cost Details . Sales and Marketing Expenses . Sales Payroll Expenses	Activities for a period range for the SLS PAYROLL financial category.
Cost Details . Sales and Marketing Expenses . Freight Expenses	Activities for a period range for the FREIGHT financial category.
Cost Details . Sales and Marketing Expenses . Other Sales Expenses	Activities for a period range for the OTHER SLS EXP financial category.
Cost Details . Sales and Marketing Expenses . Travel & Entertainment Expenses	Activities for a period range for the TRAVEL & ENT EXP financial category.
Cost Details . Sales and Marketing Expenses . Sales & Marketing Expenses	Activities for a period range for sum of Financial Categories with these values: MKTG PAYROLL, SLS PAYROLL, OTHER MKTG EXP, FREIGHT, OTHER SLS EXP, and TRAVEL & ENT EXP.
Cost Details . R&D Expenses . R&D Payroll Expenses	Activities for a period range for the R&D PAYROLL financial category.
Cost Details . R&D Expenses . Other R&D Expenses	Activities for a period range for the OTHER R&D EXP financial category.
Cost Details . R&D Expenses . R&D Expenses	Activities for a period range for sum of Financial Categories with these values OTHER R&D EXP, and R&D PAYROLL.
Cost Details . Other Operating Expenses . General Admin and Other Payroll	Activities for a period range for the GEN PAYROLL financial category.
Cost Details . Other Operating Expenses . Employee Benefits Related Expenses	Employee Benefits Related Expenses metric is the activities for a period range for the financial category 'EMP BENFT'
Cost Details . Other Operating Expenses . Employee Support Expenses	Activities for a period range for the EMP SUPP financial category.
Cost Details . Other Operating Expenses . Contracting Expenses	Activities for a period range for the CONT EXP financial category.
Cost Details . Other Operating Expenses . Employee Overtime Expenses	Activities for a period range for the EMP OVERTIME financial category.
Cost Details . Other Operating Expenses . Product Variance Expenses	Activities for a period range for the VARIANCE EXP financial category.
Cost Details . Other Operating Expenses . Depreciation Expenses	Activities for a period range for the DEPCN financial category.
Cost Details . Other Operating Expenses . Miscellaneous Operating Expenses	Activities for a period range for the MISC OPER EXP financial category.
Opening (STAT)	Shows the opening balance of the specified accounts in STAT currency.
Debit (STAT)	Shows the sum of debit entries amount for the specified accounts in STAT currency.
Credit (STAT)	Shows the sum of credit entries amount for specified accounts in STAT currency.
Activity (STAT)	Shows the activity amount of the specified accounts in STAT currency. Where Activity (STAT) = Sum of Debit (STAT) - Sum of Credit (STAT).
Closing (STAT)	Shows the closing balance of the specified accounts in STAT currency.
Profit and Loss YTD . EBIT YTD	This metric is computed as follows: Revenue YTD - Cost of Revenue YTD - Sales & Marketing Expenses YTD - Other Operating Expenses YTD - R&D Expenses YTD - Depreciation Expenses YTD.

Expenses

Overview

These tables describe Expenses metrics.

Financials — EXM Employee Expenses

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder, Document Currency (DC) fact folder and Reimbursement Currency fact folder in Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Transaction Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies. Currently we support only Expense Reports that are invoiced, paid or partially paid.

Metric	Metric Definition
Expense Reports Count	This metric shows count of distinct Expense reports.
Expense Lines Count	This metric shows count of distinct Expense report lines.
Expense Distribution Count	This metric shows count of distinct Expense report distributions.
Expense Approval Cycle Time (Days)	This metric is calculated as follows: Total Approval Days/ Expense Distribution Count where Total Approval days is the number of days between Expense Report Final approval date and Submission date.
Expense Filing Cycle Time (Days)	This metric is calculated as follows: Total Filing Days/ Expense Distribution Count where Total Filing days is the number of days between Expense Report Submission date and Creation date.
Cash Expense Reimbursement Cycle Time (Days)	This metric is calculated as follows: Total Cash Expense Days/ Expense Distribution Count where Total Cash Expense days is the number of days between Cash Expense Report Paid date and Submission date.
Manual Audit Percentage	This metric shows the percentage of expense reports with Audit type not equal to Automatic Approval.
Auto Audit Percentage	This metric shows the percentage of expense reports with Audit type equal to Automatic Approval.
Average Days Late	This metric is calculated as follows: Days Late/ Expense Reports Count where Days Late is the number of days between Expense Report Submission date and Transaction date.
Total Expense Amount	This metric shows the Expense Amount.
Credit Card Expense Amount	This metric shows the Expense Amount for lines with Expense source as Credit card.
Cash Expense Amount	This metric shows the Expense Amount for lines with Expense source as Cash.
Average Expense Amount	This metric is calculated as follows: Total Expense Amount/Expense Reports Count.
Audit Adjustment Amount	This metric is supported only in Reimbursement currency and is calculated as follows: Original Reimbursement Amount - Expense Amount.

Payables

Overview

These table describe Payables metrics.

Financials—AP Aging

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

Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Invoice date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies.

Metrics

Metric	Metric Definition
AP Turnover . Days Payables Outstanding	This metric is computed as follows : (Closing Amount * Number of days in a selected period) / (Invoice Amount - Credit Memo Amount - Debit Memo Amount). This metric will provide correct value only when used with common or pillar specific dimensions.
AP Turnover . AP Turnover	This metric is computed as follows : ((Invoice Amount - Credit Memo Amount - Debit Memo Amount )* 365) / (Closing Amount * Number of days in a selected period). This metric will provide correct value only when used with common or pillar specific dimensions.
AP Balances . Activity Amount	Shows the activities amount of the specified accounts that can be aggregated by Business Unit, Supplier, Supplier Site, and Time.
AP Balances . Opening Amount	Shows the opening balance (beginning of period balance) of the specified accounts that can be aggregated by Business Unit, Supplier, Supplier Site, and Time. This metric is available only at a monthly granularity.
AP Balances . Closing Amount	Shows the closing balance (end of period balance) of the specified accounts that can be aggregated by Business Unit, Supplier, Supplier Site, and Time. This metric is available only at a monthly granularity.
Aging Amount - Invoice Date Basis	Shows the aging amount for the open invoices based on Invoice open date grouped by selected aging period.
Aging Count - Invoice Date Basis	Shows the aging count for the open invoices based on Invoice open date grouped by selected aging period. The grain for this is invoice payment schedule.
Aging Amount - Schedule Date Basis	Shows the aging amount for the open invoices based on Schedule date grouped by selected aging period.
Aging Count - Schedule Date Basis	Shows the aging count for the open invoices based on Schedule date grouped by selected aging period. The grain for this is invoice payment schedule.
Open Invoices Amount	Shows the total invoice amount for the invoices that are fully open and partially open.
Total Outstanding Amount	Shows the outstanding invoice amount which includes current and overdue invoices.
Total Outstanding Invoices Count	Shows the count of outstanding invoices computed as follows: (Current Invoices Count + Overdue Invoices Count)
Avg Invoice Days Outstanding	This metric is computed as follows: Total number of days invoice outstanding / Total outstanding Invoices Count. This is based on Invoice date.
Current Amount	Shows the invoices amount which are yet to cross the schedule due date.
Current Invoices Count	Shows the invoices count which are yet to cross the schedule due date. The grain for this is invoice payment schedule.
Avg Invoice Days Current	This metric is computed as follows: Total number of days before due date / Current Invoices Count. This is based on schedule date.
Current Amount to Total Outstanding %	This metric is computed as follows: (Current Amount / Total Outstanding Amount) * 100.
Current Count to Total Outstanding %	This metric is computed as follows: (Current Invoices Count / Total Outstanding Invoices Count) * 100.
Overdue Amount	Shows the invoices amount which has crossed the schedule due date. The grain for this is invoice payment schedule.
Overdue Invoices Count	Shows the invoices count which has crossed the schedule due date. The grain for this is invoice payment schedule.
Avg Invoice Days Overdue	This metric is computed as follows: Total number of days invoice overdue / Overdue Invoices Count. This is based on schedule date.
Overdue Amount to Total Outstanding %	This metric is computed as follows: (Overdue Amount / Total Outstanding Amount) * 100.
Overdue Count to Total Outstanding %	This metric is computed as follows: (Overdue Invoices Count / Total Outstanding Invoices Count) * 100.
Amount Due Next 30 Days	This metric is computed as follows: Overdue Amount + Upcoming dues for 30 days for open invoices.

Financials—AP Expenses

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

Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Expense Distribution Accounting date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently we support only accounted invoices.

Metrics

Metric	Metric Definition
Expense Distribution Amount	Shows the invoice expense distribution amount for AP Invoices and considers all invoice types. Excludes cancelled distributions.
Expense Distribution Count	Shows the invoice expense distribution count for AP Invoices and considers all invoice types. Excludes cancelled distributions.

Financials—AP Holds

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

Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Invoice date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies.

Metrics

Metric	Metric Definition
Invoices on Hold Amount	Shows the invoice amount and considers all invoice types that have either Header Level Hold, Line Level Hold, or a combination. This metrics considers only active holds that are without release details.
Invoices on Hold Count	Shows the invoice count and considers all invoice types that have either Header Level Hold, Line Level Hold, or a combination. This metrics considers only active holds that are without release details.
Invoice Headers on Hold Amount	Shows the invoice amount and considers all invoice types that have Header Level Hold. This metrics considers only active holds that are without release details.
Invoice Headers on Hold Count	Shows the invoice header count which has header level hold and considers all invoice types. This metrics considers only active holds which are without release details.
Invoice Lines on Hold Count	Shows the invoice line count which has line level hold and considers all invoice types. This metrics considers only active holds which are without release details.
Total Holds Count	Shows the total number of holds applied on invoice headers and lines. This metrics considers only active holds which are without release details.
Header Holds Count	Shows the header hold count which has header level hold and considers all invoice types. This metrics considers only active holds which are without release details.
Line Holds Count	Shows the line hold count which has line level hold and considers all invoice types. This metrics considers only active holds which are without release details.
Average Days on Hold	This metric is computed as follows: (Sum (Release Date - Hold Date) / Total number of holds applied on invoice headers and lines considering active and release holds). The active holds are without release details and use the system date if the release date is not available.
Invoices on Hold Release Amount	Shows the invoice amount and considers all invoice types that have either header level hold, line level hold, or a combination. This metrics considers only active holds that are released.
Invoice Header on Hold Release Amount	Shows the invoice amount and considers all invoice types that have Header Level Hold. This metrics considers active holds that are released.
Invoice Lines on Hold Amount	Shows the invoice line amount which has line level hold and considers all invoice types. This metrics considers only active holds which are without release details.
Invoice Lines on Hold Release Amount	Shows the invoice line amount which had line level hold and considers all invoice types. This metrics considers active holds that are released.

Financials—AP Invoices

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

Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Invoice date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies.

Metrics

Metric	Metric Definition
Invoices Amount	Shows the invoice amount excluding the Credit Memo and Debit Memo invoice type.
Invoices Count	Shows the invoices count excluding the Credit Memo and Debit Memo invoice type.
Avg Invoices Amount	This metric is computed as follows: Invoices Amount / Invoices Count.
Credit Memos Amount	Shows the invoice amount for the Credit Memo invoice type.
Credit Memos Count	Shows the invoices count for Credit Memo invoice type.
Avg Credit Memos Amount	This metric is computed as follows: Credit Memos Amount / Credit Memos Count.
Debit Memos Amount	Shows the invoice amount for the Debit Memo invoice type.
Debit Memos Count	Shows the invoices count for Debit Memo invoice type.
Avg Debit Memos Amount	This metric is computed as follows: Debit Memos Amount / Debit Memos Count.
Credit Memos to Invoices Amount %	This metric is computed as follows: (Credit Memos Amount / Invoices Amount) * 100.
Discount Offered Amount	Shows the discount offered amount for all transactions.
Discount Offered %	This metric is computed as follows: (Discount Offered Amount / Total Transaction Amount) * 100.
Total Transaction Amount	Shows the sum of Invoice amount, Debit Memos Amount and Credit Memos Amount.
Total Transaction Count	Shows the sum of Invoice Count, Debit Memos Count and Credit Memos Count.

Financials—AP Liabilities

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

Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Invoice Accounting date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently we support only accounted invoices.

Metrics

Metric	Metric Definition
Liability Distribution Amount	Shows the Liability distribution amount.
Liability Balance Amount	This metric shows balance of AP liability account as of the selected time.

Financials—AP Payments

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

Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Payment Accounting date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently we support only accounted payments.

Metrics

Metric	Metric Definition
Payments Amount	Shows the total payments amount for the invoices and grain is payments or check number.
Avg Payments Amount	This metric is computed as follows: (Payments Amount / Payments Count) * 100. And grain is payments or check number.
Payments Document Count	Shows the payments document count and grain is payments or check number.
Overdue Payments Amount	Shows the amount of payment transactions where the payment date exceeds the scheduled payment date and the payment schedule status is fully paid or partly paid. Excludes cancelled payments and considers all invoice types. The grain for this is metric is Payment Schedules.
Overdue Payments Count	Shows the count of payment transactions where the payment date exceeds the scheduled payment date and the payment schedule status is fully paid or partly paid. Excludes cancelled payments and considers all invoice types. The grain for this is metric is Payment Schedules.
On Time Payments Amount	Shows the amount of payment transactions where the payment date is lesser than or equal to the scheduled payment date and payment schedule is fully paid. Excludes cancelled payments and considers all invoice types. The grain for this is metric is Payment Schedules.
On Time Payments Count	Shows the count of payment transactions where payment date is lesser than or equal to scheduled payment date and payment schedule is fully paid. Excludes cancelled payments and considers all invoice types. The grain for this is metric is Payment Schedules.
Total Paid Installments Count	This metric is computed as follows: Overdue Payments Count + On Time Payments Count.
On Time Payment Performance %	This metric is computed as follows: (On Time Payments Count / Total Payments Count) * 100.
Total Payment Days	Shows the total payment days for fully paid invoices and considers all invoice types. Payment days is computed as follows: Payment date - Invoice date.
Avg Supplier Payment Days	This metric is computed as follows: Total Payment Days / Total Payment Count.
Weighted Avg Supplier Payment Days	This metric is computed as follows: Total Payment Days times Payment Amount / Total Payment Amount.
Interest Penalties Paid	Shows the payment amount for invoices with the Interest invoice type.
% Interest Penalties Paid	This metric is computed as follows: (Interest Penalties Paid / Payment amount) * 100.
Electronic Payment Amount	Shows the paid invoice amount using electronic payment method.
% Electronic Payment Amount	This metric is computed as follows: (Electronic Payment Amount / Payments Amount) * 100.
Discount Taken Amount	Shows the discount amount taken for the invoice payments
Discount Taken %	This metric is computed as follows: (Discount Taken Amount / Total Transaction Amount) * 100. This metric will provide correct value only when used with common or pillar specific dimensions.
Discount Lost Amount	Shows the discount amount lost for the invoice payments. This metric is supported only in Document Currency.
Discount Lost %	This metric is computed as follows: (Discount Lost Amount / Total Transaction Amount) * 100. This metric is supported only in Document Currency and will provide correct value only when used with common or pillar specific dimensions.
Discount Remaining Amount	This metric is computed as follows: Discount Offered Amount - Discount Taken Amount - Discount Lost Amount. This metric is supported only in Document Currency and will provide correct value only when used with common or pillar specific dimensions.
Payment Exchange Loss(Gain) Amount	Shows the payment exchange loss or gain amount for the invoices and grain is payments or check number.
Discount Taken Exchange Loss(Gain) Amount	Shows the discount taken exchange loss or gain amount for the invoices and grain is payments or check number.
Payment Distribution Amount	Shows the payment distribution amount for AP Payments.

Receivables

Overview

These tables describe Receivables metrics.

Financials—AR Adjustments

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Adjustment date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently we support only posted adjustments.

Metrics

Metric	Metric Definition
Adjustments Amount	Shows the adjustments amount that is adjusted to the invoices, debit memos, chargebacks, onaccount credits, deposits, and guarantees.
Adjustments Count	Shows the adjustments count that is adjusted to the invoices, debit memos, chargebacks, onaccount credits, deposits, and guarantees.
Adjustments Distribution Amount	Shows the adjustments distribution amount.

Financials—AR Aging

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Transaction date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently we support only posted transactions.

Metrics

Metric	Metric Definition
Closing Amount	Shows the ending balance of the specified accounts and can be aggregated by Business Unit, Customer, Customer Account and, Time.
Opening Amount	Shows the opening balance of the specified accounts and can be aggregated by Business Unit, Customer, Customer Account, and Time.
Activity Amount	Shows the activities amount of the specified accounts and can be aggregated by Business Unit, Customer, Customer Account, and Time.
Aging Amount - Invoice Date Basis	Shows the aging amount for the open invoices and unapplied receipts based on transaction date grouped by selected aging period.
Aging Count  - Invoice Date Basis	Shows the aging count for the open invoices and unapplied receipts based on transaction date grouped by selected aging period.
Aging Amount - Schedule Date Basis	Shows the aging amount for thefor the open invoices and unapplied receipts based on Schedule date grouped by selected aging period.
Aging Count  - Schedule Date Basis	Shows the aging count for the for the open invoices and unapplied receipts based on Schedule date grouped by selected aging period.
Total Outstanding Amount	Shows the outstanding amount which includes current and overdue invoices and receipts.
Total Outstanding Invoices Count	Shows the count of outstanding invoices and unapplied receipts.
Avg Invoice Days Outstanding	This metric is computed as follows: Total number of days invoice outstanding / Total outstanding Invoices Count. This is based on Invoice date.
Current Amount	Shows the invoices amount which are yet to cross the schedule due date.
Current Invoices Count	Shows the invoices count which are yet to cross the schedule due date.
Avg Invoice Days Current	This metric is computed as follows: Total number of days before due date / Current Invoices Count. This is based on schedule date.
Current Amount to Total Outstanding %	This metric is computed as follows: (Current Amount / Total Outstanding Amount) * 100.
Current Count to Total Outstanding %	This metric is computed as follows: (Current Invoices Count / Total Outstanding Invoices Count) * 100.
Overdue Amount	Shows the invoices and unapplied receipts amount which has crossed the schedule due date.
Overdue Invoices Count	Shows the invoices and unapplied receipts count which has crossed the schedule due date.
Avg Invoice Days Overdue	This metric is computed as follows: Total number of days invoice overdue / Overdue Invoices Count. This is based on schedule date.
Overdue Amount to Total Outstanding %	This metric is computed as follows: (Overdue Amount / Total Outstanding Amount) * 100.
Overdue Count to Total Outstanding %	This metric is computed as follows: (Overdue Invoices Count / Total Outstanding Invoices Count) * 100.
Risk Amount	Shows the receipt amount for which cash is not cleared or risk is not elimiated

Financials—AR Credit Memo Applications

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Credit Memo Accounting date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently we support only posted credit memo applications.

Metrics

Metric	Metric Definition
Credit Memo Applications Amount	Shows the credit memo applications amount. This consider Credit Memo with Application Status as Applied and Credit Memo Reversals with Application Status as Activity.
Credit Memo Applications Count	Shows the credit memo applications count. This consider Credit Memo with Application Status as Applied and Credit Memo Reversals with Application Status as Activity.

Financials—AR Receipts and Applications

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Receipt date for Receipts and Transaction date for Applications to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently we support only posted receipts and applications.

Metrics

Metric	Metric Definition
Receipts Amount	Shows the receipts amount from the customers.
Receipts Transaction Count	Shows the distinct count of receipt numbers.
Avg Receipts Amount	This metric is computed as follows: Receipts Amount / Receipts Count.
Unapplied Receipts Amount	Shows receipt amount from the customers that are unapplied against outstanding invoices.
Receipts Applications Amount	Shows receipt amount from the customers that are applied against outstanding invoices.
Other Receipt Application Amount	Shows receipt amount that is applied to prepayment, claim investigations activities.
Discounts Taken Amount	Shows the total discount amount that was taken.
Discounts Taken of Applied Receipts %	This metric is computed as follows: (Discounts Taken Amount / Receipts Applications Amount) * 100.
Earned Discounts Amount	Shows the total earned discount amount that was taken.
Earned Discounts of Total Discount %	This metric is computed as follows: (Earned Discounts Amount / Discounts Taken Amount) * 100.
Unearned Discounts Amount	Shows the total unearned discount amount that was taken.
Unearned Discounts of Total Discount %	This metric is computed as follows: (Unearned Discounts Amount / Discounts Taken Amount) * 100.
Exchange Gain or Loss Amount	Shows the exchange gain or loss amount incurred at the time of receipt.
Receipts Transaction Count	Shows the distinct count of Receipt numbers.
Receipt Distribution Amount	Shows the receipt and application distribution amount.
On account Amount	Shows the receipt amount applied to On account activity when customer is found.
Unidentified Amount	Shows the unidentified receipts transaction amount.
Credit Card Refund Amount	Shows the Credit Card Refund amount.
Credit Card Chargeback Amount	Shows the Credit Card Chargeback amount.
Receipt Refund Amount	Shows the Receipt refund amount.
Receipt Write-Off Amount	Shows the Receipt Write-off amount.
Receipt to Receipt Application Amount	Shows the Receipt to Receipt Application amount.

Financials—AR Revenue

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Transaction date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently we support only posted transactions.

Metrics

Metric	Metric Definition
Transaction Amount	Shows the transaction header amount.
Line Amount	Shows the transaction line amount.
Distribution Amount	Shows the distribution amount.
Revenue Amount	Shows the revenue distribution amount that is recognized.
Unearned Revenue Amount	Shows the unearned revenue distribution amount that is yet to be recognized.
Freight Amount	Shows the freight distribution amount.
Tax Amount	Shows the tax distribution amount.
Long Term Deferred Revenue	Shows the Deferred or Unearned Revenue distribution amount that will be recognized after 365 days from current system date.
Short Term Deferred Revenue	Shows the Deferred or Unearned Revenue distribution amount that will be recognized within 365 days from current system date.
Unbilled Receivable Amount	Shows the unbilled receivable amount.

Financials—AR Transactions

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Transaction date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently we support only posted transactions.

Metrics

Metric	Metric Definition
Invoices Amount	Shows the invoice amount which includes Chargeback, Deposits, Guarantee, Invoices invoice types and excludes the Credit Memo and Debit Memo transaction type.
Invoices Count	Shows the invoices count which includes Chargeback, Deposits, Guarantee, Invoices invoice types and excludes the Credit Memo and Debit Memo transaction type.
Avg Invoices Amount	This metric is computed as follows: Invoices Amount / Invoices Count.
Debit Memos Amount	Shows the invoice amount for the Debit Memo transaction type.
Debit Memos Count	Shows the invoices count for Debit Memo transaction type.
Avg Debit Memos Amount	This metric is computed as follows: Debit Memos Amount / Debit Memos Count.
Credit Memos Amount	Shows the invoice amount for the Credit Memo transaction type.
Credit Memos Count	Shows the invoices count for Credit Memo transaction type.
Avg Credit Memos Amount	This metric is computed as follows: Credit Memos Amount / Credit Memos Count.
Total Transactions Amount	Shows the sum of invoice amount, Debit Memos Amount and Credit Memos Amount.
Total Transactions Count	Shows the distinct count of invoice numbers.

Procurement

Overview

These table describe Procurement metrics.

Procurement—Agreements

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

Metrics

Metric	Metric Definition
Header Agreed Amount	This metric is calculated as sum of header agreed amount.
Header Released Amount	This metric is calculated as sum of header released amount.
Header Released %	This metric is calculated as total agreement released amount divided by agreement amount.
Line Agreed Amount	This metric is calculated as sum of line agreed amount.
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.
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.
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.
Average Unit Price	Average of unit price at lines.
Header Agreement Count by Release %	Count of agreement header release percent in different bucket percentages.
Header Agreement Count Expired in Days	Count of agreement header which will expire in different bucket days.
Agreement Header Count	Count of distinct agreement headers.
Agreement Lines Count	Count of distinct blanket agreement lines.
Agreement Approval Cycle Time	This metric is calculated as average difference between agreement approval date for version zero and creation date.
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.
Approvers Count	This metric is calculated as average approvers for version zero of an agreement.
Item Count	Count of distinct items.
Supplier Count	Count of distinct suppliers.
Supplier Site Count	Count of distinct supplier sites.
Buyer Count	Count of distinct buyers.
Header Expiring Days	This metric is calculated as average difference between end date and system date where agreement header end date is not null.
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.
Average Number of Revisions	This metric is calculated as average of agreement versions.
Amendments Count	This metric is calculated as average amendments done for an agreement.
Internal Amendments Count	This metric is calculated as average number of internal amendments for an agreement.
Supplier Amendments Count	This metric is calculated as average number of supplier initiated amendments for an agreement.
Agreement Line Quantity	This metric is calculated as sum of agreement line quantity.

Procurement—Purchase Orders

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

Metrics

Metric	Metric Definition
Ordered Quantity	This metric is calculated as sum of quantity net of cancelled quantity at distribution level.
Original Ordered Quantity	This metric is calculated as sum of quantity including cancelled quantity at distribution level.
Cancelled Quantity	This metric is calculated as sum of cancelled quantity at distribution level.
Consignment Quantity	This metric is calculated as sum of consigned quantity at distribution level.
Billed Quantity	This metric is calculated as sum of billed quantity at distribution level.
Delivered Quantity	This metric is calculated as sum of delivered quantity at distribution level.
Received Quantity	This metric is calculated as sum of received quantity at schedule level.
Shipped Quantity	This metric is calculated as sum of shipped quantity at schedule level.
Accepted Quantity	This metric is calculated as sum of accepted quantity at schedule level.
Rejected Quantity	This metric is calculated as sum of rejected quantity at schedule level.
Over Receipt Quantity	This metric shows quantity that is received more that purchase order quantity.
Purchase Order Count	Count of distinct purchase order headers.
Purchase Order Lines Count	Count of distinct purchase order lines.
Requisition Lines Count	Count of distinct requisition lines associated in purchase order distributions.
Average Number of Revisions	This metric is calculated as average of revision numbers of a purchase order.
Amendments Count	This metric is calculated as average amendments done for a purchase order.
Internal Amendments Count	This metric is calculated as average number of internal amendments for a purchase order.
Supplier Amendments Count	This metric is calculated as average number of supplier initiated amendments for a purchase order.
Pre Processing Lead Time	This metric is calculated as average difference between purchase order approval date and purchase order creation date for version zero.
Approvers Count	This metric is calculated as average number of approvers in a purchase order.
PR to PO Cycle Time	This metric is calculated as average difference between purchase order creation date and requisition line approval 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.
PO Close Cycle Time	This metric is calculated as average difference between purchase order close date and purchase order creation date.
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.
Requisition Based PO %	This metric is calculated as count of distribution with requisition references divided by count of total distributions.
Buyers Count	Count of distinct buyers.
Payment Terms Count	Count of distinct payment terms.
Ordered Amount	This metric is calculated as sum of ordered amount at distribution level inclusive of inclusive taxes.
Total Exclusive Tax Amount	This metric is calculated as sum of total exclusive tax amount at distribution level.
Total Amount	This metric is calculated as sum of total amount at distribution level.
Non Recoverable Tax Amount	This metric is calculated as sum of non recoverable tax amount at distribution level.
Recoverable Tax Amount	This metric is calculated as sum of recoverable tax amount at distribution level.
Non Recoverable Inclusive Tax Amount	This metric is calculated as sum of non recoverable inclusive tax amount at distribution level.
Recoverable Inclusive Tax Amount	This metric is calculated as sum of recoverable inclusive tax amount at distribution level.
Delivered Amount	This metric is calculated as sum of delivered amount at distribution level.
Billed Amount	This metric is calculated as sum of billed amount at distribution level.
Cancelled Amount	This metric is calculated as sum of cancelled amount at distribution level.
Accepted Amount	This metric is calculated as sum of accepted amount at schedule level.
Accepted Rate	This metric is calculated as sum of accepted amount divided by sum of received amount at schedule level.
Received Amount	This metric is calculated as sum of received amount at schedule level.
Shipped Amount	This metric is calculated as sum of shipped amount at schedule level.
Avg Unit Price	This metric is calculated as sum of ordered amount excluding inclusive taxes divided by sum of ordered quantity.
Max Unit Price	This metric is calculated as maximum of ordered amount excluding inclusive taxes divided by sum of ordered quantity at distribution level.
Min Unit Price	This metric is calculated as minimum of ordered amount excluding inclusive taxes divided by sum of ordered quantity at distribution level.
Average Amount Per PO	This metric is calculated as sum of ordered amount divided by count of distinct purchase orders.
Supplier Count	Count of distinct Supplier.
Open PO Count	Count of purchase order header status equal to Open and Closed for Receiving.
Closed PO Count	Count of purchase order header status equal to Closed for Invoicing, Closed, and Finally Closed.
Rejected Quantity %	This metric shows Rejected Quantity percentage to overall Receipt Quantity for a given period.
Over Receipt Quantity %	This metric shows Over Receipt Quantity percentage to overall Receipt Quantity for a given period.
Cancelled Quantity %	This metric shows Cancelled Quantity percentage to overall Ordered Quantity for a given period.
Discounts Amount	This metric shows discount amount for the purchase order lines which has discount type as amount or percentage.
Negotiated Amount	This metric shows amount of the purchase order lines which has negotiated indicator as Y.
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.
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.
Over Receipt Amount	This metric shows amount that is received more than purchase order quantity at schedule level.

Procurement—Receipts

These fact folder in this subject area shows below metrics details.

Metrics

Metric	Metric Definition
Received Quantity	This metric is calculated as sum of received quantity.
Accepted Quantity	This metric is calculated as sum of accepted quantity.
Delivered Quantity	This metric is calculated as sum of delivered quantity.
Rejected Quantity	This metric is calculated as sum of rejected quantity.
Returned Quantity	This metric is calculated as sum of returned quantity.
Consumed Quantity	This metric is calculated as sum of consumed quantity.
Receipt Headers Count	Count of distinct receipt headers.
Receipt Lines Count	Count of receipt lines.
Purchase Order Count	Count of distinct purchase orders.
Purchase Order Schedule Count	Count of distinct purchase order schedule.
Shipped Quantity	This metric is calculated as sum of shipped quantity.
Received Lines On Time %	This metric is calculated as count of lines received on time 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 Early %	This metric is calculated as count of lines received early divided by count of receipt lines.
Receipt Lines with Correction Count	This metric is calculated as count of receipt lines with atleast one correction transaction.
Receipt Lines with Correction %	This metric is calculated as receipt corrected count divided by receipt line count.
Receipt Lines Rejected Count	This metric is calculated as count of receipt lines with rejected quantity greater than zero.
Receipt Lines Rejected %	This metric is calculated as receipt rejected 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 Accepted %	This metric is calculated as receipt accepted 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 Returned %	This metric is calculated as receipt returned count divided by receipt lines count.
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.
Transportation Days	This metric is calculated as average difference between receipt header creation date and shipment date for advance shipment notice-based receipts.
ASN Receipts %	This metric is calculated as count of advanced shipment notice-based receipts divided by count of receipt headers.

Procurement—Requisitions

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

Metrics

Metric	Metric Definition
Requisition Quantity	This metric is calculated as sum of quantity at distribution level and excludes 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.
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.
Pending Approval Requisition Lines Count	Count of requisition lines with pending approval status and excludes 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 metrics excludes internal requisition and 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.
Processed Requisition Lines Count	Count of requisition lines which got converted to purchase order and purchase order header having processed date (version 0). This metrics 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 metrics excludes internal requisition and reinstate, split, and replaced line status.
Unfulfilled Overdue Requisition %	This metric shows Unfulfilled Overdue Requisition Amount percentage of the overall Requisition Amount for a given period.
Fulfilled Requisition Lines Count	Count of requisition lines for which purchase order got processed and has purchase order line fulfilled flag value as Y. 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 metrics excludes internal requisition and 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.
PR to PO Cycle Time	This metric is calculated as average difference between purchase order creation date and requisition line approval date. This metrics excludes internal requisition and 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 metrics excludes internal requisition and reinstate, split, and replaced line status.
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 metrics 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 metrics excludes internal requisition and 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.
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 metrics excludes internal requisition and reinstate, split, and replaced line status.
Approved Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with approved status. This metrics excludes 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 metrics 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 metrics excludes internal requisition and reinstate, split, and replaced line status.
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 metrics 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. 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 metrics excludes internal requisition and 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 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 analytics currency. Metrics in these folders show amounts in their respective currencies. Currently we support only accounted invoices.

Metrics

Metric	Metric Definition
Invoice Amount	This metric is calculated as Sum of Amounts from the Invoice Accounting distribution lines for an invoice distribution.
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.
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.
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.
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.
Addressable Spend	This metric is calculated as the sum of Spend, where invoice distribution has a Purchase Order reference, and Invoice Line types are either Item or Misc, and excludes any tax-related lines in invoices.
PO Matched Spend	This metric is calculated as the sum of Invoice Amounts, where Invoice distributions has a Purchase Order Reference.
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.
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.
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.
Other Non Agreement Spend	This metric is calculated as Non Agreement Spend minus Agreement Leakage Spend.
Negotiated Spend	This metric is calculated as PO Matched Spend where the Negotiated Flag is checked for the corresponding Purchase Orders Lines.
Non Negotiated Spend	This metric is calculated as PO Matched Spend where the Negotiated Flag is not checked for the corresponding Purchase Orders Lines.
Average Spend Per invoice	This metric is calculated as the sum of Spend divided by the Count of Spend Invoices.
Quantity Invoiced	This metric is calculated as the sum of Quantity Invoiced from Invoice distributions.
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 Lines Count	This metric is calculated as the Count of Distinct invoice Lines.
Invoices Count	This metric is calculated as the Count of Distinct invoice Headers.
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.
Manual Invoices Count	This metric is calculated as the Count of Distinct Invoice Headers where Invoice Header source is equal to Manual Invoice Entry.
Suppliers Count	This metric is calculated as the Count of Distinct Suppliers on Invoice Headers.
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.
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.
Paid Invoices Count	This metric is calculated as Count of Distinct Invoice headers where invoice header is already paid.
Open Invoices Count	This metric is calculated as Count of Distinct Invoice headers where invoice header is not paid yet.
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.
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.
Buyer Count	This metric is calculated as Distinct Buyers on Invoice Headers.
Supplier Site Count	This metric is calculated as Count of Distinct Supplier Sites on Invoice Headers.
Payables Invoicing Business Unit Count	This metric is calculated as distinct count of Payables Invoicing Business Units on Invoice Headers.
Purchasing Category Count	This metric is calculated as Count of Distinct Purchasing Category on Invoice Lines.
Payment Terms Count	This metric is calculated as Count of Distinct Payment Terms on Invoice Headers.
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.
PO Matched Spend %	This metric is calculated as percentage of PO Matched Spend over Spend.
Non PO Matched Spend %	This metric is calculated as percentage of Non PO Matched Spend over Spend.
Agreement Spend %	This metric is calculated as percentage of Agreement Spend over Spend.
Non Agreement Spend %	This metric is calculated as percentage of Non Agreement Spend over Spend.
Agreement Leakage Spend %	This metric is calculated as percentage of Agreement Leakage Spend over Spend.
Negotiated Spend %	This metric is calculated as percentage of Negotiated Spend over Spend.
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.
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.
Invoice Price Variance	This metric is calculated as sum of amounts from Invoice distribution for Distribution Line status Invoice Price Variance.

Projects

These tables describe Projects metrics.

PPM - Project Costs

These metrics will be used in the Analytics Currency (AC), Document Currency (DC), Project Currency (PC), Project Ledger Currency (PLC) and Ledger Currency (LC) fact folder in Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Ledger Currency Conversion Rate Date if this date is populated and if not available uses expenditure item date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metrics

Metric	Metric Definition
Raw Cost	Shows the Actual Raw Cost incurred
Burden Cost	Shows the Actual Burden Cost calculated as difference between Burdened Cost and Raw Cost
Burdened Cost	Shows the Actual Burdened Cost incurred
Billable Raw Cost	Shows the Actual Raw Cost from Cost distribution lines flagged as billable
Billable Burden Cost	Shows the Billable Burden Cost calculated as difference between Billable cost and Billable Raw Cost
Billable Cost	Shows the Actual Burdened Cost from Cost distribution lines flagged as billable
Non-Billable Raw Cost	Shows the Actual Raw Cost from Cost distribution lines flagged as not billable
Non-Billable Burden Cost	Shows the Non-Billable Burden Cost calculated as difference between Non-Billable cost and Non-Billable Raw Cost
Non-Billable Cost	Shows the Actual Burdened Cost from Cost distribution lines flagged as not billable
Capitalizable Raw Cost	Shows the Actual Raw cost from Cost distribution lines flagged as Capitalizable for Capitalizable projects
Capitalizable Burden Cost	Shows the Capitalizable Burden Cost calculated as difference between Capitalizable Cost and Capitalizable Raw Cost
Capitalizable Cost	Shows the Raw cost or Burdened Cost from Cost distribution lines flagged as Capitalizable based on whether Raw or Burdened cost is Capitalizable for the project type
Non-Capitalizable Raw Cost	Shows the actual raw cost from cost distribution lines flagged as not Capitalizable for Capitalizable projects
Non-Capitalizable Burden Cost	Shows the Non-Capitalizable Burden Cost calculated as difference between Non-Capitalizable Cost and Non-Capitalizable Raw Cost
Non-Capitalizable Cost	Shows the actual burdened cost from cost distribution lines flagged as not Capitalizable for Capitalizable projects
Billable and Capitalizable Raw Cost	Shows the actual raw cost from cost distribution lines flagged as both Billable and Capitalizable.
Billable and Capitalizable Burden Cost	Shows the Billable and Capitalizable Burden Cost calculated as difference between Billable and Capitalizable Burdened Cost and Raw Cost
Billable and Capitalizable Cost	Shows the Raw cost or Burdened Cost from Cost distribution lines flagged as Capitalizable and Billable based on whether Raw or Burdened cost is Capitalizable for the project type
Labor Cost	Shows the Labor Cost calculated as Burdened Cost that is associated with Resource Class 'PEOPLE'
Equipment Cost	Shows the Equipment Cost calculated as Burdened Cost that is associated with Resource Class 'EQUIPMENT'
Transfer Price Amount	Shows the Amount charged by Provider Organization to the Receiver Organization including Transfer Price Markup
Accounted Raw Cost	Shows the Raw Cost Amount that is accounted. This metric is available in Ledger Currency, Document Currency and Analytic Currency only.
Accounted Burden Cost	Shows the Burden Cost Amount that is accounted. This metric is available in Ledger Currency, Document Currency and Analytic Currency only.
Accounted Burdened Cost	Shows the Burdened Cost Amount that is accounted. This metric is available in Ledger Currency, Document Currency and Analytic Currency only.
Debit Amount	Shows the Debit Amount from Accounting for the Cost Distribution line. This metric is available in Ledger Currency, Document Currency and Analytic Currency only.
Credit Amount	Shows the Credit Amount from Accounting for the Cost Distribution line. This metric is available in Ledger Currency, Document Currency and Analytic Currency only.
Net Amount	Shows the difference between Debit Amount and Credit Amount. This metric is available in Ledger Currency, Document Currency and Analytic Currency only.
Raw Cost - ITD	Cumulative Sum of Raw cost from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Burden Cost - ITD	Cumulative Sum of Burden cost from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Burdened Cost - ITD	Cumulative Sum of Burdened cost from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable Raw Cost - ITD	Cumulative Sum of Billable Raw cost from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable Burden Cost - ITD	Cumulative Sum of Billable Burden cost from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable Cost - ITD	Cumulative Sum of Billable Burdened cost from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Billable Raw Cost - ITD	Cumulative Sum of Non-Billable Raw cost from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Billable Burden Cost - ITD	Cumulative Sum of Non-Billable Burden cost from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Billable Cost - ITD	Cumulative Sum of Non-Billable Burdened cost from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Capitalizable Raw Cost - ITD	Cumulative Sum of Capitalizable Raw cost from start of the Project to the reporting time period selected
Capitalizable Burden Cost - ITD	Cumulative Sum of Capitalizable Burden cost from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Capitalizable Cost - ITD	Cumulative Sum of Capitalizable Burdened cost from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Capitalizable Raw Cost - ITD	Cumulative Sum of Non-Capitalizable Raw cost from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Capitalizable Burden Cost - ITD	Cumulative Sum of Non-Capitalizable Burden cost from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Capitalizable Cost - ITD	Cumulative Sum of Non-Capitalizable Burdened cost from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable and Capitalizable Raw Cost - ITD	Cumulative Sum of Billable and Capitalizable Raw cost from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable and Capitalizable Burden Cost - ITD	Cumulative Sum of Billable and Capitalizable Burden cost from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable and Capitalizable Cost - ITD	Cumulative Sum of Billable and Capitalizable Burdened cost from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Labor Cost - ITD	Cumulative sum of Labor Cost is calculated as Burdened Cost that is associated with Resource Class 'PEOPLE' from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Equipment Cost - ITD	Cumulative sum of Equipment Cost is calculated as Burdened Cost that is associated with Resource Class 'EQUIPMENT' from start of the Project to the reporting time period selected. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Raw Cost - YTD	Year to date Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Burden Cost - YTD	Year to date Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Burdened Cost - YTD	Year to date Burdened Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable Raw Cost - YTD	Year to Date Billable Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable Burden Cost - YTD	Year to Date Billable Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable Cost - YTD	Year to Date Billable Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Billable Raw Cost - YTD	Year to Date Non-Billable Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Billable Burden Cost - YTD	Year to Date Non-Billable Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Billable Cost - YTD	Year to Date Non-Billable Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Capitalizable Raw Cost - YTD	Year to Date Capitalizable Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Capitalizable Burden Cost - YTD	Year to Date Capitalizable Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Capitalizable Cost - YTD	Year to Date Capitalizable Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Capitalizable Raw Cost - YTD	Year to Date Non-Capitalizable Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Capitalizable Burden Cost - YTD	Year to Date Non-Capitalizable Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Capitalizable Cost - YTD	Year to Date Non-Capitalizable Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable and Capitalizable Raw Cost - YTD	Year to Date Billable and Capitalizable Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable and Capitalizable Burden Cost - YTD	Year to Date Billable and Capitalizable Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable and Capitalizable Cost - YTD	Year to Date Billable and Capitalizable Burdened Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Labor Cost - YTD	Year to Date Labor Cost is calculated as Burdened Cost that is associated with Resource Class 'PEOPLE'. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Equipment Cost - YTD	Year to Date Equipment Cost is calculated as Burdened Cost that is associated with Resource Class 'EQUIPMENT'. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Raw Cost - QTD	Quarter to Date Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Burden Cost - QTD	Quarter to Date Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Burdened Cost - QTD	Quarter to Date Burdened Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable Raw Cost - QTD	Quarter to Date Billable Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable Burden Cost - QTD	Quarter to Date Billable Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable Cost - QTD	Quarter to Date Billable Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Billable Raw Cost - QTD	Quarter to Date Non-Billable Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Billable Burden Cost - QTD	Quarter to Date Non-Billable Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Billable Cost - QTD	Quarter to Date Non-Billable Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Capitalizable Raw Cost - QTD	Quarter to Date Capitalizable Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Capitalizable Burden Cost - QTD	Quarter to Date Capitalizable Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Capitalizable Cost - QTD	Quarter to Date Capitalizable Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Capitalizable Raw Cost - QTD	Quarter to Date Non-Capitalizable Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Capitalizable Burden Cost - QTD	Quarter to Date Non-Capitalizable Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Capitalizable Cost - QTD	Quarter to Date Non-Capitalizable Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable and Capitalizable Raw Cost - QTD	Quarter to Date Billable and Capitalizable Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable and Capitalizable Burden Cost - QTD	Quarter to Date Billable and Capitalizable Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable and Capitalizable Cost - QTD	Quarter to Date Billable and Capitalizable Burdened Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Labor Cost - QTD	Quarter to Date Labor Cost is calculated as Burdened Cost that is associated with Resource Class 'PEOPLE'. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Equipment Cost - QTD	Quarter to Date Equipment Cost is calculated as Burdened Cost that is associated with Resource Class 'EQUIPMENT'. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Raw Cost - PTD	Period to Date Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Burden Cost - PTD	Period to Date Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Burdened Cost - PTD	Period to Date Burdened Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable Raw Cost - PTD	Period to Date Billable Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable Burden Cost - PTD	Period to Date Billable Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable Cost - PTD	Period to Date Billable Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Billable Raw Cost - PTD	Period to Date Non-Billable Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Billable Burden Cost - PTD	Period to Date Non-Billable Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Billable Cost - PTD	Period to Date Non-Billable Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Capitalizable Raw Cost - PTD	Period to Date Capitalizable Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Capitalizable Burden Cost - PTD	Period to Date Capitalizable Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Capitalizable Cost - PTD	Period to Date Capitalizable Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Capitalizable Raw Cost - PTD	Period to Date Non-Capitalizable Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Capitalizable Burden Cost - PTD	Period to Date Non-Capitalizable Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Non-Capitalizable Cost - PTD	Period to Date Non-Capitalizable Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable and Capitalizable Raw Cost - PTD	Period to Date Billable and Capitalizable Raw Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable and Capitalizable Burden Cost - PTD	Period to Date Billable and Capitalizable Burden Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Billable and Capitalizable Cost - PTD	Period to Date Billable and Capitalizable Burdened Cost calculated using the Project/Receiver Fiscal Calendar. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Labor Cost - PTD	Period to Date Labor Cost is calculated as Burdened Cost that is associated with Resource Class 'PEOPLE'. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Equipment Cost - PTD	Period to Date Equipment Cost is calculated as Burdened Cost that is associated with Resource Class 'EQUIPMENT'. This metric is available in Project Ledger Currency, Project Currency and Analytic Currency only.
Projects Count	Distinct Count of Projects with Cost Distribution Lines
Tasks Count	Distinct Count of Tasks with Cost Distribution Lines
Quantity	Number of units related to an expenditure item
Labor Effort	Number of Labor units related to an expenditure item
Equipment Effort	Number of units of Equipment used
Labor Effort - ITD	Cumulative sum of Labor units from start of the project to the reporting time period selected
Equipment Effort - ITD	Cumulative sum of units of Equipment used from start of the project to the reporting time period selected
Labor Effort - YTD	Year to Date Number of Labor units related to an expenditure item
Equipment Effort - YTD	Year to Date Number of units of Equipment used
Labor Effort - QTD	Quarter to Date Number of Labor units related to an expenditure item
Equipment Effort - QTD	Quarter to Date Number of units of Equipment used
Labor Effort - PTD	Period to Date Number of Labor units related to an expenditure item
Equipment Effort - PTD	Period to Date Number of units of Equipment used

Descriptive Flexfield (DFF)

General Ledger

These descriptive flexfields are supported by General Ledger subject areas.

Subject Area Name	Descriptive Flexfield (DFF) Supported
Financials - GL Detail Transactions	Supports Journal Headers, Journal Lines, and Journal Batches Descriptive Flexfields.

Payables

These descriptive flexfields are supported by Payables subject areas.

Descriptive Flexfield (DFF)

Subject Area Name	Descriptive Flexfield (DFF) Supported
Financials - AP Invoices	Supports Suppliers, Supplier Sites, Invoice Headers, and Invoice Installments Descriptive Flexfields.
Financials - AP Aging	Supports Suppliers, Supplier Sites, Invoice Headers, and Invoice Installments Descriptive Flexfields.
Financials - AP Payments	Supports Suppliers, Supplier Sites, and Invoice Payments Descriptive Flexfields.
Financials - AP Liabilities	Supports Suppliers, Supplier Sites, and Invoice Headers Descriptive Flexfields.
Financials - AP Expenses	Supports Suppliers, Supplier Sites, Invoice Headers, Invoice Lines, and Invoice Distributions Descriptive Flexfields.
Financials - AP Holds	Supports Suppliers, Supplier Sites, Invoice Headers, Invoice Lines, Invoice Distributions, and Invoice Holds Descriptive Flexfields.

Receivables

These descriptive flexfields are supported by Receivables subject areas.

Descriptive Flexfield (DFF)

Subject Area Name	Descriptive Flexfield (DFF) Supported
Financials - AR Transactions	Supports Customer, Customer Account, Transactions Headers, and Transactions Schedules Descriptive Flexfields.
Financials - AR Receipts and Applications	Supports Customer, Customer Account, and Receipts Descriptive Flexfields.
Financials - AR Credit Memo Applications	Supports Customer and Customer Account Descriptive Flexfields.
Financials - AR Adjustments	Supports Customer and Customer Account Descriptive Flexfields.
Financials - AR Aging	Supports Customer, Customer Account, Transactions Headers, and Transactions Schedules Descriptive Flexfields.
Financials - AR Revenue	Supports Customer, Customer Account, Transactions Headers, Transactions Lines, and Transactions Distributions Descriptive Flexfields.

Assets

Subject Area Name	Descriptive Flexfield (DFF) Supported
Financials - Assets Transactions	Supports Asset Category, Asset Invoices and Asset Retirement Descriptive Flexfields.

Purchasing

Subject Area Name	Descriptive Flexfield (DFF) Supported
Procurement - Spend	Supports Suppliers, Supplier Sites, Invoice Headers, Invoice Lines, and Invoice Distributions Descriptive Flexfields.
Procurement - Purchase Orders	Supports Suppliers and Supplier Sites Descriptive Flexfields.
Procurement - Receipts	Receipt Headers and Receipt Lines Descriptive Flexfields.
Procurement - Agreements	Supports Suppliers and Supplier Sites Descriptive Flexfields.
Procurement - Requisitions	Supports Suppliers and Supplier Sites, Requisition Headers, Requisition Lines, and Requisition Distributions

Projects

Subject Area Name	Descriptive Flexfield (DFF) Supported
PPM - Project Costs	Supports Project, Task Structure, Project Types, Expenditure Categories, Expenditure Types, Class Categories, Class Codes, Project Class Codes, Project Expenditure Item, and Project Costing Details Descriptive Flexfields.