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 35 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
AMX-RIBKEY Numeric 2 AR501
Element: Ribkey
AMX-VBANK-IDENT Alpha 1 AR13.1 AR13.2
Element: Alphadata1 This field indicates if the account AR501
number is an IBAN number that requires
an account validation check.
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
|
