POVENDLOC

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 AP590 IC258 IC266 IC58.1 IC58.2
IC58.3 PO210 PO61.4 POI7.1 POIT.1 RQIC.1
RQID.1 RQIG.1 RQIH.1


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 API2.1 API3.1 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CXCP.1 DR100 IC12.1 IC140 IC141
IC142 IC145 IC243 IC330 IC64.1 IC64.2
IC64.3 IC64.4 IC64.5 IC64.6 IC64.7 IC64.8
IC64.9 IC66.1 IC83.1 MA180 MA278 MA41.1
MA41.2 MA41.4 MA41.7 MA42.2 MA42.1 MA43.2
MA43.7 MA43.1 MA43.3 MA43.4 MA43.6 MA44.1
MA44.2 MA53.1 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 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
PD570 PO04.1 PO04.2 PO10.1 PO10.2 PO100
PO101 PO115 PO120 PO122 PO131 PO132
PO136 PO15.1 PO15.2 PO15.4 PO150 PO17.1
PO190 PO20.1 PO20.6 PO20.9 PO204 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO22.2 PO22.5 PO220 PO222 PO224
PO225 PO229 PO23.1 PO230 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO26.3
PO26.7 PO26.9 PO27.2 PO27.3 PO27.4 PO275
PO276 PO277 PO28.2 PO280 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 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 PO54.5 PO54.1 PO54.2
PO54.3 PO54.4 POCP.1 POI3.1 POID.1 POII.1
POIJ.1 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 PR514 RQ01.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1
RQII.1 RQIJ.1 WH130 WH132 WH190 WH20.2
WH20.7 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 WH32.5 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 AC160 AM115 AM117 AM15.1 AM15.2
AM15.3 AM15.4 AM19.1 AM19.2 AM20.1 AM20.3
AM21.1 AM21.3 AM22.1 AM500 AM51.1 AM551
AM97.1 AP03.3 AP110 AP115 AP150 AP210
AP220 AP271 AP305 AP90.1 AP91.1 API4.1
IC840 MX123 MX500 MA126 MA279 MA540
MA63.1 MA65.1 MA69.1 PD235 PO192 PO195
PO223 PO233 PO253 PO254 PO278 PO529
RQ260

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PVL-VENDOR-GROUP
Element: Vendor Group
Alpha 4
A vendor group represents a group of vendors that can be shared by one or more companies.
AP510 PO10.2
PVL-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
AP510 PO10.2
PVL-PURCH-FR-LOC
Element: Purch Fr Loc
Alpha 4
The vendor's purchase from location.
AP510 PO10.2
PVL-LEADTIME-DAYS
Element: Leadtime Days
Numeric 3
This field contains the average lead-time days. The average of the last and the previous lead-time days if system calculated.
AP510 PO10.2
PVL-EDI-NUMBER
Element: Edi Nbr
Alpha 15
AP510 PO10.2
PVL-FAX-PREFIX
Element: Phone Prefix
Alpha 6
The telephone number country code.
AP510 PO10.2
PVL-FAX-EXT
Element: Phone Ext
Alpha 5
This field contains the telephone extension number.
AP510 PO10.2
PVL-FAX-NUMBER
Element: Phone
Alpha 15
Phone number.
AP510 PO10.2
PVL-FREIGHT-TERMS
Element: Freight Terms
Alpha 1
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.
AP510 PO10.2
PVL-SHIP-VIA
Element: Ship Via
Alpha 12 (Lower Case)
The vendor location's default ship via description.
AP510 PO10.2
PVL-FOB-CODE
Element: Fob Code
Alpha 3
User-defined ship term code is defined as a default for this vendor location.
AP510 PO10.2
PVL-NORM-DEL-DAY
Element: Norm Del Day
Alpha 3
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
AP510 PO10.2
PVL-USHIP-TOL-PCT
Element: Uship Tol Pct
Percent 6.3 (Percent)
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.
AP510 PO10.2
PVL-ISSUE-METH
Element: Issue Meth
Alpha 1
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
AP510 PO10.2
PVL-REV-ISSUE-METH
Element: Rev Issue Meth
Alpha 1
Specifies 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
AP510 PO10.2
PVL-REV-EDI-NUMBER
Element: Edi Nbr
Alpha 15
AP510 PO10.2
PVL-REV-EDI-TRANS
Element: Rev Edi Trans
Alpha 1
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
AP510 PO10.2
PVL-REVISIONS-INCL
Element: Revisions Incl
Alpha 1
Specifies 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
AP510 PO10.2
PVL-VENDOR-CONTCT
Element: Vendor Name
Alpha 30
The requester can enter the recommended vendor's name for the requested items.
AP510 PO10.2
PVL-PHONE-PREFIX
Element: Phone Prefix
Alpha 6
The telephone number country code.
AP510 PO10.2
PVL-PHONE-NUM
Element: Phone
Alpha 15
Phone number.
AP510 PO10.2
PVL-PHONE-EXT
Element: Phone Ext
Alpha 5
This field contains the telephone extension number.
AP510 PO10.2
PVL-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code that will default from the vendor location to the purchase order.
AP510 PO10.2
PVL-OVEND-SHIP-VIA
Element: Ship Via
Alpha 12 (Lower Case)
PO10.2
PVL-LOADING-PORT
Element: Loading Port
Alpha 5
The port where the goods are loaded, if required. The port code must be defined in IN04.1 (Port Maintenance)
AP510 PO10.2
PVL-UNLOADING-PORT
Element: Unloading Port
Alpha 5
The prot where the goods are unloaded if required. Must be defined in IN04.1 (Port Maintenance)
AP510 PO10.2
PVL-PUNCHOUT-CHG-F
Element: Punchout Chg F
Numeric 1

0 = Changes allowed
1 = Changes not allowed
AP510 PO10.2
PVL-EMAIL-ADDRESS
Element: Email Address
Alpha 60 (Lower Case)
e-mail address.
AP510 PO10.2
PVL-REORDER-SUN-FL
Element: Reorder Mon Fl
Numeric 1
AP510 PO10.2
PVL-REORDER-MON-FL
Element: Reorder Mon Fl
Numeric 1
AP510 PO10.2
PVL-REORDER-TUE-FL
Element: Reorder Mon Fl
Numeric 1
AP510 PO10.2
PVL-REORDER-WED-FL
Element: Reorder Mon Fl
Numeric 1
AP510 PO10.2
PVL-REORDER-THU-FL
Element: Reorder Mon Fl
Numeric 1
AP510 PO10.2
PVL-REORDER-FRI-FL
Element: Reorder Mon Fl
Numeric 1
AP510 PO10.2
PVL-REORDER-SAT-FL
Element: Reorder Mon Fl
Numeric 1
AP510 PO10.2
PVL-LOC-ID-PRT
Element: Loc Id Prt
Numeric 1

0 = No Print
1 = Print HIN on PO Line
2 = Print GLN on PO Line
AP510 PO10.2
PVL-OSHIP-TOL-PCT
Element: Cost Pct
Percent 5.3 (Percent)
Cost Percent. Percent to applied to unit cost of the item to arrive at the Add on charge cost.
PO10.2
PVL-ZERO-OSHIP-FL
Element: All Flag
Alpha 1

N = No
Y = Yes
PO10.2
PVL-ZERO-USHIP-FL
Element: All Flag
Alpha 1

N = No
Y = Yes
PO10.2
PVL-CANCEL-ALL-BO
Element: Cancel All Bo
Alpha 1
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
PO10.2
PVL-RMA-REQUIRED
Element: All Flag
Alpha 1

N = No
Y = Yes
PO10.2
PVL-RMA-DOC-REQ
Element: All Flag
Alpha 1

N = No
Y = Yes
PO10.2
PVL-UPD-PO-COST
Element: Upd Po Cost
Numeric 1
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
PO10.2
PVL-OVER-AGRMT
Element: Over Agrmt
Alpha 1
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
PO10.2
PVL-OVER-LC-LP
Element: Over Lc Lp
Alpha 1
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
PO10.2
PVL-BUYER-CODE
Element: Buyer
Alpha 3
PO10.2
PVL-OPEN-PO-LIMIT
Element: Intl Amt
Signed 18.2
PO10.2
PVL-OPEN-PO-AMT
Element: Intl Amt
Signed 18.2
...
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
PVL-MAX-ORDER-AMT
Element: Intl Amt
Signed 18.2
PO10.2
PVL-REQ-LOC-LEVEL
Element: Req Loc Level
Alpha 1
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
PO10.2
PVL-MIN-ORD-WEIGHT
Element: Min Ord Weight
Signed 9.3
PO10.2
PVL-ONE-SRC-ONE-PO
Element: One Src One Po
Numeric 1

0 = No
1 = 1 Requisition to One PO
2 = One Sales Order to One PO
3 = Req and Sales Order to One PO
PO10.2
PVL-MIN-PO-AMT
Element: Intl Amt
Signed 18.2
PO10.2
PVL-GLN-NBR
Element: Gln Nbr
Alpha 13
AP510 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO10.2
PVL-REQ-CONT-LEVEL
Element: Req Cont Level
Alpha 1
PO10.2
PVL-DSP-PAT-ID
Element: Flag
Alpha 1
PO10.2
PVL-EDI-PAT-ID
Element: Flag
Alpha 1
PO10.2
PVL-MSK-PAT-ID
Element: Flag
Alpha 1
PO10.2
PVL-DSP-VISIT-NBR
Element: Flag
Alpha 1
PO10.2
PVL-EDI-VISIT-NBR
Element: Flag
Alpha 1
PO10.2
PVL-MSK-VISIT-NBR
Element: Flag
Alpha 1
PO10.2
PVL-DSP-CASE-NBR
Element: Flag
Alpha 1
PO10.2
PVL-EDI-CASE-NBR
Element: Flag
Alpha 1
PO10.2
PVL-MSK-CASE-NBR
Element: Flag
Alpha 1
PO10.2
PVL-DSP-PROC
Element: Flag
Alpha 1
PO10.2
PVL-EDI-PROC
Element: Flag
Alpha 1
PO10.2
PVL-DSP-PROC-DT
Element: Flag
Alpha 1
PO10.2
PVL-EDI-PROC-DT
Element: Flag
Alpha 1
PO10.2
PVL-DSP-PHYS-NAME
Element: Flag
Alpha 1
PO10.2
PVL-EDI-PHYS-NAME
Element: Flag
Alpha 1
PO10.2
PVL-DSP-NRS-COORD
Element: Flag
Alpha 1
PO10.2
PVL-EDI-NRS-COORD
Element: Flag
Alpha 1
PO10.2
PVL-DSP-SALES-REP
Element: Flag
Alpha 1
PO10.2
PVL-EDI-SALES-REP
Element: Flag
Alpha 1
PO10.2
PVL-DSP-ORD-NBR
Element: Flag
Alpha 1
PO10.2
PVL-EDI-ORD-NBR
Element: Flag
Alpha 1
PO10.2
PVL-DSP-REQUESTOR
Element: Flag
Alpha 1
PO10.2
PVL-EDI-REQUESTOR
Element: Flag
Alpha 1
PO10.2
PVL-DSP-LOT
Element: Flag
Alpha 1
PO10.2
PVL-EDI-LOT
Element: Flag
Alpha 1
PO10.2
PVL-DSP-SER-NBR
Element: Flag
Alpha 1
PO10.2
PVL-EDI-SER-NBR
Element: Flag
Alpha 1
PO10.2
PVL-DSP-USERDEF1
Element: Flag
Alpha 1
PO10.2
PVL-EDI-USERDEF1
Element: Flag
Alpha 1
PO10.2
PVL-DSP-USERDEF2
Element: Flag
Alpha 1
PO10.2
PVL-EDI-USERDEF2
Element: Flag
Alpha 1
PO10.2
PVL-ALLOW-VI-UPDT
Element: All Flag
Alpha 1

N = No
Y = Yes
PO10.2
PVL-DSP-PAT-NAME
Element: Flag
Alpha 1
PO10.2
PVL-EDI-PAT-NAME
Element: Flag
Alpha 1
PO10.2
PVL-DSP-BIRTHDATE
Element: Flag
Alpha 1
PO10.2
PVL-EDI-BIRTHDATE
Element: Flag
Alpha 1
PO10.2
PVL-DSP-GENDER
Element: Flag
Alpha 1
PO10.2
PVL-EDI-GENDER
Element: Flag
Alpha 1
PO10.2
PVL-DSP-SSN
Element: Flag
Alpha 1
PO10.2
PVL-EDI-SSN
Element: Flag
Alpha 1
PO10.2
PVL-DSP-PROC-MOD
Element: Flag
Alpha 1
PO10.2
PVL-EDI-PROC-MOD
Element: Flag
Alpha 1
PO10.2
PVL-ORDER-MIN-EDIT
Element: Flag Num
Numeric 1

0 = Purchase Orders
1 = Purchase Orders & Requisitions
PO10.2


POVENDLOC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PVLSET1 VENDOR-GROUP
VENDOR
PURCH-FR-LOC
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.2
AP110 AP115
AP125 AP126
AP131 AP150
AP20.1 AP20.2
AP20.3 AP20.4


POVENDLOC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Glnloc GLNLOC Not Required
Valid When PVL-GLN-NBR !=Spaces
PCG-ITEM-GROUP->GLO-ITEM-GROUP
PVL-GLN-NBR->GLO-GLN-NBR
Glnlocdtl GLNLOCDTL Not Required
Valid When PVL-GLN-NBR !=Spaces
PCG-ITEM-GROUP->GLX-ITEM-GROUP
10->GLX-GLN-TYPE
PVL-VENDOR->GLX-VENDOR
PVL-PURCH-FR-LOC->GLX-LOCATION-CODE
PVL-GLN-NBR->GLX-GLN-NBR
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


File created: Thu Jun 09 02:28:07 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.