ARMICRCUST FILE
AR MICR Customer Cross Ref
AR MICR Customer Cross Ref
REFERENCED BY
AR10.1 AR21.1 AR213 AR570
UPDATED BY
AR13.1 AR13.2 AR28.1 AR301 AR501 AR575
AR952 AR978
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AMX-COMPANY Numeric 4 AR13.1 AR13.2
Company Company number. AR28.1 AR501
AR575 AR952
AR978
AMX-BANK-ENTITY Alpha 15 AR13.1 AR13.2
Bank Represents a bank institution location. AR28.1 AR501
AR575 AR952
AR978
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 AR952
code. AR978
AMX-CUSTOMER Alpha 9 (Right Justified) AR13.1 AR13.2
Customer Customer number. AR28.1 AR501
AR575 AR952
AR978
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
|