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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MCISET1
  1. COMPANY
  2. VENDOR
  3. EDI-NBR
  4. INVOICE
  5. SUFFIX
  6. DIST-SEQ
  7. RECORD-TYPE
  8. SEQ-NBR
PrimaryMA54.1, MA54.8, MA540

Programs

Updated by (2)