Lawson Insight Technical Documentation

                             CRANALYST FILE

                           AR Credit Analysts

The AR Credit Analysts file contains credit analyst records. These records act
as an identifier of a credit analyst that will be assigned to customer
records. Credit anlyst codes are used for selection and sort criteria in
various forms and reports.

REFERENCED BY

AR01.1    AR08.1    AR105     AR110     AR115     AR120
AR140     AR206     AR210     AR217     AR234     AR235
AR238     AR239     AR251     AR253     AR260     AR264
AR265     AR271     AR274     AR275     AR282     AR290
AR292     AR300     AR70.1    AR70.2    AR74.1

UPDATED BY

AR06.1    AR09.1    AR10.1    AR301     AR501     AR550
BL02.1    BL802     PW550     TX140

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CAN-COMPANY            Numeric 4                                 AR06.1
Element: Company       The number representing an AR company.

CAN-CREDIT-ANLYST      Alpha 4                                   AR06.1
Element: Credit Anlyst Credit Analyst. Code or identifier of a
                       credit analyst or definition of
                       responsibility that will be assigned to
                       a customer.

CAN-NAME               Alpha 30  (Lower Case)                    AR06.1
Element: Credit AnalystThe name/description of the credit
                       responsibility.


CAN-PHONE-NMBR         Alpha 15                                  AR06.1
Element: Phone         Credit analyst's telephone number.

CAN-PHONE-EXT          Alpha 5                                   AR06.1
Element: Phone Ext     Telephone extension number.

CAN-USED-FL            Alpha 1                                   AR06.1  AR09.1
Element: Used Fl       This field indicates whether or not       AR10.1  AR301
                       this credit analyst has been used,        AR501   AR550
                       (assigned to a customer). Valid values    BL02.1  BL802
                       are:                                      PW550   TX140

                       N = No
                       Y = Yes

                         CRANALYST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CANSET1   COMPANY                                                AR01.1  AR06.1
          CREDIT-ANLYST                                          AR08.1  AR09.1
                                                                 AR10.1  AR105
                                                                 AR110   AR115
                                                                 AR120   AR140
                                                                 AR206   AR210
                                                                 AR217   AR234
                                                                 AR235   AR238
                                                                 AR239   AR251
                                                                 AR253   AR260
                                                                 AR264   AR265
                                                                 AR271   AR274
                                                                 AR275   AR282
                                                                 AR290   AR292
                                                                 AR300   AR301
                                                                 ...

                         CRANALYST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            CAN-COMPANY          -> ACO-COMPANY

                         CRANALYST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Creditsel      ARCDSELECT   Delete Cascades

                            CAN-COMPANY          -> SEL-COMPANY
                            CAN-CREDIT-ANLYST    -> SEL-CREDIT-ANLYST
                                                    SEL-DATE
                                                    SEL-SYS-TIME
                                                    SEL-CUSTOMER
                                                    SEL-SELECT-LEVEL