AP_VendorPDFLog AP Vendor PDF Log Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_VendorPDFLog.M4T"
KPRIMARY: APDivisionNo+VendorNo+Document+ModuleCode+DocumentKey+DocumentDate+Sequence
KFILENAME: Filename+APDivisionNo+VendorNo+Document+ModuleCode+DocumentKey+DocumentDate+Sequence
KDATE: DocumentDate+APDivisionNo+VendorNo+Document+ModuleCode+DocumentKey+Sequence
KUPDATED: Updated+APDivisionNo+VendorNo+Document+ModuleCode+DocumentKey+DocumentDate+Sequence
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SYY AP Division Number. . . . . . .APDIVISION
Mask:00 FmtType:ZEROFILL
2 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO
FmtType:MASTERNUM ChngTag:Rep
lace1/APDivisionNo$
3 Document. . . . . . . . . . . 30 SNY Document Name . . . . . . . . .
4 ModuleCode. . . . . . . . . . 3 SYY Module Code . . . . . . . . . .MODULECODE
5 DocumentKey . . . . . . . . . 10 SYY DocumentKey . . . . . . . . . .
FmtType:CHARNUM
6 DocumentDate. . . . . . . . . 8 SNY Document Date . . . . . . . . .DATE
7 Sequence. . . . . . . . . . . 3 SNY Sequence. . . . . . . . . . . .
FmtType:ZEROFILL
8 PurchaseOrderNo . . . . . . . 7 SNY Purchase Order Number . . . . .PURCHASEORDERNO
9 OrderType . . . . . . . . . . 1 SYN Order Type. . . . . . . . . . .
Valid:S,D,M,R,X Notes: S =
Standard, D = Drop ship, M =
Master, R = Repeating, X =
Mat. Req
10 AccountingDate. . . . . . . . 8 SNN Accounting Date . . . . . . . .DATE
11 Directory . . . . . . . . . . 150 SNY Directory . . . . . . . . . . .
12 Filename. . . . . . . . . . . 60 SNN File Name . . . . . . . . . . .
Notes: If document has been
updated this is for display
purposes only
13 Sent. . . . . . . . . . . . . 1 SYN Sent. . . . . . . . . . . . . .
DfltVal:N Valid:Y,N,P Notes:
Y=Yes, N=No, P=Pending
14 Updated . . . . . . . . . . . 1 SYN Updated . . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
15 PasswordProtected . . . . . . 1 SYN Password Protected. . . . . . .YESNO
DfltVal:N Valid:Y,N
16 Password. . . . . . . . . . . 33 SNN Password. . . . . . . . . . . .
17 DateCreated . . . . . . . . . 8 SNY Date Created. . . . . . . . . .DATE
18 TimeCreated . . . . . . . . . 8 SNY Time Created. . . . . . . . . .
19 UserCreatedKey. . . . . . . . 10 SYY User Created Key. . . . . . . .USER
Mask:0000000000