Lawson Insight Technical Documentation

                             SALESREP FILE

                              AR SalesReps

The AR SalesReps file carries sales representative codes. Sale representative
codes are added to a customer record, contained on transaction records and are
used for reporting purposes.

REFERENCED BY

AR206     AR210     AR234     AR235     AR251     AR253
AR260     AR271     AR275     AR282     AR292     AR502
AR560

UPDATED BY

AR06.3    AR08.1    AR42.2    AR501     AR550     BL02.1
BL30.1    BL30.2    BL30.3    BL30.5    BL31.1    BL31.2
BL31.3    BL31.5    BL31.7    BL32.1    BL32.2    BL32.3
BL32.4    BL80.1    BL802     AR01.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SAW-COMPANY          Numeric 4                                   AR06.3
Company              Company number.

SAW-SALESMAN         Numeric 4                                   AR06.3
SalesRep Number      Sales representative number established
                     online.

SAW-NAME             Alpha 30  (Lower Case)                      AR06.3
Name                 The name/description of the Sales
                     Representative.

SAW-TERRITORY        Alpha 4                                     AR06.3
Sales Territory      Sales Territory for the particular
                     sales representative.

SAW-COMM-RATE        Percent 7.5  (Percent)                      AR06.3
Commission Rate      Commission Rate for sales
                     representative.

SAW-USED-FL          Alpha 1                                     AR06.3  AR08.1
Used                 Indicates whether or not the sales          AR42.2  AR501
                     representative has been used. Valid         AR550   BL02.1
                     values are:                                 BL30.1  BL30.2
                                                                 BL30.3  BL30.5
                     N = No                                      BL31.1  BL31.2
                     Y = Yes                                     BL31.3  BL31.5
                                                                 BL31.7  BL32.1
                                                                 BL32.2  BL32.3
                                                                 BL32.4  BL80.1
                                                                 BL802

SAW-ACTIVE-STATUS    Alpha 1                                     AR06.3
Status               Determines the active status of the
                     sales representative. Valid values are:

                     A = Active
                     I = Inactive

                         SALESREP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SAWSET1   COMPANY       This is the primary path used to access  AR01.1  AR06.3
          SALESMAN      records.                                 AR08.1  AR206
                                                                 AR210   AR234
                                                                 AR235   AR251
                                                                 AR253   AR260
                                                                 AR271   AR275
                                                                 AR282   AR292
                                                                 AR42.2  AR42.6
                                                                 AR501   AR502
                                                                 AR550   AR560
                                                                 BL02.1  BL30.1
                                                                 BL30.2  BL30.3
                                                                 BL30.5  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 ...

                         SALESREP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            SAW-COMPANY      -> ACO-COMPANY

Territory      TERITORY     Required

                            SAW-COMPANY      -> TRY-COMPANY
                            SAW-TERRITORY    -> TRY-TERRITORY