MACRECERR – MA Record Error

System
Matching (MA)
Prefix
MRE
Primary key
COMPANY, REFERENCE-NO, ERROR-TYPE, LINE-NBR, SEQ-NBR
Fields
18
Updated by
3 programs
Referenced by
0 programs

MACRECERR is the MA Record Error table in Lawson Matching (prefix MRE). It is indexed by COMPANY, REFERENCE-NO, ERROR-TYPE, LINE-NBR, SEQ-NBR (MRESET1). It is updated by MA53.1, MA53.2 and MA531. The table has 18 fields, 1 index and 0 documented relations.

About MACRECERR

No description in the Lawson data dictionary.

Fields (18)

Column = COBOL field name without the MRE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
MRE-ERROR-TYPE PK
ERROR_TYPE
Numeric 1MA531
MRE-REC-TYPE
REC_TYPE
Alpha 1The file record type.
  • 1 MACRECHDR
  • 2 MACRECAOC
  • 3 MACRECLINE
  • 4 MACRECPOT
MA531
MRE-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.MA531
MRE-NAME
NAME
Alpha 30 (Lower Case)Displays the company description.MA531
MRE-VENDOR
VENDOR
Alpha 9 (Right Justified)The vendor's identification code.MA531
MRE-VENDOR-NAME
VENDOR_NAME
Alpha 30The requester can enter the recommended vendor's name for the requested items.MA531
MRE-REFERENCE-NO PK
REFERENCE_NO
Alpha 25 (Right Justified)MA531
MRE-LINE-NBR PK
LINE_NBR
Numeric 6This field contains the line number.MA531
MRE-SEQ-NBR PK
SEQ_NBR
Numeric 4An automatically assigned sequence number.MA531
MRE-PO-NUMBER
PO_NUMBER
Alpha 14 (Right Justified)This field contains the number representing the purchase order.MA531
MRE-PO-RELEASE
PO_RELEASE
Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).MA531
MRE-PO-CODE
PO_CODE
Alpha 4This is the purchase order code.MA531
MRE-ENT-REC-QTY
ENT_REC_QTY
Signed 13.4This field contains the desired quantity.MA531
MRE-ORIG-UNIT-CST
ORIG_UNIT_CST
Signed 18.5MA531
MRE-DATA-FIELD
DATA_FIELD
Alpha 15MA531
MRE-DATA-VALUE
DATA_VALUE
Alpha 20MA531
MRE-DATA-MSG
DATA_MSG
Alpha 58MA531
MRE-VENDOR-GLN
VENDOR_GLN
Alpha 13

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MRESET1COMPANY, REFERENCE-NO, ERROR-TYPE, LINE-NBR, SEQ-NBRPrimaryMA53.1, MA53.2, MA53.3, MA531

Programs

Updated by (3)