ARCONTACTS FILE

                          AR Customer Contacts

AR Customer Contacts

REFERENCED BY

AR211     AR70.2

UPDATED BY

AR10.1    AR11.1    AR301

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CON-COMPANY          Numeric 4                                   AR11.1
Company              Company number.

CON-CUSTOMER         Alpha 9  (Right Justified)                  AR11.1
Customer             Customer number.

CON-RESP-CODE        Alpha 5                                     AR11.1
Responsibility Code  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.

CON-NAME             Alpha 30  (Lower Case)                      AR11.1
Contact Name         The name of the contact person.

CON-INT-PREFIX       Alpha 6                                     AR11.1
International Prefix The contact's international telephone
                     number prefix.

CON-PHONE-NMBR       Alpha 15                                    AR11.1
Telephone Number     The telephone number of the contact
                     person.

CON-PHONE-EXT        Alpha 5                                     AR11.1
Telephone Extension  Telephone extension number.

CON-FAX-NMBR         Alpha 15                                    AR11.1
Fax Number           Fax number of the contact person.

CON-FAX-EXT          Alpha 5                                     AR11.1
Fax Extension        Fax extension number.

CON-DESC             Alpha 30  (Lower Case)                      AR11.1
Description          Description or notes for this contact.

                         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

                         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