ROUTE_INV_VW2 (SQL View)	Index Back
Route Customer View This view will return all the effective routes and their associated Ship Tos or Locations.

ROUTE_INV_VW2

(SQL View)

Route Customer View

This view will return all the effective routes and their associated Ship Tos or Locations.

select distinct A.BUSINESS_UNIT, A.ROUTE_CD, A.CARRIER_ID, A.SHIP_TYPE_ID, B.ROUTE_SCHED_DATE from PS_ROUTE_INV A, PS_ROUTE_CAL_INV B where A.BUSINESS_UNIT = B.BUSINESS_UNIT and A.ROUTE_CD = B.ROUTE_CD and B.ROUTE_CLOSED_FLG = 'N' and B.ROUTE_SCHED_DATE >= %currentdatein

# 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.

#	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.