GL_GeneralJournalWrk GL General Journal Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: GL_GeneralJournal_upd,GL_ReprintJournals_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_GeneralJournalWrk"+%S$+".M4T"
KPRIMARY: SourceJournal+EntryNo+LineSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 SourceJournal . . . . . . . . 2 SYY Source Journal. . . . . . . . .SOURCEJOURNAL 2 EntryNo . . . . . . . . . . . 6 SYY Entry Number. . . . . . . . . . Mask:000000 FmtType:ZEROFILL 3 LineSeqNo . . . . . . . . . . 14 SYY Line Sequence Number. . . . . . 4 PostingDate . . . . . . . . . 8 SNY Posting Date. . . . . . . . . .DATE Notes: YYYYMMDD 5 ReversingDate . . . . . . . . 8 SNY Reversing Date. . . . . . . . .DATE Notes: YYYYMMDD 6 JournalType . . . . . . . . . 1 SYN Journal Type. . . . . . . . . . Valid:F,N 7 JournalComment. . . . . . . . 2048 SNN Journal Comment . . . . . . . .COMMENT 8 JournalDeleted. . . . . . . . 1 SYY Journal Deleted . . . . . . . .YESNO DfltVal:N Valid:Y,N 9 BatchFlag . . . . . . . . . . 1 SYY Batch Flag. . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 10 BatchNo . . . . . . . . . . . 5 SYY Batch Number. . . . . . . . . .BATCHNO FmtType:ALPHANUM 11 AccountKey. . . . . . . . . . 9 SYY Account Number. . . . . . . . .ACCOUNT Notes: Validated against GL_Account 12 Account . . . . . . . . . . . 41 SYY Fully Formatted Account Number. 13 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . . 14 PostingComment. . . . . . . . 2048 SNN Posting Comment . . . . . . . .COMMENT 15 UserUpdatedLogon. . . . . . . 60 SNN User Updated Logon. . . . . . . 16 DebitAmount . . . . . . . . . 16.2 NNY Debit Amount. . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00- 17 CreditAmount. . . . . . . . . 16.2 NNY Credit Amount . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00-