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    MA531

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  MA531
Company              The company number represents an
                     established company and is entered on
                     all function codes.


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

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

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

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

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

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

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

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

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

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

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

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



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

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


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

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

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

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

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

MRH-PRINT-CODE       Alpha 1                                     MA531
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
Match Ref Nbr

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


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


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

MRH-NOTES            Alpha 20  (Lower Case)
Notes

MRH-RECORD-ERROR     Alpha 1                                     MA53.1  MA531
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                                           MA531

MRHSET2   RUN-GROUP     KeyChange                                MA531
          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
                            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