ARMICRCUST

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
AR213


UPDATED BY
AR10.1 AR13.1 AR13.2 AR301 AR501

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AMX-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
AR13.1 AR13.2
AR501
AMX-BANK-ENTITY
Element: Bank Entity
Alpha 15
Represents a bank institution location.
AR13.1 AR13.2
AR501
AMX-BANK-ACCT-NBR
Element: Bank Acct Nbr
Alpha 35
The bank-assigned account number identification to be used for the cash code.
AR13.1 AR13.2
AR501
AMX-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
The customer number associated to the bank and bank account.
AR13.1 AR13.2
AR501
AMX-RIBKEY
Element: Ribkey
Numeric 2
This field contains the Ribkey value for the bank account number.
AR501
AMX-VBANK-IDENT
Element: Alphadata1
Alpha 1
AR13.1 AR13.2
AR501


ARMICRCUST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AMXSET1 COMPANY
BANK-ENTITY
BANK-ACCT-NBR
AR10.1 AR13.1
AR13.2 AR213
AR501
AMXSET2 COMPANY
CUSTOMER
BANK-ENTITY
BANK-ACCT-NBR
AR13.2 AR301


ARMICRCUST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:09:03 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.