|
|
OEROUTE FILE
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
OE260 WH21.3 WH21.4 AP125 AP126 AP131
AP25.1 AP25.2 AP26.1 AP27.1 AP30.4 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 CXCP.1
IC28.1 IC83.1 MA180 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA66.3 MA67.1
MA67.2 MA70.1 MA75.1 MA80.1 MAI1.1 OE10.1
OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7
OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110
OE111 OE113 OE114 OE116 OE129 OE13.2
OE13.3 OE13.5 OE13.6 OE14.4 OE30.1 OE30.2
OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9
OE510 OE530 OE81.1 OE810 OE830 OE90.1
OE90.2 PO100 PO101 PO122 PO131 PO20.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO33.1 PO34.1 PO35.1 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
POI3.1 POIE.1 POII.1 POIJ.1 RQ10.1 RQ10.2
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500 RQIF.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 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 WO120 WO132 WO140 WO20.1
WO30.1 WO32.1 WO40.1 WO40.2 WO40.3 WO40.4
WO40.5 WO41.1 WO41.2 WO41.3 WO41.4 WO42.1
WO42.2 WO42.3 WO42.4 WO42.5 WO45.1 WOEX.1
WOSP.1
UPDATED BY
OE60.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ORT-COMPANY Numeric 4 OE60.1
Element: Company 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 Alpha 5 OE60.1
Element: Location Code This field contains a valid stock
location within the company inventory.
ORT-ROUTE Numeric 4 OE60.1
Element: Route 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 Numeric 4 OE60.1
Element: Stop 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 Numeric 1 OE60.1
Element: Day Of Week 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 Alpha 9 (Right Justified) OE60.1
Element: Customer NumbeThis field contains the number that
represents a customer who has a stop on
the route.
ORT-SHIP-TO Numeric 4 OE60.1
Element: Ship-to Code 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 OE260 OE60.1
LOCATION WH21.3 WH21.4
DAY-OF-WEEK
ROUTE
STOP
ORTSET2 COMPANY KeyChange AP125 AP126
LOCATION AP131 AP25.1
CUSTOMER AP25.2 AP26.1
SHIP-TO AP27.1 AP30.4
DAY-OF-WEEK BL120 BL122
ROUTE BL130 BL20.1
STOP BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
OEROUTE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
