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