IN_FW_RTE_1_VW (SQL View)	Index Back
Route Code View Defines the route codes that have been assigned to unfulfilled demand lines. Used as prompt table for routes when there could be a business unit range.

IN_FW_RTE_1_VW

(SQL View)

Route Code View

Defines the route codes that have been assigned to unfulfilled demand lines. Used as prompt table for routes when there could be a business unit range.

SELECT DISTINCT a.business_unit , a.route_cd , a.descr FROM PS_ROUTE_INV a WHERE a.route_cd <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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.

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
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.
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description