GL_GeneralJournalHistory GL General Journal History Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_GeneralJournal_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_GeneralJournalHistory.M4T"
KPRIMARY: SourceJournal+EntryNo+SequenceNo
KSEQNO: SequenceNo(u)
KPOSTINGDATE: PostingDate(d)+SourceJournal+EntryNo+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 SourceJournal . . . . . . . . 2 SYY Source Journal. . . . . . . . .SOURCEJOURNAL
2 EntryNo . . . . . . . . . . . 6 SNY Entry Number. . . . . . . . . .
Mask:000000 FmtType:ZEROFILL
3 SequenceNo. . . . . . . . . . 14 SNY Sequence Number . . . . . . . .
Mask:00000000000000
FmtType:ZEROFILL
4 PostingDate . . . . . . . . . 8 SNY Posting Date. . . . . . . . . .DATE
5 ReversingDate . . . . . . . . 8 SNN Reversing Date. . . . . . . . .DATE
6 JournalComment. . . . . . . . 2048 SNY Journal Comment . . . . . . . .COMMENT
7 JournalDeleted. . . . . . . . 1 SYY Journal Deleted . . . . . . . .YESNO
DfltVal:N Valid:Y,N
8 AllocationNo. . . . . . . . . 7 SYY Allocation Number . . . . . . .ALLOCATIONNO
FmtType:ALPHANUM
9 BatchNo . . . . . . . . . . . 5 SYY Batch Number. . . . . . . . . .BATCHNO
FmtType:ALPHANUM
10 DateUpdated . . . . . . . . . 8 SNN Date Updated. . . . . . . . . .DATE
Read Only:Y
11 TimeUpdated . . . . . . . . . 8 SNN Time Updated. . . . . . . . . .
Read Only:Y
12 UserUpdatedKey. . . . . . . . 10 SYN User. . . . . . . . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL