Lawson Insight Technical Documentation

                             TERITORY FILE

                             AR Territories

The AR Territories file stores all user defined sales territories for a
particular company. A territory is required when adding a customer and is used
by the Lawson Order Entry system.

REFERENCED BY

AR206

UPDATED BY

AR06.2    AR06.3    AR08.1    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    BL802     AR01.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

TRY-COMPANY          Numeric 4                                   AR06.2
Company              Company number.

TRY-TERRITORY        Alpha 4                                     AR06.2
Sales Territory      The code representing the Sales
                     Territory.

TRY-DESCRIPTION      Alpha 30  (Lower Case)                      AR06.2
Description          Description of sales territories.

TRY-USED-FL          Alpha 1                                     AR06.2  AR06.3
Used                 Used flag indicates whether or not          AR08.1  AR501
                     territory has been used. Valid vales        AR550   BL02.1
                     are:                                        BL30.1  BL30.2
                                                                 BL30.3  BL30.5
                     N = Territory has not been used             BL31.1  BL31.2
                     Y = Territory has been used                 BL31.3  BL31.5
                                                                 BL31.7  BL32.1
                                                                 BL32.2  BL32.3
                                                                 BL32.4  BL802

TRY-ACTIVE-STATUS    Alpha 1                                     AR06.2
Status               Active status indicates whether or not
                     a territory is active. Valid values are:


                     A = Active
                     I = Inactive

                         TERITORY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TRYSET1   COMPANY       This is the primary path used to access  AR01.1  AR06.2
          TERRITORY     records.                                 AR06.3  AR08.1
                                                                 AR206   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  BL802

TRYSET2   TERRITORY
          COMPANY

                         TERITORY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            TRY-COMPANY    -> ACO-COMPANY  (ACOSET1)