 |
Lawson Insight Technical Documentation |
|
ROUTESTOP FILE
Route Stop
The Route Stop file contains records set up to identify the stops along a
route.
REFERENCED BY
WH210
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 CXCP.1 DR100 IC141 IC142 IC28.1
IC83.1 MA180 MA43.9 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.3 MA67.1 MA67.2
MA70.1 MAI1.1 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 RQ10.3 RQ11.1 RQ12.1 RQ13.1 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
RTS-COMPANY Numeric 4 AP125 AP126
Company This field contains the company number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
RTS-LOCATION Alpha 5 AP125 AP126
Location Code This field contains a valid stock AP131 AP25.1
location within the company inventory. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
RTS-ROUTE Numeric 4 AP125 AP126
Route This field contains the route number. AP131 AP25.1
The route assigned to the ship-to AP25.2 AP26.1
customer defaults from the Order Entry AP27.1 CXCP.1
Route file. DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
RTS-DATE Numeric 8 (yyyymmdd) AP125 AP126
Date This field contains the system date AP131 AP25.1
this route was created. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
RTS-STOP Numeric 4 AP125 AP126
Stop This field contains the stop within the AP131 AP25.1
route. If left blank, the stop AP25.2 AP26.1
associated with the ship-to customer AP27.1 CXCP.1
defaults from the Route file. DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
RTS-CUSTOMER Alpha 9 (Right Justified) AP125 AP126
Customer Number This field contains the number that AP131 AP25.1
represents a customer. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
RTS-SHIP-TO Numeric 4 AP125 AP126
Ship-to Code This field contains the number AP131 AP25.1
representing the ship to customer. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
RTS-CUBIC-FEET Signed 9.3 AP125 AP126
Cubic Feet This field contains the unit cubic feet AP131 AP25.1
of the item based on the stock unit of AP25.2 AP26.1
measure. AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
RTS-WEIGHT Signed 9.3 AP125 AP126
Unit Weight This field contains the weight of the AP131 AP25.1
item based on the stock unit of measure. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
RTS-PIECES Signed 13.4 AP125 AP126
Pieces This field contains the number of items AP131 AP25.1
dropped off at a particular stop along AP25.2 AP26.1
the route. AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
RTS-DOCUMENTS Numeric 4 AP125 AP126
Documents This field contains the number of AP131 AP25.1
documents assigned to a specific route AP25.2 AP26.1
and stop. AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
ROUTESTOP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTSSET1 COMPANY Primary index used for accessing and AP125 AP126
LOCATION updating the table. AP131 AP25.1
DATE AP25.2 AP26.1
ROUTE AP27.1 CXCP.1
STOP DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
...
ROUTESTOP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
RTS-COMPANY -> ACO-COMPANY
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
RTS-CUSTOMER -> CUD-CUSTOMER
Iccompany ICCOMPANY Required
RTS-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
RTS-COMPANY -> ICL-COMPANY
RTS-LOCATION -> ICL-LOCATION
Routehdr ROUTEHDR Required
RTS-COMPANY -> RTE-COMPANY
RTS-LOCATION -> RTE-LOCATION
RTS-DATE -> RTE-DATE
RTS-ROUTE -> RTE-ROUTE
Shipto SHIPTO Required
RTS-COMPANY -> SHP-COMPANY
RTS-CUSTOMER -> SHP-CUSTOMER
RTS-SHIP-TO -> SHP-SHIP-TO
ROUTESTOP FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Routedoc ROUTEDOC
RTS-COMPANY -> RDC-COMPANY
RTS-LOCATION -> RDC-LOCATION
RTS-DATE -> RDC-DATE
RTS-ROUTE -> RDC-ROUTE
RTS-STOP -> RDC-STOP
RDC-DOC-NBR
|