General Ledger Tables and Views

Owned by Knowledge Assistant
Last updated: Apr 09, 2024
1 min read



Description of Issue

What are the most common GL table and related views for reporting purposes?



Context

  • Standard Query Language (SQL)

  • SQL Server Reporting Services (SSRS)

  • Database Table & Views

  • Crystal Reports



Cause

View needed for reports and views receive data from Munis tables



Resolution

Site's can use reporting views, view are populated by SQL tables. The specific table and fields programs are for Tyler internally and sites should not be using tables.

VIEWS:

  • gl_master equal to Accounts table

  • gl_master_history equal to AccountHistories table

  • gl_master_bal equal to MasterBals table

  • gl_masterbal_hit equal to MasterBalHistories table

  • gl_object equal to Objects table

  • gl_organs equal to Organizations table

  • gl_project equal to Projects

  • gl_journal_proof equal to JournalProofHeader & JournalProofDetail

  • gl_history equal to equal to Journals & JournalLineItems



Additional Information