GL_GeneralJournalMemo GL General Journal Memo Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: GL_GeneralJournalMemo_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_GeneralJournalMemo.M4T"
KPRIMARY: SourceJournal+EntryNo+MemoCode+SeqNo KMEMO: MemoCode+SourceJournal+EntryNo
Fld Column Name M/L TUR Description/Notes Class
1 SourceJournal . . . . . . . . 2 SYY Source Journal. . . . . . . . .SOURCEJOURNAL Notes: Validated against GL_Account 2 EntryNo . . . . . . . . . . . 6 SNY Entry Number. . . . . . . . . . Mask:000000 3 MemoCode. . . . . . . . . . . 10 SNY Memo Code . . . . . . . . . . . 4 SeqNo . . . . . . . . . . . . 6 SNN Sequence Number . . . . . . . . 5 MemoDesc. . . . . . . . . . . 30 SNN Memo Description. . . . . . . . 6 MemoDate. . . . . . . . . . . 8 SNN Memo Date . . . . . . . . . . .DATE Notes: YYYYMMDD 7 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE Notes: YYYYMMDD 8 ReminderStartDate . . . . . . 8 SNN Reminder Start Date . . . . . .DATE Notes: YYYYMMDD 9 ReminderEndDate . . . . . . . 8 SNN Reminder End Date . . . . . . .DATE Notes: YYYYMMDD 10 AutoDisplaySetting. . . . . . 1 SNN Auto DisplaySetting . . . . . . DfltVal:N Valid:Y,N,D Notes: Y=Always, N=Never, D=by reminder Date 11 MemoText. . . . . . . . . . . 7168 SNN Memo Text . . . . . . . . . . .MEMO 12 OriginalModuleCode. . . . . . 3 SNN Original Module Code. . . . . . 13 OriginalMemoType. . . . . . . 2 SNN Original Memo Type. . . . . . . 14 Attachment. . . . . . . . . . 128 SNN Attachment. . . . . . . . . . . 15 DateCreated . . . . . . . . . 8 SNN Date Created. . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 16 TimeCreated . . . . . . . . . 8 SNN Time Created. . . . . . . . . . Read Only:Y 17 UserCreatedKey. . . . . . . . 10 SYN User Created ID . . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL 18 DateUpdated . . . . . . . . . 8 SNN Date Updated. . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 19 TimeUpdated . . . . . . . . . 8 SNN Time Updated. . . . . . . . . . Read Only:Y 20 UserUpdatedKey. . . . . . . . 10 SYN User Updated ID . . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL