Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TERITORY


                             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    AR10.1    AR501     AR550
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:                                      WH20.2  WH20.7

                       N = Territory has not been used
                       Y = Territory has been used

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
                                                                 WH20.2  WH20.7

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)