Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARCONTACTS


                            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

AC551     AR211     AR70.2    BR11.1    BR20.7    BR21.1
BR211     BR252     BR521     BR55.1    BRIP.1    BRPI.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  AC551   AR10.1
          CUSTOMER      customer contact records.                AR11.1  AR211
          RESP-CODE                                              AR301   AR70.2
                                                                 BR11.1  BR20.7
                                                                 BR21.1  BR211
                                                                 BR252   BR521
                                                                 BR55.1  BRIP.1
                                                                 BRPI.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