|
|
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 CXCP.1 PO190 PO210 POCP.1 POIT.1
RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500
RQIB.1 RQIC.1 RQID.1 RQIF.1 RQIG.1 RQIJ.1
WH130 WH132 WH190 WH222 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 AP30.2 AP300
AP510 API1.1 API3.1 BL120 BL122 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.7
MA43.4 MA43.6 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PO10.1 PO10.2 PO100 PO101 PO122
PO131 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.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 PO32.4
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 POID.1 POII.1 POIJ.1 PR05.1
PR05.3 PR226 PR247 PR26.1 PR47.1 PR514
UK47.1 RQ10.1 RQ10.2 WH20.2 WH20.7 AC160
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM19.1 AM19.2 AM20.1 AM20.3 AM21.1 AM21.3
AM500 AM51.1 AM551 AM97.1 AP03.3 AP110
AP115 AP210 AP220 AP305 AP90.1 AP91.1
API2.1 API4.1 MX123 MX500 MA279 MA63.1
MA65.1 PD235 PO120 PO220 PO223 PO233
PO253 PO254 PO278 PO54.1 PO54.2 PO54.3
PO54.4
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 The vendor's identification code.
PVL-PURCH-FR-LOC Alpha 4 AP510 PO10.2
Element: Purch Fr Loc The vendor's purchase from location.
PVL-LEADTIME-DAYS Numeric 3 AP510 PO10.2
Element: Leadtime Days This field contains the average
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 Nbr
PVL-FAX-PREFIX Alpha 6 AP510 PO10.2
Element: Phone Prefix The telephone number country code.
PVL-FAX-EXT Alpha 5 AP510 PO10.2
Element: Phone Ext This field contains the telephone
extension number.
PVL-FAX-NUMBER Alpha 15 AP510 PO10.2
Element: Phone Phone number.
PVL-FREIGHT-TERMS Alpha 1 AP510 PO10.2
Element: 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) AP510 PO10.2
Element: Ship Via The vendor location's default ship via
description.
PVL-FOB-CODE Alpha 3 AP510 PO10.2
Element: Fob Code User-defined ship term code is defined
as a default for this vendor location.
PVL-NORM-DEL-DAY Alpha 3 AP510 PO10.2
Element: Norm Del 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-USHIP-TOL-PCT Percent 6.3 (Percent) AP510 PO10.2
Element: Uship Tol Pct This is the quantity undership
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 Nbr
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 The requester can enter the recommended
vendor's name for the requested items.
PVL-PHONE-PREFIX Alpha 6 AP510 PO10.2
Element: Phone Prefix The telephone number country code.
PVL-PHONE-NUM Alpha 15 AP510 PO10.2
Element: Phone Phone number.
PVL-PHONE-EXT Alpha 5 AP510 PO10.2
Element: Phone Ext This 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 (Lower Case) PO10.2
Element: Ship Via
PVL-LOADING-PORT Alpha 5 AP510 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 AP510 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 AP510 PO10.2
Element: Punchout Chg F0 = Changes allowed
1 = Changes not allowed
PVL-EMAIL-ADDRESS Alpha 60 (Lower Case) AP510 PO10.2
Element: Email Address e-mail address.
PVL-REORDER-SUN-FL Numeric 1 AP510 PO10.2
Element: Reorder Mon Fl
PVL-REORDER-MON-FL Numeric 1 AP510 PO10.2
Element: Reorder Mon Fl
PVL-REORDER-TUE-FL Numeric 1 AP510 PO10.2
Element: Reorder Mon Fl
PVL-REORDER-WED-FL Numeric 1 AP510 PO10.2
Element: Reorder Mon Fl
PVL-REORDER-THU-FL Numeric 1 AP510 PO10.2
Element: Reorder Mon Fl
PVL-REORDER-FRI-FL Numeric 1 AP510 PO10.2
Element: Reorder Mon Fl
PVL-REORDER-SAT-FL Numeric 1 AP510 PO10.2
Element: Reorder Mon Fl
PVL-LOC-ID-PRT Numeric 1 AP510 PO10.2
Element: Loc Id Prt 0 = No Print
1 = Print HIN on PO Line
2 = Print GLN on PO Line
PVL-OSHIP-TOL-PCT Percent 5.3 (Percent) PO10.2
Element: Cost Pct Cost Percent. Percent to applied to
unit cost of the item to arrive at the
Add on charge cost.
PVL-ZERO-OSHIP-FL Alpha 1 PO10.2
Element: All Flag N = No
Y = Yes
PVL-ZERO-USHIP-FL Alpha 1 PO10.2
Element: All Flag N = No
Y = Yes
PVL-CANCEL-ALL-BO Alpha 1 PO10.2
Element: Cancel All Bo If set to "Y", when the first receiving
is processed against a purchase order
for this vendor, any items that are
backordered will be canceled, including
items that were not shipped.
Y = Cancel all backorders
N = Do not cancel all backorders
PVL-RMA-REQUIRED Alpha 1 PO10.2
Element: All Flag N = No
Y = Yes
PVL-RMA-DOC-REQ Alpha 1 PO10.2
Element: All Flag N = No
Y = Yes
PVL-UPD-PO-COST Numeric 1 PO10.2
Element: Upd Po Cost Used by Pharmacy subsystem to indicate
if the line item cost should be updated
by programs PO122 and MA531. By setting
the value to 3 the user is telling the
programs to take the pricing of this
item from the EDI 855 and 856
transactions an update the PO.
1 = Do not update PO cost from Rec
2 = Update PO cost from Rec or Ack
PVL-OVER-AGRMT Alpha 1 PO10.2
Element: Over Agrmt Enter a Y to indicate the user can
manually enter a cost which will not be
overridden by an existing price
agreement.
Y = Yes
N = No
PVL-OVER-LC-LP Alpha 1 PO10.2
Element: Over Lc Lp Enter a Y to indicate the user can
manually enter a cost which will not be
overridden by a last cost or last PO
created cost default.
Y = Yes
N = No
PVL-BUYER-CODE Alpha 3 PO10.2
Element: Buyer
PVL-OPEN-PO-LIMIT Signed 18.2 PO10.2
Element: Intl Amt
PVL-OPEN-PO-AMT Signed 18.2 AP125 AP126
Element: Intl Amt AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
MAI1.1 PD10.1
PD10.2 PD130
PD20.1 PD20.2
...
PVL-MAX-ORDER-AMT Signed 18.2 PO10.2
Element: Intl Amt
PVL-REQ-LOC-LEVEL Alpha 1 PO10.2
Element: Req Loc Level This field is used to determine how
requisition lines can be combined, based
on requesting location, in two different
circumstances.
The first circumstance is whether
multiple requisition lines can be
combined into one PO line. If the flag
is set to "S", they can be combined
regardless of requesting locations on
the lines. If the flag is set to "L" or
"H", the req lines can only be combined
if the requesting locations are the
same.
The second circumstance is whether
requisition lines for different
requesting locations can be combined on
the same PO. If the flag is set to "S"
or "L", they can be combined. If the
flag is set to "H", they cannot be
combined.
S = Combine req lines to PO line
L = Comb reqs to PO line by loc
H = Cannot mix req loc on PO
N = Cannot combine requisitions
PVL-MIN-ORD-WEIGHT Signed 9.3 PO10.2
Element: Min Ord Weight
PVL-ONE-SRC-ONE-PO Numeric 1 PO10.2
Element: One Src One Po0 = No
1 = 1 Requisition to One PO
2 = One Sales Order to One PO
3 = Req and Sales Order to One PO
POVENDLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PVLSET1 VENDOR-GROUP AC160 AM115
VENDOR AM117 AM15.1
PURCH-FR-LOC AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.2 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
...
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
Buyer BUYER Required
PCG-PROCURE-GROUP -> BUY-PROCURE-GROUP
PVL-BUYER-CODE -> BUY-BUYER-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
Popvluf POPVLUF Not Required
PVL-VENDOR-GROUP -> UFF-VENDOR-GROUP
PVL-VENDOR -> UFF-VENDOR
PVL-PURCH-FR-LOC -> UFF-PURCH-FR-LOC
Procuregrp PROCUREGRP Required
PVL-VENDOR-GROUP -> PCG-VENDOR-GROUP
|
