ARCONTACTS

AR Customer Contacts

The AR Customer Contacts file contains additional contact names for a customer. (Each customer has a contact at the group customer level and one contact at the company customer level.)

REFERENCED BY
AC56.1 AC560 AR09.1 AR09.4 AR12.1 AR12.2
AR13.1 AR13.2 AR210 AR211 AR501 AR550
ARLL.1 BR11.1 BR20.7 BR21.1 BR211 BR252
BR55.1 BRIP.1 CB06.2 CB191 TX140


UPDATED BY
AR10.1 AR11.1 AR301

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CON-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
AR11.1
CON-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
Customer number.
AR11.1
CON-RESP-CODE
Element: Responsibility Code
Alpha 5
This field's primary purpose is to maintain uniqueness among the contacts. It also represents the responsibility of the contact in a short form. For example, "AP" for accounts payable manager. The responsibility code is user defined.
AR11.1
CON-NAME
Element: Contact Name
Alpha 30 (Lower Case)
The name of the contact person.
AR11.1
CON-INT-PREFIX
Element: International Prefix
Alpha 6
The contact's international telephone number prefix.
AR11.1
CON-PHONE-NMBR
Element: Telephone Number
Alpha 15
The telephone number of the contact person.
AR11.1
CON-PHONE-EXT
Element: Telephone Extension
Alpha 5
Telephone extension number.
AR11.1
CON-FAX-NMBR
Element: Fax Number
Alpha 15
Fax number of the contact person.
AR11.1
CON-FAX-EXT
Element: Fax Extension
Alpha 5
Fax extension number.
AR11.1
CON-DESC
Element: Description
Alpha 30 (Lower Case)
Description or notes for this contact.
AR11.1
CON-E-MAIL-ADDRESS
Element: Email Address
Alpha 60 (Lower Case)
The contact's Email address.
AR11.1


ARCONTACTS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CONSET1 COMPANY
CUSTOMER
RESP-CODE
AC56.1 AC560
AR09.1 AR09.4
AR10.1 AR11.1
AR12.1 AR12.2
AR13.1 AR13.2
AR210 AR211
AR301 AR501
AR550 ARLL.1
BR11.1 BR20.7
BR21.1 BR211
BR252 BR55.1
BRIP.1 CB06.2
CB191 TX140


ARCONTACTS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
CON-COMPANY->ACO-COMPANY
Conbod CONBOD Not Required, Delete Cascades
CON-COMPANY->YCN-COMPANY
CON-CUSTOMER->YCN-CUSTOMER
CON-RESP-CODE->YCN-RESP-CODE
Custcontact ARCUSTOMER Required
CON-COMPANY->ACM-COMPANY
CON-CUSTOMER->ACM-CUSTOMER
Custdesc CUSTDESC Required
ACO-CUST-GROUP->CUD-CUST-GROUP
CON-CUSTOMER->CUD-CUSTOMER


File created: Thu Jun 09 02:09:00 2016

Home
Contact Us



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