GL_ExceptionReportWrk GL Exception Report Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_ExceptionReport_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_ExceptionReportWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNY Sort Field. . . . . . . . . . .
2 GroupField. . . . . . . . . . 20 SNY Group Field . . . . . . . . . .
3 GroupFieldDesc. . . . . . . . 75 SNN Group Field Description . . . .
4 ExceptionType . . . . . . . . 1 SNN Exception Type. . . . . . . . .
Valid:1-7 Notes: 1=change
acct balance, 2=ending
balance, 3=variance to acct
budget, 4=debit accts with
credit bal., 5=credit accts
with debit bal., 6=Inactive
accts with activity,
7=deleted accts with activity
5 AccountKey. . . . . . . . . . 9 SYN Account Number. . . . . . . . .ACCOUNT
Notes: Validated against
GL_Account
6 Account . . . . . . . . . . . 41 SYN Fully Formatted Account Number.
7 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . .
8 Category. . . . . . . . . . . 1 SNN Category. . . . . . . . . . . .
9 Balance . . . . . . . . . . . 16.2 NNN Balance Amount. . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-