GL_DetailBySourceWrk GL Detail by Source Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: GL_DetailBySource_rpt SQL Def: N SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_DetailBySourceWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SYY Sort Field. . . . . . . . . . . 2 AccountKey. . . . . . . . . . 9 SYN Account Number. . . . . . . . .ACCOUNT Notes: Validated against GL_Account 3 Account . . . . . . . . . . . 41 SYN Account . . . . . . . . . . . . 4 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . . 5 PostingDate . . . . . . . . . 8 SNN Posting Date. . . . . . . . . .DATE Notes: YYYYMMDD 6 SourceModule. . . . . . . . . 2 SYN Source Module . . . . . . . . . 7 SourceJournal . . . . . . . . 2 SYN Source Journal. . . . . . . . .SOURCEJOURNAL 8 JournalRegisterNo . . . . . . 6 SNN Journal Register Number . . . . Mask:000000 9 SequenceNo. . . . . . . . . . 14 SNN Sequence No . . . . . . . . . . Mask:00000000000000 FmtType:ZEROFILL 10 BatchNo . . . . . . . . . . . 5 SNN Batch Number. . . . . . . . . .BATCHNO 11 PostingComment. . . . . . . . 2048 SNN Posting Comment . . . . . . . .COMMENT 12 DebitAmount . . . . . . . . . 16.2 NNN Debit Amount. . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00- 13 CreditAmount. . . . . . . . . 16.2 NNN Credit Amount . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00-