RSF_OPP_PTNR_VW

(SQL View)
 Index Back

Opportunity Partner table

Keeps track of the Partner based on opportunity.

SELECT OPPORTUNITY_ID , BO_ID_CUST , CONTACT_ID , PRODUCT_ID , DESCR100 , BO_ID_CONTACT , PARTNER_ROLE_ID , PARTNER_TYPE_ID , PARTNER_RATE_ID , PARTNER_STATUS_ID FROM PS_RSF_OPP_PARTNER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
2 BO_ID_PARTNER Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID of Partner Company.
3 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

Prompt Table: RSF_PARNTCONTVW

4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: RSF_OPP_C_PRD_V

5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
6 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
7 PARTNER_ROLE_ID Character(15) VARCHAR2(15) NOT NULL Partner Role ID

Prompt Table: RSF_P_ROLE_A_VW

8 PARTNER_TYPE_ID Character(15) VARCHAR2(15) NOT NULL Partner Type ID

Prompt Table: RSF_P_TYPE_A_VW

9 PARTNER_RATE_ID Character(15) VARCHAR2(15) NOT NULL Partner Rate ID

Prompt Table: RSF_P_RATE_A_VW

10 PARTNER_STATUS_ID Character(15) VARCHAR2(15) NOT NULL Partner Status ID

Prompt Table: RSF_P_STAT_A_VW