Table of Contents
- Title and Copyright Information
- Preface
- 1 Introduction
-
2
Tables
-
Tables Details
- Expenses
- General Ledger
- Receivables
- Subledger Accounting
-
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_PAYMENT_METHOD_LKP_TL
- DW_AP_PAYMENT_STATUS_LKP_TL
- DW_AP_PAYMNT_DIST_TYPE_LKP_TL
- DW_AP_POSTING_STATUS_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_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_BUCKET_TYPE_LKP_TL
- DW_BUSINESS_UNIT_D
- DW_BUSINESS_UNIT_D_TL
- DW_CATALOG_CONTROL_LVL_LKP_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_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_TABLE_COLUMNS
- DW_DMD_EXT_TABLE_DOMAINS
- DW_DMD_EXT_TABLE_JOIN_INFO
- DW_DMD_EXT_TABLE_SUBJECT_AREA_MAP
- DW_DMD_EXT_TABLES
- DW_DMD_TABLE_DOMAINS
- DW_EGP_APPROVAL_STATUS_LKP_TL
- DW_EGP_ITEM_TYPE_LKP_TL
- DW_EGP_LIFECYCLE_PHASE_LKP_TL
- DW_EGP_PLANNING_CODE_LKP_TL
- DW_EGP_PLANNING_TYPE_LKP_TL
- DW_ENRICHMENT_TABLE_DETAILS
- DW_ERR_RECORD_STRUCTURE
- DW_ERR_RECORDS
- 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_CODE_COMBINATION_D
- DW_GL_JOURNAL_REV_STAT_LKP_TL
- DW_GL_JOURNAL_STATUS_LKP_TL
- DW_GL_LEDGER_RELATIONSHIPS_D
- DW_GL_SEGMENT_D
- DW_GL_SEGMENT_D_TL
- DW_GL_SEGMENT_DH
- DW_GL_TRANSFER_STATUS_LKP_TL
- 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_INV_ORG_USAGE_LKP_TL
- DW_ITEM_CAT_ASSIGNMENTS_D
- DW_ITEM_CATEGORIES_D
- DW_ITEM_CATEGORIES_D_TL
- DW_ITEM_CATEGORIES_DH
- 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_SET_ASSIGNMENTS_D
- DW_LEDGER_SET_D
- DW_LEGAL_ENTITY_D
- DW_LEGAL_ENTITY_LEDGER_REL_D
- DW_MATCH_BASIS_LKP_TL
- DW_MSC_PLAN_MAKE_BUY_LKP_TL
- DW_NATURAL_ACCOUNT_D
- DW_NATURAL_ACCOUNT_DH
- DW_OAX_VERSION
- DW_ORGANIZATION_TYPE_LKP_TL
- DW_PARTY_SIC_CODE_TYPE_TL
- DW_PARTY_STATUS_LKP_TL
- DW_PLACE_OF_SUPPLY_TYPE_LKP_TL
- DW_POR_ITEM_SOURCE_D_TL
- DW_PO_INV_MATCH_OPTION_LKP_TL
- DW_PURCHASE_BASIS_LKP_TL
- DW_RCPT_CREATION_STATUS_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_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
-
Purchasing
- DW_ACCEPTANCE_REQUIRED_D_TL
- DW_AGING_ONSET_POINT_D_TL
- DW_AGREEMENT_CF
- DW_AGREEMENT_LINE_STATUS_D_TL
- DW_AGREEMENT_STATUS_D_TL
- DW_CONSMPTN_ADVICE_FREQ_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_INVOICE_SPEND_CF
- DW_POR_DESTINATION_TYPE_D_TL
- DW_POR_DLVR_TO_LCTN_TYPE_D_TL
- DW_POR_DOCUMENT_STATUS_D_TL
- DW_POR_ITEM_SOURCE_D_TL
- DW_POR_LINE_STATUS_D_TL
- DW_POR_SOURCE_TYPE_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_PRICE_BREAK_TYPE_D_TL
- DW_PURCHASE_ORDER_CF
- DW_PURCHASING_CAT_HIERARCHY_D
- DW_PURCHASING_CATEGORY_D_TL
- 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
-
Cost Management
- DW_CST_COST_BOOKS_TL
- DW_CST_COST_ELEMENT_TYPES_LKP_TL
- DW_CST_COST_ELEMENTS_D
- DW_CST_COST_ELEMENTS_D_TL
- DW_CST_COST_METHODS_LKP_TL
- DW_CST_COST_ORG_BOOKS_D
- DW_CST_COST_PROFILES_D
- DW_CST_COST_PROFILES_D_TL
- DW_CST_EXPENSE_POOLS_D
- DW_CST_EXPENSE_POOLS_D_TL
- DW_CST_INV_VALUATION_CF
- DW_CST_ITEM_COST_CF
- DW_CST_SCENARIOS_D
- DW_CST_VALUATION_STRUCTURE_MODES_LKP_TL
- DW_CST_VALUATION_STRUCTURE_TYPES_LKP_TL
- DW_CST_VALUATION_STRUCTURES_TL
- DW_CST_VALUATION_UNITS_D
- DW_CST_VALUATION_UNITS_TL
- DW_ORA_CST_SCENARIO_STATE_LKP_TL
- DW_ORA_CST_SCENARIO_STATUS_SMPL_LKP_TL
- DW_ORA_CST_SCENARIO_TYPES_LKP_TL
- DW_ORA_CST_STD_COST_LEVEL_LKP_TL
-
Inventory Management
- DW_INV_LOCATOR_CONTROL_LKP_TL
- DW_INV_LOCATOR_D
- DW_INV_LOCATOR_TYPE_LKP_TL
- DW_INV_MATERIAL_TXNS_CF
- DW_INV_MTL_TXNS_LOT_SERIAL_CF
- DW_INV_OWNING_TYPE_LKP_TL
- DW_INV_SERIAL_NUM_LKP_TL
- DW_INV_SUB_TYPE_LKP_TL
- DW_INV_SUBINVENTORY_D
- DW_INV_TRANSACTION_TYPES_TL
- DW_INV_TRNX_ACTION_LKP_TL
- DW_INV_TXN_SOURCE_TYPES_TL
- DW_INV_YES_NO_NUMERIC_LKP_TL
-
Order Management
- DW_DEMAND_CLASS_LKP_TL
- DW_FOB_POINT_LKP_TL
- DW_FREIGHT_CHARGE_TERMS_LKP_TL
- DW_HOLD_RELEASE_REASON_LKP_TL
- DW_MSG_ENTITY_TYPE_LKP_TL
- DW_OM_FULFILLMENT_CF
- DW_OM_HOLD_CODES_D
- DW_OM_HOLD_CODES_D_TL
- DW_OM_HOLDS_CF
- DW_OM_STATUS_D
- DW_OM_STATUS_D_TL
- DW_ORDER_FULFILL_MODE_LKP_TL
- DW_ORDER_ITEM_SUBTYPE_LKP_TL
- DW_ORDER_ITEM_TYPE_LKP_TL
- DW_ORDER_LINE_CATEGORY_LKP_TL
- DW_ORDER_LINE_TYPE_LKP_TL
- DW_ORDER_RETURN_TYPE_LKP_TL
- DW_ORDER_TYPE_LKP_TL
- DW_RETURN_REASON_LKP_TL
- DW_SALES_PRODUCT_TYPE_LKP_TL
- DW_SHIPMENT_PRIORITY_LKP_TL
- DW_WSH_SERVICE_LEVEL_LKP_TL
- DW_WSH_TRANSPORT_MODE_LKP_TL
- Tables Without WHO Columns
-
Tables Details
- 3 Relationship Diagrams
- 4 Data Store
- 5 Data Lineage
- 6 Data Augmentation
-
7
Subject Areas
- Subject Areas
-
Business Questions
- How effective is an organization to schedule and manage fulfillment end-to-end cycle times?
- How is purchase distributed across suppliers?
- How long does it take for purchase requisitions to get approved?
- How many approvers on a average are approving agreements?
- How many approvers on a average are approving purchase orders?
- How many non-catalog purchase requisitions are created by volume, item, and amount?
- How many times are we amending agreements and whether amendment initiation is internal or external?
- How many times are we amending purchase orders and whether amendment initiation is internal or external?
- 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 items, categories, and suppliers with compliance issues in their purchase agreements.
- Identify the key areas for improving process efficiencies.
- Is a company using strategic suppliers and contracts effectively?
- Top 10 inventory movements by plant or item category
- Top 10 items issues by transaction type
- Top 10 items receipts by transaction type
- What are cycle times in terms of PR and PO Approval, PR to PO conversion?
- What are my cycle times for agreement approvals?
- What are my lead time standard and variances in purchase cycles?
- What are my negotiation to agreement approval cycle times?
- 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 my purchase volume across business units?
- What are purchase orders creation sources and corresponding requisition sources?
- What are return rates for suppliers?
- What are the agreements utilization rates?
- What is an organization's current period order booking, open, shipped, invoiced, returned, open returned, past due amount in terms of quantity and amounts?
- What are the creation sources for agreements?
- What is an organization's inventory position across supply chain in terms of quantity?
- What is an organization's inventory value across supply chain for an item, item category, and organization?
- What is my contract vs off contract spend?
- What is the average hold times for different kinds of holds?
- 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?
- What is the inventory valuations for items or item category for a given period?
- What is the item unit cost by different cost subelements like material, material overhead, and overhead by value and percentage?
- What is the item unit cost for a cost organization and different cost books?
- What is the shipment and delivery performance for an organization in terms of perfect order, shipped in full and on time (shipment and delivery) percentages?
- What is the total booking, returns, shipped, on time shipped, perfect orders, shipped in full, late shipped amounts trends?
- What is the trend for onhand quantity by product and category?
- What is the trend in inventory movement in and out for items, item category, and plants?
- What is the trend in inventory valuations for items and organizations?
- What is the trend of item costs over a period of time?
- What items are showing most volatile trend over a period of time?
- What commodities and services have been purchased, in what volume and price?
- What is accepted and rejected rates for commodities, by suppliers?
- What receipts are created manually or through ASNs?
- What type of holds are applied to orders?
- What,when and how much materials are being returned?
- When were products shipped and what is the average delivery times?
- Which agreements are under utilized?
- Which agreements are utilized before expiry?
- Which all orders have holds applied currently and in the past?
- Which product, category, organization are high in terms of inventory quantity in the asset subinventory location?
- Which suppliers deliver consistently on time?
-
Job Roles
- Account Payable Invoice Supervisor
- Account Payable Payment Supervisor
- Accounts Payable Manager
- Accounts Payable Specialist
- Accounts Payable Supervisor
- Buyer
- Category Manager
- Cost Accountant
- Inventory Manager
- Order Administrator
- Order Manager
- Procurement Contract Administrator
- Procurement Manager
- Purchase Analysis
- Warehouse Manager
-
Duty Roles
- Inventory Balances Analysis Duty
- Inventory Transactions Analysis Duty
- Inventory Valuations Analysis Duty
- Item Cost Analysis Duty
- Order Management Analysis Duty
- Order Management Holds Analysis Duty
- Procurement Purchase Agreement Analysis
- Procurement Purchase Order Analysis Duty
- Procurement Purchase Receipts Analysis Duty
- Procurement Requisitions Analysis Duty
- Procurement Spend Analysis Duty
- Subject Area Metric Details
- Descriptive Flexfield (DFF)
- 8 Prebuilt