POVENDLOC – Vendor Location Master

System
Purchase Order (PO)
Prefix
PVL
Primary key
VENDOR-GROUP, VENDOR, PURCH-FR-LOC
Fields
98
Updated by
289 programs
Referenced by
15 programs

POVENDLOC is the Vendor Location Master table in Lawson Purchase Order (prefix PVL). It is indexed by VENDOR-GROUP, VENDOR, PURCH-FR-LOC (PVLSET1). It is related 1:1 to APVENLOC, BUYER, FOBCODE, GLNLOC, GLNLOCDTL, POFRTTERM, POPVLUF and PROCUREGRP. It is updated by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 281 more and referenced by AP10.2, AP590, IC258, IC266, IC58.1, IC58.2, IC58.3, PO210 and 7 more. The table has 98 fields, 1 index and 8 documented relations.

About POVENDLOC

This file contains information for a vendor's purchase-from location. This information is for use by the Purchase Order system.

Fields (98)

Column = COBOL field name without the PVL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PVL-VENDOR-GROUP PK
VENDOR_GROUP		Alpha 4A vendor group represents a group of vendors that can be shared by one or more companies.AP510, PO10.2
PVL-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP510, PO10.2
PVL-PURCH-FR-LOC PK
PURCH_FR_LOC		Alpha 4The vendor's purchase from location.AP510, PO10.2
PVL-LEADTIME-DAYS
LEADTIME_DAYS		Numeric 3This 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
EDI_NUMBER		Alpha 15—AP510, PO10.2
PVL-FAX-PREFIX
FAX_PREFIX		Alpha 6The telephone number country code.AP510, PO10.2
PVL-FAX-EXT
FAX_EXT		Alpha 5This field contains the telephone extension number.AP510, PO10.2
PVL-FAX-NUMBER
FAX_NUMBER		Alpha 15Phone number.AP510, PO10.2
PVL-FREIGHT-TERMS
FREIGHT_TERMS		Alpha 1Freight 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
SHIP_VIA		Alpha 12 (Lower Case)The vendor location's default ship via description.AP510, PO10.2
PVL-FOB-CODE
FOB_CODE		Alpha 3User-defined ship term code is defined as a default for this vendor location.AP510, PO10.2
PVL-NORM-DEL-DAY
NORM_DEL_DAY		Alpha 3The 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
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
ISSUE_METH		Alpha 1Specifies 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
REV_ISSUE_METH		Alpha 1Specifies 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
REV_EDI_NUMBER		Alpha 15—AP510, PO10.2
PVL-REV-EDI-TRANS
REV_EDI_TRANS		Alpha 1For 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
REVISIONS_INCL		Alpha 1Specifies 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). " " = Not Applicable
  • O Revisions Only
  • C Revisions Complete
  • I Reissue
AP510, PO10.2
PVL-VENDOR-CONTCT
VENDOR_CONTCT		Alpha 30The requester can enter the recommended vendor's name for the requested items.AP510, PO10.2
PVL-PHONE-PREFIX
PHONE_PREFIX		Alpha 6The telephone number country code.AP510, PO10.2
PVL-PHONE-NUM
PHONE_NUM		Alpha 15Phone number.AP510, PO10.2
PVL-PHONE-EXT
PHONE_EXT		Alpha 5This field contains the telephone extension number.AP510, PO10.2
PVL-PO-CODE
PO_CODE		Alpha 4This is the purchase order code that will default from the vendor location to the purchase order.AP510, PO10.2
PVL-OVEND-SHIP-VIA
OVEND_SHIP_VIA		Alpha 12 (Lower Case)—PO10.2
PVL-LOADING-PORT
LOADING_PORT		Alpha 5The 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
UNLOADING_PORT		Alpha 5The prot where the goods are unloaded if required. Must be defined in IN04.1 (Port Maintenance)AP510, PO10.2
PVL-PUNCHOUT-CHG-F
PUNCHOUT_CHG_F		Numeric 1—
  • 0 Changes allowed
  • 1 Changes not allowed
AP510, PO10.2
PVL-EMAIL-ADDRESS
EMAIL_ADDRESS		Alpha 60 (Lower Case)e-mail address.AP510, PO10.2
PVL-REORDER-SUN-FL
REORDER_SUN_FL		Numeric 1—AP510, PO10.2
PVL-REORDER-MON-FL
REORDER_MON_FL		Numeric 1—AP510, PO10.2
PVL-REORDER-TUE-FL
REORDER_TUE_FL		Numeric 1—AP510, PO10.2
PVL-REORDER-WED-FL
REORDER_WED_FL		Numeric 1—AP510, PO10.2
PVL-REORDER-THU-FL
REORDER_THU_FL		Numeric 1—AP510, PO10.2
PVL-REORDER-FRI-FL
REORDER_FRI_FL		Numeric 1—AP510, PO10.2
PVL-REORDER-SAT-FL
REORDER_SAT_FL		Numeric 1—AP510, PO10.2
PVL-LOC-ID-PRT
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
OSHIP_TOL_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
ZERO_OSHIP_FL		Alpha 1—
  • N No
  • Y Yes
PO10.2
PVL-ZERO-USHIP-FL
ZERO_USHIP_FL		Alpha 1—
  • N No
  • Y Yes
PO10.2
PVL-CANCEL-ALL-BO
CANCEL_ALL_BO		Alpha 1If 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
RMA_REQUIRED		Alpha 1—
  • N No
  • Y Yes
PO10.2
PVL-RMA-DOC-REQ
RMA_DOC_REQ		Alpha 1—
  • N No
  • Y Yes
PO10.2
PVL-UPD-PO-COST
UPD_PO_COST		Numeric 1Used 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
OVER_AGRMT		Alpha 1Enter 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
OVER_LC_LP		Alpha 1Enter 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
BUYER_CODE		Alpha 3—PO10.2
PVL-OPEN-PO-LIMIT
OPEN_PO_LIMIT		Signed 18.2—PO10.2
PVL-OPEN-PO-AMT
OPEN_PO_AMT		Signed 18.2—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVL-MAX-ORDER-AMT
MAX_ORDER_AMT		Signed 18.2—PO10.2
PVL-REQ-LOC-LEVEL
REQ_LOC_LEVEL		Alpha 1This 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
MIN_ORD_WEIGHT		Signed 9.3—PO10.2
PVL-ONE-SRC-ONE-PO
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
MIN_PO_AMT		Signed 18.2—PO10.2
PVL-GLN-NBR
GLN_NBR		Alpha 13—AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +3 more
PVL-REQ-CONT-LEVEL
REQ_CONT_LEVEL		Alpha 1—PO10.2
PVL-DSP-PAT-ID
DSP_PAT_ID		Alpha 1—PO10.2
PVL-EDI-PAT-ID
EDI_PAT_ID		Alpha 1—PO10.2
PVL-MSK-PAT-ID
MSK_PAT_ID		Alpha 1—PO10.2
PVL-DSP-VISIT-NBR
DSP_VISIT_NBR		Alpha 1—PO10.2
PVL-EDI-VISIT-NBR
EDI_VISIT_NBR		Alpha 1—PO10.2
PVL-MSK-VISIT-NBR
MSK_VISIT_NBR		Alpha 1—PO10.2
PVL-DSP-CASE-NBR
DSP_CASE_NBR		Alpha 1—PO10.2
PVL-EDI-CASE-NBR
EDI_CASE_NBR		Alpha 1—PO10.2
PVL-MSK-CASE-NBR
MSK_CASE_NBR		Alpha 1—PO10.2
PVL-DSP-PROC
DSP_PROC		Alpha 1—PO10.2
PVL-EDI-PROC
EDI_PROC		Alpha 1—PO10.2
PVL-DSP-PROC-DT
DSP_PROC_DT		Alpha 1—PO10.2
PVL-EDI-PROC-DT
EDI_PROC_DT		Alpha 1—PO10.2
PVL-DSP-PHYS-NAME
DSP_PHYS_NAME		Alpha 1—PO10.2
PVL-EDI-PHYS-NAME
EDI_PHYS_NAME		Alpha 1—PO10.2
PVL-DSP-NRS-COORD
DSP_NRS_COORD		Alpha 1—PO10.2
PVL-EDI-NRS-COORD
EDI_NRS_COORD		Alpha 1—PO10.2
PVL-DSP-SALES-REP
DSP_SALES_REP		Alpha 1—PO10.2
PVL-EDI-SALES-REP
EDI_SALES_REP		Alpha 1—PO10.2
PVL-DSP-ORD-NBR
DSP_ORD_NBR		Alpha 1—PO10.2
PVL-EDI-ORD-NBR
EDI_ORD_NBR		Alpha 1—PO10.2
PVL-DSP-REQUESTOR
DSP_REQUESTOR		Alpha 1—PO10.2
PVL-EDI-REQUESTOR
EDI_REQUESTOR		Alpha 1—PO10.2
PVL-DSP-LOT
DSP_LOT		Alpha 1—PO10.2
PVL-EDI-LOT
EDI_LOT		Alpha 1—PO10.2
PVL-DSP-SER-NBR
DSP_SER_NBR		Alpha 1—PO10.2
PVL-EDI-SER-NBR
EDI_SER_NBR		Alpha 1—PO10.2
PVL-DSP-USERDEF1
DSP_USERDEF1		Alpha 1—PO10.2
PVL-EDI-USERDEF1
EDI_USERDEF1		Alpha 1—PO10.2
PVL-DSP-USERDEF2
DSP_USERDEF2		Alpha 1—PO10.2
PVL-EDI-USERDEF2
EDI_USERDEF2		Alpha 1—PO10.2
PVL-ALLOW-VI-UPDT
ALLOW_VI_UPDT		Alpha 1—
  • N No
  • Y Yes
PO10.2
PVL-DSP-PAT-NAME
DSP_PAT_NAME		Alpha 1—PO10.2
PVL-EDI-PAT-NAME
EDI_PAT_NAME		Alpha 1—PO10.2
PVL-DSP-BIRTHDATE
DSP_BIRTHDATE		Alpha 1—PO10.2
PVL-EDI-BIRTHDATE
EDI_BIRTHDATE		Alpha 1—PO10.2
PVL-DSP-GENDER
DSP_GENDER		Alpha 1—PO10.2
PVL-EDI-GENDER
EDI_GENDER		Alpha 1—PO10.2
PVL-DSP-SSN
DSP_SSN		Alpha 1—PO10.2
PVL-EDI-SSN
EDI_SSN		Alpha 1—PO10.2
PVL-DSP-PROC-MOD
DSP_PROC_MOD		Alpha 1—PO10.2
PVL-EDI-PROC-MOD
EDI_PROC_MOD		Alpha 1—PO10.2
PVL-ORDER-MIN-EDIT
ORDER_MIN_EDIT		Numeric 1—
  • 0 Purchase Orders
  • 1 Purchase Orders & Requisitions
PO10.2

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PVLSET1VENDOR-GROUP, VENDOR, PURCH-FR-LOCPrimaryAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)

Relations

One to one (8) — lookups and parents

RelationTableRulesConditionField map
ApvenlocAPVENLOCRequiredPVL-VENDOR-GROUP → VLO-VENDOR-GROUP, PVL-VENDOR → VLO-VENDOR, PVL-PURCH-FR-LOC → VLO-LOCATION-CODE
BuyerBUYERRequiredPCG-PROCURE-GROUP → BUY-PROCURE-GROUP, PVL-BUYER-CODE → BUY-BUYER-CODE
FobcodeFOBCODENot RequiredPCG-PROCURE-GROUP → FOB-PROCURE-GROUP, PVL-FOB-CODE → FOB-FOB-CODE
GlnlocGLNLOCNot RequiredValid When PVL-GLN-NBR != SpacesPCG-ITEM-GROUP → GLO-ITEM-GROUP, PVL-GLN-NBR → GLO-GLN-NBR
GlnlocdtlGLNLOCDTLNot RequiredValid When PVL-GLN-NBR != SpacesPCG-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
PofrttermPOFRTTERMNot RequiredPCG-PROCURE-GROUP → POF-PROCURE-GROUP, PVL-FREIGHT-TERMS → POF-FREIGHT-TERMS
PopvlufPOPVLUFNot RequiredPVL-VENDOR-GROUP → UFF-VENDOR-GROUP, PVL-VENDOR → UFF-VENDOR, PVL-PURCH-FR-LOC → UFF-PURCH-FR-LOC
ProcuregrpPROCUREGRPRequiredPVL-VENDOR-GROUP → PCG-VENDOR-GROUP

Programs

Updated by (289)

Referenced by (15)