RSF_OPP_PPLN_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 A.OPPORTUNITY_ID , A.OPPORTUNITY_NAME , A.OPPORTUNITY_STATUS , A.PERSON_ID , A.TEAM_ID , A.TEAM_DESCR , A.CUST_SETID , A.BUSINESS_UNIT , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , A.NAME1 , A.REGIONDESCR , A.TERRITORYDESCR , A.COUNTRY , A.SALES_USER_NAME , A.CONTACT_ID , A.BO_ID_CONTACT , A.PHONE_TYPE , A.PHONE , A.NAME , A.SALES_MODEL , A.SALES_STAGE , A.SEQNUM , A.SEQ_NUM , A.SALES_TASK , A.INDUSTRY_ID , A.EST_REVENUE , A.ACT_REVENUE , A.CURRENCY_CD , A.CONFIDENCE_PCT , A.STAGE_PCT_CLOSE , A.ACT_CLOSE_DT , A.EST_CLOSE_DT , A.FORECAST , A.LEAD_SOURCE_ID , A.LEAD_ID , A.NEXT_ACTIVITY_DT , A.PRODUCT_GROUP , A.PRODUCT_ID , B.PERSON_ID , B.PCT_ALLOC , B.SHADOW_PCT , B.SHADOW_AMT , A.FORECAST_TOTAL , A.ROW_ADDED_DTTM FROM PS_RSF_OPPORTUNITY A , PS_RSF_OPP_SLSREP B WHERE A.OPPORTUNITY_ID = B.OPPORTUNITY_ID

# 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 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: RD_PERSON

5 TEAM_ID Character(15) VARCHAR2(15) NOT NULL Sales Team ID

Prompt Table: RSF_TEAM

6 TEAM_DESCR Character(30) VARCHAR2(30) NOT NULL Sales Team
7 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer Setid
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: SFA01

Prompt Table: SP_BU_RSF_NONVW

9 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

10 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
11 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
12 REGIONDESCR Character(30) VARCHAR2(30) NOT NULL Description
13 TERRITORYDESCR Character(30) VARCHAR2(30) NOT NULL Description
14 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
15 SALES_USER_NAME Character(50) VARCHAR2(50) NOT NULL Sales User Name field
16 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
17 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
18 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL phone type field to store value of phone type.
BUSN=Business Phone
CAMP=Campus
CELL=Cellular Phone
DFLT=Default
DORM=Dormitory
FAX=FAX
HOME=Home Phone
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work

Default Value: BUSN

19 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.
20 NAME Character(50) VARCHAR2(50) NOT NULL Name
21 SALES_MODEL Character(18) VARCHAR2(18) NOT NULL Sales Model Id

Default Value: PSFT

Prompt Table: RSF_SALES_MODEL

22 SALES_STAGE Character(24) VARCHAR2(24) NOT NULL Sales Stage Identifier

Prompt Table: RSF_SALES_STG_V

23 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
24 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
25 SALES_TASK Character(24) VARCHAR2(24) NOT NULL Sales Stage Task Identifier

Prompt Table: RSF_SALES_TASK

26 INDUSTRY_ID Character(30) VARCHAR2(30) NOT NULL Industry ID.
27 EST_REVENUE Signed Number(28,3) DECIMAL(26,3) NOT NULL The expected revenue (amount) associated with an Opportunity. This is particularly used for forecasting.
28 ACT_REVENUE Number(27,3) DECIMAL(26,3) NOT NULL Actual Revenue
29 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

Default Value: USD

Prompt Table: CURRENCY_CD_TBL

30 CONFIDENCE_PCT Number(3,0) SMALLINT NOT NULL Confidence Percentage
31 STAGE_PCT_CLOSE Number(3,0) SMALLINT NOT NULL To indicate a % of how much a stage is completed
32 ACT_CLOSE_DT Date(10) DATE Actual Close Date of an Opportunity
33 EST_CLOSE_DT Date(10) DATE Estimated Close Date of an Opportunity
34 FORECAST Character(1) VARCHAR2(1) NOT NULL Include in Cash Forecast
N=Not Forecasted
Y=Forecasted
35 LEAD_SOURCE_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation to identify the source of a Sales Lead.

Prompt Table: RSF_LE_SRC_TBL

36 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
37 NEXT_ACTIVITY_DT Date(10) DATE Next Activity Date
38 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group
39 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
40 PERSON_ID2 Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
41 PCT_ALLOC Number(3,0) SMALLINT NOT NULL Allocation Percentage
42 SHADOW_PCT Number(6,2) DECIMAL(5,2) NOT NULL Shadow Amount Percent
43 SHADOW_AMT Number(27,3) DECIMAL(26,3) NOT NULL An amount for a 'shadow' forecast.
44 FORECAST_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Forecast Total
45 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.