ROUTESTOP FILE
Route Stop
The Route Stop file contains records set up to identify the stops along a
route.
REFERENCED BY
WH210
UPDATED BY
BL92.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC141 IC142 IC83.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 OE113 OE114
OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4
OE15.5 OE15.7 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE810
OE830 OE90.1 OE90.2 OE920 OE950 PO31.1
RQ10.1 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ20.1
RQ35.1 RQ500 RQ961 WH120 WH130 WH132
WH190 WH20.1 WH20.2 WH20.7 WH21.1 WH21.2
WH21.3 WH21.4 WH222 WH30.1 WH30.2 WH30.3
WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3
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
RTS-COMPANY Numeric 4 BL92.1 CX100
Company This field contains the company number. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ20.1
...
RTS-LOCATION Alpha 5 BL92.1 CX100
Location This field contains a valid stock CX20.1 CX20.2
location within the company inventory. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ20.1
...
RTS-ROUTE Numeric 4 BL92.1 CX100
Route This field contains the route number. CX20.1 CX20.2
The route assigned to the ship-to CX20.4 CX20.5
customer defaults from the Order Entry CX220 CX30.1
Route file. CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ20.1
...
RTS-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Date This field contains the system date CX20.1 CX20.2
this route was created. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ20.1
...
RTS-STOP Numeric 4 BL92.1 CX100
Stop This field contains the stop within the CX20.1 CX20.2
route. If left blank, the stop CX20.4 CX20.5
associated with the ship-to customer CX220 CX30.1
defaults from the Route file. CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ20.1
...
RTS-CUSTOMER Alpha 9 (Right Justified) BL92.1 CX100
Customer This field contains the number that CX20.1 CX20.2
represents a customer. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ20.1
...
RTS-SHIP-TO Numeric 4 BL92.1 CX100
Ship-to This field contains the number CX20.1 CX20.2
representing the ship-to customer. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ20.1
...
RTS-CUBIC-FEET Signed 9.3 BL92.1 CX100
Cubic Feet This field contains the unit cubic feet CX20.1 CX20.2
of the item based on the stock unit of CX20.4 CX20.5
measure. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ20.1
...
RTS-WEIGHT Signed 9.3 BL92.1 CX100
Weight This field contains the weight of the CX20.1 CX20.2
item based on the stock unit of measure. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ20.1
...
RTS-PIECES Signed 13.4 BL92.1 CX100
Pieces This field contains the number of items CX20.1 CX20.2
dropped off at a particular stop along CX20.4 CX20.5
the route. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ20.1
...
RTS-DOCUMENTS Numeric 4 BL92.1 CX100
Documents This field contains the number of CX20.1 CX20.2
documents assigned to a specific route CX20.4 CX20.5
and stop. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ20.1
...
ROUTESTOP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTSSET1 COMPANY Primary index used for accessing and BL92.1 CX100
LOCATION updating the table. CX20.1 CX20.2
DATE CX20.4 CX20.5
ROUTE CX220 CX30.1
STOP CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.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
OE113 OE114
...
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
|