TERITORY – AR Territories

System
Accounts Receivable (AR)
Prefix
TRY
Primary key
COMPANY, TERRITORY
Fields
5
Updated by
9 programs
Referenced by
1 program

TERITORY is the AR Territories table in Lawson Accounts Receivable (prefix TRY). It is indexed by COMPANY, TERRITORY (TRYSET1). It is related 1:1 to ARCOMP. It is updated by AR01.1, AR06.2, AR06.3, AR08.1, AR10.1, AR501, AR550, WH20.2 and 1 more and referenced by AR206. The table has 5 fields, 1 index and 1 documented relation.

About TERITORY

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.

Fields (5)

Column = COBOL field name without the TRY- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
TRY-COMPANY PK
COMPANY		Numeric 4Company number.AR06.2
TRY-TERRITORY PK
TERRITORY		Alpha 4The code representing the Sales Territory.AR06.2
TRY-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Description of sales territories.AR06.2
TRY-USED-FL
USED_FL		Alpha 1Used flag indicates whether or not territory has been used. Valid vales are:
  • N Territory has not been used
  • Y Territory has been used
AR06.2, AR06.3, AR08.1, AR10.1, AR501, AR550, WH20.2, WH20.7
TRY-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1Active status indicates whether or not a territory is active. Valid values are:
  • A Active
  • I Inactive
AR06.2

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TRYSET1COMPANY, TERRITORYPrimaryAR01.1, AR06.2, AR06.3, AR08.1, AR10.1, AR206, AR501, AR550 +2 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequiredTRY-COMPANY → ACO-COMPANY

Programs

Updated by (9)

Referenced by (1)