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.

REFERENCED BY

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

UPDATED BY

AR06.1    AR10.1    AR501     AR550

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CAN-COMPANY            Numeric 4                                 AR06.1
Element: Company       Company number.

CAN-CREDIT-ANLYST      Alpha 4                                   AR06.1
Element: Credit AnalystCredit 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: Telephone NumbCredit analyst's telephone number.

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

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

                       N = No
                       Y = Yes

                         CRANALYST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CANSET1   COMPANY       This path is used for record uniqueness  AR01.1  AR06.1
          CREDIT-ANLYST and selection.                           AR08.1  AR10.1
                                                                 AR105   AR110
                                                                 AR115   AR140
                                                                 AR206   AR210
                                                                 AR217   AR234
                                                                 AR235   AR251
                                                                 AR253   AR260
                                                                 AR271   AR274
                                                                 AR275   AR282
                                                                 AR290   AR292
                                                                 AR501   AR550
                                                                 AR70.1  AR70.2
                                                                 AR74.1

                         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