 |
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
CXCP.1 DR100 IC141 IC142 IC83.1 POIJ.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
RTS-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.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
RTS-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.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
RTS-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 Order Entry RQ11.1 RQ12.1
Route file. 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
RTS-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.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
RTS-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 RQ12.1 RQ13.1
defaults from the Route file. 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
RTS-CUSTOMER Alpha 9 (Right Justified) CXCP.1 DR100
Customer Number This field contains the number that IC141 IC142
represents a customer. IC83.1 POIJ.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
RTS-SHIP-TO Numeric 4 CXCP.1 DR100
Ship-to Code This field contains the number IC141 IC142
representing the ship to customer. IC83.1 POIJ.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
RTS-CUBIC-FEET Signed 9.3 CXCP.1 DR100
Cubic Feet This field contains the unit cubic feet IC141 IC142
of the item based on the stock unit of IC83.1 POIJ.1
measure. 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
RTS-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
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
RTS-PIECES Signed 13.4 CXCP.1 DR100
Pieces This field contains the number of items IC141 IC142
dropped off at a particular stop along IC83.1 POIJ.1
the route. 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
RTS-DOCUMENTS Numeric 4 CXCP.1 DR100
Documents This field contains the number of IC141 IC142
documents assigned to a specific route IC83.1 POIJ.1
and stop. 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
ROUTESTOP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTSSET1 COMPANY Primary index used for accessing and CXCP.1 DR100
LOCATION updating the table. IC141 IC142
DATE IC83.1 POIJ.1
ROUTE RQ12.1 RQ13.1
STOP WH120 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
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
|