Project Ledger Tables and Views

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

• Standard Query Language (SQL)

• SQL Server Reporting Services (SSRS)

• Database Table & Views

• Crystal Reports

View needed for reports and views receive data from Munis tables

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.

• pa_project_master equal to Project table

• pa_segment equal to ProjectSegments table

• pa_project_string equal to ProjectStrings table

• pa_monthly_amounts equal to ProjectMonthAmounts table

• pa_journal_detail equal to ProjectJournalLines table