Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


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

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

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
                                                                 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)