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-