OEROUTE – Order Entry Route

System
OE (OE)
Prefix
ORT
Primary key
COMPANY, LOCATION, DAY-OF-WEEK, ROUTE, STOP
Fields
7
Updated by
0 programs
Referenced by
0 programs

OEROUTE is the Order Entry Route table in Lawson OE (prefix ORT). It is indexed by COMPANY, LOCATION, DAY-OF-WEEK, ROUTE, STOP (ORTSET1); alternate indexes: ORTSET2. It is related 1:1 to ARCOMP, ARCUSTOMER, CUSTDESC, ICLOCATION, OECOMPANY and SHIPTO. The table has 7 fields, 2 indexes and 6 documented relations.

About OEROUTE

The Order Entry Route file contains all user-defined routes that are set up in the Lawson Order Entry system. If a company uses route processing, all orders are picked and shipped for customers in the order each customer appears on the route.

Fields (7)

Column = COBOL field name without the ORT- 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
#ORT-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.—
#ORT-LOCATION PK
LOCATION		Alpha 5This field contains a valid stock location within the company inventory.—
#ORT-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. Routes are set up in OE60.1 (Routes).—
#ORT-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 Order Entry Route file.—
#ORT-DAY-OF-WEEK PK
DAY_OF_WEEK		Numeric 1This field contains the day of the week the route is used.
  • 1 Sunday
  • 2 Monday
  • 3 Tuesday
  • 4 Wednesday
  • 5 Thursday
  • 6 Friday
  • 7 Saturday
—
#ORT-CUSTOMER SET2
CUSTOMER		Alpha 9 (Right Justified)This field contains the number that represents a customer who has a stop on the route.—
#ORT-SHIP-TO SET2
SHIP_TO		Numeric 4This field contains the ship to customer's number that represents a stop along the route.—

Indexes (2)

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
ORTSET1
  1. COMPANY
  2. LOCATION
  3. DAY-OF-WEEK
  4. ROUTE
  5. STOP
PrimaryWH21.3, WH21.4
ORTSET2
  1. COMPANY
  2. LOCATION
  3. CUSTOMER
  4. SHIP-TO
  5. DAY-OF-WEEK
  6. ROUTE
  7. STOP
KeyChangeAP125, 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)
ARCOMPARCUSTOMERCUSTDESCICLOCATIONOECOMPANYSHIPTOOEROUTE

One to one (6) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequired
ORT-COMPANY→ACO-COMPANY
ArcustomerARCUSTOMERRequired
ORT-COMPANY→ACM-COMPANY
ORT-CUSTOMER→ACM-CUSTOMER
CustdescCUSTDESCRequired
ACO-CUST-GROUP→CUD-CUST-GROUP
ORT-CUSTOMER→CUD-CUSTOMER
IclocationICLOCATIONRequired
ORT-COMPANY→ICL-COMPANY
ORT-LOCATION→ICL-LOCATION
OecompanyOECOMPANYRequired
ORT-COMPANY→OEC-COMPANY
ShiptoSHIPTORequiredWhen ORT-SHIP-TO > Zeroes
ORT-COMPANY→SHP-COMPANY
ORT-CUSTOMER→SHP-CUSTOMER
ORT-SHIP-TO→SHP-SHIP-TO

Programs

No Lawson programs are documented as updating or referencing this table.