MACRECHDR

UPDATED BY
MA53.1 MA53.5 MA531

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MRH-RUN-GROUP
Element: 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
Element: 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
Element: Reference No
Alpha 10 (Right Justified)
MA53.1 MA531
MRH-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
MA53.1 MA531
MRH-REC-NUMBER
Element: Rec Number
Numeric 10
The receiver number. Assigned when this receiving information was added.
MA531
MRH-PO-NUMBER
Element: Po Number
Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
MA53.1 MA531
MRH-PO-RELEASE
Element: Po Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
MA53.1 MA531
MRH-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
MA53.1 MA531
MRH-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
MA53.1 MA531
MRH-OPER-ID
Element: Operator
Alpha 10
This field is used to store the login id of the person who entered the record.
MA53.1 MA531
MRH-BUYER-CODE
Element: Buyer
Alpha 3
MA53.1 MA531
MRH-BOL-NBR
Element: Bol Nbr
Alpha 22
This field contains the Bill of Lading number.
MA53.1 MA531
MRH-REC-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
MA53.1 MA531
MRH-CARRIER
Element: Carrier
Alpha 9 (Right Justified)
This is the carrier vendor number. It must be a valid vendor.
MA53.1 MA531
MRH-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
MA53.1 MA531
MRH-PURCH-FR-LOC
Element: Purch Fr Loc
Alpha 4
The vendor's purchase from location.
MA53.1
MRH-REC-COMMENTS
Element: Ers Comments
Alpha 100 (Lower Case)
MA53.1 MA531
MRH-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
MA53.1 MA531
MRH-LOGGED-FL
Element: Logged Fl
Alpha 1

Y = Yes
N = No
MA53.1 MA531
MRH-ACTUAL-TIME
Element: 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
Element: Ers Comments
Alpha 100 (Lower Case)
MA53.1 MA531
MRH-ERS-STATUS
Element: Ers Status
Numeric 1
The status of the receipt in the Evaluated Receipts Settlement process.
MA53.1 MA531
MRH-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
MA53.1 MA531
MRH-INVC-REF-TYPE
Element: Invc Ref Type
Alpha 2
Indicates the type of number the vendor is providing to reference the invoice.
MA53.1 MA531
MRH-PRINT-CODE
Element: 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
Element: Match Ref Nbr
Alpha 22
MA53.1 MA531
MRH-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
MA53.1 MA531
MRH-PROCESS-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
MA53.1 MA531
MRH-TERMS-CD
Element: Term Code
Alpha 5
A user-defined code representing a method of determining invoice due and discount dates.
MA53.1 MA531
MRH-NOTES
Element: Notes
Alpha 20 (Lower Case)
MRH-RECORD-ERROR
Element: Record Error
Alpha 1

Y = Yes
N = No
MA53.1 MA531
MRH-XREF-VENDOR
Element: 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
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
MA531
MRH-RETAIL-FLAG
Element: Retail Flag
Numeric 1
MA53.1 MA531


MACRECHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MRHSET1 COMPANY
REFERENCE-NO
SEQ-NBR
MA53.1 MA53.5
MA531
MRHSET2 RUN-GROUP
RECORD-ERROR
COMPANY
VENDOR
REFERENCE-NO
SEQ-NBR
KeyChange
MA531


MACRECHDR FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 11:20:18 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.