Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             MACRECHDR FILE

UPDATED BY

MA53.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MRH-RUN-GROUP        Alpha 15
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
Company              The company number represents an
                     established company and is entered on
                     all function codes.

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

MRH-REC-NUMBER       Numeric 10
Receiver Number      The receiver number.  Assigned when
                     this receiving information was added.

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

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

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

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

MRH-OPER-ID          Alpha 10                                    MA53.1
Operator
Identification

MRH-BUYER-CODE       Alpha 3                                     MA53.1
Buyer Code           The user defined buyer identifier.

MRH-BOL-NBR          Alpha 22                                    MA53.1
Bill of Lading       This field contains the Bill of Lading
Number               number.

MRH-REC-DATE         Numeric 8  (yyyymmdd)                       MA53.1
Receiving Date

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

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



MRH-REC-COMMENTS     Alpha 100  (Lower Case)                     MA53.1
Receiving Comments

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

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

MRH-ACTUAL-TIME      Numeric 4                                   MA53.1
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)
Ers Comments

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

MRH-INVOICE          Alpha 22                                    MA53.1
Invoice Number       Used to identify the invoice.

MRH-INVC-REF-TYPE    Alpha 2                                     MA53.1
Invoice Reference    Indicates the type of number the vendor
Type                 is providing to reference the invoice.

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

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

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

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

MRH-TERMS-CD         Alpha 5                                     MA53.1
Terms Code

MRH-NOTES            Alpha 20  (Lower Case)
Notes

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

                         MACRECHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MRHSET1   COMPANY                                                MA53.1  MA53.5
          REFERENCE-NO

MRHSET2   RUN-GROUP     KeyChange
          RECORD-ERROR
          COMPANY
          VENDOR
          REFERENCE-NO

                         MACRECHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Macrecaoc      MACRECAOC

                            MRH-COMPANY         -> MRA-COMPANY  (MRASET1)
                            MRH-REFERENCE-NO    -> MRA-REFERENCE-NO
                                                   MRA-LINE-NBR
                                                   MRA-AOC-CODE

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