ROUTE_INV_FULVW (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.

ROUTE_INV_FULVW

(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.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 SL_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit selection field

2 TO_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit selection field

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

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

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