Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARIMICR


                              ARIMICR FILE

                     MICR Customer Xref Conversion

The MICR Customer Xref Conversion record is used as a cross reference between
a customer number and a MICR number. Records in this file have been converted
from an external source and will be loaded into the Accounts Receivable system
by AR501 (Customer Conversion).

UPDATED BY

AR501

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IMI-COMPANY            Numeric 4
Element: Company       Company number.  Required.

IMI-BANK-ENTITY        Alpha 15
Element: Bank          Represents a bank institution location.
                       Required.

IMI-BANK-ACCT-NBR      Alpha 35
Element: Bank Account NThe bank-assigned account number
                       identification.  Required.

IMI-CUSTOMER           Alpha 9  (Right Justified)
Element: Customer      Customer number.  Required.

IMI-RIBKEY             Numeric 2
Element: Ribkey

IMI-VBANK-IDENT        Alpha 1
Element: Alphadata1    This field indicates if the account
                       number is an IBAN number that requires
                       an account validation check.

                         ARIMICR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IMISET1   COMPANY       The patch is used to keep the records    AR501
          BANK-ENTITY   unique.
          BANK-ACCT-NBR
          CUSTOMER