70 likes | 397 Views
Financial Management Reference Model. Teradata Industry Logical Data Models. Core Finance and Performance Management Subject Areas. Comprehensive enterprise-wide model of finance business functions 22 subject areas 500+ business questions
E N D
Teradata Industry Logical Data Models Core Finance and Performance Management Subject Areas • Comprehensive enterprise-wide model of finance business functions • 22 subject areas • 500+ business questions • Technology neutral – not designed for any specific ETL tool, ERP system, or business intelligence tool • Flexible and extensible architecture compatible with Decision Experts • Core Areas: G/L, A/R, FA, A/P, Procurement and Project Assets Revenue Expense Liabilities Equity G/L ACCOUNTS Accounts Receivable Fixed Assets Accounts Payable Procurement Project iLDM
Business Requirements Focus on Summary Financials Income Statement Balance Sheet Transaction details Journal voucher Links to sub-ledgers like Accounts Payable and Accounts Receivable Relates to: Set of Books Income Statement & Balance Sheet reporting Summary control accounts for sub-ledgers Transactional, functional and global (reporting) currencies Journal Entry transaction detail General Ledger General Data and Process Flows for General Ledger CONTRACTS CHANNEL PRODUCT PARTY Purchase Order Project G/L Balance G/L Internal Organization AP Invoices Time Reporting G/L Product Segment Journal Entry Time Period Fixed Assets Project Accounting G/L Accounts AR Invoices G/L Sub Account GL Sub Ledgers SALES ORDER REVENUE EXPENSE ASSET LIABILITIES EQUITY
Business Questions What is the profitability by geography, business unit, and product line? How do actual results compare to budget? What areas have the greatest variance from plan results? How much has been written off against each general ledger account? What is the expense history across controlling areas and cost centers? How do my overhead costs compare by store and region? How is this quarter’s income distributed across legal entities? What is the current balance sheet position? Concepts Chart of Account Balance Journal Entry GL Main Account GL Sub Account GL Internal Org GL Product Segment GL Project Segment Asset Account Liability Account Equity Account Expense Account Revenue Account General Ledger
A single Financial and Operational View – FPM LDMBlueprint for Integrating Finance and Operational Data • Pre-built industry LDMs spanning financial and operational data provide linkage between financial results and operational drivers • Integration with TDE 12.0 domains provides speed of deployment • Comprehensive enterprise-wide model of finance business functions • Technology neutral – not designed for any specific ETL tool, ERP system, or BI tool • Flexible and extensible architecture reduces implementation time and risk Industry-centric, Enterprise-wide data models including financial management data elements provides a flexible foundation for accelerating the integration of financial and operational data: CHANNEL LOCATION PARTY CONTRACTS PRODUCT Project G/L Internal Organization Purchase Order G/L Balance G/L Product Segment Journal Entry Time Period Inventory AP Invoices G/L Sub Account Labor Distribution G/L Accounts GL Sub Ledgers Fixed Assets Project Accounting Expense Liabilities Revenue Asset Equity AR Invoices Sales Order Training Admin Not all relationships are shown. Red indicates new in 2007. Payroll Human Resources Benefits Analysis