RB_CONT_CLD_VW (SQL View)	Index Back
Contact List Account Children

RB_CONT_CLD_VW

(SQL View)

Contact List Account Children

SELECT DISTINCT A.PERSON_ID_OWNER , F.CUST_ID_PARENT , F.CUST_ID , B.BO_NAME , R.SYNCID FROM PS_RB_CONT_ACCT_VW A , PS_RB_CUST_FLAT F , PS_BO_REL R , PS_BO B WHERE A.CUST_ID = F.CUST_ID_PARENT AND F.BO_ID = R.BO_ID_2 AND R.BO_ID_1 = B.BO_ID AND R.REL_TYPE_ID IN (9, 10)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

2 CUST_ID_PARENT Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID

4 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.

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_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
2	CUST_ID_PARENT	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
4	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.
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.