ROUTEHDR FILE
Route Header
For all routes created, a header record is added to the Route Header file.
REFERENCED BY
WH210
UPDATED BY
BL92.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC141 IC142 IC83.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 OE113 OE114
OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4
OE15.5 OE15.7 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE810
OE830 OE90.1 OE90.2 OE920 OE950 PO31.1
RQ10.1 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ20.1
RQ35.1 RQ500 RQ961 WH120 WH130 WH132
WH190 WH20.1 WH20.2 WH20.7 WH21.1 WH21.2
WH21.3 WH21.4 WH222 WH30.1 WH30.2 WH30.3
WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3
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
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 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 BL92.1 CX100
Cubic Feet This field contains the total cubic CX20.1 CX20.2
feet of all items on all orders to CX20.4 CX20.5
delivered along the route. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ20.1
...
RTE-WEIGHT Signed 9.3 BL92.1 CX100
Weight This field contains the total weight of CX20.1 CX20.2
all the items on all the orders that are CX20.4 CX20.5
delivered on this route. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ20.1
...
RTE-PIECES Signed 13.4 BL92.1 CX100
Pieces This field contains the total number of CX20.1 CX20.2
items to deliver along this route. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ20.1
...
RTE-STOPS Numeric 6 BL92.1 CX100
Stops This field contains the number of stops CX20.1 CX20.2
along the route. Each customer ship to CX20.4 CX20.5
or bill to location where orders are CX220 CX30.1
dropped off is considered a stop. Stops CX300 CX506
are defined using OE60.1 (Routes). CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ20.1
...
RTE-DOCUMENTS Numeric 4 BL92.1 CX100
Documents This field contains the number of CX20.1 CX20.2
documents to be delivered on this route. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ20.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 BL92.1 CX100
LOCATION updating the table. CX20.1 CX20.2
DATE CX20.4 CX20.5
ROUTE CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
...
RTESET2 COMPANY KeyChange, Duplicates 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
|