Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    AP30.4    API1.1    CXCP.1    IC28.1
IC83.1    MA180     MA41.2    MA41.7    MA43.1    MA43.2
MA43.3    MA43.9    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    PO100     PO101
PO122     PO131     PO20.1    PO21.1    PO21.2    PO21.3
PO21.4    PO21.5    PO22.1    PO23.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    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    POII.1    POIJ.1    RQ10.1    RQ10.2    RQ10.3
RQ11.1    RQ12.1    RQ13.1    RQ35.1    RQ500     RQIE.1
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   AP20.1
                       feet of all items on all orders to        AP20.2  AP20.3
                       delivered along the route.                AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 CXCP.1  IC28.1
                                                                 IC83.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO25.1  PO25.5
                                                                 PO25.6  PO25.7
                                                                 PO27.2  PO29.1
                                                                 PO30.1  PO30.2
                                                                 ...

RTE-WEIGHT             Signed 9.3                                AP125   AP126
Element: Unit 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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 CXCP.1  IC28.1
                                                                 IC83.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO25.1  PO25.5
                                                                 PO25.6  PO25.7
                                                                 PO27.2  PO29.1
                                                                 PO30.1  PO30.2
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 CXCP.1  IC28.1
                                                                 IC83.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO25.1  PO25.5
                                                                 PO25.6  PO25.7
                                                                 PO27.2  PO29.1
                                                                 PO30.1  PO30.2
                                                                 ...

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  AP23.1
                       are defined using OE60.1 (Routes).        AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 CXCP.1  IC28.1
                                                                 IC83.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO25.1  PO25.5
                                                                 PO25.6  PO25.7
                                                                 PO27.2  PO29.1
                                                                 PO30.1  PO30.2
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 CXCP.1  IC28.1
                                                                 IC83.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO25.1  PO25.5
                                                                 PO25.6  PO25.7
                                                                 PO27.2  PO29.1
                                                                 PO30.1  PO30.2
                                                                 ...

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   AP20.1
          DATE                                                   AP20.2  AP20.3
          ROUTE                                                  AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 CXCP.1  IC28.1
                                                                 IC83.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 ...

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