Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MACRECHDR


                             MACRECHDR FILE

UPDATED BY

MA53.1    MA531

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MRH-RUN-GROUP          Alpha 15                                  MA53.1
Element: Run Group     Run Group and Seq Number are the keys
                       to the file.  They should be used to
                       group records together for interfacing.

MRH-COMPANY            Numeric 4                                 MA53.1  MA531
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

MRH-REFERENCE-NO       Alpha 10  (Right Justified)               MA53.1  MA531
Element: Reference No

MRH-SEQ-NBR            Numeric 4                                 MA53.1  MA531
Element: Seq Nbr       An automatically assigned sequence
                       number.

MRH-REC-NUMBER         Numeric 10                                MA531
Element: Rec Number    The receiver number.  Assigned when
                       this receiving information was added.

MRH-PO-NUMBER          Alpha 14  (Right Justified)               MA53.1  MA531
Element: Po Number     This field contains the number
                       representing the purchase order.

MRH-PO-RELEASE         Numeric 4                                 MA53.1  MA531
Element: Po Release    Used to identify a purchase order
                       release (created from a Blanket or
                       Standing order).

MRH-PO-CODE            Alpha 4                                   MA53.1  MA531
Element: Po Code       This is the purchase order code.

MRH-LOCATION           Alpha 5                                   MA53.1  MA531
Element: Location      This field contains a valid stocking
                       location within the company inventory.

MRH-OPER-ID            Alpha 10                                  MA53.1  MA531
Element: Operator      This field is used to store the login
                       id of the person who entered the record.


MRH-BUYER-CODE         Alpha 3                                   MA53.1  MA531
Element: Buyer

MRH-BOL-NBR            Alpha 22                                  MA53.1  MA531
Element: Bol Nbr       This field contains the Bill of Lading
                       number.

MRH-REC-DATE           Numeric 8  (yyyymmdd)                     MA53.1  MA531
Element: Date          This field displays the system date
                       when this was created.

MRH-CARRIER            Alpha 9  (Right Justified)                MA53.1  MA531
Element: Carrier       This is the carrier vendor number. It
                       must be a valid vendor.

MRH-VENDOR             Alpha 9  (Right Justified)                MA53.1  MA531
Element: Vendor        The vendor's identification code.



MRH-PURCH-FR-LOC       Alpha 4                                   MA53.1
Element: Purch Fr Loc  The vendor's purchase from location.

MRH-REC-COMMENTS       Alpha 100  (Lower Case)                   MA53.1  MA531
Element: Ers Comments

MRH-STATUS             Numeric 1                                 MA53.1  MA531
Element: Status        This field displays the status of the
                       transaction.

MRH-LOGGED-FL          Alpha 1                                   MA53.1  MA531
Element: Logged Fl     Y = Yes
                       N = No

MRH-ACTUAL-TIME        Numeric 4                                 MA53.1  MA531
Element: Actual Time   This field contains the actual time the
                       receiver was entered into the system.
                       This filed defaults to the system date
                       if an actual time was not entered.

MRH-ERS-COMMENTS       Alpha 100  (Lower Case)                   MA53.1  MA531
Element: Ers Comments

MRH-ERS-STATUS         Numeric 1                                 MA53.1  MA531
Element: Ers Status    The status of the receipt in the
                       Evaluated Receipts Settlement process.

MRH-INVOICE            Alpha 22                                  MA53.1  MA531
Element: Invoice       Used to identify the invoice.

MRH-INVC-REF-TYPE      Alpha 2                                   MA53.1  MA531
Element: Invc Ref Type Indicates the type of number the vendor
                       is providing to reference the invoice.

MRH-PRINT-CODE         Alpha 1                                   MA53.1  MA531
Element: Print Code    This field contains the print code,
                       which defines where comments are
                       displayed or printed.

MRH-MATCH-REF-NBR      Alpha 22                                  MA53.1  MA531
Element: Match Ref Nbr

MRH-CURRENCY-CODE      Alpha 5                                   MA53.1  MA531
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

MRH-PROCESS-LEVEL      Alpha 5                                   MA53.1  MA531
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

MRH-TERMS-CD           Alpha 5                                   MA53.1  MA531
Element: Term Code     A user-defined code representing a
                       method of determining invoice due and
                       discount dates.

MRH-NOTES              Alpha 20  (Lower Case)
Element: Notes

MRH-RECORD-ERROR       Alpha 1                                   MA53.1  MA531
Element: Record Error  Y = Yes
                       N = No

MRH-XREF-VENDOR        Alpha 9  (Right Justified)
Element: Xref Vendor   This is a vendor that is supported on a
                       system outside Lawson.  When records are
                       interfaces we will maintain this vendor
                       on the file but we will use the Lawson
                       vendor while in the lawson application.

MRH-SHIP-TO-ARRIVE     Numeric 8  (yyyymmdd)                     MA531
Element: Date          This field displays the system date
                       when this was created.

MRH-RETAIL-FLAG        Numeric 1                                 MA53.1  MA531
Element: Retail Flag

                         MACRECHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MRHSET1   COMPANY                                                MA53.1  MA53.5
          REFERENCE-NO                                           MA531
          SEQ-NBR

MRHSET2   RUN-GROUP     KeyChange                                MA531
          RECORD-ERROR
          COMPANY
          VENDOR
          REFERENCE-NO
          SEQ-NBR

                         MACRECHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Macrecaoc      MACRECAOC

                            MRH-COMPANY         -> MRA-COMPANY
                            MRH-REFERENCE-NO    -> MRA-REFERENCE-NO
                                                   MRA-LINE-NBR
                                                   MRA-AOC-CODE
                                                   MRA-SEQ-NBR

Macrecerr      MACRECERR

                            MRH-COMPANY         -> MRE-COMPANY
                            MRH-REFERENCE-NO    -> MRE-REFERENCE-NO
                                                   MRE-ERROR-TYPE
                                                   MRE-LINE-NBR
                                                   MRE-SEQ-NBR

Macrecpot      MACRECPOT

                            MRH-COMPANY         -> MRP-COMPANY
                            MRH-REFERENCE-NO    -> MRP-REFERENCE-NO
                                                   MRP-LINE-NBR
                                                   MRP-SEQ