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    AR501     AR550     BL02.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

CAN-CREDIT-ANLYST    Alpha 4                                     AR06.1
Credit Analyst       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
Credit Analyst Name  The name/description of the credit
                     responsibility.


CAN-PHONE-NMBR       Alpha 15                                    AR06.1
Telephone Number     Credit analyst's telephone number.

CAN-PHONE-EXT        Alpha 5                                     AR06.1
Telephone Extension  Telephone extension number.

CAN-USED-FL          Alpha 1                                     AR06.1  AR501
Used                 This field indicates whether or not         AR550   BL02.1
                     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  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
                                                                 BL02.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