GL_TrialBalanceWrk GL Trial Balance Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_TrialBalance_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_TrialBalanceWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SYY Sort Field. . . . . . . . . . .
2 GroupField. . . . . . . . . . 20 SNY Group Field . . . . . . . . . .
3 GroupFieldDesc. . . . . . . . 75 SNN Group Field Desc. . . . . . . .
4 AccountKey. . . . . . . . . . 9 SYY Account Number. . . . . . . . .ACCOUNT
Notes: Validated against
GL_Account
5 Account . . . . . . . . . . . 41 SYY Account . . . . . . . . . . . .
6 AccountDescription. . . . . . 50 SNN Account Description . . . . . .
7 AccountType . . . . . . . . . 2 SYY Account Type. . . . . . . . . .ACCOUNTTYPE
Mask:00 FmtType:ZEROFILL
Notes: Validated against
GL_AccountType
8 AccountGroup. . . . . . . . . 15 SNY Account Group . . . . . . . . .
Notes: Validated against
GL_AccountGroup
9 AccountGroupDesc. . . . . . . 50 SNN Account Group Description . . .
10 AccountCategory . . . . . . . 1 SYY Account Category. . . . . . . .ACCOUNTCATEGORY
Read Only:Y Notes: Validated
against GL_AccountCategory
11 BeginningBalance. . . . . . . 16.2 NNY Beginning Balance . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
12 DebitAmount . . . . . . . . . 16.2 NNY Debit Amount. . . . . . . . . .TRANSACTIONAMT
Mask:###,###,###.00-
13 CreditAmount. . . . . . . . . 16.2 NNY Credit Amount . . . . . . . . .TRANSACTIONAMT
Mask:###,###,###.00-
14 EndingBalance . . . . . . . . 16.2 NNY Ending Balance. . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-