IM_ItemMemo IM Item Memo Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: IM_ItemMemo_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_ItemMemo.M4T"
KPRIMARY: ItemCode+MemoCode+SeqNo
Fld Column Name M/L TUR Description/Notes Class
1 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE
Notes: {IMP$(1,15)}
2 MemoCode. . . . . . . . . . . 10 SYY Memo Code . . . . . . . . . . .MEMOCODE
Notes: {IMP$(16,10)}
3 SeqNo . . . . . . . . . . . . 6 SNN Sequence Number . . . . . . . .
4 MemoDesc. . . . . . . . . . . 30 SNN Memo Description. . . . . . . .DESCRIPTION
Notes: {IMP$(29,30)}
5 MemoDate. . . . . . . . . . . 8 SNN Memo Date . . . . . . . . . . .DATE
Notes: {IMP$(59,6)}
6 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE
7 ReminderStartDate . . . . . . 8 SNN Reminder Start Date . . . . . .DATE
Notes: {IMP$(69,6)}
8 ReminderEndDate . . . . . . . 8 SNN Reminder End Date . . . . . . .DATE
9 AutoDisplaySetting. . . . . . 1 SYN Auto Display Setting. . . . . .
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 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Notes: YYYYMMDD
13 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
14 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Mask:0000000000
15 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Notes: YYYYMMDD
16 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
17 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Mask:0000000000 FmtType:ZEROF
ILL