AR_InvoiceMemo AR Invoice Memo Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_InvoiceMemo_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_InvoiceMemo.M4T"
KPRIMARY: InvoiceNo+InvoiceType+MemoCode+SeqNo KMEMO: MemoCode+InvoiceNo+InvoiceType
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM Notes: {AR7$(1,7)} 2 InvoiceType . . . . . . . . . 2 SYY Invoice Type. . . . . . . . . . DfltVal:IN Valid:CM,DM,IN,AD, FC,CA,XD Notes: CM=Credit Memo, DM=Debit Memo, IN=Invoice, AD=Adjustment., FC=Finance Charge, CA=Cash, XD=Deleted {AR7$(8,2)} 3 MemoCode. . . . . . . . . . . 10 SYY Memo Code . . . . . . . . . . .MEMOCODE 4 SeqNo . . . . . . . . . . . . 6 SNN Sequence Number . . . . . . . . 5 MemoDesc. . . . . . . . . . . 30 SNN Memo Description. . . . . . . .DESCRIPTION 6 MemoDate. . . . . . . . . . . 8 SNN Memo Date . . . . . . . . . . .DATE 7 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE 8 ReminderStartDate . . . . . . 8 SNN Reminder Start Date . . . . . .DATE 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 Attachment. . . . . . . . . . 128 SNN Attachment. . . . . . . . . . . 12 MemoText. . . . . . . . . . . 7168 SNN Memo Text . . . . . . . . . . .MEMO 13 OriginalModuleCode. . . . . . 3 SNN Original Module Code. . . . . . 14 OriginalMemoType. . . . . . . 2 SNN Original Memo Type. . . . . . . 15 DateCreated . . . . . . . . . 8 SNN Creation Date . . . . . . . . .DATE Read Only:Y 16 TimeCreated . . . . . . . . . 8 SNN Creation Time . . . . . . . . . Read Only:Y 17 UserCreatedKey. . . . . . . . 10 SNN Creation User ID. . . . . . . . Read Only:Y 18 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y 19 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 20 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . . Read Only:Y