|
|
ARCONTACTS FILE
AR Customer Contacts
The AR Customer Contacts file contains additional contact names (each
customer has two contacts, one at the group customer and one at the company
customer levels) for a given customer at the company level.
REFERENCED BY
AR211 AR70.2 BR11.1 BR20.7 BR21.1 BR211
BRIP.1 PBIP.1
UPDATED BY
AR10.1 AR11.1 AR301
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CON-COMPANY Numeric 4 AR11.1
Element: Company Company number.
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
ARCONTACTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CONSET1 COMPANY This is the primary path used to access AR10.1 AR11.1
CUSTOMER customer contact records. AR211 AR301
RESP-CODE AR70.2 BR11.1
BR20.7 BR21.1
BR211 BRIP.1
PBIP.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
|
