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
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
RDC-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
...
RDC-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
...
RDC-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 Route file. 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
...
RDC-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
...
RDC-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
...
RDC-SYSTEM-CD Alpha 2
System Code This field indicates on which Lawson
system the document originated.
OE = Customer Order
RQ = Requisition
RDC-DOC-NBR Alpha 10 (Right Justified) BL92.1 CX100
Document Number This field contains the document number CX20.1 CX20.2
containing the route. 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
...
RDC-CUBIC-FEET Signed 9.3 BL92.1 CX100
Cubic Feet This field contains the cubic feet of CX20.1 CX20.2
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
...
RDC-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
...
RDC-PIECES Signed 13.4 BL92.1 CX100
Pieces This field contains the total number of CX20.1 CX20.2
pieces to deliver for this route. 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
...
ROUTEDOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RDCSET1 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
DOC-NBR 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
...
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
|