RSF_NM_SRCH_VW

(SQL View)
Index Back

Search BO View

This record is a view used for BO search

SELECT L.SYNCID , L.BO_ID_CUST , L.ROLE_TYPE_ID_CUST , N.BO_NAME , N.BO_NAME_UPPER FROM PS_RSF_LEAD L , PS_BO_NAME N WHERE L.BO_ID_CUST = N.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
2 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
3 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
4 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
5 BO_NAME_UPPER Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object