Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TERITORY


                             TERITORY FILE

                             AR Territories

This 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    AR10.1    AR120     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    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: Territory     The 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 Fl       Used flag indicates whether or not        AR08.1  AR10.1
                       territory has been used. Valid vales      AR120   AR501
                       are:                                      AR550   BL02.1
                                                                 BL120   BL122
                       N = Territory has not been used           BL130   BL20.1
                       Y = Territory has been used               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
                                                                 WH20.2  WH20.7

TRY-ACTIVE-STATUS      Alpha 1                                   AR06.2
Element: Active 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                                                AR01.1  AR06.2
          TERRITORY                                              AR06.3  AR08.1
                                                                 AR10.1  AR120
                                                                 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
                                                                 ...

                         TERITORY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            TRY-COMPANY    -> ACO-COMPANY