RO_CONTACTS_VW (SQL View)	Index Back
Order Capture Contacts View Order Capture Contacts View for bulk service management

RO_CONTACTS_VW

(SQL View)

Order Capture Contacts View

Order Capture Contacts View for bulk service management

SELECT A.BO_ID , A.BO_ID_CONTACT ,C.NAME FROM PS_BO_CNTCT_BC_VW A , PS_BO_NAME C WHERE A.BO_ID_CONTACT = C.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
2	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
3	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.