RB_CUST_CNTS_VW (SQL View)	Index Back
Customer Contacts Person ID, bo_id of custome and contact for all contacts

RB_CUST_CNTS_VW

(SQL View)

Customer Contacts

Person ID, bo_id of custome and contact for all contacts

SELECT B.PERSON_ID , B.BO_ID , R.BO_ID_2 , PERS.BO_NAME , B.SYNCID FROM PS_BO_REL R , PS_RD_PERSON B , PS_BO PERS WHERE R.REL_TYPE_ID BETWEEN 9 AND 14 AND R.ROLE_TYPE_ID_2 IN ( 2 , 9) AND R.BO_ID_1 = B.BO_ID AND R.START_DT <= %CurrentDateIn AND R.END_DT > %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

3 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

4 BO_NAME_CONTACT Character(50) VARCHAR2(50) NOT NULL BO_NAME_CONTACT

5 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID_CONT	Character(15)	VARCHAR2(15) NOT NULL	Person ID
2	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
3	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
4	BO_NAME_CONTACT	Character(50)	VARCHAR2(50) NOT NULL	BO_NAME_CONTACT
5	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.