 |
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
CXCP.1 DR100 IC141 IC142 IC83.1 POIJ.1
RQ11.1 RQ12.1 RQ13.1 WH120 WH130 WH21.1
WH21.2 WH21.3 WH21.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
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 CXCP.1 DR100
Cubic Feet This field contains the total cubic IC141 IC142
feet of all items on all orders to IC83.1 POIJ.1
delivered along the route. RQ11.1 RQ12.1
RQ13.1 WH120
WH130 WH21.3
WH21.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
RTE-WEIGHT Signed 9.3 CXCP.1 DR100
Unit Weight This field contains the total weight of IC141 IC142
all the items on all the orders that are IC83.1 POIJ.1
delivered on this route. RQ11.1 RQ12.1
RQ13.1 WH120
WH130 WH21.3
WH21.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
RTE-PIECES Signed 13.4 CXCP.1 DR100
Pieces This field contains the total number of IC141 IC142
items to deliver along this route. IC83.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH120
WH130 WH21.3
WH21.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
RTE-STOPS Numeric 6 CXCP.1 DR100
Stops This field contains the number of stops IC141 IC142
along the route. Each customer ship to IC83.1 POIJ.1
or bill to location where orders are RQ11.1 RQ12.1
dropped off is considered a stop. Stops RQ13.1 WH120
are defined using OE60.1 (Routes). WH130 WH21.1
WH21.3 WH21.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
RTE-DOCUMENTS Numeric 4 CXCP.1 DR100
Documents This field contains the number of IC141 IC142
documents to be delivered on this route. IC83.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH120
WH130 WH21.3
WH21.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
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 CXCP.1 DR100
LOCATION updating the table. IC141 IC142
DATE IC83.1 POIJ.1
ROUTE RQ11.1 RQ12.1
RQ13.1 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
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
|