|
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 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 API1.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 CXCP.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.7 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA66.3 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 PO100 PO101 PO122 PO131
PO190 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 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 POI3.1 POID.1 POII.1 POIJ.1 RQ10.1
RQ10.2 RQ12.1 RQ13.1 RQ13.2 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
Element: Company This field contains the company number. WH21.3 WH21.4
RTE-LOCATION Alpha 5 WH120 WH21.1
Element: Location This field contains a valid stock WH21.3 WH21.4
location within the company inventory.
RTE-ROUTE Numeric 4 WH120 WH21.1
Element: 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
Element: 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
Element: 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
Element: 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
Element: Cubic Feet This field contains the total cubic AP131 AP20.1
feet of all items on all orders to AP20.2 AP20.3
delivered along the route. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
RTE-WEIGHT Signed 9.3 AP125 AP126
Element: Weight This field contains the total weight of AP131 AP20.1
all the items on all the orders that are AP20.2 AP20.3
delivered on this route. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
RTE-PIECES Signed 13.4 AP125 AP126
Element: Pieces This field contains the total number of AP131 AP20.1
items to deliver along this route. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
RTE-STOPS Numeric 6 AP125 AP126
Element: Stops This field contains the number of stops AP131 AP20.1
along the route. Each customer ship to AP20.2 AP20.3
or bill to location where orders are AP20.4 AP20.5
dropped off is considered a stop. Stops AP20.7 AP21.1
are defined using OE60.1 (Routes). AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
RTE-DOCUMENTS Numeric 4 AP125 AP126
Element: Documents This field contains the number of AP131 AP20.1
documents to be delivered on this route. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
RTE-IN-USE Alpha 1 WH130 WH21.3
Element: All Flag 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 AP125 AP126
LOCATION AP131 AP20.1
DATE AP20.2 AP20.3
ROUTE AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
...
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
|