Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARMICRCUST


                            ARMICRCUST FILE

                       AR MICR Customer Cross Ref

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

REFERENCED BY

AR10.1    AR21.1    AR213     AR570

UPDATED BY

AR13.1    AR13.2    AR28.1    AR301     AR501     AR575

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AMX-COMPANY            Numeric 4                                 AR13.1  AR13.2
Element: Company       Company number.                           AR28.1  AR501
                                                                 AR575

AMX-BANK-ENTITY        Alpha 15                                  AR13.1  AR13.2
Element: Bank          Represents a bank institution location.   AR28.1  AR501
                                                                 AR575

AMX-BANK-ACCT-NBR      Alpha 17                                  AR13.1  AR13.2
Element: Bank Account NThe bank-assigned account number          AR28.1  AR501
                       identification to be used for the cash    AR575
                       code.

AMX-CUSTOMER           Alpha 9  (Right Justified)                AR13.1  AR13.2
Element: Customer      Customer number.                          AR28.1  AR501
                                                                 AR575

                         ARMICRCUST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AMXSET1   COMPANY       This path is used for record             AR10.1  AR13.1
          BANK-ENTITY   uniqueness.                              AR13.2  AR21.1
          BANK-ACCT-NBR                                          AR213   AR28.1
                                                                 AR501   AR570
                                                                 AR575

AMXSET2   COMPANY       This path is used to access the file by  AR13.2  AR28.1
          CUSTOMER      customer number.                         AR301
          BANK-ENTITY
          BANK-ACCT-NBR

                         ARMICRCUST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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