ROUTESTOP – Route Stop

System
Warehouse (WH)
Prefix
RTS
Primary key
COMPANY, LOCATION, DATE, ROUTE, STOP
Fields
11
Updated by
229 programs
Referenced by
1 program

ROUTESTOP is the Route Stop table in Lawson Warehouse (prefix RTS). It is indexed by COMPANY, LOCATION, DATE, ROUTE, STOP (RTSSET1). It is related 1:1 to ARCOMP, CUSTDESC, ICCOMPANY, ICLOCATION, ROUTEHDR and SHIPTO and 1:M to ROUTEDOC. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 221 more and referenced by WH210. The table has 11 fields, 1 index and 7 documented relations.

About ROUTESTOP

The Route Stop file contains records set up to identify the stops along a route.

Fields (11)

Column = COBOL field name without the RTS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#RTS-COMPANY PK
COMPANY		Numeric 4This field contains the company number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RTS-LOCATION PK
LOCATION		Alpha 5This field contains a valid stock location within the company inventory.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RTS-ROUTE PK
ROUTE		Numeric 4This field contains the route number. The route assigned to the ship-to customer defaults from the Order Entry Route file.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RTS-DATE PK
DATE		Numeric 8 (yyyymmdd)This field contains the system date this route was created.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RTS-STOP PK
STOP		Numeric 4This field contains the stop within the route. If left blank, the stop associated with the ship-to customer defaults from the Route file.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RTS-CUSTOMER
CUSTOMER		Alpha 9 (Right Justified)This field contains the number that represents a customer.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RTS-SHIP-TO
SHIP_TO		Numeric 4This field contains the number representing the ship to customer.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RTS-CUBIC-FEET
CUBIC_FEET		Signed 9.3This field contains the unit cubic feet of the item based on the stock unit of measure.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RTS-WEIGHT
WEIGHT		Signed 9.3This field contains the weight of the item based on the stock unit of measure.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RTS-PIECES
PIECES		Signed 13.4This field contains the number of items dropped off at a particular stop along the route.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RTS-DOCUMENTS
DOCUMENTS		Numeric 4This field contains the number of documents assigned to a specific route and stop.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RTSSET1
  1. COMPANY
  2. LOCATION
  3. DATE
  4. ROUTE
  5. STOP
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ARCOMPCUSTDESCICCOMPANYICLOCATIONROUTEHDRSHIPTOROUTEDOCROUTESTOP

One to one (6) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequired
RTS-COMPANY→ACO-COMPANY
CustdescCUSTDESCRequired
ACO-CUST-GROUP→CUD-CUST-GROUP
RTS-CUSTOMER→CUD-CUSTOMER
IccompanyICCOMPANYRequired
RTS-COMPANY→ICC-COMPANY
IclocationICLOCATIONRequired
RTS-COMPANY→ICL-COMPANY
RTS-LOCATION→ICL-LOCATION
RoutehdrROUTEHDRRequired
RTS-COMPANY→RTE-COMPANY
RTS-LOCATION→RTE-LOCATION
RTS-DATE→RTE-DATE
RTS-ROUTE→RTE-ROUTE
ShiptoSHIPTORequired
RTS-COMPANY→SHP-COMPANY
RTS-CUSTOMER→SHP-CUSTOMER
RTS-SHIP-TO→SHP-SHIP-TO

One to many (1) — child tables

RelationTableRulesConditionField map
RoutedocROUTEDOC
RTS-COMPANY→RDC-COMPANY
RTS-LOCATION→RDC-LOCATION
RTS-DATE→RDC-DATE
RTS-ROUTE→RDC-ROUTE
RTS-STOP→RDC-STOP
—→RDC-DOC-NBR

Programs

Updated by (229)

Referenced by (1)