General Ledger Tables and Views

Owned by Knowledge Assistant
Last updated: Dec 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 = (current/next year posted sum of MasterBal, memo amounts MasterBal + Proof and other account specific data)

  • gl_master_history = (prior year sum of MasterBal data)

  • gl_master_bal equal = (current/next year posted sum of each period)

  • gl_masterbal_hit = (prior year posted sum of each period)

  • gl_object = Objects in chart manager and chart of account segments

  • gl_organs = Organizations in chart manager and chart of account segments

  • gl_project = Projects of 5 or less characters from project master not flagged as PL only.

  • gl_journal_proof = (GEN, GCR, GNI, GEL & BUA) unposted proof transactions

  • gl_history = posted journals equal to journal inquiry/print records.




Additional Information