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    AP210     AP51.5    CXCP.1    DR100     IC140
IC141     IC142     IC531     IC83.1    PO150     PO210
PO220     PO223     POCP.1    POID.1    POIT.1    RQ11.1
RQ12.1    RQ13.1    RQ140     RQ300     RQ35.1    RQ40.1
RQ41.1    RQ42.1    RQ44.1    RQ44.2    RQ500     RQIC.1
RQID.1    RQIF.1    RQIG.1    RQIH.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     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     AP20.1    AP20.2
AP20.3    AP20.4    AP20.5    AP20.7    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    AP300     AP510
API1.1    API3.1    API4.1    IC28.1    IC840     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    PO10.1    PO100     PO101     PO122
PO131     PO20.1    PO21.1    PO21.2    PO21.3    PO21.4
PO21.5    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    PR05.1    PR05.3    PR226     PR247
PR26.1    PR47.1    PR514     UK47.1    RQ10.1    RQ10.2
RQ10.3    RQIE.1    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

POV-OPEN-PO-LIMIT      Signed 15.2                               AP510   PO10.1
Element: Adj 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 15.2                               AP125   AP126
Element: Adj 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  AP23.1
                       stated in base currency.                  AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  AP510
                                                                 API1.1  IC28.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  PO10.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO25.1  PO25.5
                                                                 PO25.6  PO25.7
                                                                 PO27.2  PO29.1
                                                                 PO30.1  PO30.2
                                                                 ...

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                                              PO220

POV-FAX-PREFIX         Alpha 6                                   AP510   PO10.1
Telephone Country
Code

POV-FAX-EXT            Alpha 5                                   AP510   PO10.1
Element: Telephone Extension

POV-FAX-NUMBER         Alpha 15                                  AP510   PO10.1
Element: Telephone Number

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

POV-FREIGHT-TERMS      Alpha 1                                   AP510   PO10.1
Element: Ac Usage      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
Element: Cost Pct

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      N = No
                       Y = Yes

POV-OVEND-SHIP-VIA     Alpha 12                                  AP510   PO10.1
Inbound frm Vendor
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

POV-REQ-CONT-LEVEL     Alpha 1                                   AP510
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

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

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                                   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                                   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  POII.1
Element: Email Address

POV-LOC-INDICATOR      Derived
Element: Loc Indicator

                         POVENDOR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

POVSET1   VENDOR-GROUP                                           AM115   AM15.1
          VENDOR                                                 AM15.2  AM15.3
                                                                 AM15.4  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP10.1
                                                                 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
                                                                 ...

                         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