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

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  AR09.1
Element: Used          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
                       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  AR09.1
                                                                 AR10.1  AR105
                                                                 AR110   AR115
                                                                 AR140   AR206
                                                                 AR210   AR217
                                                                 AR234   AR235
                                                                 AR251   AR253
                                                                 AR260   AR271
                                                                 AR274   AR275
                                                                 AR282   AR290
                                                                 AR292   AR301
                                                                 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