Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             MACRECHDR FILE

UPDATED BY

PO53.1    PO530

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MRH-COMPANY          Numeric 4                                   PO53.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

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

MRH-REC-NUMBER       Alpha 10  (Right Justified)
Receiver Number      The receiver number.  Assigned when
                     this receiving information was added.

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

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

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

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

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

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


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

MRH-CARRIER          Alpha 9                                     PO53.1
Carrier Vendor       This is the carrier vendor number. It
Number               must be a valid vendor.

MRH-VENDOR           Alpha 9                                     PO53.1
Vendor ID            The vendor's identification code.



MRH-REC-COMMENTS     Alpha 30  (Lower Case)                      PO53.1
Receiving Comments

MRH-STATUS           Numeric 1                                   PO53.1
Status               This field contains the status of the
                     transaction.

MRH-LOGGED-FL        Alpha 1                                     PO53.1
Logged Fl            Y
                     N

MRH-ACTUAL-TIME      Numeric 4                                   PO53.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-INVOICE          Alpha 22                                    PO53.1
Invoice Number       Used to identify the invoice.

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

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

MRH-RECORD-ERROR     Alpha 1                                     PO53.1  PO530
Record Error

                         MACRECHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MRHSET1   COMPANY                                                PO53.1  PO53.3
          REFERENCE-NO                                           PO530

MRHSET2   COMPANY       Subset                                   PO53.1
          REFERENCE-NO  Where RECORD-ERROR = "Y"

                         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

Macrecline     MACRECLINE

                            MRH-COMPANY         -> MRL-COMPANY
                            MRH-REFERENCE-NO    -> MRL-REFERENCE-NO
                                                   MRL-LINE-NBR

Macrecpot      MACRECPOT

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