AR_CustomerPDFLog AR Customer PDF Log Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CustomerPDFLog.M4T"
KPRIMARY: ARDivisionNo+CustomerNo+Document+ModuleCode+DocumentKey+DocumentDate+Sequence KFILENAME: Filename+ARDivisionNo+CustomerNo+Document+ModuleCode+DocumentKey+DocumentDate+Sequence KJOBNO: JobNo+ARDivisionNo+CustomerNo+Document+ModuleCode+DocumentKey+DocumentDate+Sequence KDATE: DocumentDate+ARDivisionNo+CustomerNo+Document+ModuleCode+DocumentKey+Sequence
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SYY AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL 2 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$ 3 Document. . . . . . . . . . . 30 SYY Document Name . . . . . . . . . 4 ModuleCode. . . . . . . . . . 3 SYY Module Code . . . . . . . . . .MODULECODE 5 DocumentKey . . . . . . . . . 9 SNN Document Key. . . . . . . . . . 6 DocumentDate. . . . . . . . . 8 SNY Document Date . . . . . . . . .DATE 7 Sequence. . . . . . . . . . . 3 SNY Sequence. . . . . . . . . . . . FmtType:ZEROFILL 8 InvoiceNo . . . . . . . . . . 7 SYN Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM 9 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . Valid:IN,CM,DM,FC,CA,RT 10 SalesOrderNo. . . . . . . . . 7 SYN Sales Order Number. . . . . . .SALESORDERNO FmtType:CHARNUM 11 OrderType . . . . . . . . . . 1 SYN Order Type. . . . . . . . . . . Valid:S,B,Q,R,M 12 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . .JOBNO FmtType:CHARNUM 13 AccountingDate. . . . . . . . 8 SNN Accounting Date . . . . . . . .DATE 14 Directory . . . . . . . . . . 150 SNY Directory . . . . . . . . . . . 15 Filename. . . . . . . . . . . 60 SNY Filename. . . . . . . . . . . . 16 Sent. . . . . . . . . . . . . 1 SYN Sent. . . . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 17 Updated . . . . . . . . . . . 1 SYN Updated . . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 18 PasswordProtected . . . . . . 1 SYN Password Protected. . . . . . .YESNO DfltVal:N Valid:Y,N 19 Password. . . . . . . . . . . 33 SNN Password. . . . . . . . . . . . 20 DateCreated . . . . . . . . . 8 SNY Date Created. . . . . . . . . .DATE 21 TimeCreated . . . . . . . . . 8 SNY Time Created. . . . . . . . . . 22 UserCreatedKey. . . . . . . . 10 SYY User Created Key. . . . . . . .USER Mask:0000000000