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.

Field / column	Type	Description & values	Updated by
`MRH-RUN-GROUP` RUN_GROUP	Alpha 15	Run 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 4	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.	MA53.1, MA531
`MRH-REFERENCE-NO` PK REFERENCE_NO	Alpha 25 (Right Justified)	—	MA53.1, MA531
`MRH-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	MA53.1, MA531
`MRH-REC-NUMBER` REC_NUMBER	Numeric 10	The 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 4	Used to identify a purchase order release (created from a Blanket or Standing order).	MA53.1, MA531
`MRH-PO-CODE` PO_CODE	Alpha 4	This is the purchase order code.	MA53.1, MA531
`MRH-LOCATION` LOCATION	Alpha 5	This field contains a valid stocking location within the company inventory.	MA53.1, MA531
`MRH-OPER-ID` OPER_ID	Alpha 10	This 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 22	This 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` VENDOR	Alpha 9 (Right Justified)	The vendor's identification code.	MA53.1, MA531
`MRH-PURCH-FR-LOC` PURCH_FR_LOC	Alpha 4	The vendor's purchase from location.	MA53.1
`MRH-REC-COMMENTS` REC_COMMENTS	Alpha 100 (Lower Case)	—	MA53.1, MA531
`MRH-STATUS` STATUS	Numeric 1	This 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 4	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.	MA53.1, MA531
`MRH-ERS-COMMENTS` ERS_COMMENTS	Alpha 100 (Lower Case)	—	MA53.1, MA531
`MRH-ERS-STATUS` ERS_STATUS	Numeric 1	The status of the receipt in the Evaluated Receipts Settlement process.	MA53.1, MA531
`MRH-INVOICE` INVOICE	Alpha 22	Used to identify the invoice.	MA53.1, MA531
`MRH-INVC-REF-TYPE` INVC_REF_TYPE	Alpha 2	Indicates the type of number the vendor is providing to reference the invoice.	MA53.1, MA531
`MRH-PRINT-CODE` PRINT_CODE	Alpha 1	This 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 5	This field contains the company base currency code established in Company (GL10.1 ).	MA53.1, MA531
`MRH-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	This field contains the process level, which is the reporting hierarchy below company.	MA53.1, MA531
`MRH-TERMS-CD` TERMS_CD	Alpha 5	A 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` 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`MRHSET1`	`COMPANY`, `REFERENCE-NO`, `SEQ-NBR`	Primary		MA53.1, MA53.5, MA531
`MRHSET2`	`RUN-GROUP`, `RECORD-ERROR`, `COMPANY`, `VENDOR`, `REFERENCE-NO`, `SEQ-NBR`	KeyChange		MA531

Relations

One to many (3) — child tables

Relation	Table	Field map
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`

Programs

Updated by (2)

MA53.1 Receipt Interface
MA531 Receipt Interface