Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ROUTEDOC


                             ROUTEDOC FILE

                             Route Document

The Route Document file contains documents that are to be delivered along a
route, referencing which route they are to be delivered along and which stop
the document is dropped off at.

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

RDC-COMPANY            Numeric 4                                 AP125   AP126
Element: Company       This field contains the company number.   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
                                                                 ...

RDC-LOCATION           Alpha 5                                   AP125   AP126
Element: Location      This field contains a valid stock         AP131   AP20.1
                       location within the company inventory.    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
                                                                 ...

RDC-ROUTE              Numeric 4                                 AP125   AP126
Element: Route         This field contains the route number.     AP131   AP20.1
                       The route assigned to the ship-to         AP20.2  AP20.3
                       customer defaults from the Route file.    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
                                                                 ...

RDC-DATE               Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Date          This field contains the system date       AP131   AP20.1
                       this route was created.                   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
                                                                 ...

RDC-STOP               Numeric 4                                 AP125   AP126
Element: Stop          This field contains the stop within the   AP131   AP20.1
                       route.  If left blank, the stop           AP20.2  AP20.3
                       associated with the ship-to customer      AP20.4  AP20.5
                       defaults from the Route file.             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
                                                                 ...

RDC-SYSTEM-CD          Alpha 2
Element: System Cd     This field indicates on which Lawson
                       system the document originated.
                       OE = Customer Order
                       RQ = Requisition

RDC-DOC-NBR            Alpha 10  (Right Justified)               AP125   AP126
Element: Doc Nbr       This field contains the document number   AP131   AP20.1
                       containing the 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
                                                                 ...

RDC-CUBIC-FEET         Signed 9.3                                AP125   AP126
Element: Cubic Feet    This field contains the cubic feet of     AP131   AP20.1
                       the item based on the stock unit of       AP20.2  AP20.3
                       measure.                                  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
                                                                 ...

RDC-WEIGHT             Signed 9.3                                AP125   AP126
Element: Weight        This field contains the weight of the     AP131   AP20.1
                       item based on the stock unit of measure.  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
                                                                 ...

RDC-PIECES             Signed 13.4                               AP125   AP126
Element: Pieces        This field contains the total number of   AP131   AP20.1
                       pieces to deliver for 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
                                                                 ...

                         ROUTEDOC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RDCSET1   COMPANY                                                AP125   AP126
          LOCATION                                               AP131   AP20.1
          DATE                                                   AP20.2  AP20.3
          ROUTE                                                  AP20.4  AP20.5
          STOP                                                   AP20.7  AP21.1
          DOC-NBR                                                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
                                                                 ...

                         ROUTEDOC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            RDC-COMPANY      -> ICC-COMPANY

Iclocation     ICLOCATION   Required

                            RDC-COMPANY      -> ICL-COMPANY
                            RDC-LOCATION     -> ICL-LOCATION

Routehdr       ROUTEHDR     Required

                            RDC-COMPANY      -> RTE-COMPANY
                            RDC-LOCATION     -> RTE-LOCATION
                            RDC-DATE         -> RTE-DATE
                            RDC-ROUTE        -> RTE-ROUTE

Routestop      ROUTESTOP    Required

                            RDC-COMPANY      -> RTS-COMPANY
                            RDC-LOCATION     -> RTS-LOCATION
                            RDC-DATE         -> RTS-DATE
                            RDC-ROUTE        -> RTS-ROUTE
                            RDC-STOP         -> RTS-STOP

Whdemndhdr     WHDEMNDHDR   Required

                            RDC-COMPANY      -> WDH-COMPANY
                            RDC-SYSTEM-CD    -> WDH-SYSTEM-CD
                            RDC-DOC-NBR      -> WDH-DOC-NBR