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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ORT-COMPANY PKCOMPANY | Numeric 4 | Identifies 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 PKLOCATION | Alpha 5 | This field contains a valid stock location within the company inventory. | — |
ORT-ROUTE PKROUTE | Numeric 4 | This 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 PKSTOP | Numeric 4 | This 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 PKDAY_OF_WEEK | Numeric 1 | This field contains the day of the week the route is used.
| — |
ORT-CUSTOMERCUSTOMER | Alpha 9 (Right Justified) | This field contains the number that represents a customer who has a stop on the route. | — |
ORT-SHIP-TOSHIP_TO | Numeric 4 | This field contains the ship to customer's number that represents a stop along the route. | — |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ORTSET1 | COMPANY, LOCATION, DAY-OF-WEEK, ROUTE, STOP | Primary | WH21.3, WH21.4 | |
ORTSET2 | COMPANY, LOCATION, CUSTOMER, SHIP-TO, DAY-OF-WEEK, ROUTE, STOP | KeyChange | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source) |
Relations
One to one (6) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Arcomp | ARCOMP | Required | ORT-COMPANY → ACO-COMPANY | |
| Arcustomer | ARCUSTOMER | Required | ORT-COMPANY → ACM-COMPANY, ORT-CUSTOMER → ACM-CUSTOMER | |
| Custdesc | CUSTDESC | Required | ACO-CUST-GROUP → CUD-CUST-GROUP, ORT-CUSTOMER → CUD-CUSTOMER | |
| Iclocation | ICLOCATION | Required | ORT-COMPANY → ICL-COMPANY, ORT-LOCATION → ICL-LOCATION | |
| Oecompany | OECOMPANY | Required | ORT-COMPANY → OEC-COMPANY | |
| Shipto | SHIPTO | Required | When 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.