Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            POMAGRMTHD FILE

REFERENCED BY

PO225     PO28.1    POI1.1    POI7.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PMH-PROCURE-GROUP    Alpha 4                                     PO28.1  POI1.1
Procure Group        This field contains the identifier for a
                     group of companies that share a common
                     procurement effort. They buy items and
                     services together.

PMH-MAS-AGRMT-REF    Alpha 30                                    PO28.1  POI1.1
Mas Agrmt Ref

PMH-VENDOR           Alpha 9  (Right Justified)                  PO28.1  POI1.1
Vendor ID            The vendor's identification code.



PMH-PURCH-FR-LOC     Alpha 4                                     PO28.1  POI1.1
Purchase From        The vendor's purchase from location.
Location Code

PMH-AGMT-TYPE        Alpha 1                                     PO28.1  POI1.1
Agmt Type            C = Contract
                     B = Blanket
                     T = Catalog/Quote

PMH-DESCRIPTION      Alpha 30  (Lower Case)                      PO28.1  POI1.1
Description          This field displays the description.

PMH-DESCRIPTION2     Alpha 30  (Lower Case)                      PO28.1  POI1.1
Second Description   This field contains the second line of
                     the description.

PMH-GRP-PURCH-ORG    Alpha 9  (Right Justified)                  PO28.1  POI1.1
Grp Purch Org

PMH-AGRMT-ADMIN      Alpha 10  (Lower Case)                      PO28.1  POI1.1
Agrmt Admin

PMH-MANUF-CODE       Alpha 4                                     PO28.1  POI1.1
Manufacturer's Code  This field contains a user defined code
                     that indicates the  manufacturer of an
                     item.

PMH-MANUF-DIVISION   Alpha 4                                     PO28.1  POI1.1
Manufacturer's       This is a user defined code that
Division             indicates which division of a
                     manufacturer is tied to an item.

PMH-TERM-CODE        Alpha 5                                     PO28.1  POI1.1
Terms Code           A user-defined code representing a
                     method of determining invoice due and
                     discount dates.

PMH-EFFECTIVE-DT     Numeric 8  (yyyymmdd)                       PO28.1  POI1.1
Effective Date

PMH-EXPIRE-DT        Numeric 8  (yyyymmdd)                       PO28.1  POI1.1
Expire Dt

PMH-FREIGHT-TERMS    Alpha 1                                     PO28.1  POI1.1
Freight Terms        Freight 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.

PMH-FOB-CODE         Alpha 3                                     PO28.1  POI1.1
Shipping Term Code   The user defined Free On Board Code.

PMH-CURRENCY-CODE    Alpha 5                                     PO28.1  POI1.1
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).

PMH-ORDER-MIN-AMT    Numeric 13                                  PO28.1  POI1.1
Order Min Amt

PMH-DS-AGRMT-REF     Alpha 30                                    PO28.1  POI1.1
Ds Agrmt Ref

PMH-LAST-LINE-NBR    Numeric 6                                   PO28.1  POI1.1
Last Line Number     This field contains the number of the
                     last line item added to the document. It
                     is used to determine what the next line
                     number is when you add another
                     item.

PMH-STOCKLESS-FL     Alpha 1                                     PO28.1  POI1.1
Stockless Fl         Y = Yes
                     N = No

                         POMAGRMTHD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PMHSET1   PROCURE-GROUP                                          PO225   PO28.1
          MAS-AGRMT-REF                                          POI1.1  POI7.1

                         POMAGRMTHD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Poagmtpric     POAGMTPRIC

                            PMH-PROCURE-GROUP    -> PRI-PROCURE-GROUP
                            PMH-MAS-AGRMT-REF    -> PRI-MAS-AGRMT-REF
                            Spaces               -> PRI-VEN-AGRMT-REF
                                                    PRI-EFFECTIVE-DT

Pomagrmtln     POMAGRMTLN

                            PMH-PROCURE-GROUP    -> PML-PROCURE-GROUP
                            PMH-MAS-AGRMT-REF    -> PML-MAS-AGRMT-REF
                                                    PML-LINE-NBR

Povagrmthd     POVAGRMTHD

                            PMH-PROCURE-GROUP    -> PVH-PROCURE-GROUP
                            PMH-MAS-AGRMT-REF    -> PVH-MAS-AGRMT-REF
                                                    PVH-VEN-AGRMT-REF