|
|
POVENDLOC FILE
Vendor Location Master
This file contains information for a vendor's purchase-from location. This
information is for use by the Purchase Order system.
REFERENCED BY
AP10.2 AP125 AP126 AP131 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP210 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP30.4 API1.1
DR100 IC141 IC142 IC28.1 IC83.1 MA180
MA41.2 MA41.7 MA43.1 MA43.2 MA43.3 MA43.9
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.1 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO210 PO22.1 PO23.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO33.1 PO34.1
PO35.1 PO36.1 PO36.2 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 PO536 POI3.1
POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1
RQ35.1 RQ500 RQIC.1 RQID.1 RQIE.1 RQIF.1
RQIG.1 RQIJ.1 WH20.2 WH20.7
UPDATED BY
AP300 AP510 API3.1 PO10.2 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 PR514 UK47.1
AM115 AM15.1 AM15.2 AM15.3 AM15.4 AM20.1
AM20.3 AM21.1 AM21.3 AM500 AM51.1 AM551
AM97.1 API4.1 IC840
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PVL-VENDOR-GROUP Alpha 4 AP510 PO10.2
Element: Vendor Group A vendor group represents a group of
vendors that can be shared by one or
more companies.
PVL-VENDOR Alpha 9 (Right Justified) AP510 PO10.2
Element: Vendor ID The vendor's identification code.
PVL-PURCH-FR-LOC Alpha 4 AP510 PO10.2
Purchase From The vendor's purchase from location.
Location Code
PVL-LEADTIME-DAYS Numeric 3 AP510 PO10.2
Leadtime Number of This field contains the average
Days lead-time days. The average of the last
and the previous lead-time days if
system calculated.
PVL-EDI-NUMBER Alpha 15 AP510 PO10.2
Element: EDI Number
PVL-FAX-PREFIX Alpha 6 AP510 PO10.2
Telephone Country
Code
PVL-FAX-EXT Alpha 5 AP510 PO10.2
Element: Telephone Extension
PVL-FAX-NUMBER Alpha 15 AP510 PO10.2
Element: Telephone Number
PVL-FREIGHT-TERMS Alpha 1 AP510 PO10.2
Element: Ac Usage
PVL-SHIP-VIA Alpha 12 (Lower Case) AP510 PO10.2
Element: Ship Via DescrThe vendor location's default ship via
description.
PVL-FOB-CODE Alpha 3 AP510 PO10.2
Element: Shipping Term User-defined ship term code is defined
as a default for this vendor location.
PVL-NORM-DEL-DAY Alpha 3 AP510 PO10.2
Element: Normal DeliverThe normal delivery day for this vendor
at this location. Information only.
FRI = Friday
MON = Monday
SAT = Saturday
SUN = Sunday
THU = Thursday
TUE = Tuesday
WED = Wednesday
PVL-USHIP-TOL-PCT Percent 6.3 (Percent) AP510 PO10.2
Cancel Backorder This is the quantity undership
Percent percentage for automatic back order
cancellation. If a value of 10% is
entered here, for instance, and a
quantity of 91 is shipped against an
ordered quantity of 100, that would be
considered a 9% undershipment. Since
this is less than the 10% limit, the
backordered amount would be canceled.
This process takes place at receiving
time. If a backorder is not canceled
manually, the system checks, in order,
the purchase order line, the purchase
order vendor purchase from record, the
purchase order vendor record, and the
company record. If an undershipment
percentage of a zero percent flag set to
Y is encountered at any level, that
value is used.
NOTE-The percentage can be set at 100%,
which would cancel all backorders.
This file contains purchase order
specific information for purchase order
vendor defaulting.
PVL-ISSUE-METH Alpha 1 AP510 PO10.2
Element: Issue Meth Specifies the method that will be used
to issue the purchase order to the
vendor.
P = Paper
F = Fax
E = EDI
I = Internet Mail
D = Do Not Print
PVL-REV-ISSUE-METH Alpha 1 AP510 PO10.2
Element: Rev Issue MethSpecifies the method that will be used
to issue purchase order revisions to the
vendor.
P = Paper
F = Fax
E = EDI
I = Internet Mail
D = Do Not Print
PVL-REV-EDI-NUMBER Alpha 15 AP510 PO10.2
Element: EDI Number
PVL-REV-EDI-TRANS Alpha 1 AP510 PO10.2
Element: Rev Edi Trans For vendors that receive purchase order
revisions via EDI, this specifies
whether the EDI transaction is a normal
EDI purchase order transaction (for
example, an ANSI X12 850) or a change
purchase order transaction (for
example, an ANSI X12 860).
N = Not Applicable
P = PO Transaction
C = Change Transaction
PVL-REVISIONS-INCL Alpha 1 AP510 PO10.2
Element: Revisions InclSpecifies what information will be
included when a revised Purchase Order
is re-issued.
You may specify that only the revised
information is included, along with
messages that indicate what was revised
(option O - Revisions Only).
Alternately, you may specify that the
entire PO is included, along with
messages that indicate the revisions.
Finally, you may specify that the entire
PO is re-issued. No revision messages
will appear.
If the PO has not been printed, or the
revised PO is not to be re-issued, this
field will be blank (Not Applicable).
O = Revisions Only
C = Revisions Complete
I = Reissue
" " = Not Applicable
PVL-VENDOR-CONTCT Alpha 30 AP510 PO10.2
Element: Vendor Name
PVL-PHONE-PREFIX Alpha 6 AP510 PO10.2
Telephone Country The telephone number country code.
Code
PVL-PHONE-NUM Alpha 15 AP510 PO10.2
Element: Telephone NumbThis is the main telephone number.
PVL-PHONE-EXT Alpha 5 AP510 PO10.2
Element: Telephone ExteThis field contains the telephone
extension number.
PVL-PO-CODE Alpha 4 AP510 PO10.2
Element: Po Code This is the purchase order code that
will default from the vendor location to
the purchase order.
PVL-OVEND-SHIP-VIA Alpha 12 PO10.2
Inbound frm Vendor
Ship Via
PVL-LOADING-PORT Alpha 5 PO10.2
Element: Loading Port The port where the goods are loaded, if
required. The port code must be defined
in IN04.1 (Port Maintenance)
PVL-UNLOADING-PORT Alpha 5 PO10.2
Element: Unloading PortThe prot where the goods are unloaded if
required. Must be defined in IN04.1
(Port Maintenance)
PVL-PUNCHOUT-CHG-F Numeric 1 PO10.2
Element: Punchout Chg F0 = Changes allowed
1 = Changes not allowed
PVL-EMAIL-ADDRESS Alpha 60 (Lower Case) PO10.2 POII.1
Element: Email Address
POVENDLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PVLSET1 VENDOR-GROUP AM115 AM15.1
VENDOR AM15.2 AM15.3
PURCH-FR-LOC AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.2
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP210
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
...
POVENDLOC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apvenloc APVENLOC Required
PVL-VENDOR-GROUP -> VLO-VENDOR-GROUP
PVL-VENDOR -> VLO-VENDOR
PVL-PURCH-FR-LOC -> VLO-LOCATION-CODE
Fobcode FOBCODE Not Required
PCG-PROCURE-GROUP -> FOB-PROCURE-GROUP
PVL-FOB-CODE -> FOB-FOB-CODE
Pofrtterm POFRTTERM Not Required
PCG-PROCURE-GROUP -> POF-PROCURE-GROUP
PVL-FREIGHT-TERMS -> POF-FREIGHT-TERMS
Procuregrp PROCUREGRP Required
PVL-VENDOR-GROUP -> PCG-VENDOR-GROUP
|
