Database view that stores budget amounts for Multi-Year Life-to-Date accounts
Description of Issue
What is the database view/table that stores budget amounts for Multi-Year Life-to-date (MY LTD) accounts
Context
- Account Inquiry
- Account Master
Cause
View needed for custom SSRS report
Resolution
The budget amounts are stored on the dbo.gl_master view
Additional Information
Current Year information
my_orig_bud_fy (Original Budget)
my_bud_xfr_in_fy (Transfer In)
my_bud_xfr_out_fy (Transfer Out)
my_rev_bud_fy (Revised Budget)
Life to Date information
my_orig_bud_ltd (Original Budget)
my_bud_xfr_in_ltd (Transfer In)
my_bud_xfr_out_ltd (Transfer Out)
my_rev_bud_ltd (Revised Budget)