Skip to main content

GL Transaction Details

The data model includes ledger entries (debit, credit, and total posting), transaction details (debit, credit, and total posting), global totals for debit, credit, and posting across transactions, and manufacturing KPIs for regular and overtime labor hours with overtime percentage. It also provides views such as Trial Balance for balance summaries and GL Transaction Details for detailed financial transaction records, facilitating financial statement validation, analysis, and auditing.

Benefits of This Data Model​

  • Enhanced Financial Reporting: The data model allows for detailed financial statement validation and analysis through views like Trial Balance and GL Transaction Details.
  • Improved Audit Trail: Detailed record-keeping of all financial transactions enhances auditing processes and ensures transparency.
  • Efficient Manufacturing Analysis: Manufacturing KPIs for regular and overtime labor hours enable monitoring of labor productivity and overtime utilization.
  • Global Currency Insights: The aggregated view of transactions by account in global currency provides a comprehensive understanding of financial performance across regions.
  • Simplified Financial Analysis: The structured dimensions and measures streamline financial data analysis and decision-making processes.

Key Performance Indicators (KPIs)​

  • Ledger Debit: The amount debited in the ledger for a transaction.
  • Ledger Credit: The amount credited in the ledger for a transaction.
  • Ledger Posting: The total posting (sum of debits and credits) in the ledger for a transaction.
  • Transaction Debit: The amount debited in the transaction.
  • Transaction Credit: The amount credited in the transaction.
  • Transaction Posting: The total posting (sum of debits and credits) in the transaction.
  • Global Debit: The total amount debited globally across all transactions.
  • Global Credit: The total amount credited globally across all transactions.
  • Global Posting: The total global posting (sum of debits and credits) across all transactions.
  • Manufacturing KPI Regular Labor Hours: The total regular labor hours used in manufacturing key performance indicators.
  • Manufacturing KPI Overtime Labor Hours: The total overtime labor hours used in manufacturing key performance indicators.
  • Manufacturing KPI Overtime Hours %: The percentage of overtime hours over total labor hours in manufacturing key performance indicators.

Available Visualizations​

View NameDescription
Trial BalanceSummary of account balances to validate financial statements.
GL Transaction DetailsDetailed record of all financial transactions for analysis and auditing.
GL Transaction Details DBDatabase view providing direct access to transaction details.
GL Transaction by Account (Global Currency)Aggregated view of transactions by account in global currency.