ARIMICR – MICR Customer Xref Conversion

System
Accounts Receivable (AR)
Prefix
IMI
Primary key
COMPANY, BANK-ENTITY, BANK-ACCT-NBR, CUSTOMER
Fields
6
Updated by
1 program
Referenced by
0 programs

ARIMICR is the MICR Customer Xref Conversion table in Lawson Accounts Receivable (prefix IMI). It is indexed by COMPANY, BANK-ENTITY, BANK-ACCT-NBR, CUSTOMER (IMISET1). It is updated by AR501. The table has 6 fields, 1 index and 0 documented relations.

About ARIMICR

No description in the Lawson data dictionary.

Fields (6)

Column = COBOL field name without the IMI- 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
#IMI-COMPANY PK
COMPANY
Numeric 4The number representing an AR company.—
#IMI-BANK-ENTITY PK
BANK_ENTITY
Alpha 15Represents a bank institution location. Required.—
#IMI-BANK-ACCT-NBR PK
BANK_ACCT_NBR
Alpha 35The bank-assigned account number identification. Required.—
#IMI-CUSTOMER PK
CUSTOMER
Alpha 9 (Right Justified)Customer number. Required.—
#IMI-RIBKEY
RIBKEY
Numeric 2This field contains the Ribkey value for the bank account number.—
#IMI-VBANK-IDENT
VBANK_IDENT
Alpha 1——

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
IMISET1
  1. COMPANY
  2. BANK-ENTITY
  3. BANK-ACCT-NBR
  4. CUSTOMER
PrimaryAR501

Programs

Updated by (1)