ROUTEHDR

Route Header

For all routes created, a header record is added to the Route Header file.
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 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTE-COMPANY
Element: Company
Numeric 4
This field contains the company number.
RTE-LOCATION
Element: Location
Alpha 5
This field contains a valid stock location within the company inventory.
RTE-ROUTE
Element: Route
Numeric 4
This field contains the route number. The route assigned to the ship-to customer defaults from the Route file.
RTE-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field contains the route's 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
Element: Day Of Week
Numeric 1
This field contains the day of the week this route is delivered.
1 = Sunday
2 = Monday
3 = Tuesday
4 = Wednesday
5 = Thursday
6 = Friday
7 = Saturday
RTE-STATUS
Element: Status
Numeric 1
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
Element: Cubic Feet
Signed 9.3
This field contains the total cubic feet of all items on all orders to delivered along the route.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
RTE-WEIGHT
Element: Weight
Signed 9.3
This field contains the total weight of all the items on all the orders that are delivered on this route.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
RTE-PIECES
Element: Pieces
Signed 13.4
This field contains the total number of items to deliver along this route.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
RTE-STOPS
Element: Stops
Numeric 6
This field contains the number of stops along the route. Each customer ship to or bill to location where orders are dropped off is considered a stop. Stops are defined using OE60.1 (Routes).
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
RTE-DOCUMENTS
Element: Documents
Numeric 4
This field contains the number of documents to be delivered on this route.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
RTE-IN-USE
Element: All Flag
Alpha 1
This field indicates if the route is currently in use.
Y = Yes
N = No


ROUTEHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTESET1 COMPANY
LOCATION
DATE
ROUTE
...
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
RTESET2 COMPANY
LOCATION
ROUTE
DATE
KeyChange


ROUTEHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
RTE-COMPANY->ICC-COMPANY (ICCSET1)
Iclocation ICLOCATION Required
RTE-COMPANY->ICL-COMPANY
RTE-LOCATION->ICL-LOCATION


ROUTEHDR FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Wed Jun 08 20:51:50 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.