|
|
MACRECHDR FILE
UPDATED BY
MA53.1 MA531
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MRH-RUN-GROUP Alpha 15
Element: 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
Element: Company 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.
MRH-REFERENCE-NO Alpha 10 (Right Justified) MA53.1 MA531
Element: Reference No
MRH-REC-NUMBER Numeric 10 MA531
Element: Receiver NumbeThe receiver number. Assigned when
this receiving information was added.
MRH-PO-NUMBER Alpha 14 (Right Justified) MA53.1 MA531
Element: PO Number This field contains the number
representing the purchase order.
MRH-PO-RELEASE Numeric 4 MA53.1 MA531
Element: PO Release NumUsed to identify a purchase order
release (created from a Blanket or
Standing order).
MRH-PO-CODE Alpha 4 MA53.1 MA531
Element: Po Code This is the purchase order code.
MRH-LOCATION Alpha 5 MA53.1 MA531
Element: Location Code This field contains a valid stocking
location within the company inventory.
MRH-OPER-ID Alpha 10 MA53.1 MA531
Element: Operator Code
MRH-BUYER-CODE Alpha 3 MA53.1 MA531
Element: Buyer 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
Element: 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
Element: Vendor ID The vendor's identification code.
MRH-REC-COMMENTS Alpha 100 (Lower Case) MA53.1
Element: Ers Comments
MRH-STATUS Numeric 1 MA53.1 MA531
Element: Status This field displays the status of the
transaction.
MRH-LOGGED-FL Alpha 1 MA53.1 MA531
Element: Logged Fl Y = Yes
N = No
MRH-ACTUAL-TIME Numeric 4 MA53.1 MA531
Element: 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
Element: Ers Comments
MRH-ERS-STATUS Numeric 1 MA53.1 MA531
Element: ERS Status The status of the receipt in the
Evaluated Receipts Settlement process.
MRH-INVOICE Alpha 22 MA53.1 MA531
Element: Invoice NumberUsed 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 MA53.1 MA531
Element: 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
Element: Match Ref Nbr
MRH-CURRENCY-CODE Alpha 5 MA53.1 MA531
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
MRH-PROCESS-LEVEL Alpha 5 MA53.1 MA531
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
MRH-TERMS-CD Alpha 5 MA53.1 MA531
Element: Terms Code
MRH-NOTES Alpha 20 (Lower Case)
Element: Notes
MRH-RECORD-ERROR Alpha 1 MA53.1 MA531
Element: Record Error Y = Yes
N = No
MRH-XREF-VENDOR Alpha 9 (Right Justified)
Element: Xref Vendor 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 Numeric 8 (yyyymmdd) MA531
Element: Date
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
|
