Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POVENDOR


                             POVENDOR FILE

                            PO Vendor Master

This file contains default values for the vendor used by the Purchase Order
system when creating purchase orders, as well as vendor purchasing contact
information.

REFERENCED BY

AP10.1    CXCP.1    PO150     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
RQIH.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

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     AP125     AP126     AP131     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.7    AP21.1
AP210     AP220     AP23.1    AP25.1    AP25.2    AP26.1
AP27.1    AP30.2    AP30.4    AP300     AP305     AP510
AP90.1    AP91.1    API1.1    API2.1    API3.1    API4.1
BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
MX123     MX500     MA180     MA279     MA41.1    MA41.2
MA41.4    MA41.7    MA43.1    MA43.2    MA43.3    MA43.4
MA43.6    MA43.7    MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA63.1    MA65.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    PD235     PO10.1    PO10.2
PO100     PO101     PO120     PO122     PO131     PO20.1
PO21.1    PO21.2    PO21.3    PO21.4    PO21.5    PO22.1
PO220     PO223     PO23.1    PO233     PO24.1    PO25.1
PO25.5    PO25.6    PO25.7    PO253     PO254     PO27.2
PO278     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     PO54.1
PO54.2    PO54.3    PO54.4    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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

POV-VENDOR-GROUP       Alpha 4                                   AP510   PO10.1
Element: Vendor Group  A vendor group represents a group of
                       vendors that can be shared by one or
                       more companies.

POV-VENDOR             Alpha 9  (Right Justified)                AP510   PO10.1
Element: Vendor        The vendor's identification code.



POV-BUYER-CODE         Alpha 3                                   AP510   PO10.1
Element: Buyer

POV-OPEN-PO-LIMIT      Signed 18.2                               AP510   PO10.1
Element: Intl Amt      The maximum open purchase order amount    PO22.1
                       that is allowed for the vendor.  A
                       purchase order may not be released if it
                       will cause the Open PO Amount to exceed
                       this value.

POV-OPEN-PO-AMT        Signed 18.2                               AP125   AP126
Element: Intl Amt      The total open amount (not cancelled and  AP131   AP20.1
                       not paid) for the Vendor.  This total     AP20.2  AP20.3
                       includes only product costs (add on       AP20.4  AP20.5
                       costs and taxes are not included) and is  AP20.7  AP21.1
                       stated in base currency.                  AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 AP510   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
                                                                 ...

POV-LEADTIME-DAYS      Numeric 3                                 AP510   PO10.1
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.

POV-EDI-NUMBER         Alpha 15                                  AP510   PO10.1
Element: Edi Nbr                                                 PO220

POV-FAX-PREFIX         Alpha 6                                   AP510   PO10.1
Element: Phone Prefix  The telephone number country code.

POV-FAX-EXT            Alpha 5                                   AP510   PO10.1
Element: Phone Ext     This field contains the telephone
                       extension number.

POV-FAX-NUMBER         Alpha 15                                  AP510   PO10.1
Element: Phone         Phone number.

POV-MAX-ORDER-AMT      Signed 18.2                               AP510   PO10.1
Element: Intl Amt      The maximum open purchase order amount
                       for this vendor.

POV-FREIGHT-TERMS      Alpha 1                                   AP510   PO10.1
Element: Freight Terms The vendor's default freight term.

POV-SHIP-VIA           Alpha 12  (Lower Case)                    AP510   PO10.1
Element: Ship Via      The vendor's default ship via narrative.

POV-FOB-CODE           Alpha 3                                   AP510   PO10.1
Element: Fob Code      The vendor's user-defined ship term
                       code is used as a default at purchase
                       order entry time.

POV-NORM-DEL-DAY       Alpha 3                                   AP510   PO10.1
Element: Norm Del Day  The vendor's normal delivery day.
                       Information only.
                       FRI = Friday
                       MON = Monday
                       SAT = Saturday
                       SUN = Sunday
                       THU = Thursday
                       TUE = Tuesday
                       WED = Wednesday

POV-OSHIP-TOL-PCT      Percent 5.3  (Percent)                    AP510   PO10.1
Element: Oship Tol Pct Quantity overshipment tolerance
                       percentage.

POV-USHIP-TOL-PCT      Percent 6.3  (Percent)                    AP510   PO10.1
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.

POV-ZERO-OSHIP-FL      Alpha 1                                   AP510   PO10.1
Element: All Flag      The vendor default overshipment
                       quantity tolerance flag.
                       N = No
                       Y = Yes

POV-ZERO-USHIP-FL      Alpha 1                                   AP510   PO10.1
Element: All Flag      Set this flag to "Y" to indicate that
                       the undershipment tolerance percent
                       should be set to "zero" at this level.
                       This means that no backorders will be
                       canceled.

                       The undershipment tolerance percent
                       must be blank to set this flag to "Y".
                       N = No
                       Y = Yes

POV-CANCEL-ALL-BO      Alpha 1                                   AP510   PO10.1
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

POV-RMA-REQUIRED       Alpha 1                                   AP510   PO10.1
Element: All Flag      Enter a Y to indicate that the vendor
                       requires return material authorization
                       numbers when returns are made to them.
                       The RMA number will then be required to
                       be entered on any returns to that
                       vendor, and vendor RMA documents can be
                       printed to send to the vendor with the
                       return goods.
                       N = No
                       Y = Yes

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

POV-OVEND-SHIP-VIA     Alpha 12  (Lower Case)                    AP510   PO10.1
Element: Ship Via

POV-REQ-LOC-LEVEL      Alpha 1                                   AP510   PO10.1
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 purchase order 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 requisition 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 purchase order. 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

POV-REQ-CONT-LEVEL     Alpha 1
Element: Req Cont LevelThis field is used to determine whether
                       requisition lines with different
                       agreement references can be combined
                       onto a single purchase order.

                       If the flag is set to "L", different
                       contracts can be combined. If the flag
                       is set to "H", they cannot be combined.
                       This file contains header information
                       for





                       each purchase order.
                       L = Can Mix Contracts On PO
                       H = Cannot Mix Contracts On PO

POV-ISSUE-METH         Alpha 1                                   AP510   PO10.1
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

POV-REV-ISSUE-METH     Alpha 1                                   AP510   PO10.1
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

POV-REV-EDI-NUMBER     Alpha 15                                  AP510   PO10.1
Element: Edi Nbr

POV-REV-EDI-TRANS      Alpha 1                                   AP510   PO10.1
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).
                       " " = Not Applicable
                       P = PO Transaction
                       C = Change Transaction

POV-REVISIONS-INCL     Alpha 1                                   AP510   PO10.1
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
                       N = Not applicable

POV-VENDOR-CONTCT      Alpha 30                                  AP510   PO10.1
Element: Vendor Name   The requester can enter the recommended
                       vendor's name for the requested items.

POV-PHONE-PREFIX       Alpha 6                                   AP510   PO10.1
Element: Phone Prefix  The telephone number country code.

POV-PHONE-NUM          Alpha 15                                  AP510   PO10.1
Element: Phone         Phone number.

POV-PHONE-EXT          Alpha 5                                   AP510   PO10.1
Element: Phone Ext     This field contains the telephone
                       extension number.

POV-PO-CODE            Alpha 4                                   AP510   PO10.1
Element: Po Code       This is the purchase order code that
                       will default from the vendor to the
                       purchase order.

POV-MIN-ORD-WEIGHT     Signed 9.3                                AP510   PO10.1
Element: Min Ord Weight

POV-UPD-PO-COST        Numeric 1                                 AP510   PO10.1
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

POV-LOADING-PORT       Alpha 5                                   AP510   PO10.1
Element: Loading Port  The port where the goods are loaded, if
                       required.  The port code must be defined
                       in IN04.1 (Port Maintenance)

POV-UNLOADING-PORT     Alpha 5                                   AP510   PO10.1
Element: Unloading PortThe prot where the goods are unloaded if
                       required.  Must be defined in IN04.1
                       (Port Maintenance)

POV-PUNCHOUT-CHG-F     Numeric 1                                 AP510   PO10.1
Element: Punchout Chg F0 = Changes allowed
                       1 = Changes not allowed

POV-EMAIL-ADDRESS      Alpha 60  (Lower Case)                    AP510   PO10.1
Element: Email Address e-mail address.

POV-REORDER-SUN-FL     Numeric 1                                 AP510   PO10.1
Element: Reorder Mon Fl

POV-REORDER-MON-FL     Numeric 1                                 AP510   PO10.1
Element: Reorder Mon Fl

POV-REORDER-TUE-FL     Numeric 1                                 AP510   PO10.1
Element: Reorder Mon Fl

POV-REORDER-WED-FL     Numeric 1                                 AP510   PO10.1
Element: Reorder Mon Fl

POV-REORDER-THU-FL     Numeric 1                                 AP510   PO10.1
Element: Reorder Mon Fl

POV-REORDER-FRI-FL     Numeric 1                                 AP510   PO10.1
Element: Reorder Mon Fl

POV-REORDER-SAT-FL     Numeric 1                                 AP510   PO10.1
Element: Reorder Mon Fl

POV-LOC-ID-PRT         Numeric 1                                 AP510   PO10.1
Element: Loc Id Prt    0 = No Print
                       1 = Print HIN on PO Line
                       2 = Print GLN on PO Line

POV-OVER-AGRMT         Alpha 1                                   PO10.1
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

POV-OVER-LC-LP         Alpha 1                                   PO10.1
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

POV-ONE-SRC-ONE-PO     Numeric 1                                 PO10.1
Element: One Src One Po0 = No
                       1 = One Requisition to One PO
                       2 = One Sales Order to One PO
                       3 = Req and Sales Order to One PO

POV-LOC-INDICATOR      Derived
Element: Loc Indicator

                         POVENDOR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

POVSET1   VENDOR-GROUP                                           AC160   AM115
          VENDOR                                                 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
                                                                 AP10.1  AP110
                                                                 AP115   AP125
                                                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 ...

                         POVENDOR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apvenmast      APVENMAST    Required

                            POV-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            POV-VENDOR           -> VEN-VENDOR

Buyer          BUYER        Required

                            PCG-PROCURE-GROUP    -> BUY-PROCURE-GROUP
                            POV-BUYER-CODE       -> BUY-BUYER-CODE

Fobcode        FOBCODE      Not Required

                            PCG-PROCURE-GROUP    -> FOB-PROCURE-GROUP
                            POV-FOB-CODE         -> FOB-FOB-CODE

Pofrtterm      POFRTTERM    Not Required

                            PCG-PROCURE-GROUP    -> POF-PROCURE-GROUP
                            POV-FREIGHT-TERMS    -> POF-FREIGHT-TERMS

Popovuf        POPOVUF      Not Required

                            POV-VENDOR-GROUP     -> UFV-VENDOR-GROUP
                            POV-VENDOR           -> UFV-VENDOR

Procuregrp     PROCUREGRP   Required

                            POV-VENDOR-GROUP     -> PCG-VENDOR-GROUP

                         POVENDOR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Povendloc      POVENDLOC

                            POV-VENDOR-GROUP     -> PVL-VENDOR-GROUP
                            POV-VENDOR           -> PVL-VENDOR
                                                    PVL-PURCH-FR-LOC