RSF_FCAST_SU_VW (SQL View)	Index Back
Forecast Sales Users Used to display the name of the Sales User on a forecast.

RSF_FCAST_SU_VW

(SQL View)

Forecast Sales Users

Used to display the name of the Sales User on a forecast.

SELECT A.PERSON_ID , %Substring(B.BO_NAME_DISPLAY ,1 ,50) FROM PS_RD_PERSON A , PS_BO_NAME B WHERE A.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

2 SALES_USER_NAME Character(50) VARCHAR2(50) NOT NULL Sales User Name field

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
2	SALES_USER_NAME	Character(50)	VARCHAR2(50) NOT NULL	Sales User Name field