Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POVENDLOC


                             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