|
|
ARCONTACTS FILE
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 AR211 AR70.2 BR11.1 BR20.7
BR21.1 BR211 BR252 BR55.1 BRIP.1
UPDATED BY
AR10.1 AR11.1 AR301
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CON-COMPANY Numeric 4 AR11.1
Element: Company The number representing an AR company.
CON-CUSTOMER Alpha 9 (Right Justified) AR11.1
Element: Customer Customer number.
CON-RESP-CODE Alpha 5 AR11.1
Element: ResponsibilityThis 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.
CON-NAME Alpha 30 (Lower Case) AR11.1
Element: Contact Name The name of the contact person.
CON-INT-PREFIX Alpha 6 AR11.1
Element: International The contact's international telephone
number prefix.
CON-PHONE-NMBR Alpha 15 AR11.1
Element: Telephone NumbThe telephone number of the contact
person.
CON-PHONE-EXT Alpha 5 AR11.1
Element: Telephone ExteTelephone extension number.
CON-FAX-NMBR Alpha 15 AR11.1
Element: Fax Number Fax number of the contact person.
CON-FAX-EXT Alpha 5 AR11.1
Element: Fax Extension Fax extension number.
CON-DESC Alpha 30 (Lower Case) AR11.1
Element: Description Description or notes for this contact.
CON-E-MAIL-ADDRESS Alpha 60 (Lower Case) AR11.1
Element: Email Address The contact's Email address.
ARCONTACTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CONSET1 COMPANY AC56.1 AC560
CUSTOMER AR10.1 AR11.1
RESP-CODE AR211 AR301
AR70.2 BR11.1
BR20.7 BR21.1
BR211 BR252
BR55.1 BRIP.1
ARCONTACTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
CON-COMPANY -> ACO-COMPANY
Custcontact ARCUSTOMER Required
CON-COMPANY -> ACM-COMPANY
CON-CUSTOMER -> ACM-CUSTOMER
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
CON-CUSTOMER -> CUD-CUSTOMER
|
