GL_BudgetAndHistoryWrk GL Budget and History Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_BudgetHistory_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_BudgetAndHistoryWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNY Sort Field. . . . . . . . . . .
2 GroupField. . . . . . . . . . 20 SNN Group Field . . . . . . . . . .
3 GroupFieldDesc. . . . . . . . 75 SNN Group Field Description . . . .
4 AccountKey. . . . . . . . . . 9 SYN Account Number. . . . . . . . .ACCOUNT
5 Account . . . . . . . . . . . 41 SYN Fully Formatted Account Number.
6 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . .
7 BudgetNo. . . . . . . . . . . 2 SNN Budget Number . . . . . . . . .
Mask:00 FmtType:ZEROFILL
8 Budget1FiscalYear . . . . . . 4 SNN Budget 1 FiscalYear . . . . . .
Mask:0000 FmtType:ZEROFILL
9 Budget1Desc . . . . . . . . . 40 SNN Budget 1 Description. . . . . .
10 Budget2FiscalYear . . . . . . 4 SNN Budget 2 FiscalYear . . . . . .
Mask:0000 FmtType:ZEROFILL
11 Budget2Desc . . . . . . . . . 40 SNN Budget 2 Description. . . . . .
12 Budget3FiscalYear . . . . . . 4 SNN Budget 3 FiscalYear . . . . . .
Mask:0000 FmtType:ZEROFILL
13 Budget3Desc . . . . . . . . . 40 SNN Budget 3 Description. . . . . .
14 Budget4FiscalYear . . . . . . 4 SNN Budget 4 FiscalYear . . . . . .
Mask:0000 FmtType:ZEROFILL
15 Budget4Desc . . . . . . . . . 40 SNN Budget 4 Description. . . . . .
16 Budget5FiscalYear . . . . . . 4 SNN Budget 5 FiscalYear . . . . . .
Mask:0000 FmtType:ZEROFILL
17 Budget5Desc . . . . . . . . . 40 SNN Budget 5 Description. . . . . .
18 Budget1NoFiscalPeriods. . . . 2.0 NNN Budget 1 Number of Fiscal Perio
19 Budget1BegBalance . . . . . . 16.2 NNN Budget 1 Beg Balance. . . . . .BALANCEAMT
20 Budget1Period1. . . . . . . . 16.2 NNN Budget 1 Period 1 . . . . . . .BALANCEAMT
21 Budget1Period2. . . . . . . . 16.2 NNN Budget 1 Period 2 . . . . . . .BALANCEAMT
22 Budget1Period3. . . . . . . . 16.2 NNN Budget 1 Period 3 . . . . . . .BALANCEAMT
23 Budget1Period4. . . . . . . . 16.2 NNN Budget 1 Period 4 . . . . . . .BALANCEAMT
24 Budget1Period5. . . . . . . . 16.2 NNN Budget 1 Period 5 . . . . . . .BALANCEAMT
25 Budget1Period6. . . . . . . . 16.2 NNN Budget 1 Period 6 . . . . . . .BALANCEAMT
26 Budget1Period7. . . . . . . . 16.2 NNN Budget 1 Period 7 . . . . . . .BALANCEAMT
27 Budget1Period8. . . . . . . . 16.2 NNN Budget 1 Period 8 . . . . . . .BALANCEAMT
28 Budget1Period9. . . . . . . . 16.2 NNN Budget 1 Period 9 . . . . . . .BALANCEAMT
29 Budget1Period10 . . . . . . . 16.2 NNN Budget 1 Period 10. . . . . . .BALANCEAMT
30 Budget1Period11 . . . . . . . 16.2 NNN Budget 1 Period 11. . . . . . .BALANCEAMT
31 Budget1Period12 . . . . . . . 16.2 NNN Budget 1 Period 12. . . . . . .BALANCEAMT
32 Budget1Period13 . . . . . . . 16.2 NNN Budget 1 Period 13. . . . . . .BALANCEAMT
33 Budget1EndBalance . . . . . . 16.2 NNN Budget 1 End Balance. . . . . .BALANCEAMT
34 Budget2NoFiscalPeriods. . . . 2.0 NNN Budget 2 Number of Fiscal Perio
35 Budget2BegBalance . . . . . . 16.2 NNN Budget 2 Beg Balance. . . . . .BALANCEAMT
36 Budget2Period1. . . . . . . . 16.2 NNN Budget 2 Period 1 . . . . . . .BALANCEAMT
37 Budget2Period2. . . . . . . . 16.2 NNN Budget 2 Period 2 . . . . . . .BALANCEAMT
38 Budget2Period3. . . . . . . . 16.2 NNN Budget 2 Period 3 . . . . . . .BALANCEAMT
39 Budget2Period4. . . . . . . . 16.2 NNN Budget 2 Period 4 . . . . . . .BALANCEAMT
40 Budget2Period5. . . . . . . . 16.2 NNN Budget 2 Period 5 . . . . . . .BALANCEAMT
41 Budget2Period6. . . . . . . . 16.2 NNN Budget 2 Period 6 . . . . . . .BALANCEAMT
42 Budget2Period7. . . . . . . . 16.2 NNN Budget 2 Period 7 . . . . . . .BALANCEAMT
43 Budget2Period8. . . . . . . . 16.2 NNN Budget 2 Period 8 . . . . . . .BALANCEAMT
44 Budget2Period9. . . . . . . . 16.2 NNN Budget 2 Period 9 . . . . . . .BALANCEAMT
45 Budget2Period10 . . . . . . . 16.2 NNN Budget 2 Period 10. . . . . . .BALANCEAMT
46 Budget2Period11 . . . . . . . 16.2 NNN Budget 2 Period 11. . . . . . .BALANCEAMT
47 Budget2Period12 . . . . . . . 16.2 NNN Budget 2 Period 12. . . . . . .BALANCEAMT
48 Budget2Period13 . . . . . . . 16.2 NNN Budget 2 Period 13. . . . . . .BALANCEAMT
49 Budget2EndBalance . . . . . . 16.2 NNN Budget 2 End Balance. . . . . .BALANCEAMT
50 Budget3NoFiscalPeriods. . . . 2.0 NNN Budget 3 Number of Fiscal Perio
51 Budget3BegBalance . . . . . . 16.2 NNN Budget 3 Beg Balance. . . . . .BALANCEAMT
52 Budget3Period1. . . . . . . . 16.2 NNN Budget 3 Period 1 . . . . . . .BALANCEAMT
53 Budget3Period2. . . . . . . . 16.2 NNN Budget 3 Period 2 . . . . . . .BALANCEAMT
54 Budget3Period3. . . . . . . . 16.2 NNN Budget 3 Period 3 . . . . . . .BALANCEAMT
55 Budget3Period4. . . . . . . . 16.2 NNN Budget 3 Period 4 . . . . . . .BALANCEAMT
56 Budget3Period5. . . . . . . . 16.2 NNN Budget 3 Period 5 . . . . . . .BALANCEAMT
57 Budget3Period6. . . . . . . . 16.2 NNN Budget 3 Period 6 . . . . . . .BALANCEAMT
58 Budget3Period7. . . . . . . . 16.2 NNN Budget 3 Period 7 . . . . . . .BALANCEAMT
59 Budget3Period8. . . . . . . . 16.2 NNN Budget 3 Period 8 . . . . . . .BALANCEAMT
60 Budget3Period9. . . . . . . . 16.2 NNN Budget 3 Period 9 . . . . . . .BALANCEAMT
61 Budget3Period10 . . . . . . . 16.2 NNN Budget 3 Period 10. . . . . . .BALANCEAMT
62 Budget3Period11 . . . . . . . 16.2 NNN Budget 3 Period 11. . . . . . .BALANCEAMT
63 Budget3Period12 . . . . . . . 16.2 NNN Budget 3 Period 12. . . . . . .BALANCEAMT
64 Budget3Period13 . . . . . . . 16.2 NNN Budget 3 Period 13. . . . . . .BALANCEAMT
65 Budget3EndBalance . . . . . . 16.2 NNN Budget 3 End Balance. . . . . .BALANCEAMT
66 Budget4NoFiscalPeriods. . . . 2.0 NNN Budget 4 Number of Fiscal Perio
67 Budget4BegBalance . . . . . . 16.2 NNN Budget 4 Beg Balance. . . . . .BALANCEAMT
68 Budget4Period1. . . . . . . . 16.2 NNN Budget 4 Period 1 . . . . . . .BALANCEAMT
69 Budget4Period2. . . . . . . . 16.2 NNN Budget 4 Period 2 . . . . . . .BALANCEAMT
70 Budget4Period3. . . . . . . . 16.2 NNN Budget 4 Period 3 . . . . . . .BALANCEAMT
71 Budget4Period4. . . . . . . . 16.2 NNN Budget 4 Period 4 . . . . . . .BALANCEAMT
72 Budget4Period5. . . . . . . . 16.2 NNN Budget 4 Period 5 . . . . . . .BALANCEAMT
73 Budget4Period6. . . . . . . . 16.2 NNN Budget 4 Period 6 . . . . . . .BALANCEAMT
74 Budget4Period7. . . . . . . . 16.2 NNN Budget 4 Period 7 . . . . . . .BALANCEAMT
75 Budget4Period8. . . . . . . . 16.2 NNN Budget 4 Period 8 . . . . . . .BALANCEAMT
76 Budget4Period9. . . . . . . . 16.2 NNN Budget 4 Period 9 . . . . . . .BALANCEAMT
77 Budget4Period10 . . . . . . . 16.2 NNN Budget 4 Period 10. . . . . . .BALANCEAMT
78 Budget4Period11 . . . . . . . 16.2 NNN Budget 4 Period 11. . . . . . .BALANCEAMT
79 Budget4Period12 . . . . . . . 16.2 NNN Budget 4 Period 12. . . . . . .BALANCEAMT
80 Budget4Period13 . . . . . . . 16.2 NNN Budget 4 Period 13. . . . . . .BALANCEAMT
81 Budget4EndBalance . . . . . . 16.2 NNN Budget 4 End Balance. . . . . .BALANCEAMT
82 Budget5NoFiscalPeriods. . . . 2.0 NNN Budget 5 Number of Fiscal Perio
83 Budget5BegBalance . . . . . . 16.2 NNN Budget 5 Beg Balance. . . . . .BALANCEAMT
84 Budget5Period1. . . . . . . . 16.2 NNN Budget 5 Period 1 . . . . . . .BALANCEAMT
85 Budget5Period2. . . . . . . . 16.2 NNN Budget 5 Period 2 . . . . . . .BALANCEAMT
86 Budget5Period3. . . . . . . . 16.2 NNN Budget 5 Period 3 . . . . . . .BALANCEAMT
87 Budget5Period4. . . . . . . . 16.2 NNN Budget 5 Period 4 . . . . . . .BALANCEAMT
88 Budget5Period5. . . . . . . . 16.2 NNN Budget 5 Period 5 . . . . . . .BALANCEAMT
89 Budget5Period6. . . . . . . . 16.2 NNN Budget 5 Period 6 . . . . . . .BALANCEAMT
90 Budget5Period7. . . . . . . . 16.2 NNN Budget 5 Period 7 . . . . . . .BALANCEAMT
91 Budget5Period8. . . . . . . . 16.2 NNN Budget 5 Period 8 . . . . . . .BALANCEAMT
92 Budget5Period9. . . . . . . . 16.2 NNN Budget 5 Period 9 . . . . . . .BALANCEAMT
93 Budget5Period10 . . . . . . . 16.2 NNN Budget 5 Period 10. . . . . . .BALANCEAMT
94 Budget5Period11 . . . . . . . 16.2 NNN Budget 5 Period 11. . . . . . .BALANCEAMT
95 Budget5Period12 . . . . . . . 16.2 NNN Budget 5 Period 12. . . . . . .BALANCEAMT
96 Budget5Period13 . . . . . . . 16.2 NNN Budget 5 Period 13. . . . . . .BALANCEAMT
97 Budget5EndBalance . . . . . . 16.2 NNN Budget 5 End Balance. . . . . .BALANCEAMT