SHIP_PRMPT15_VW (SQL View)	Index Back
Ship Prpt9 - Route/Add mode Determines the route codes assigned to a pick confirmed order line. Used as a prompt table for route code on the Shipping/Issues Selection Criteria - Add Mode. 04/06/04 mmt Data model changes

SHIP_PRMPT15_VW

(SQL View)

Ship Prpt9 - Route/Add mode

Determines the route codes assigned to a pick confirmed order line. Used as a prompt table for route code on the Shipping/Issues Selection Criteria - Add Mode. 04/06/04 mmt Data model changes

SELECT DISTINCT a.business_unit , a.route_cd , b.descr FROM PS_IN_DEMAND a , ps_route_inv b WHERE a.in_fulfill_state >='50' AND a.in_fulfill_state < '90' AND a.route_cd <> ' ' AND a.business_unit = b.business_unit AND a.route_cd = b.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