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
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
Company Company number. AR28.1 AR501
AR575
AMX-BANK-ENTITY Alpha 15 AR13.1 AR13.2
Bank Represents a bank institution location. AR28.1 AR501
AR575
AMX-BANK-ACCT-NBR Alpha 17 AR13.1 AR13.2
Bank Account Number The 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
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 AR13.1 AR13.2
BANK-ENTITY uniqueness. AR21.1 AR213
BANK-ACCT-NBR 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
|
