APCINVERR – AP Invoice Conversion Error

System
Accounts Payable (AP)
Prefix
AER
Primary key
COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, DIST-SEQ, RECORD-TYPE, SEQ-NBR
Fields
9
Updated by
3 programs
Referenced by
0 programs

APCINVERR is the AP Invoice Conversion Error table in Lawson Accounts Payable (prefix AER). It is indexed by COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, DIST-SEQ, RECORD-TYPE, SEQ-NBR (AERSET1). It is updated by AP305, AP52.1 and AP520. The table has 9 fields, 1 index and 0 documented relations.

About APCINVERR

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the AER- 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
#AER-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.AP520
#AER-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP520
#AER-EDI-NBR PK
EDI_NBR		Alpha 15The EDI number assigned to the invoice.AP520
#AER-INVOICE PK
INVOICE		Alpha 22The invoice number.AP520
#AER-SUFFIX PK
SUFFIX		Numeric 3This is the suffix for the invoice.AP520
#AER-DIST-SEQ PK
DIST_SEQ		Numeric 4The distribution sequence number. Keeps the distribution unique.AP520
#AER-RECORD-TYPE PK
RECORD_TYPE		Alpha 1Identifies the record type which contains the error. Valid values are:
  • 1 Invoice
  • 2 Payment
  • 3 Distribution
AP520
#AER-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.AP520
#AER-ERR-MESSAGE
ERR_MESSAGE		Alpha 60The error number and error message.AP520

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
AERSET1
  1. COMPANY
  2. VENDOR
  3. EDI-NBR
  4. INVOICE
  5. SUFFIX
  6. DIST-SEQ
  7. RECORD-TYPE
  8. SEQ-NBR
PrimaryAP305, AP52.1, AP52.6, AP520

Programs

Updated by (3)