Lawson Insight Technical Documentation |
|
ROUTEHDR
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 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 CXCP.1 IC28.1 IC83.1 MA180
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.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 OE111 OE113 OE114
OE116 OE129 OE13.2 OE13.3 OE13.5 OE13.6
OE14.4 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE510 OE530 OE81.1
OE810 OE830 OE90.1 OE90.2 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 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 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
Element: Company This field contains the company number. WH21.3 WH21.4
RTE-LOCATION Alpha 5 WH120 WH21.1
Element: Location Code 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 AP25.1
feet of all items on all orders to AP25.2 AP26.1
delivered along the route. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
...
RTE-WEIGHT Signed 9.3 AP125 AP126
Element: 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 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
...
RTE-PIECES Signed 13.4 AP125 AP126
Element: Pieces This field contains the total number of AP131 AP25.1
items to deliver along this route. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
...
RTE-STOPS Numeric 6 AP125 AP126
Element: 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 AP30.4
dropped off is considered a stop. Stops BL120 BL122
are defined using OE60.1 (Routes). BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
...
RTE-DOCUMENTS Numeric 4 AP125 AP126
Element: Documents This field contains the number of AP131 AP25.1
documents to be delivered on this route. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
...
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 Primary index used for accessing and AP125 AP126
LOCATION updating the table. AP131 AP25.1
DATE AP25.2 AP26.1
ROUTE AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.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
|