TERITORY FILE

                             AR Territories

AR Territories

REFERENCED BY

AR206     OE13.1    SA258     SAA2.1

UPDATED BY

AR01.1    AR06.2    AR06.3    AR08.1    AR10.1    AR501
AR550     BL02.1    BL120     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     BL902     BL92.1    BL940     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
OE113     OE114     OE129     OE14.4    OE15.1    OE15.2
OE15.3    OE15.4    OE15.5    OE15.7    OE288     OE30.1
OE30.2    OE30.3    OE30.4    OE30.5    OE30.6    OE30.7
OE30.9    OE510     OE810     OE830     OE920     OE950
SA02.1    SA250     SA253     SA80.1    SA90.1    WH20.2
WH20.7

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  AR10.1
                     territory has been used. Valid vales        AR501   AR550
                     are:                                        BL02.1  BL120
                                                                 BL130   BL20.1
                     N = Territory has not been used             BL20.3  BL21.2
                     Y = Territory has been used                 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   BL902
                                                                 BL92.1  BL940
                                                                 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   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 OE15.2  OE15.3
                                                                 OE15.4  OE15.5
                                                                 OE15.7  OE288
                                                                 OE30.1  OE30.2
                                                                 ...

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

                         TERITORY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            TRY-COMPANY    -> ACO-COMPANY