GL_BudgetRevisionWrk GL Budget Revision Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_BudgetRevision_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_BudgetRevisionWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNY Sort Field. . . . . . . . . . .
2 AccountKey. . . . . . . . . . 9 SYY Account Number. . . . . . . . .ACCOUNT
Notes: Validated against
GL_Account
3 Account . . . . . . . . . . . 41 SYN Fully Formatted Account Number.
4 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . .
5 FiscalYear. . . . . . . . . . 4 SNN Fiscal Year . . . . . . . . . .YEAR
Mask:0000
6 BudgetType. . . . . . . . . . 1 SYY Budget Type . . . . . . . . . .
Valid:C,D,R Notes: C=Current
amount, D=revised amount,
R=Revision amount
7 BudgetDesc. . . . . . . . . . 40 SNN Budget Description. . . . . . .
8 BudgetPeriod01. . . . . . . . 16.2 NNN Budget Period 01. . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
9 BudgetPeriod02. . . . . . . . 16.2 NNN Budget Period 02. . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
10 BudgetPeriod03. . . . . . . . 16.2 NNN Budget Period 03. . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
11 BudgetPeriod04. . . . . . . . 16.2 NNN Budget Period 04. . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
12 BudgetPeriod05. . . . . . . . 16.2 NNN Budget Period 05. . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
13 BudgetPeriod06. . . . . . . . 16.2 NNN Budget Period 06. . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
14 BudgetPeriod07. . . . . . . . 16.2 NNN Budget Period 07. . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
15 BudgetPeriod08. . . . . . . . 16.2 NNN Budget Period 08. . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
16 BudgetPeriod09. . . . . . . . 16.2 NNN Budget Period 09. . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
17 BudgetPeriod10. . . . . . . . 16.2 NNN Budget Period 10. . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
18 BudgetPeriod11. . . . . . . . 16.2 NNN Budget Period 11. . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
19 BudgetPeriod12. . . . . . . . 16.2 NNN Budget Period 12. . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
20 BudgetPeriod13. . . . . . . . 16.2 NNN Budget Period 13. . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-