GL_DetailReportWrk GL Detail Report Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_DetailReport_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_DetailReportWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SYY Sort Field. . . . . . . . . . .
2 GroupField. . . . . . . . . . 20 SNN Group Field . . . . . . . . . .
3 GroupFieldDesc. . . . . . . . 75 SNN Group Field Description . . . .
4 AccountKey. . . . . . . . . . 9 SYY Account Number. . . . . . . . .ACCOUNT
5 Account . . . . . . . . . . . 41 SYY Account . . . . . . . . . . . .
6 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . .
7 Period. . . . . . . . . . . . 2 SNN Posting Date Period . . . . . .
Mask:00 FmtType:ZEROFILL
8 PostingDate . . . . . . . . . 8 SNN Posting Date. . . . . . . . . .DATE
9 SourceJournal . . . . . . . . 2 SYY Source Journal. . . . . . . . .SOURCEJOURNAL
10 JournalRegisterNo . . . . . . 6 SYY Journal Register Number . . . .
Mask:000000 FmtType:ZEROFILL
11 SequenceNo. . . . . . . . . . 14 SNY Sequence Number . . . . . . . .
Mask:00000000000000
FmtType:ZEROFILL
12 SourceModule. . . . . . . . . 2 SYN Source Module . . . . . . . . .
13 PostingComment. . . . . . . . 2048 SNN Posting Comment . . . . . . . .COMMENT
14 BatchNo . . . . . . . . . . . 5 SNN Batch Number. . . . . . . . . .BATCHNO
15 DateCreated . . . . . . . . . 8 SNY Date Created. . . . . . . . . .DATE
Read Only:Y
16 TimeCreated . . . . . . . . . 8 SNY Time Created. . . . . . . . . .
Read Only:Y
17 UserCreatedKey. . . . . . . . 10 SYY User Created Key. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
18 UserCreatedLogon. . . . . . . 60 SNN User Created Logon. . . . . . .
19 BeginningBalance. . . . . . . 16.2 NNY Beginning Balance . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
20 DebitAmount . . . . . . . . . 16.2 NNY Debit Amount. . . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
21 CreditAmount. . . . . . . . . 16.2 NNY Credit Amount . . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
22 EndingBalance . . . . . . . . 16.2 NNY Ending Balance. . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-