AR_CustomerMemo AR Customer Memo Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_CustomerMemo_bus
SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CustomerMemo.M4T"
KPRIMARY: ARDivisionNo+CustomerNo+MemoCode+SeqNo
KMEMO: MemoCode+ARDivisionNo+CustomerNo
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {ARP$(1,2)}
2 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC ChngTag:Re
place1/ARDivisionNo$ Notes:
{ARP$(3,7)}
3 MemoCode. . . . . . . . . . . 10 SYY Memo Code . . . . . . . . . . .MEMOCODE
Notes: {ARP$(10,10)}
4 SeqNo . . . . . . . . . . . . 6 SNN Sequence Number . . . . . . . .
5 MemoDesc. . . . . . . . . . . 30 SNN Memo Description. . . . . . . .DESCRIPTION
Notes: {ARP$(23,30)}
6 MemoDate. . . . . . . . . . . 8 SNN Memo Date . . . . . . . . . . .DATE
Notes: {ARP$(53,6)}
7 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE
8 ReminderStartDate . . . . . . 8 SNN Reminder Start Date . . . . . .DATE
Notes: {ARP$(63,6)}
9 ReminderEndDate . . . . . . . 8 SNN Reminder End Date . . . . . . .DATE
10 AutoDisplaySetting. . . . . . 1 SYN Auto Display Setting. . . . . .
DfltVal:N Valid:Y,N,D Notes:
Y=Always, N=Never, D=by
reminder Date
11 MemoText. . . . . . . . . . . 7168 SNN Memo Text . . . . . . . . . . .MEMO
12 Attachment. . . . . . . . . . 128 SNN Attachment. . . . . . . . . . .
13 OriginalModuleCode. . . . . . 3 SNN Original Module Code. . . . . .
14 OriginalMemoType. . . . . . . 2 SNN Original Memo Type. . . . . . .
15 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
16 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
17 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
18 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
19 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
20 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000