MACINVERR – Inv Interface/Conversion Error

System
Matching (MA)
Prefix
MCI
Primary key
COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, DIST-SEQ, RECORD-TYPE, SEQ-NBR
Fields
9
Updated by
2 programs
Referenced by
0 programs

MACINVERR is the Inv Interface/Conversion Error table in Lawson Matching (prefix MCI). It is indexed by COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, DIST-SEQ, RECORD-TYPE, SEQ-NBR (MCISET1). It is updated by MA54.1 and MA540. The table has 9 fields, 1 index and 0 documented relations.

About MACINVERR

No description in the Lawson data dictionary.

Fields (9)

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

Field / columnTypeDescription & valuesUpdated by
MCI-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.MA540
MCI-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.MA540
MCI-EDI-NBR PK
EDI_NBR		Alpha 15The electronic data interchange (EDI) number assigned to the vendor.MA540
MCI-INVOICE PK
INVOICE		Alpha 22Used to identify the invoice.MA540
MCI-SUFFIX PK
SUFFIX		Numeric 3This is the suffix for the invoice.MA540
MCI-DIST-SEQ PK
DIST_SEQ		Numeric 4A unique sequence number assigned to Sequence Number the distribution record.MA540
MCI-RECORD-TYPE PK
RECORD_TYPE		Alpha 1This field identifies the type of record defined. Valid values are:
  • 1 MACINVOICE file
  • 2 MACINVDTL file
  • 3 MACAPDTL file
  • 4 Macinvaoc
MA540
MCI-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.MA540
MCI-ERR-MESSAGE
ERR_MESSAGE		Alpha 60Error message. Indicates why the invoice failed the interface or conversion edits.MA540

Indexes (1)

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

IndexKeysFlagsConditionUsed in
MCISET1COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, DIST-SEQ, RECORD-TYPE, SEQ-NBRPrimaryMA54.1, MA54.8, MA540

Programs

Updated by (2)