MACRECHDR – MA Record Header

System
Matching (MA)
Prefix
MRH
Primary key
COMPANY, REFERENCE-NO, SEQ-NBR
Fields
42
Updated by
2 programs
Referenced by
0 programs

MACRECHDR is the MA Record Header table in Lawson Matching (prefix MRH). It is indexed by COMPANY, REFERENCE-NO, SEQ-NBR (MRHSET1); alternate indexes: MRHSET2. It is related 1:M to MACRECAOC, MACRECERR and MACRECPOT. It is updated by MA53.1 and MA531. The table has 42 fields, 2 indexes and 3 documented relations.

About MACRECHDR

No description in the Lawson data dictionary.

Fields (42)

Column = COBOL field name without the MRH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#MRH-RUN-GROUP SET2
RUN_GROUP		Alpha 15Run Group and Seq Number are the keys to the file. They should be used to group records together for interfacing.MA53.1
#MRH-COMPANY PK
COMPANY		Numeric 4Identifies 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.MA53.1, MA531
#MRH-REFERENCE-NO PK
REFERENCE_NO		Alpha 25 (Right Justified)—MA53.1, MA531
#MRH-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.MA53.1, MA531
#MRH-REC-NUMBER
REC_NUMBER		Numeric 10The receiver number. Assigned when this receiving information was added.MA531
#MRH-PO-NUMBER
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.MA53.1, MA531
#MRH-PO-RELEASE
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).MA53.1, MA531
#MRH-PO-CODE
PO_CODE		Alpha 4This is the purchase order code.MA53.1, MA531
#MRH-LOCATION
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.MA53.1, MA531
#MRH-OPER-ID
OPER_ID		Alpha 10This field is used to store the login id of the person who entered the record.MA53.1, MA531
#MRH-BUYER-CODE
BUYER_CODE		Alpha 3—MA53.1, MA531
#MRH-BOL-NBR
BOL_NBR		Alpha 22This field contains the Bill of Lading number.MA53.1, MA531
#MRH-REC-DATE
REC_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.MA53.1, MA531
#MRH-CARRIER
CARRIER		Alpha 9 (Right Justified)This is the carrier vendor number. It must be a valid vendor.MA53.1, MA531
#MRH-VENDOR SET2
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.MA53.1, MA531
#MRH-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4The vendor's purchase from location.MA53.1
#MRH-REC-COMMENTS
REC_COMMENTS		Alpha 100 (Lower Case)—MA53.1, MA531
#MRH-STATUS
STATUS		Numeric 1This field displays the status of the transaction.MA53.1, MA531
#MRH-LOGGED-FL
LOGGED_FL		Alpha 1—
  • Y Yes
  • N No
MA53.1, MA531
#MRH-ACTUAL-TIME
ACTUAL_TIME		Numeric 4This 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.MA53.1, MA531
#MRH-ERS-COMMENTS
ERS_COMMENTS		Alpha 100 (Lower Case)—MA53.1, MA531
#MRH-ERS-STATUS
ERS_STATUS		Numeric 1The status of the receipt in the Evaluated Receipts Settlement process.MA53.1, MA531
#MRH-INVOICE
INVOICE		Alpha 22Used to identify the invoice.MA53.1, MA531
#MRH-INVC-REF-TYPE
INVC_REF_TYPE		Alpha 2Indicates the type of number the vendor is providing to reference the invoice.MA53.1, MA531
#MRH-PRINT-CODE
PRINT_CODE		Alpha 1This field contains the print code, which defines where comments are displayed or printed.MA53.1, MA531
#MRH-MATCH-REF-NBR
MATCH_REF_NBR		Alpha 22—MA53.1, MA531
#MRH-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).MA53.1, MA531
#MRH-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.MA53.1, MA531
#MRH-TERMS-CD
TERMS_CD		Alpha 5A user-defined code representing a method of determining invoice due and discount dates.MA53.1, MA531
#MRH-NOTES
NOTES		Alpha 20 (Lower Case)——
#MRH-RECORD-ERROR SET2
RECORD_ERROR		Alpha 1—
  • Y Yes
  • N No
MA53.1, MA531
#MRH-XREF-VENDOR
XREF_VENDOR		Alpha 9 (Right Justified)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
SHIP_TO_ARRIVE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.MA531
#MRH-RETAIL-FLAG
RETAIL_FLAG		Numeric 1—MA53.1, MA531
#MRH-LOCATION-GLN
LOCATION_GLN		Alpha 13——
#MRH-BUYER-GLN
BUYER_GLN		Alpha 13——
#MRH-VENDOR-GLN
VENDOR_GLN		Alpha 13——
#MRH-FREIGHT-TOT
FREIGHT_TOT		Signed 18.2——
#MRH-INSURANCE-TOT
INSURANCE_TOT		Signed 18.2——
#MRH-CSTMS-TOT
CSTMS_TOT		Signed 18.2——
#MRH-OTHER-AOC-TOT
OTHER_AOC_TOT		Signed 18.2——
#MRH-GLBL-DOC-TYPE
GLBL_DOC_TYPE		Alpha 10—MA53.1

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MRHSET1
  1. COMPANY
  2. REFERENCE-NO
  3. SEQ-NBR
PrimaryMA53.1, MA53.5, MA531
MRHSET2
  1. RUN-GROUP
  2. RECORD-ERROR
  3. COMPANY
  4. VENDOR
  5. REFERENCE-NO
  6. SEQ-NBR
KeyChangeMA531

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
MACRECAOCMACRECERRMACRECPOTMACRECHDR

One to many (3) — child tables

RelationTableRulesConditionField map
MacrecaocMACRECAOC
MRH-COMPANY→MRA-COMPANY
MRH-REFERENCE-NO→MRA-REFERENCE-NO
—→MRA-LINE-NBR
—→MRA-AOC-CODE
—→MRA-SEQ-NBR
MacrecerrMACRECERR
MRH-COMPANY→MRE-COMPANY
MRH-REFERENCE-NO→MRE-REFERENCE-NO
—→MRE-ERROR-TYPE
—→MRE-LINE-NBR
—→MRE-SEQ-NBR
MacrecpotMACRECPOT
MRH-COMPANY→MRP-COMPANY
MRH-REFERENCE-NO→MRP-REFERENCE-NO
—→MRP-LINE-NBR
—→MRP-SEQ

Programs

Updated by (2)