 |
Lawson Insight Technical Documentation |
|
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
CXCP.1 DR100 IC141 IC142 IC83.1 POIJ.1
RQ11.1 RQ12.1 RQ13.1 WH120 WH130 WH21.1
WH21.2 WH21.3 WH21.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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RDC-COMPANY Numeric 4 CXCP.1 DR100
Company This field contains the company number. IC141 IC142
IC83.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH120
WH130 WH21.3
WH21.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
RDC-LOCATION Alpha 5 CXCP.1 DR100
Location Code This field contains a valid stock IC141 IC142
location within the company inventory. IC83.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH120
WH130 WH21.3
WH21.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
RDC-ROUTE Numeric 4 CXCP.1 DR100
Route This field contains the route number. IC141 IC142
The route assigned to the ship-to IC83.1 POIJ.1
customer defaults from the Route file. RQ11.1 RQ12.1
RQ13.1 WH120
WH130 WH21.3
WH21.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
RDC-DATE Numeric 8 (yyyymmdd) CXCP.1 DR100
Date This field contains the system date IC141 IC142
this route was created. IC83.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH120
WH130 WH21.3
WH21.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
RDC-STOP Numeric 4 CXCP.1 DR100
Stop This field contains the stop within the IC141 IC142
route. If left blank, the stop IC83.1 POIJ.1
associated with the ship-to customer RQ11.1 RQ12.1
defaults from the Route file. RQ13.1 WH120
WH130 WH21.3
WH21.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
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) CXCP.1 DR100
Doc Nbr This field contains the document number IC141 IC142
containing the route. IC83.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH120
WH130 WH21.3
WH21.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
RDC-CUBIC-FEET Signed 9.3 CXCP.1 DR100
Cubic Feet This field contains the cubic feet of IC141 IC142
the item based on the stock unit of IC83.1 POIJ.1
measure. RQ11.1 RQ12.1
RQ13.1 WH120
WH130 WH21.2
WH21.3 WH21.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
RDC-WEIGHT Signed 9.3 CXCP.1 DR100
Unit Weight This field contains the weight of the IC141 IC142
item based on the stock unit of measure. IC83.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH120
WH130 WH21.2
WH21.3 WH21.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
RDC-PIECES Signed 13.4 CXCP.1 DR100
Pieces This field contains the total number of IC141 IC142
pieces to deliver for this route. IC83.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH120
WH130 WH21.2
WH21.3 WH21.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
ROUTEDOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RDCSET1 COMPANY Primary index used for accessing and CXCP.1 DR100
LOCATION updating the table. IC141 IC142
DATE IC83.1 POIJ.1
ROUTE RQ11.1 RQ12.1
STOP RQ13.1 WH120
DOC-NBR WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
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
|