Lawson Insight Technical Documentation

                             SALESREP FILE

                              AR SalesReps

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

REFERENCED BY

AR09.1    AR206     AR210     AR234     AR235     AR239
AR251     AR253     AR260     AR264     AR271     AR275
AR282     AR292     AR300     AR301     AR502     AR560
ARLL.1    PW550     TX140

UPDATED BY

AR06.3    AR08.1    AR10.1    AR120     AR42.2    AR501
AR550     BL02.1    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    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
BL520     BL80.1    BL802     BL820     BL92.1    WH20.2
WH20.7    AR01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SAW-COMPANY            Numeric 4                                 AR06.3
Element: Company       The number representing an AR company.

SAW-SALESMAN           Numeric 4                                 AR06.3
Element: SalesRep NumbeThe sales representative number.

SAW-NAME               Alpha 30  (Lower Case)                    AR06.3
Element: Name          The name of the sales representative.

SAW-TERRITORY          Alpha 4                                   AR06.3
Element: Territory     Sales Territory for the particular sales
                       representative.  Used by the Lawson
                       Order Processing system.

SAW-COMM-RATE          Percent 7.5  (Percent)                    AR06.3
Element: Comm Rate     Commission Rate for the sales
                       representative.  Used by the Lawson
                       Order Processing system.

SAW-USED-FL            Alpha 1                                   AR06.3  AR08.1
Element: Used Fl       Indicates whether or not the sales        AR10.1  AR120
                       representative has been used. Valid       AR42.2  AR501
                       values are:                               AR550   BL02.1
                                                                 BL120   BL122
                       N = No                                    BL130   BL20.1
                       Y = Yes                                   BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  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
                                                                 BL520   BL80.1
                                                                 BL802   BL820
                                                                 BL92.1  WH20.2
                                                                 WH20.7

SAW-ACTIVE-STATUS      Alpha 1                                   AR06.3
Element: Active 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                                                AR01.1  AR06.3
          SALESMAN                                               AR08.1  AR09.1
                                                                 AR10.1  AR120
                                                                 AR206   AR210
                                                                 AR234   AR235
                                                                 AR239   AR251
                                                                 AR253   AR260
                                                                 AR264   AR271
                                                                 AR275   AR282
                                                                 AR292   AR300
                                                                 AR301   AR42.2
                                                                 AR42.6  AR501
                                                                 AR502   AR550
                                                                 AR560   ARLL.1
                                                                 BL02.1  BL120
                                                                 ...

                         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