OEROUTE

Order Entry Route

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.

REFERENCED BY
WH21.3 WH21.4 AP125 AP126 AP131 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.4
AP510 API1.1 API2.1 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CXCP.1 DR100 IC12.1 IC140 IC141 IC142
IC145 IC243 IC330 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC66.1 IC83.1 MA180 MA278 MA41.1 MA41.2
MA41.4 MA41.7 MA42.2 MA43.2 MA43.7 MA44.1
MA44.2 MA53.1 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PD570 PO04.1 PO04.2 PO10.1 PO10.2 PO100
PO101 PO115 PO120 PO122 PO131 PO132
PO136 PO15.1 PO15.2 PO15.4 PO150 PO17.1
PO190 PO20.1 PO20.6 PO20.9 PO204 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO220 PO222 PO224 PO225 PO229
PO23.1 PO230 PO234 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO251 PO26.3 PO26.7 PO26.9
PO27.2 PO27.3 PO27.4 PO275 PO276 PO277
PO28.2 PO280 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 PO54.5 POCP.1 POI3.1 POID.1 POII.1
POIJ.1 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4
RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1 RQII.1
RQIJ.1 WH120 WH130 WH132 WH190 WH20.1
WH20.2 WH20.7 WH222 WH25.1 WH25.2 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ORT-COMPANY
Element: Company
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
Element: Location
Alpha 5
This field contains a valid stock location within the company inventory.
ORT-ROUTE
Element: Route
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
Element: Stop
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
Element: Day Of Week
Numeric 1
This 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
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer who has a stop on the route.
ORT-SHIP-TO
Element: Ship To
Numeric 4
This field contains the ship to customer's number that represents a stop along the route.


OEROUTE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ORTSET1 COMPANY
LOCATION
DAY-OF-WEEK
ROUTE
STOP
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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100


OEROUTE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 02:24:30 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.