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