Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEROUTE


                              OEROUTE FILE

                           Order Entry Route

The Order Entry Route file contains all user-defined routes that are set up
in the Lawson Order Entry system.  If a company uses route processing, all
orders are picked and shipped for customers in the order each customer appears
on the route.

REFERENCED BY

WH21.3    WH21.4    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    WH120     WH130     WH132
WH190     WH20.1    WH20.2    WH20.7    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

ORT-COMPANY            Numeric 4
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

ORT-LOCATION           Alpha 5
Element: Location      This field contains a valid stock
                       location within the company inventory.

ORT-ROUTE              Numeric 4
Element: Route         This field contains the route number.
                       The route assigned to the ship to
                       customer defaults from the Order Entry
                       Route file.  Routes are set up in OE60.1
                       (Routes).

ORT-STOP               Numeric 4
Element: Stop          This field contains the stop within the
                       route.  If left blank, the stop
                       associated with the ship-to customer
                       defaults from the Order Entry Route
                       file.

ORT-DAY-OF-WEEK        Numeric 1
Element: Day Of Week   This field contains the day of the week
                       the route is used.
                       1 = Sunday
                       2 = Monday
                       3 = Tuesday
                       4 = Wednesday
                       5 = Thursday
                       6 = Friday
                       7 = Saturday

ORT-CUSTOMER           Alpha 9  (Right Justified)
Element: Customer      This field contains the number that
                       represents a customer who has a stop on
                       the route.

ORT-SHIP-TO            Numeric 4
Element: Ship To       This field contains the ship to
                       customer's number that represents a stop
                       along the route.

                         OEROUTE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ORTSET1   COMPANY                                                WH21.3  WH21.4
          LOCATION
          DAY-OF-WEEK
          ROUTE
          STOP

ORTSET2   COMPANY       KeyChange                                AP125   AP126
          LOCATION                                               AP131   AP20.1
          CUSTOMER                                               AP20.2  AP20.3
          SHIP-TO                                                AP20.4  AP20.5
          DAY-OF-WEEK                                            AP20.7  AP21.1
          ROUTE                                                  AP23.1  AP25.1
          STOP                                                   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
                                                                 ...

                         OEROUTE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            ORT-COMPANY       -> ACO-COMPANY

Arcustomer     ARCUSTOMER   Required

                            ORT-COMPANY       -> ACM-COMPANY
                            ORT-CUSTOMER      -> ACM-CUSTOMER

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP    -> CUD-CUST-GROUP
                            ORT-CUSTOMER      -> CUD-CUSTOMER

Iclocation     ICLOCATION   Required

                            ORT-COMPANY       -> ICL-COMPANY
                            ORT-LOCATION      -> ICL-LOCATION

Oecompany      OECOMPANY    Required

                            ORT-COMPANY       -> OEC-COMPANY

Shipto         SHIPTO       Required
                            When ORT-SHIP-TO > Zeroes

                            ORT-COMPANY       -> SHP-COMPANY
                            ORT-CUSTOMER      -> SHP-CUSTOMER
                            ORT-SHIP-TO       -> SHP-SHIP-TO