RSF_OPP_PORT_VW

(SQL View)
 Index Back

Opportunity Header

This is the Opportunity Header table. This table contains one row per opportunity and holds all the key information for this opportunity.

SELECT OPPORTUNITY_ID , OPPORTUNITY_NAME , OPPORTUNITY_STATUS , BUSINESS_UNIT , CUST_SETID , BO_ID_CUST , NAME1 , PERSON_ID , SALES_USER_NAME , CONTACT_ID , NAME , PHONE , ROLE_TYPE_ID_CUST , BO_ID_CONTACT , ROW_ADDED_DTTM FROM PS_RSF_OPPORTUNITY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID

Default Value: NEXT

2 OPPORTUNITY_NAME Character(50) VARCHAR2(50) NOT NULL Opportunity Name - User Enters this field in Mixed Case.
3 OPPORTUNITY_STATUS Character(1) VARCHAR2(1) NOT NULL Opportunity Status. The values are XLat Values
0=Open
1=Closed - Lost
2=Closed - Won
3=Inactive

Default Value: 0

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: SFA01

Prompt Table: SP_BU_RSF_NONVW

5 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
6 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

Prompt Table: RSF_BC_CUST_VW

7 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
8 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: RD_PERSON

9 SALES_USER_NAME Character(50) VARCHAR2(50) NOT NULL Sales User Name field
10 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
11 NAME Character(50) VARCHAR2(50) NOT NULL Name
12 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.
13 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
14 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
15 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.