|
|
POVENDLOC FILE
Vendor Location Master
This file contains information for a vendor's purchase-from location. This
information is purchase order specific.
REFERENCED BY
AP10.1 AP10.2 AP300 BL92.1 IN20.1 OE10.1
OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7
OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110
OE113 OE114 OE129 OE14.4 OE15.1 OE15.2
OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810
OE920 PO100 PO120 PO121 PO123 PO20.1
PO21.1 PO21.2 PO21.5 PO21.6 PO210 PO22.1
PO22.2 PO22.3 PO25.1 PO30.1 PO30.2 PO31.1
PO33.1 PO34.1 PO35.1 PO530 PO820 PO821
RQ125 RQ20.1 RQ20.3 RQ20.4 WH20.2 WH20.7
UPDATED BY
PO10.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PVL-COMPANY Numeric 4 PO10.2
Company The company number.
PVL-VENDOR Alpha 9 PO10.2
Vendor ID The vendor's identification code.
PVL-PURCH-FR-LOC Alpha 4 PO10.2
Purchase From The vendor's purchase from location.
Location Code
PVL-LEADTIME-DAYS Numeric 3 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-PO-FLAG Alpha 1 PO10.2
Fax/EDI Flag Indicates whether the vendor at this
location is an EDI vendor. If Yes, then
an EDI number is required at entry time.
If this flag is Yes, the system sets the
EDI transmit flag to Yes on each
purchase order created for this vendor
and purchase from location.
If the flag is set to "F", a fax number
is required for this vendor. When a
purchase order is created for this
vendor it is flagged for fax
transmission.
N = No
E = EDI
F = Fax
PVL-EDI-NUMBER Alpha 15 PO10.2
EDI Number EDI number.
PVL-FAX-PREFIX Alpha 6 PO10.2
Fax Country Code The fax number prefix.
PVL-FAX-EXT Alpha 5 PO10.2
Fax Extension This field contains the fax number
extension.
PVL-FAX-NUMBER Alpha 15 PO10.2
Fax Number This field contains the fax number.
PVL-FREIGHT-TERMS Alpha 1 PO10.2
Freight Terms Freight terms are used to define who
pays for freight costs incurred when
goods are shipped. Prepaid, for
instance, would normally mean that the
vendor would pay for freight. Collect
would mean the customer would pay for
freight.
A freight terms code can be entered on
a purchase order, or defaulted by vendor
or company.
PVL-SHIP-VIA Alpha 12 (Lower Case) PO10.2
Ship Via Description The vendor location's default ship via
description.
PVL-FOB-CODE Alpha 2 PO10.2
Shipping Term Code User-defined ship term code is defined
as a default for this vendor location.
PVL-NORM-DEL-DAY Alpha 3 PO10.2
Normal Delivery Day The 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-HIN-NBR Alpha 9
Hin Nbr The Health Industry Number is a unique
number assigned to any company or
facility doing business in the health
industry. This number is assigned by the
Health Industry Business Communications
Council (HIBCC).
PVL-USHIP-TOL-PCT Percent 6.3 (Percent) 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.
POVENDLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PVLSET1 COMPANY AP10.1 AP10.2
VENDOR AP300 BL92.1
PURCH-FR-LOC IN20.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
...
POVENDLOC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
PVL-COMPANY -> CPY-COMPANY
Fob Code FOBCODE Required
PVL-COMPANY -> FOB-COMPANY
PVL-FOB-CODE -> FOB-FOB-CODE
Pocompany POCOMPANY Required
PVL-COMPANY -> PCY-COMPANY
Pofrtterm POFRTTERM Required
When PVL-FREIGHT-TERMS != Spaces
PVL-COMPANY -> POF-COMPANY
PVL-FREIGHT-TERMS -> POF-FREIGHT-TERMS
Povendor POVENDOR Required
PVL-COMPANY -> POV-COMPANY
PVL-VENDOR -> POV-VENDOR
Vendloc APVENLOC Required
CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP
PVL-VENDOR -> VLO-VENDOR
PVL-PURCH-FR-LOC -> VLO-LOCATION-CODE
Vendor APVENMAST Not Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
PVL-VENDOR -> VEN-VENDOR
|