RSF_PARTBOIDVW (SQL View)	Index Back
All Sales Users View A view of all Partner Sales Users

RSF_PARTBOIDVW

(SQL View)

All Sales Users View

A view of all Partner Sales Users

SELECT P.BO_ID , N.BO_NAME , N.BO_NAME , N.BO_NAME_DISPLAY FROM PS_RD_COMPANY P , PS_BO_NAME N WHERE P.BO_ID = N.BO_ID AND N.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID_PARTNER Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID of Partner Company.

2 NAME Character(50) VARCHAR2(50) NOT NULL Name

3 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

4 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID_PARTNER	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID of Partner Company.
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
4	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object