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