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
payments 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 The number representing an AR company. AR28.1 AR501
AR575
AMX-BANK-ENTITY Alpha 15 AR13.1 AR13.2
Element: Bank Entity Represents a bank institution location. AR28.1 AR501
AR575
AMX-BANK-ACCT-NBR Alpha 35 AR13.1 AR13.2
Element: Bank Acct Nbr 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
Element: Customer The customer number associated to the AR28.1 AR501
bank and bank account. AR575
AMX-RIBKEY Numeric 2 AR501
Element: Ribkey This field contains the Ribkey value for
the bank account number.
AMX-VBANK-IDENT Alpha 1 AR13.1 AR13.2
Element: Alphadata1 AR501
ARMICRCUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AMXSET1 COMPANY AR10.1 AR13.1
BANK-ENTITY AR13.2 AR21.1
BANK-ACCT-NBR AR213 AR28.1
AR501 AR570
AR575
AMXSET2 COMPANY AR13.2 AR28.1
CUSTOMER 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
|
