RSF_OPP_CNFG_VW (SQL View)	Index Back
Opportunity Homepage Opportunity Configurable Search Homepage view

RSF_OPP_CNFG_VW

(SQL View)

Opportunity Homepage

Opportunity Configurable Search Homepage view

SELECT O.OPPORTUNITY_ID , O.BUSINESS_UNIT , O.NAME1 , O.FIRST_NAME , O.LAST_NAME , O.PHONE , O.OPPORTUNITY_NAME , O.CONTACT_ID , O.BO_ID_CONTACT , O.NAME , O.OPPORTUNITY_STATUS , O.PERSON_ID , O.BO_ID_PERSON , O.SALES_STAGE , O.SALES_PRIORITY , O.COUNTRY , O.ADDRESS1 , O.CITY , O.STATE , O.POSTAL , O.SALES_USER_NAME , O.SALES_MODEL , O.TEAM_DESCR , O.BO_ID_CUST , O.BO_ID_PARTNER , O.BO_ID_PART_CONT , O.CUST_SETID , O.ROLE_TYPE_ID_CUST , O.ROLE_TYPE_ID_CNTCT , O.ROLE_TYPE_ID_PART , O.ROLE_TYPE_ID_PARTC , O.SEQ_NUM , O.SALES_TASK , O.SEQNUM , O.TREE_NAME , O.TERRITORY_ID , O.TERRITORYDESCR , O.REGION_ID , O.REGIONDESCR , O.PRODUCT_GROUP , O.PRODUCT_ID , O.STAGE_PCT_CLOSE , O.CONFIDENCE_PCT , O.NEXT_ACTIVITY_DT , O.EST_CLOSE_DT , O.CURRENCY_CD , O.EST_REVENUE , O.FORECAST_TOTAL , O.FORECAST , O.ROW_ADDED_DTTM , O.ACT_CLOSE_DT , O.ACT_REVENUE , O.PREV_CLOSE_DT , O.PREV_REVENUE , O.EMAIL_ADDR , O.SYNCID FROM PS_RSF_OPPORTUNITY O

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_RSF_NONVW

3 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.

4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

6 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.

7 OPPORTUNITY_NAME Character(50) VARCHAR2(50) NOT NULL Opportunity Name - User Enters this field in Mixed Case.

8 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
Prompt Table: RSF_CNTCT_BC_VW

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

10 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
Prompt Table: RD_PERSON

11 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

12 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
Prompt Table: RSF_USER_BU_VW

13 BO_ID_PERSON Number(31,0) DECIMAL(31) NOT NULL Business Object ID

14 SALES_STAGE Character(24) VARCHAR2(24) NOT NULL Sales Stage Identifier
Prompt Table: RSF_SALES_STG_V

15 SALES_PRIORITY Character(3) VARCHAR2(3) NOT NULL Priority of sales lead and opportunity
1=1-One
2=2-Two
3=3-Three
4=4-Four
5=5-Five
6=6-Six
7=7-Seven
8=8-Eight
9=9-Nine

16 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

17 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

18 CITY Character(30) VARCHAR2(30) NOT NULL City

19 STATE Character(6) VARCHAR2(6) NOT NULL State

20 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

21 SALES_USER_NAME Character(50) VARCHAR2(50) NOT NULL Sales User Name field

22 SALES_MODEL Character(18) VARCHAR2(18) NOT NULL Sales Model Id
Prompt Table: RSF_SLSMDL_A_VW

23 TEAM_DESCR Character(30) VARCHAR2(30) NOT NULL Sales Team

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

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

26 BO_ID_PART_CONT Signed Number(32,0) DECIMAL(31) NOT NULL This is the business object identifier for the partner contact.

27 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer Setid

28 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
Prompt Table: RSF_BO_ROLTY_VW

29 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact

30 ROLE_TYPE_ID_PART Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner

31 ROLE_TYPE_ID_PARTC Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner contact

32 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

33 SALES_TASK Character(24) VARCHAR2(24) NOT NULL Sales Stage Task Identifier
Prompt Table: RSF_SALES_TSK_V

34 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

35 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
Prompt Table: RSF_OPR_TREE1VW

36 TERRITORY_ID Character(20) VARCHAR2(20) NOT NULL Territory ID
Prompt Table: RSF_TER_NODE_VW

37 TERRITORYDESCR Character(30) VARCHAR2(30) NOT NULL Description

38 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.
Prompt Table: RSF_REGION_VW

39 REGIONDESCR Character(30) VARCHAR2(30) NOT NULL Description

40 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group
Prompt Table: RSF_PRODGRP_VW

41 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Prompt Table: RSF_PROD_VW

42 STAGE_PCT_CLOSE Number(3,0) SMALLINT NOT NULL To indicate a % of how much a stage is completed

43 CONFIDENCE_PCT Number(3,0) SMALLINT NOT NULL Confidence Percentage

44 NEXT_ACTIVITY_DT Date(10) DATE Next Activity Date

45 EST_CLOSE_DT Date(10) DATE Estimated Close Date of an Opportunity

46 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
Prompt Table: CURRENCY_CD_TBL

47 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.

48 FORECAST_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Forecast Total

49 FORECAST Character(1) VARCHAR2(1) NOT NULL Include in Cash Forecast
N=Not Forecasted
Y=Forecasted

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

51 ACT_CLOSE_DT Date(10) DATE Actual Close Date of an Opportunity

52 ACT_REVENUE Number(27,3) DECIMAL(26,3) NOT NULL Actual Revenue

53 PREV_CLOSE_DT Date(10) DATE Estimated Close Date of an Opportunity

54 PREV_REVENUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Revenue

55 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.

56 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPPORTUNITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Opportunity ID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RSF_NONVW
3	NAME1	Character(50)	VARCHAR2(50) NOT NULL	Generic 50 character name field for storing names.
4	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
5	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
6	PHONE	Character(24)	VARCHAR2(24) NOT NULL	This field stores the Telephone number.
7	OPPORTUNITY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Opportunity Name - User Enters this field in Mixed Case.
8	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: RSF_CNTCT_BC_VW
9	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
10	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty. Prompt Table: RD_PERSON
11	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
12	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RSF_USER_BU_VW
13	BO_ID_PERSON	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
14	SALES_STAGE	Character(24)	VARCHAR2(24) NOT NULL	Sales Stage Identifier Prompt Table: RSF_SALES_STG_V
15	SALES_PRIORITY	Character(3)	VARCHAR2(3) NOT NULL	Priority of sales lead and opportunity 1=1-One 2=2-Two 3=3-Three 4=4-Four 5=5-Five 6=6-Six 7=7-Seven 8=8-Eight 9=9-Nine
16	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
17	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
18	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
19	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
20	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
21	SALES_USER_NAME	Character(50)	VARCHAR2(50) NOT NULL	Sales User Name field
22	SALES_MODEL	Character(18)	VARCHAR2(18) NOT NULL	Sales Model Id Prompt Table: RSF_SLSMDL_A_VW
23	TEAM_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Sales Team
24	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
25	BO_ID_PARTNER	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID of Partner Company.
26	BO_ID_PART_CONT	Signed Number(32,0)	DECIMAL(31) NOT NULL	This is the business object identifier for the partner contact.
27	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer Setid
28	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer Prompt Table: RSF_BO_ROLTY_VW
29	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
30	ROLE_TYPE_ID_PART	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the partner
31	ROLE_TYPE_ID_PARTC	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the partner contact
32	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
33	SALES_TASK	Character(24)	VARCHAR2(24) NOT NULL	Sales Stage Task Identifier Prompt Table: RSF_SALES_TSK_V
34	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
35	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Prompt Table: RSF_OPR_TREE1VW
36	TERRITORY_ID	Character(20)	VARCHAR2(20) NOT NULL	Territory ID Prompt Table: RSF_TER_NODE_VW
37	TERRITORYDESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
38	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value. Prompt Table: RSF_REGION_VW
39	REGIONDESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
40	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	PRoduct Group Prompt Table: RSF_PRODGRP_VW
41	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: RSF_PROD_VW
42	STAGE_PCT_CLOSE	Number(3,0)	SMALLINT NOT NULL	To indicate a % of how much a stage is completed
43	CONFIDENCE_PCT	Number(3,0)	SMALLINT NOT NULL	Confidence Percentage
44	NEXT_ACTIVITY_DT	Date(10)	DATE	Next Activity Date
45	EST_CLOSE_DT	Date(10)	DATE	Estimated Close Date of an Opportunity
46	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value. Prompt Table: CURRENCY_CD_TBL
47	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.
48	FORECAST_TOTAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Forecast Total
49	FORECAST	Character(1)	VARCHAR2(1) NOT NULL	Include in Cash Forecast N=Not Forecasted Y=Forecasted
50	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
51	ACT_CLOSE_DT	Date(10)	DATE	Actual Close Date of an Opportunity
52	ACT_REVENUE	Number(27,3)	DECIMAL(26,3) NOT NULL	Actual Revenue
53	PREV_CLOSE_DT	Date(10)	DATE	Estimated Close Date of an Opportunity
54	PREV_REVENUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Estimated Revenue
55	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email.
56	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.