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     SA258     SATE.1

UPDATED BY

AR06.2    AR06.3    AR08.1    AR10.1    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
BL802     BL820     BL92.1    OE10.1    OE10.2    OE10.3
OE10.4    OE10.5    OE10.6    OE10.7    OE10.8    OE11.1
OE11.4    OE11.8    OE11.9    OE110     OE111     OE113
OE114     OE116     OE129     OE13.2    OE13.3    OE13.5
OE14.4    OE288     OE30.1    OE30.2    OE30.3    OE30.4
OE30.5    OE30.6    OE30.7    OE30.9    OE510     OE530
OE810     OE830     SA02.1    SA250     SA253     SA80.1
SA90.1    WH20.2    WH20.7    AR01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

TRY-TERRITORY          Alpha 4                                   AR06.2
Element: Sales TerritorThe code representing the Sales
                       Territory.

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

TRY-USED-FL            Alpha 1                                   AR06.2  AR06.3
Element: Used          Used flag indicates whether or not        AR08.1  AR10.1
                       territory has been used. Valid vales      AR501   AR550
                       are:                                      BL02.1  BL120
                                                                 BL122   BL130
                       N = Territory has not been used           BL20.1  BL20.3
                       Y = Territory has been used               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
                                                                 BL802   BL820
                                                                 BL92.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE116
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE14.4  OE288
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 ...

TRY-ACTIVE-STATUS      Alpha 1                                   AR06.2
Element: 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
                                                                 AR10.1  AR206
                                                                 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
                                                                 ...

                         TERITORY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            TRY-COMPANY    -> ACO-COMPANY