ARMICRCUST – AR MICR Customer Cross Ref

System
Accounts Receivable (AR)
Prefix
AMX
Primary key
COMPANY, BANK-ENTITY, BANK-ACCT-NBR
Fields
6
Updated by
4 programs
Referenced by
2 programs

ARMICRCUST is the AR MICR Customer Cross Ref table in Lawson Accounts Receivable (prefix AMX). It is indexed by COMPANY, BANK-ENTITY, BANK-ACCT-NBR (AMXSET1); alternate indexes: AMXSET2. It is related 1:1 to ARCOMP, ARCUSTOMER and CUSTDESC. It is updated by AR13.1, AR13.2, AR301 and AR501 and referenced by AR10.1 and AR213. The table has 6 fields, 2 indexes and 3 documented relations.

About ARMICRCUST

The AR MICR Customer Cross Reference file contains MICR/customer number cross reference records. This relationship is needed to process lock box payments so payments can be assigned to a customer. This file is optionally used when manually entering payments.

Fields (6)

Column = COBOL field name without the AMX- 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
#AMX-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR13.1, AR13.2, AR501
#AMX-BANK-ENTITY PK
BANK_ENTITY		Alpha 15Represents a bank institution location.AR13.1, AR13.2, AR501
#AMX-BANK-ACCT-NBR PK
BANK_ACCT_NBR		Alpha 35The bank-assigned account number identification to be used for the cash code.AR13.1, AR13.2, AR501
#AMX-CUSTOMER SET2
CUSTOMER		Alpha 9 (Right Justified)The customer number associated to the bank and bank account.AR13.1, AR13.2, AR501
#AMX-RIBKEY
RIBKEY		Numeric 2This field contains the Ribkey value for the bank account number.AR501
#AMX-VBANK-IDENT
VBANK_IDENT		Alpha 1—AR13.1, AR13.2, AR501

Indexes (2)

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
AMXSET1
  1. COMPANY
  2. BANK-ENTITY
  3. BANK-ACCT-NBR
PrimaryAR10.1, AR13.1, AR13.2, AR213, AR501
AMXSET2
  1. COMPANY
  2. CUSTOMER
  3. BANK-ENTITY
  4. BANK-ACCT-NBR
AR13.2, AR301

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ARCOMPARCUSTOMERCUSTDESCARMICRCUST

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequired
AMX-COMPANY→ACO-COMPANY
ArcustomerARCUSTOMERRequired
AMX-COMPANY→ACM-COMPANY
AMX-CUSTOMER→ACM-CUSTOMER
CustdescCUSTDESCRequired
ACO-CUST-GROUP→CUD-CUST-GROUP
AMX-CUSTOMER→CUD-CUSTOMER

Programs

Updated by (4)

Referenced by (2)