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

AP03.3    AP10.1    AP210     CXCP.1    DR100     IC140
IC141     IC142     IC531     IC83.1    PO150     PO210
PO220     PO223     PO25.5    PO27.2    POCP.1    POID.1
POIT.1    RQ11.1    RQ12.1    RQ13.1    RQ13.2    RQ140
RQ300     RQ35.1    RQ40.1    RQ41.1    RQ42.1    RQ44.1
RQ44.2    RQ500     RQIC.1    RQID.1    RQIF.1    RQIG.1
RQIJ.1    WH130     WH132     WH190     WH222     WH25.1
WH25.2    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     WO132
WO140

UPDATED BY

AM115     AM117     AM15.1    AM15.2    AM15.3    AM15.4
AM20.1    AM20.3    AM21.1    AM21.3    AM500     AM51.1
AM551     AM97.1    AP125     AP126     AP131     AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    AP510     API3.1
API4.1    BL120     BL122     BL130     BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL820
BL92.1    IC28.1    IC840     MA180     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
OE10.1    OE10.2    OE10.3    OE10.4    OE10.5    OE10.6
OE10.7    OE10.8    OE11.1    OE11.4    OE11.8    OE11.9
OE110     OE111     OE113     OE114     OE116     OE129
OE13.2    OE13.3    OE13.5    OE13.6    OE14.4    OE30.1
OE30.2    OE30.3    OE30.4    OE30.5    OE30.6    OE30.7
OE30.9    OE510     OE530     OE81.1    OE810     OE830
OE90.1    OE90.2    PO10.1    PO100     PO101     PO122
PO131     PO20.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO29.1    PO30.1    PO30.2    PO30.3
PO300     PO31.1    PO31.2    PO32.2    PO33.1    PO34.1
PO35.1    PO38.1    PO39.1    PO39.2    PO44.1    PO50.1
PO52.1    PO520     POI3.1    POIE.1    POII.1    POIJ.1
PR05.1    PR05.3    PR226     PR247     PR26.1    PR47.1
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 ID     The vendor's identification code.



POV-BUYER-CODE         Alpha 3                                   AP510   PO10.1
Element: Buyer         The user defined buyer identifier.

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   AP25.1
                       not paid) for the Vendor.  This total     AP25.2  AP26.1
                       includes only product costs (add on       AP27.1  AP30.4
                       costs and taxes are not included) and is  AP510   BL120
                       stated in base currency.                  BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC28.1
                                                                 MA180   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  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE116
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE13.6  OE14.4
                                                                 ...

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

POV-EDI-NUMBER         Alpha 15                                  AP510   PO10.1
Element: EDI Number    EDI number.                               PO220

POV-FAX-PREFIX         Alpha 6                                   AP510   PO10.1
Telephone Country      The fax number prefix.
Code

POV-FAX-EXT            Alpha 5                                   AP510   PO10.1
Element: Telephone ExteThis field contains the fax number
                       extension.


POV-FAX-NUMBER         Alpha 15                                  AP510   PO10.1
Element: Telephone NumbThis field contains the fax 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 DescrThe vendor's default ship via narrative.

POV-FOB-CODE           Alpha 3                                   AP510   PO10.1
Element: Shipping Term 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: Normal DeliverThe 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
Overshipment           Quantity overshipment tolerance
Tolerance Percent      percentage.

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

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      Set to Yes to indicate that Return
                       Material Authorization documents
                       provided by the vendor must be sent with
                       any goods returned to this vendor. RMA
                       documents can also be printed internally
                       and sent to the vendor, but this flag
                       does not pertain to those documents.
                       N = No
                       Y = Yes

POV-OVEND-SHIP-VIA     Alpha 12  (Lower Case)                    AP510   PO10.1
Element: Ship Via DescrThis is the shipping method to be used
                       for the shipment of return goods to the
                       vendor. This may be defaulted from the
                       vendor.

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

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 Number    Enter the number used to identify the
                       trading partner in the EDI translation
                       software for purchase order revisions.

                       If you do not specify a value, the
                       vendor's EDI Number will be used on
                       purchase order revisions.

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 vendor contact name.

POV-PHONE-PREFIX       Alpha 6                                   AP510   PO10.1
Telephone Country      The telephone number country code.
Code

POV-PHONE-NUM          Alpha 15                                  AP510   PO10.1
Element: Telephone NumbThis is the main telephone number.

POV-PHONE-EXT          Alpha 5                                   AP510   PO10.1
Element: Telephone ExteThis 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                                 PO10.1
Element: Punchout Chg F0 = Changes allowed
                       1 = Changes not allowed

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

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

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

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

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

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

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

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

POV-LOC-ID-PRT         Alpha 1
Element: Print Flag    G = Print GLN on PO Line
                       H = Print HIN on PO Line
                       " " = No print

POV-LOC-INDICATOR      Derived
Element: Loc Indicator

                         POVENDOR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

POVSET1   VENDOR-GROUP                                           AM115   AM117
          VENDOR                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP03.3  AP10.1
                                                                 AP125   AP126
                                                                 AP131   AP210
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  AP510
                                                                 API3.1  API4.1
                                                                 BL120   BL122
                                                                 ...

                         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