PO_ReceiptHistoryMemo PO Receipt History Memo Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: PO_ReceiptHistoryMemo_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_ReceiptHistoryMemo.M4T"
KPRIMARY: PurchaseOrderNo+ReceiptType+ReceiptNo+HeaderSeqNo+MemoCode+SeqNo(**) **=Case Sensitive KMEMO: MemoCode+PurchaseOrderNo+ReceiptType+ReceiptNo+HeaderSeqNo+SeqNo
Fld Column Name M/L TUR Description/Notes Class
1 PurchaseOrderNo . . . . . . . 7 SYN Purchase Order Number . . . . .PURCHASEORDERNO Mask:0000000 2 ReceiptType . . . . . . . . . 1 SYY ReceiptType . . . . . . . . . . 3 ReceiptNo . . . . . . . . . . 6 SYY Receipt Number. . . . . . . . .RECEIPTNO FmtType:CHARNUM 4 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . . 5 MemoCode. . . . . . . . . . . 10 SYY Memo Code . . . . . . . . . . .MEMOCODE 6 SeqNo . . . . . . . . . . . . 6 SNN Sequence Number . . . . . . . . 7 MemoDesc. . . . . . . . . . . 30 SNN Memo Description. . . . . . . .DESCRIPTION 8 MemoDate. . . . . . . . . . . 8 SNN Memo Date . . . . . . . . . . .DATE 9 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE 10 ReminderStartDate . . . . . . 8 SNN Reminder Start Date . . . . . .DATE 11 ReminderEndDate . . . . . . . 8 SNN Reminder End Date . . . . . . .DATE 12 AutoDisplaySetting. . . . . . 1 SYN AUTO Display Setting. . . . . . DfltVal:N Valid:Y,N,D Notes: Y=Always, N-Never, D=by reminder Date 13 Attachment. . . . . . . . . . 128 SNN Attachment. . . . . . . . . . . 14 MemoText. . . . . . . . . . . 7168 SNN Memo Text . . . . . . . . . . .MEMO 15 OriginalModuleCode. . . . . . 3 SNN Original Module Code. . . . . . 16 OriginalModuleType. . . . . . 2 SNN Original Module Type. . . . . . 17 DateCreated . . . . . . . . . 8 SNN Creation Date . . . . . . . . .DATE 18 TimeCreated . . . . . . . . . 8 SNN Creation Time . . . . . . . . . 19 UserCreatedKey. . . . . . . . 10 SNN Creation User ID. . . . . . . . 20 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE 21 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . 22 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .