GL_RecurringJournalHistory GL Recurring Journal History Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: GL_RecurringJournal_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_RecurringJournalHistory.M4T"
KPRIMARY: SourceJournal+Reference+SequenceNo KSEQNO: SequenceNo(u) KPOSTINGDATE: PostingDate(d)+SourceJournal+Reference+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 SourceJournal . . . . . . . . 2 SYY Source Journal. . . . . . . . .SOURCEJOURNAL 2 Reference . . . . . . . . . . 6 SYY Reference . . . . . . . . . . . 3 SequenceNo. . . . . . . . . . 14 SNY Sequence Number . . . . . . . . Mask:00000000000000 FmtType:ZEROFILL 4 JournalNo . . . . . . . . . . 6 SNY Journal Number. . . . . . . . . Mask:000000 FmtType:ZEROFILL 5 PostingDate . . . . . . . . . 8 SNY Posting Date. . . . . . . . . .DATE 6 SelectCycle . . . . . . . . . 2 SNY Select Cycle. . . . . . . . . . 7 SelectStartDate . . . . . . . 8 SNY Select Start Date . . . . . . .DATE 8 SelectStopDate. . . . . . . . 8 SNY Select Stop Date. . . . . . . .DATE 9 JournalComment. . . . . . . . 2048 SNN Journal Comment . . . . . . . .COMMENT 10 JournalDeleted. . . . . . . . 1 SYY Journal Deleted . . . . . . . .YESNO DfltVal:N Valid:Y,N 11 DateUpdated . . . . . . . . . 8 SNN Date Updated. . . . . . . . . .DATE Read Only:Y 12 TimeUpdated . . . . . . . . . 8 SNN Time Updated. . . . . . . . . . Read Only:Y 13 UserUpdatedKey. . . . . . . . 10 SYN User. . . . . . . . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL