Lawson Insight Technical Documentation |
|
ROUTEDOC
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
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 CXCP.1 IC28.1
IC83.1 MA180 MA41.2 MA41.7 MA43.1 MA43.2
MA43.3 MA43.9 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 MA67.1 MA67.2
MA70.1 MA75.1 MA80.1 MAI1.1 PO100 PO101
PO122 PO131 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.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 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 POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3
RQ11.1 RQ12.1 RQ13.1 RQ35.1 RQ500 RQIE.1
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 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 AP125 AP126
Element: Company This field contains the company number. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 IC28.1
IC83.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
...
RDC-LOCATION Alpha 5 AP125 AP126
Element: Location Code This field contains a valid stock AP131 AP20.1
location within the company inventory. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 IC28.1
IC83.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
...
RDC-ROUTE Numeric 4 AP125 AP126
Element: Route This field contains the route number. AP131 AP20.1
The route assigned to the ship-to AP20.2 AP20.3
customer defaults from the Route file. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 IC28.1
IC83.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
...
RDC-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field contains the system date AP131 AP20.1
this route was created. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 IC28.1
IC83.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
...
RDC-STOP Numeric 4 AP125 AP126
Element: Stop This field contains the stop within the AP131 AP20.1
route. If left blank, the stop AP20.2 AP20.3
associated with the ship-to customer AP20.4 AP20.5
defaults from the Route file. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 IC28.1
IC83.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
...
RDC-SYSTEM-CD Alpha 2
Element: System Code This field indicates on which Lawson
system the document originated.
OE = Customer Order
RQ = Requisition
RDC-DOC-NBR Alpha 10 (Right Justified) AP125 AP126
Element: Doc Nbr This field contains the document number AP131 AP20.1
containing the route. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 IC28.1
IC83.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
...
RDC-CUBIC-FEET Signed 9.3 AP125 AP126
Element: Cubic Feet This field contains the cubic feet of AP131 AP20.1
the item based on the stock unit of AP20.2 AP20.3
measure. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 IC28.1
IC83.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
...
RDC-WEIGHT Signed 9.3 AP125 AP126
Element: Unit Weight This field contains the weight of the AP131 AP20.1
item based on the stock unit of measure. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 IC28.1
IC83.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
...
RDC-PIECES Signed 13.4 AP125 AP126
Element: Pieces This field contains the total number of AP131 AP20.1
pieces to deliver for this route. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 IC28.1
IC83.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
...
ROUTEDOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RDCSET1 COMPANY Primary index used for accessing and AP125 AP126
LOCATION updating the table. AP131 AP20.1
DATE AP20.2 AP20.3
ROUTE AP20.4 AP20.5
STOP AP20.7 AP23.1
DOC-NBR AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 IC28.1
IC83.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
...
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
|