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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
AMX-COMPANY PKCOMPANY | Numeric 4 | The number representing an AR company. | AR13.1, AR13.2, AR501 |
AMX-BANK-ENTITY PKBANK_ENTITY | Alpha 15 | Represents a bank institution location. | AR13.1, AR13.2, AR501 |
AMX-BANK-ACCT-NBR PKBANK_ACCT_NBR | Alpha 35 | The bank-assigned account number identification to be used for the cash code. | AR13.1, AR13.2, AR501 |
AMX-CUSTOMERCUSTOMER | Alpha 9 (Right Justified) | The customer number associated to the bank and bank account. | AR13.1, AR13.2, AR501 |
AMX-RIBKEYRIBKEY | Numeric 2 | This field contains the Ribkey value for the bank account number. | AR501 |
AMX-VBANK-IDENTVBANK_IDENT | Alpha 1 | — | AR13.1, AR13.2, AR501 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
AMXSET1 | COMPANY, BANK-ENTITY, BANK-ACCT-NBR | Primary | AR10.1, AR13.1, AR13.2, AR213, AR501 | |
AMXSET2 | COMPANY, CUSTOMER, BANK-ENTITY, BANK-ACCT-NBR | AR13.2, AR301 |
Relations
One to one (3) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Arcomp | ARCOMP | Required | AMX-COMPANY → ACO-COMPANY | |
| Arcustomer | ARCUSTOMER | Required | AMX-COMPANY → ACM-COMPANY, AMX-CUSTOMER → ACM-CUSTOMER | |
| Custdesc | CUSTDESC | Required | ACO-CUST-GROUP → CUD-CUST-GROUP, AMX-CUSTOMER → CUD-CUSTOMER |