RSF_OPP_REV_VW (SQL View)	Index Back
Opportunity Revenue View View used for retrieving opportunity revenue.

RSF_OPP_REV_VW

(SQL View)

Opportunity Revenue View

View used for retrieving opportunity revenue.

SELECT DISTINCT CURRENCY_CD , BO_ID_CUST , BO_ID_SITE , BO_ID_PARTNER , ROW_ADDED_DTTM FROM PS_RSF_OPPORTUNITY WHERE OPPORTUNITY_STATUS = '2'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

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

3 BO_ID_SITE Number(31,0) DECIMAL(31) NOT NULL Business Object ID

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

5 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
2	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
3	BO_ID_SITE	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
4	BO_ID_PARTNER	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID of Partner Company.
5	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.