/
Database view that stores project ledger transaction details

Database view that stores project ledger transaction details



Description of Issue

Needing database view that stores project ledger transaction details



Context
  • Project Strings

  • Project Expense String

  • Project Funding Source String

  • Database Views



Cause

Needing database view that stores project ledger transaction details



Resolution

pa_transact_detail can be used



Additional Information

Additional PL database views:

pa_journal_detail (project journals view)

pa_monthly_amounts (project monthly amounts view)











Related content

Project Ledger Tables and Views
Project Ledger Tables and Views
More like this
SSRS Reporting views that can be used for Project Ledger amounts
SSRS Reporting views that can be used for Project Ledger amounts
More like this
Report to Reconcile the Project Ledger with the General Ledger
Report to Reconcile the Project Ledger with the General Ledger
More like this
Report to show all project strings and GL accounts associated with them, without transactions
Report to show all project strings and GL accounts associated with them, without transactions
More like this
Need budget report that includes projects - YTD Project Budget Report
Need budget report that includes projects - YTD Project Budget Report
More like this
Project Ledger Cube excluding unposted transactions
Project Ledger Cube excluding unposted transactions
More like this