RTE_CST_INV_VW2 (SQL View)	Index Back
Route Stop Table This record will return the minimum schedule date for a given route.

RTE_CST_INV_VW2

(SQL View)

Route Stop Table

This record will return the minimum schedule date for a given route.

select BUSINESS_UNIT, ROUTE_CD, CARRIER_ID, SHIP_TYPE_ID, min(ROUTE_SCHED_DATE), ROUTE_CAL_CURR_YR, ROUTE_STOP_NBR, SETID, SHIP_TO_CUST_ID, ADDRESS_SEQ_NUM, LOCATION from PS_RTE_CST_INV_VW group by BUSINESS_UNIT, ROUTE_CD, CARRIER_ID, SHIP_TYPE_ID, ROUTE_CAL_CURR_YR, ROUTE_STOP_NBR, SETID, SHIP_TO_CUST_ID, ADDRESS_SEQ_NUM, LOCATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW

2 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.
Prompt Table: ROUTE_INV_VW

3 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

4 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

5 ROUTE_SCHED_DATE Date(10) DATE Date on which a delivery route code can be used to fulfill orders.

6 ROUTE_CAL_CURR_YR Number(4,0) SMALLINT NOT NULL Year for which the route calendar dates are being maintained.

7 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.

8 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

9 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
Prompt Table: INV_CUST_SHP_VW
Set Control Field: SETID

10 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
Prompt Table: INV_CUST_ADR_VW

11 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
Prompt Table: INV_LOCATION_VW
Set Control Field: BUSINESS_UNIT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW
2	ROUTE_CD	Character(6)	VARCHAR2(6) NOT NULL	A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles. Prompt Table: ROUTE_INV_VW
3	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID
4	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
5	ROUTE_SCHED_DATE	Date(10)	DATE	Date on which a delivery route code can be used to fulfill orders.
6	ROUTE_CAL_CURR_YR	Number(4,0)	SMALLINT NOT NULL	Year for which the route calendar dates are being maintained.
7	ROUTE_STOP_NBR	Number(5,0)	INTEGER NOT NULL	An identifier used to sequence customer addresses/location for a given route.
8	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
9	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer Prompt Table: INV_CUST_SHP_VW Set Control Field: SETID
10	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Prompt Table: INV_CUST_ADR_VW
11	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: INV_LOCATION_VW Set Control Field: BUSINESS_UNIT