 |
Lawson Insight Technical Documentation |
|
ROUTEHDR FILE
Route Header
For all routes created, a header record is added to the Route Header file.
REFERENCED BY
WH210
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 CXCP.1 DR100 IC141 IC142 IC28.1
IC83.1 MA180 MA43.9 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.3 MA67.1 MA67.2
MA70.1 MAI1.1 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 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ35.1
RQ500 RQIF.1 WH110 WH120 WH130 WH132
WH190 WH20.1 WH20.2 WH20.7 WH21.1 WH21.2
WH21.3 WH21.4 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTE-COMPANY Numeric 4 WH120 WH21.1
Company This field contains the company number. WH21.3 WH21.4
RTE-LOCATION Alpha 5 WH120 WH21.1
Location Code This field contains a valid stock WH21.3 WH21.4
location within the company inventory.
RTE-ROUTE Numeric 4 WH120 WH21.1
Route This field contains the route number. WH21.3 WH21.4
The route assigned to the ship-to
customer defaults from the Route file.
RTE-DATE Numeric 8 (yyyymmdd) WH120 WH21.1
Date This field contains the route's WH21.3 WH21.4
delivery date. This delivery date is
found on the order lines that are to be
delivered on this route. The delivery
date is used by the system when
determining which orders should be
delivered on the day's route. When a
route is built, the user determines
which delivery date is used. Only those
lines with that delivery date are
printed on WH120 (Route Creation) and
the pick list for processing.
RTE-DAY-OF-WEEK Numeric 1 WH120 WH21.3
Day Of Week This field contains the day of the week WH21.4
this route is delivered.
1 = Sunday
2 = Monday
3 = Tuesday
4 = Wednesday
5 = Thursday
6 = Friday
7 = Saturday
RTE-STATUS Numeric 1 WH120 WH21.1
Status This field contains status, which
indicates whether the route is released
and is available for printing on the
pick list. Routes are released on
WH21.1 (Routes).
0 = Edit
1 = Released
RTE-CUBIC-FEET Signed 9.3 AP125 AP126
Cubic Feet This field contains the total cubic AP131 AP25.1
feet of all items on all orders to AP25.2 AP26.1
delivered along the route. AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
RTE-WEIGHT Signed 9.3 AP125 AP126
Unit Weight This field contains the total weight of AP131 AP25.1
all the items on all the orders that are AP25.2 AP26.1
delivered on this route. AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
RTE-PIECES Signed 13.4 AP125 AP126
Pieces This field contains the total number of AP131 AP25.1
items to deliver along this route. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
RTE-STOPS Numeric 6 AP125 AP126
Stops This field contains the number of stops AP131 AP25.1
along the route. Each customer ship to AP25.2 AP26.1
or bill to location where orders are AP27.1 CXCP.1
dropped off is considered a stop. Stops DR100 IC141
are defined using OE60.1 (Routes). IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
RTE-DOCUMENTS Numeric 4 AP125 AP126
Documents This field contains the number of AP131 AP25.1
documents to be delivered on this route. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
RTE-IN-USE Alpha 1 WH130 WH21.3
In Use This field indicates if the route is WH21.4
currently in use.
Y = Yes
N = No
ROUTEHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTESET1 COMPANY Primary index used for accessing and AP125 AP126
LOCATION updating the table. AP131 AP25.1
DATE AP25.2 AP26.1
ROUTE AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
...
RTESET2 COMPANY KeyChange WH130
LOCATION
ROUTE
DATE
ROUTEHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
RTE-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
RTE-COMPANY -> ICL-COMPANY
RTE-LOCATION -> ICL-LOCATION
ROUTEHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Routestop ROUTESTOP
RTE-COMPANY -> RTS-COMPANY
RTE-LOCATION -> RTS-LOCATION
RTE-DATE -> RTS-DATE
RTE-ROUTE -> RTS-ROUTE
RTS-STOP
|