Table of Contents
- Title and Copyright Information
- Preface
- 1 Introduction
-
2
Tables
- Overview
-
Tables Details
-
Assets
- DW_FA_1245_1250_PROPERTY_LKP_TL
- DW_FA_ASSET_D
- DW_FA_ASSET_DESCRIPTION_LKP_TL
- DW_FA_ASSET_FINANCIALS_CF
- DW_FA_ASSET_HISTORY_D
- DW_FA_ASSET_KEYWORDS_D
- DW_FA_ASSET_SOURCE_LINES_D
- DW_FA_ASSET_TYPE_LKP_TL
- DW_FA_BOOK_CLASS_LKP_TL
- DW_FA_BOOK_CONTROLS_D
- DW_FA_BOOKS_D
- DW_FA_CAL_PERIOD_SUFFIX_LKP_TL
- DW_FA_CALENDAR_PERIODS_D
- DW_FA_CATEGORIES_D
- DW_FA_CATEGORY_TYPE_LKP_TL
- DW_FA_CONVENTION_TYPES_D
- DW_FA_DEPRN_PERIODS_D
- DW_FA_DISTRIBUTION_HISTORY_D
- DW_FA_FEEDER_SYSTEM_LKP_TL
- DW_FA_IMPAIRMENT_STATUS_LKP_TL
- DW_FA_IMPAIRMENTS_D
- DW_FA_LOCATIONS_D
- DW_FA_METHODS_D
- DW_FA_NEWUSE_LKP_TL
- DW_FA_OWNLEASE_LKP_TL
- DW_FA_PROPERTY_TYPE_LKP_TL
- DW_FA_RETIREMENT_TYPE_LKP_TL
- DW_FA_RETIREMENTS_D
- DW_FA_REVAL_VALUE_TYPES_LKP_TL
- DW_FA_REVALUATIONS_D
- DW_FA_SLA_TRANSACTIONS_CF
- DW_FA_TRANSACTION_TYPE_LKP_TL
-
Common
- DW_ACC_TYPE_LKP_TL
- DW_ACTIVE_INACTIVE_LKP_TL
- DW_ADJUSTMENT_STATUS_LKP_TL
- DW_AGING_TYPE_LKP_TL
- DW_AP_ACCOUNTING_STATUS_LKP_TL
- DW_AP_DIST_MATCH_STATUS_LKP_TL
- DW_AP_DISTRIBUTION_TYPE_LKP_TL
- DW_AP_HOLD_LKP_TL
- DW_AP_HOLD_TYPE_LKP_TL
- DW_AP_INV_APPR_STATUS_LKP_TL
- DW_AP_INV_LINE_PROD_TYP_LKP_TL
- DW_AP_INV_LINE_SOURCE_LKP_TL
- DW_AP_INV_SCH_STATUS_LKP_TL
- DW_AP_INV_VAL_STATUS_LKP_TL
- DW_AP_INVOICE_LINE_TYPE_LKP_TL
- DW_AP_INVOICE_SOURCE_LKP_TL
- DW_AP_INVOICE_TYPE_LKP_TL
- DW_AP_PAYMENT_METHOD_LKP_TL
- DW_AP_PAYMENT_STATUS_LKP_TL
- DW_AP_PAYMNT_DIST_TYPE_LKP_TL
- DW_AP_POSTING_STATUS_LKP_TL
- DW_APPTYPE_CODE_VALUES_LKP_TL
- DW_AR_ADJ_REASON_LKP_TL
- DW_AR_ADJUSTMENT_TYPES_LKP_TL
- DW_AR_APP_STATUS_LKP_TL
- DW_AR_DIST_SOURCE_TYPE_LKP_TL
- DW_AR_PAY_SCH_STATUS_LKP_TL
- DW_AR_RECEIPT_METHOD_LKP_TL
- DW_AR_RECEIPT_STATUS_LKP_TL
- DW_AR_RECEIPT_TYPE_LKP_TL
- DW_AR_REV_CATEGORY_TYPE_LKP_TL
- DW_AR_SCH_RULE_STATUS_LKP_TL
- DW_AR_SCH_RULE_TYPE_LKP_TL
- DW_AR_TRANSACTION_CLASS_LKP_TL
- DW_AR_TRANSACTION_TYPE_LKP_TL
- DW_AR_TRXN_REASON_LKP_TL
- DW_BALANCING_SEGMENT_D
- DW_BALANCING_SEGMENT_DH
- DW_BANK_ACCOUNT_D
- DW_BUCKET_TYPE_LKP_TL
- DW_BUSINESS_UNIT_D
- DW_BUSINESS_UNIT_D_TL
- DW_CHART_OF_ACC_LKP_TL
- DW_CODE_VALUES_LKP_TL
- DW_CONTENT_PARAM_CONFIG
- DW_COST_CENTER_D
- DW_COST_CENTER_DH
- DW_COUNTRY_D_TL
- DW_CURRENCY_DETAILS_D_TL
- DW_CUSTOMER_CATEGORY_LKP_TL
- DW_CUSTOMER_CLASS_LKP_TL
- DW_CUSTOMER_TYPE_CODE_LKP_TL
- DW_CUSTOMER_TYPE_LKP_TL
- DW_DAY_D
- DW_DAYS_OF_WEEK_LKP_TL
- DW_DEPARTMENT_D
- DW_DEPARTMENT_D_TL
- DW_DMD_EXT_TABLES
- DW_DMD_EXT_TABLE_COLUMNS
- DW_DMD_EXT_TABLE_DOMAINS
- DW_DMD_EXT_TABLE_JOIN_INFO
- DW_DMD_EXT_TABLE_SUBJECT_AREA_MAP
- DW_DMD_TABLE_DOMAINS
- DW_EGP_ITEM_TYPE_LKP_TL
- DW_EGP_LIFECYCLE_PHASE_LKP_TL
- DW_ENRICHMENT_TABLE_DETAILS
- DW_ERR_RECORDS
- DW_ERR_RECORD_STRUCTURE
- DW_FISCAL_CONTEXT_G
- DW_FISCAL_DAY_D
- DW_FISCAL_PERIOD_D
- DW_FISCAL_QUARTER_D
- DW_FISCAL_YEAR_D
- DW_FLEX_BI_OBJECT_LBL_LKP_TL
- DW_FLEX_BI_OBJECT_VAL_SET_H
- DW_GL_BATCH_APP_STATUS_LKP_TL
- DW_GL_JOURNAL_REV_STAT_LKP_TL
- DW_GL_JOURNAL_STATUS_LKP_TL
- DW_GL_LEDGER_RELATIONSHIPS_D
- DW_GL_TRANSFER_STATUS_LKP_TL
- DW_GLOBAL_EXCH_RATE_CG
- DW_GROUP_ACC_LKP_TL
- DW_INDUSTRY_LKP_TL
- DW_INSERT_ACCTG_METHD_LKP_TL
- DW_INSERT_COUNTRY_LKP_TL
- DW_INSERT_LEDGER_CAT_LKP_TL
- DW_INTERNAL_ORG_CLASS_D
- DW_INTERNAL_ORG_D
- DW_INTERNAL_ORG_D_TL
- DW_INV_ORGANIZATION_D
- DW_INV_ORGANIZATION_D_TL
- DW_INVENTORY_ITEM_D
- DW_INVENTORY_ITEM_D_TL
- DW_ITEM_CAT_ASSIGNMENTS_D
- DW_ITEM_CATEGORIES_D
- DW_ITEM_CATEGORIES_DH
- DW_ITEM_CATEGORIES_D_TL
- DW_ITEM_CATEGORY_SETS_D
- DW_ITEM_CATEGORY_SETS_D_TL
- DW_ITEM_CLASS_LKP_TL
- DW_ITEM_PHASE_LKP_TL
- DW_ITEM_STATUS_LKP_TL
- DW_JOURNAL_CATEGORY_LKP_TL
- DW_JOURNAL_SOURCE_LKP_TL
- DW_LEDGER_D
- DW_LEDGER_SET_ASSIGNMENTS_D
- DW_LEDGER_SET_D
- DW_LEGAL_EMPLOYER_D
- DW_LEGAL_EMPLOYER_D_TL
- DW_LEGAL_ENTITY_D
- DW_LEGAL_ENTITY_LEDGER_REL_D
- DW_MATCH_BASIS_LKP_TL
- DW_MONTH_D
- DW_MSC_PLAN_MAKE_BUY_LKP_TL
- DW_OAX_VERSION
- DW_OFA_SEGMENT_D_TL
- DW_ORGANIZATION_CF_DH
- DW_ORGANIZATION_TYPE_LKP_TL
- DW_PARTY_D
- DW_PARTY_SIC_CODE_TYPE_TL
- DW_PARTY_STATUS_LKP_TL
- DW_PLACE_OF_SUPPLY_TYPE_LKP_TL
- DW_PURCHASE_BASIS_LKP_TL
- DW_QUARTER_D
- DW_RCPT_CREATION_STATUS_LKP_TL
- DW_REFTYPE_CODE_VALUES_LKP_TL
- DW_SCM_CODE_VALUES_LKP_TL
- DW_SUPPLIER_SITE_D
- DW_SUPPLIER_SOURCE_LKP_TL
- DW_SUPPLIER_TYPE_LKP_TL
- DW_SUPSITE_PMT_GRP_NAME_LKP_TL
- DW_TARGET_EXTENSION_MAPPINGS_DFG
- DW_TAX_POINT_BASIS_LKP_TL
- DW_UNIT_OF_MEASURE_D_TL
- DW_USER_D
- DW_WEEK_D
- DW_WH_REFRESH_DETAILS
- DW_WH_REFRESH_SUMMARY
- DW_WORKER_LOCATION_D
- DW_WORKER_LOCATION_D_TL
- DW_XLA_ACCNT_LINE_TYPES_LKP_TL
- DW_XLA_ACCOUNT_CLASS_LKP_TL
- DW_XLA_EVENT_CLASSES_LKP_TL
- DW_XLA_EVENT_TYPES_LKP_TL
- DW_YEAR_D
- DW_YESNO_LKP_TL
- DW_YESNONEVER_LKP_TL
- DW_YN_LKP_TL
- DW_ZX_JURISDICTIONS_LKP_TL
- DW_ZX_RATES_LKP_TL
- DW_ZX_REGIMES_LKP_TL
- DW_ZX_TAXES_LKP_TL
- DW_ZX_WHT_CALC_POINT_LKP_TL
-
Expenses
- DW_EMPLOYEE_EXPENSE_CF
- DW_EXM_AUDIT_CODE_D_TL
- DW_EXM_AUDIT_ISSUE_D_TL
- DW_EXM_EXPENSE_CATEGORY_D_TL
- DW_EXM_EXPENSE_SOURCE_D_TL
- DW_EXM_EXPENSE_TEMPLATES_D
- DW_EXM_EXPENSE_TYPES_D
- DW_EXM_EXPENSE_TYPE_CATEGORY_D_TL
- DW_EXM_RECEIPT_STATUS_D_TL
- DW_EXM_REPORT_STATUS_D_TL
- DW_EXM_YES_NO_D_TL
- DW_PJF_EXP_TYPES_D_TL
- DW_PJF_PROJ_ELEMENTS_D_TL
- DW_PJF_PROJECTS_ALL_D_TL
- General Ledger
-
Payables
- DW_AP_AGING_BUCKETS_D
- DW_AP_HOLD_RELEASE_REASON_D
- DW_AP_HOLD_RELEASE_REASON_D
- DW_AP_HOLDS_CF
- DW_AP_SLA_AGING_INVOICE_CA
- DW_AP_SLA_AGING_SUPPLIER_CA
- DW_AP_SLA_EXPENSE_DIST_CF
- DW_AP_SLA_INVOICE_SCHEDULE_CF
- DW_AP_SLA_LIAB_PMT_CA
- DW_AP_SLA_LIAB_PMT_CF
- DW_AP_SLA_LIABILITY_DIST_CF
- DW_AP_SLA_PAYMENTS_CF
- DW_AP_TERMS_D
- DW_AP_TERMS_D_TL
- Procurement
-
Projects
- DW_CC_CHARGE_TYPE_LKP_TL
- DW_CC_PROCESSED_CODE_LKP_TL
- DW_COST_DIST_LINE_TYPE_LKP_TL
- DW_EVT_INVOICED_FLAG_LKP_TL
- DW_EXP_PERSON_TYPE_LKP_TL
- DW_PROJ_BILL_HOLD_LKP_TL
- DW_PROJ_CAPITAL_COST_LKP_TL
- DW_PROJ_PRIORITY_CODE_LKP_TL
- DW_PROJ_REVENUE_HOLD_LKP_TL
- DW_PROJ_SERVICE_TYPE_LKP_TL
- DW_PROJECT_CLASS_ASSIGNMENT_D
- DW_PROJECT_CLASS_CATEGORY_TL
- DW_PROJECT_CLASS_CODE_TL
- DW_PROJECT_COST_CF
- DW_PROJECT_D
- DW_PROJECT_D_TL
- DW_PROJECT_ELEMENT_D
- DW_PROJECT_ELEMENT_D_TL
- DW_PROJECT_EXP_CATEGORY_TL
- DW_PROJECT_EXPENDITURE_TYPE_D
- DW_PROJECT_EXPENDITURE_TYPE_D_TL
- DW_PROJECT_MNGR_CRRNT_D
- DW_PROJECT_NON_LABOR_RES_TL
- DW_PROJECT_PARTY_D
- DW_PROJECT_ROLE_TYPE_D
- DW_PROJECT_ROLE_TYPE_TL
- DW_PROJECT_SLA_COST_CF
- DW_PROJECT_STATUS_TL
- DW_PROJECT_SYSTEM_LINKAGE_TL
- DW_PROJECT_TASK_HIERARCHY_DH
- DW_PROJECT_TXN_DOC_ENTRY_TL
- DW_PROJECT_TXN_DOCUMENT_TL
- DW_PROJECT_TXN_SOURCE_TL
- DW_PROJECT_TYPE_D_TL
- DW_PROJECT_WORK_TYPE_TL
- DW_RESOURCE_CLASS_D
- DW_RESOURCE_CLASS_D_TL
- DW_REVENUE_CATEGORY_LKP_TL
- DW_REVENUE_RECOGNIZED_LKP_TL
-
Purchasing
- DW_ACCEPTANCE_REQUIRED_D_TL
- DW_AGING_ONSET_POINT_D_TL
- DW_AGREEMENT_CF
- DW_AGREEMENT_LINE_STATUS_D_TL
- DW_CONSMPTN_ADVICE_FREQ_D_TL
- DW_AGREEMENT_STATUS_D_TL
- DW_CONSMPTN_ADVICE_SUMMRY_D_TL
- DW_DOC_COMM_METHOD_D_TL
- DW_DOC_STYLE_LINES_TL
- DW_DOCUMENT_STATUS_D_TL
- DW_PO_AGENT_ASSIGNMENTS_D
- DW_PO_COUNTRY_CODE_D_TL
- DW_PO_DISCOUNT_TYPE_D_TL
- DW_PO_DOC_CREATION_METHOD_D_TL
- DW_PO_DOCUMENT_TYPES_ALL_D_TL
- DW_PO_LINE_STATUS_D_TL
- DW_PO_LOCATION_TYPE_D_TL
- DW_PO_MATCH_OPTION_D_TL
- DW_PO_MATCHING_TYPE_D_TL
- DW_PO_MODE_OF_TRANSPORT_D_TL
- DW_PO_SCHEDULE_STATUS_D_TL
- DW_PO_SERVICE_LEVELS_D_TL
- DW_POR_DESTINATION_TYPE_D_TL
- DW_POR_DLVR_TO_LCTN_TYPE_D_TL
- DW_POR_DOCUMENT_STATUS_D_TL
- DW_POR_FUNDS_STATUS_D_TL
- DW_POR_ITEM_SOURCE_D_TL
- DW_POR_LINE_STATUS_D_TL
- DW_POR_SOURCE_TYPE_D_TL
- DW_PRICE_BREAK_TYPE_D_TL
- DW_PURCHASE_ORDER_CF
- DW_PURCHASING_CATEGORY_D_TL
- DW_PURCHASING_CAT_HIERARCHY_D
- DW_PURCHASING_LINE_TYPE_D
- DW_PURCHASING_LINE_TYPE_D_TL
- DW_RATE_TYPE_D_TL
- DW_RCV_ASN_TYPE_D_TL
- DW_RCV_DESTINATION_TYPE_D_TL
- DW_RCV_ROUTING_HEADERS_D_TL
- DW_RCV_SHIPMENT_STATUS_D_TL
- DW_RCV_SHIPMENTS_CF
- DW_RCV_SOURCE_DOCUMENT_TYPE_D_TL
- DW_REQUISITION_CF
- DW_Y_N_D_TL
- DW_ZX_PRODUCT_TYPE_D_TL
-
Receivables
- DW_AR_ACCOUNT_CLASS_TL
- DW_AR_AGING_BUCKETS_D
- DW_AR_MEMO_LINES_TL
- DW_AR_PAYMENT_TERMS_D
- DW_AR_PAYMENT_TERMS_D_TL
- DW_AR_SCHEDULING_RULE_D
- DW_AR_SLA_ADJUSTMENTS_CF
- DW_AR_SLA_AGING_CUSTOMER_CA
- DW_AR_SLA_AGING_INVOICE_CA
- DW_AR_AGING_RCPT_CUSTOMER_CA
- DW_AR_AGING_RECEIPT_CA
- DW_AR_SLA_APPLICATIONS_CF
- DW_AR_SLA_CREDITMEMO_CF
- DW_AR_SLA_REVENUE_CF
- DW_AR_SLA_SCHEDULES_CF
- DW_AR_SLA_TRANSACTIONS_CF
- DW_AR_TRANSACTION_TYPES_D
- DW_AR_TRX_BATCH_SOURCES_D
- DW_CUSTOMER_ACCOUNT_D
- DW_CUSTOMER_LOCATION_D
- Subledger Accounting
- Tables Without WHO Columns
-
Assets
- 3 Relationship Diagram
- 4 Data Store
- 5 Data Lineage
- 6 Data Augmentation
-
7
Subject Areas
-
Subject Areas
- Overview
- Financials—AP Holds
- Financials—AP Aging
- Financials—AP Expenses
- Financials—AP Invoices
- Financials—AP Liabilities
- Financials—AP Payments
- Financials—AR Adjustments
- Financials—AR Aging
- Financials—AR Credit Memo Applications
- Financials—AR Receipts and Applications
- Financials—AR Revenue
- Financials—AR Transactions
- Financials — Assets Analysis
- Financials — Assets Transactions
- Financials—EXM Employee Expenses
- Financials—GL Account Analysis
- Financials—GL Balance Sheet
- Financials—GL Budgets
- Financials—GL Detail Transactions
- Financials—GL Profitability
- PPM — Project Costs
- Procurement—Agreements
- Procurement—Purchase Orders
- Procurement—Receipts
- Procurement — Requisitions
- Procurement—Spend
-
Business Questions
- Overview
- What is the trend of AP for last 8 quarters?
- How are my asset balances tracking across regions (COA) for last 2 years?
- What are the CapEx requirements in near future? Will PPE hold up, or will an early capital infusion be needed?
- What is the working capital position and trend for past x quarters?
- How is debt equity mix structured at present, and is it actionable for improved financial gearing?
- 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?
- What is the trend around operating and net margins for past 2 years?
- How is the trend analysis for journals from subledger sources against manual GL journals, both in terms of amount and volume?
- 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?
- What are the details of entries booked in GL for reclassification from expense to assets and vice versa?
- What is the count and amount of invoices processed for the period by business units and trend comparison?
- What are the invoice types processed by AP department and the payment methods used to understand the downstream activities?
- What is the validation, approval and accounting status of invoices processed during the period?
- No. of invoices paid vs unpaid including partly paid with amount?
- Analysis around payment terms by transaction type, transaction source for the invoices processed?
- What is the count and amount of payments processed for the period by business units and trend comparison?
- What is the ratio of on-time payment performance?
- What is the count and amount of overdue payments?
- What is the average supplier payment days by BU's?
- What are the interest penalties paid by amount and percentage?
- 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 is the count and value of AP invoices overdue?
- What is the summary of AP invoices across aging buckets, count, and value?
- What is the trend of outstanding AP Balances at consolidated level, supplier level, and Business Unit level?
- How are AP balances trending for a particular supplier over last 8 quarters?
- What are the top 10 suppliers with maximum AP outstanding?
- Whether the company was able to meet the guided revenue growth for past quarters or years?
- How is the actual performance vs the budgeted performance of top Balance Sheet metrics for the last quarter or year?
- What is the trend for profitability metrics actual vs budget and direction of variance?
- Is higher than anticipated OPEX a one-off case or how is the trend for past eight quarters?
- What is the split of budgeted receivables by entity or ledgers?
- 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?
- What is the count and amount of AP Invoices that have either Header Level Hold, Line Level Hold, or combination?
- 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 average number of days for invoices on hold and the trend for past six quarters?
- What is the count and amount of AP Invoices on Hold due to distribution variances?
- What is the count and amount of AP Invoices on Hold due to PO matching variances?
- What is the count and amount of AP Invoices on Hold due to supplier site limits?
- What is the split of invoices on Hold by manual holds vs system holds?
- What is the summary of invoices (count and amount) by various hold reasons and hold by user?
- 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?
- What is the trend of AP Expenses for the past six quarters?
- 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 count and amount of transactions processed over the period of time?
- What is the classification of transactions processed during the period by Transaction Type and Source?
- What are the payment terms and receipt methods associated with the transactions?
- What is the summary of Transactions by statuses?
- What is the count and amount of receipts processed over the period of time?
- What is the count and amount of applied receipts?
- What is the count and amount of unapplied receipts?
- What is the trend for Average Receipt Days?
- What is the analysis of due and overdue receipts?
- What is the amount of discount Taken vs Lost?
- 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?
- 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 ratio of AR Adjustments applications to Invoice %?
- What is the status of AR Adjustments?
- What is the count and value of AR invoices Overdue?
- 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 summary of AR invoices overdue with respect to their aging buckets and payment terms?
- What is the trend of outstanding AR Balances by Customer or Business Unit?
- What is the AR account activity for the period and balance amount by Business Unit?
- How are AR balances trending for a particular customer over the last eight quarters?
- What are the top 10 customers with maximum AR outstanding?
- What is the trend for operating revenue for past 6 quarters by Ledger, Legal Entity, Billing BU, etc?
- What is the revenue mix by geography, business units, product lines, SKU, key customers, transaction source, transaction type?
- What is the distribution of Revenue by top 10 customer accounts?
- What is the contribution of non operating revenue and trend for past quarters?
- What is the distribution of revenue by top 5 revenue accounts?
- 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 breakdown of inter company revenue vs external revenue based on AR transaction type, transaction source?
- What is the Revenue mix from services, subscription fees, material installation, merchant fees, sale of goods, etc?
- 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 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 analyze GL Balances/Journals with the ability to get the extended details of subledger transaction attributes and accounting events?
- 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 support account analysis across multi period, multi ledger at detailed or roll up account levels across Chart of Account Segments?
- How to monitor GL accounts with respect to accounting and posting activity for all contributing transactions during an accounting period?
- 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.
- What is the employee expense Spend by Business Units?
- 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 is the Total Expense Trend for last few quarters?
- Which are top cost centers by employee expenses?
- What is the expense breakdown by expense type?
- What is the number of expenses which are filed late?
- Who are the top managers by expenses?
- Which are the top cost centers and organizations with Audit violations for expense reports which are paid?
- What is the percentage of reports which are Auto approved?
- What is the trend in Credit vs Cash expense?
- What are the cycle times for report submission, filing, approvals?
- What commodities and services have been purchased, in what volume and price?
- How is purchase distributed across suppliers?
- Is a company using strategic suppliers and contracts effectively?
- What are my purchase volume across business units?
- What is my contract vs off contract spend?
- What are cycle times in terms of PR and PO Approval, PR to PO conversion?
- How many times are we amending purchase orders and whether amendment initiation is internal or external?
- How many approvers on a average are approving purchase orders?
- What are my lead time standard and variances in purchase cycles?
- What are purchase orders creation sources and corresponding requisition sources?
- When were products shipped and what is the average delivery times?
- Which suppliers deliver consistently on time?
- What is accepted and rejected rates for commodities, by suppliers?
- What are return rates for suppliers?
- What receipts are created manually or through ASNs?
- What are my processing and post processing lead time standards and variances for an Item?
- What are my products and services for which we have agreements?
- What are the agreements utilization rates?
- Which agreements are under utilized?
- Which agreements are utilized before expiry?
- What are the creation sources for agreements?
- What are my cycle times for agreement approvals?
- What are my negotiation to agreement approval cycle times?
- How many times are we amending agreements and whether amendment initiation is internal or external?
- How many approvers on a average are approving 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 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?
- What is the actual cost by Project and Task?
- What is the actual cost by Project Type?
- What is the actual cost by Project Organization?
- 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 % of cost have been billed?
- What is the actual cost by Project Class codes?
- What are the ITD, YTD and PTD actual costs?
- What is the Labor cost and effort breakup by Employee, Job?
- What is the trend of cost?
- What is the total project cost by Project Organization, Project Type, Expenditure type, Expenditure Category, Expenditure Organization?
- What is the trend of Project Cost by Organization, Project type etc?
- What is the overall net book value for PP&E assets and trend over multiple periods by entity, asset book,etc?
- What is the period active asset unit details for particular asset category and trend details?
- What is the period active asset mix across various asset categories?
- What is the asset mix across various asset types CIP, Capitalized, Expensed?
- What are the period wise last active asset employee assignment details?
- Summary of assets by original cost, salvage value, net book value by entity, category, time historic, etc.
- What is the average life of asset by asset category?
- What is summary of assets which has exceeded economic life or nearby end of life?
- How to track asset book health, lifecycle tracking with historic data?
- What is the summary of asset addition/ CapEx for a particular entity, asset book, asset category?
- What are the source document details for asset additions?
- What is the trend of asset retirement over a period of time in terms of cost retired, NBV retired?
- What are the details of asset retired by various asset categories?
- 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 reclassified during the period?
- What is the amount and quantity of assets adjusted by transaction type and GL accounts, segments?
-
Job Roles
- Overview
- Account Payable Invoice Supervisor
- Account Payable Payment Supervisor
- Accounts Payable Manager
- Accounts Payable Specialist
- Accounts Payable Supervisor
- Accounts Receivable Manager
- Accounts Receivable Specialist
- Asset Accountant
- Asset Accounting Manager
- Buyer
- Category Manager
- Expense Manager
- Financial Analyst
- General Accountant
- General Accounting Manager
- Procurement Contract Administrator
- Procurement Manager
- Project Accountant
- Project Administrator
- Project Manager
- Purchase Analysis
- Warehouse Manager
-
Duty Roles
- Overview
- 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
- 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
- Employee Expense Analysis Duty
- Fixed Asset Analysis Duty
- Fixed Asset Transactions Analysis Duty
- General Ledger Account Analysis Duty
- General Ledger Balance Sheet Analysis Duty
- General Ledger Budget Analysis Duty
- General Ledger Detail Transactions Analysis Duty
- Procurement Spend Analysis Duty
- Procurement Purchase Order Analysis Duty
- Procurement Purchase Receipts Analysis Duty
- Procurement Purchase Agreement Analysis
- Procurement Requisitions Analysis Duty
- Profitability Analysis Duty
- Project Costing Costs Analysis Duty
- Subject Area Metric Details
- Descriptive Flexfield (DFF)
-
Subject Areas
- 8 Prebuilt
- A Frequently Asked Questions
- B Troubleshooting