PL_SHIP_ID_VW (SQL View)	Index Back
Ship ID EST view Creates a list of Estimated Ship IDs in a single Sales Order. Used on PL_SO_HDR to select a valid SHIP ID EST.

PL_SHIP_ID_VW

(SQL View)

Ship ID EST view

Creates a list of Estimated Ship IDs in a single Sales Order. Used on PL_SO_HDR to select a valid SHIP ID EST.

SELECT DISTINCT PROBINST , BUSINESS_UNIT , ORDER_NO , SHIP_ID_EST FROM PS_PL_ORD_SCHEDULE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

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

3 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

4 SHIP_ID_EST Character(10) VARCHAR2(10) NOT NULL Estimated Ship ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
4	SHIP_ID_EST	Character(10)	VARCHAR2(10) NOT NULL	Estimated Ship ID