RSF_OPPORTUNITY (SQL Table)	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.

RSF_OPPORTUNITY

(SQL Table)

Opportunity Header

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

Parent Record Of RSF_OPP_ATTR RSF_OP_ATR_LNG

# 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 TEAM_ID Character(15) VARCHAR2(15) NOT NULL Sales Team ID
Prompt Table: RSF_TEAM_A_VW

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

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

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

8 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID

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

10 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
Default Value: 2
Prompt Table: RSF_BO_ROLTY_VW

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

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

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

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

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

16 ROLE_TYPE_ID_USER Number(12,0) DECIMAL(12) NOT NULL Self service user role type id

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

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

19 BO_ID_SITE Number(31,0) DECIMAL(31) NOT NULL Business Object ID
Prompt Table: RD_SITE_VW

20 ROLE_TYPE_ID_SITE Number(12,0) DECIMAL(12) NOT NULL Role Type ID

21 SITE_NAME Character(30) VARCHAR2(30) NOT NULL Site Name

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

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

24 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
Default Value: INSTALLATION.DEF_CUR_RT_TYPE

25 PROFILE_CM_SEQ Number(31,0) DECIMAL(31) NOT NULL The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.
Prompt Table: RSF_ROLE_ADR_VW

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

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

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

29 ASSIGN_GROUP Character(30) VARCHAR2(30) NOT NULL This field is used to specify assignment group name for Territory assignment.
Prompt Table: RSF_ASSIGN_GRP
Set Control Field: BUSINESS_UNIT

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

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

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

33 PERSON_ID_PARTNER Character(15) VARCHAR2(15) NOT NULL Partner Rep

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

35 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

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

37 NAME Character(50) VARCHAR2(50) NOT NULL Name
Prompt Table: RD_PERSON

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

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

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

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

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

43 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
Default Value: 5

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

45 INDUSTRY_ID Character(30) VARCHAR2(30) NOT NULL Industry ID.
Prompt Table: RSF_INDUSTRY_VW

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

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

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

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

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

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

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

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

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

55 FORECAST Character(1) VARCHAR2(1) NOT NULL Include in Cash Forecast
N=Not Forecasted
Y=Forecasted
Y/N Table Edit
Default Value: N

56 FORECAST_TYPE Character(10) VARCHAR2(10) NOT NULL Type of forecast, eg 'Open' or 'closed'
Prompt Table: RSF_FCAST_TO_VW

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

58 LEAD_SOURCE_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation to identify the source of a Sales Lead.
Default Value: SALES
Prompt Table: RSF_LE_SRC_VW

59 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.

60 NEXT_ACTIVITY_DT Date(10) DATE Next Activity Date

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

62 PRODGROUPDESCR Character(30) VARCHAR2(30) NOT NULL Description

63 PROD_GRP_SETID Character(5) VARCHAR2(5) NOT NULL Product Group SetID

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

65 PRODUCTDESCR Character(30) VARCHAR2(30) NOT NULL Description

66 PROD_SETID Character(5) VARCHAR2(5) NOT NULL Product SET ID

67 FULFILL_SETID Character(5) VARCHAR2(5) NOT NULL FULFIL

68 CM_ID_ADDRESS Number(31,0) DECIMAL(31) NOT NULL Contact Method ID

69 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

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

71 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

72 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

73 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

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

75 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

76 NUM2 Character(4) VARCHAR2(4) NOT NULL Number 2

77 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference

78 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

79 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

80 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

81 COUNTY Character(30) VARCHAR2(30) NOT NULL County

82 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: %EDIT_STATE

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

84 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

85 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit
Default Value: Y

86 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS1_AC

87 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS2_AC

88 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS3_AC

89 ADDRESS4_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 4.

90 CITY_AC Character(30) VARCHAR2(30) NOT NULL CITY_AC

91 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
Prompt Table: PSTIMEZONE

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

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

94 CLONED_FROM_OPP Character(15) VARCHAR2(15) NOT NULL Cloned from Opportunity ID

95 CLONED_TO_OPP Character(15) VARCHAR2(15) NOT NULL Cloned To Opportunity ID

96 CNSMR_CNTCT_SEQ Number(3,0) SMALLINT NOT NULL Consumer Contact Row Seq#

97 CNSMR_CNTCT_FLG Character(1) VARCHAR2(1) NOT NULL Consumer Contact Row created?
Y/N Table Edit
Default Value: N

98 BILL_TO_FLG Character(1) VARCHAR2(1) NOT NULL A boolean that flags whether or not the customer is a valid Bill To customer.
Y/N Table Edit
Default Value: N

99 SOLD_TO_FLG Character(1) VARCHAR2(1) NOT NULL A boolean that flags whether or not the customer is a valid Sold To customer.
Default Value: Y

100 SHIP_TO_FLG Character(1) VARCHAR2(1) NOT NULL A flag indicating that the customer or address is a valid Ship To customer or address.
Default Value: N

101 BUSINESS_UNIT_RA Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_RA_NONVW

102 RA_CAMPAIGN_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id.
Prompt Table: RSF_CAMPAIGN_VW

103 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID
Prompt Table: RSF_CMPGN_WA_VW

104 CHNL_PARTNER_ID Character(30) VARCHAR2(30) NOT NULL Unique identifier for a Channel Partner
Prompt Table: RSF_CHNL_PRT_VW

105 ALLIANC_PARTNER_ID Character(30) VARCHAR2(30) NOT NULL Alliance Partner
Prompt Table: RSF_ALLNC_PRT_V

106 LEAD_TYPE Character(2) VARCHAR2(2) NOT NULL Used by Sales Force Automation to indicate what type of Lead,
IN=Inquiry
LE=Lead
QU=Qualified Lead
TQ=Turnback Qualified Lead
TU=Turnback Lead

107 ACCEPTED_DT Date(10) DATE Accepted Date

108 REFERRED_DT Date(10) DATE Referred Date

109 SURVEY_SETID Character(5) VARCHAR2(5) NOT NULL Survey SetID

110 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

111 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution field to store institution information in campus solution system.
Prompt Table: RD_USR_INS_VW

112 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic career field coming from campus solution system.
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
Prompt Table: RD_USR_CAR_VW

113 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL stores information about term attending.
Prompt Table: RD_ACAD_ATE_VW

114 LAST_SCH_ATTEND Character(11) VARCHAR2(11) NOT NULL Last school attended
Prompt Table: EXT_ORG_TBL

115 RAE_EVENT_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id.
Prompt Table: RSF_EVENT_VW

116 MARKET Character(3) VARCHAR2(3) NOT NULL Market

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

118 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

119 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

120 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

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

122 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	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	TEAM_ID	Character(15)	VARCHAR2(15) NOT NULL	Sales Team ID Prompt Table: RSF_TEAM_A_VW
5	TEAM_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Sales Team
6	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer Setid
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RSF_NONVW
8	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
9	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
10	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer Default Value: 2 Prompt Table: RSF_BO_ROLTY_VW
11	BO_ID_PARTNER	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID of Partner Company.
12	ROLE_TYPE_ID_PART	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the partner
13	BO_ID_PART_CONT	Signed Number(32,0)	DECIMAL(31) NOT NULL	This is the business object identifier for the partner contact.
14	ROLE_TYPE_ID_PARTC	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the partner contact
15	BO_ID_PERSON	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
16	ROLE_TYPE_ID_USER	Number(12,0)	DECIMAL(12) NOT NULL	Self service user role type id
17	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
18	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
19	BO_ID_SITE	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID Prompt Table: RD_SITE_VW
20	ROLE_TYPE_ID_SITE	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
21	SITE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Site Name
22	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RSF_USER_BU_VW
23	SALES_USER_NAME	Character(50)	VARCHAR2(50) NOT NULL	Sales User Name field
24	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Default Value: INSTALLATION.DEF_CUR_RT_TYPE
25	PROFILE_CM_SEQ	Number(31,0)	DECIMAL(31) NOT NULL	The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables. Prompt Table: RSF_ROLE_ADR_VW
26	NAME1	Character(50)	VARCHAR2(50) NOT NULL	Generic 50 character name field for storing names.
27	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value. Prompt Table: RSF_REGION_VW
28	REGIONDESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
29	ASSIGN_GROUP	Character(30)	VARCHAR2(30) NOT NULL	This field is used to specify assignment group name for Territory assignment. Prompt Table: RSF_ASSIGN_GRP Set Control Field: BUSINESS_UNIT
30	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Prompt Table: RSF_OPR_TREE1VW
31	TERRITORY_ID	Character(20)	VARCHAR2(20) NOT NULL	Territory ID Prompt Table: RSF_TER_NODE_VW
32	TERRITORYDESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
33	PERSON_ID_PARTNER	Character(15)	VARCHAR2(15) NOT NULL	Partner Rep
34	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: RSF_CNTCT_BC_VW
35	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
36	PHONE	Character(24)	VARCHAR2(24) NOT NULL	This field stores the Telephone number.
37	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Prompt Table: RD_PERSON
38	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email.
39	SALES_MODEL	Character(18)	VARCHAR2(18) NOT NULL	Sales Model Id Prompt Table: RSF_SLSMDL_A_VW
40	SALES_STAGE	Character(24)	VARCHAR2(24) NOT NULL	Sales Stage Identifier Prompt Table: RSF_SALES_STG_V
41	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
42	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
43	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 Default Value: 5
44	SALES_TASK	Character(24)	VARCHAR2(24) NOT NULL	Sales Stage Task Identifier Prompt Table: RSF_SALES_TSK_V
45	INDUSTRY_ID	Character(30)	VARCHAR2(30) NOT NULL	Industry ID. Prompt Table: RSF_INDUSTRY_VW
46	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.
47	ACT_REVENUE	Number(27,3)	DECIMAL(26,3) NOT NULL	Actual Revenue
48	PREV_REVENUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Estimated Revenue
49	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value. Prompt Table: CURRENCY_CD_TBL
50	CONFIDENCE_PCT	Number(3,0)	SMALLINT NOT NULL	Confidence Percentage
51	STAGE_PCT_CLOSE	Number(3,0)	SMALLINT NOT NULL	To indicate a % of how much a stage is completed Default Value: 0
52	ACT_CLOSE_DT	Date(10)	DATE	Actual Close Date of an Opportunity
53	EST_CLOSE_DT	Date(10)	DATE	Estimated Close Date of an Opportunity
54	PREV_CLOSE_DT	Date(10)	DATE	Estimated Close Date of an Opportunity
55	FORECAST	Character(1)	VARCHAR2(1) NOT NULL	Include in Cash Forecast N=Not Forecasted Y=Forecasted Y/N Table Edit Default Value: N
56	FORECAST_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Type of forecast, eg 'Open' or 'closed' Prompt Table: RSF_FCAST_TO_VW
57	FORECAST_TOTAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Forecast Total
58	LEAD_SOURCE_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation to identify the source of a Sales Lead. Default Value: SALES Prompt Table: RSF_LE_SRC_VW
59	LEAD_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
60	NEXT_ACTIVITY_DT	Date(10)	DATE	Next Activity Date
61	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	PRoduct Group Prompt Table: RSF_PRODGRP_VW
62	PRODGROUPDESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
63	PROD_GRP_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product Group SetID
64	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: RSF_PROD_VW
65	PRODUCTDESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
66	PROD_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product SET ID
67	FULFILL_SETID	Character(5)	VARCHAR2(5) NOT NULL	FULFIL
68	CM_ID_ADDRESS	Number(31,0)	DECIMAL(31) NOT NULL	Contact Method ID
69	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
70	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
71	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
72	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
73	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
74	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
75	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
76	NUM2	Character(4)	VARCHAR2(4) NOT NULL	Number 2
77	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
78	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
79	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
80	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
81	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
82	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
83	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
84	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
85	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit Default Value: Y
86	ADDRESS1_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS1_AC
87	ADDRESS2_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS2_AC
88	ADDRESS3_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS3_AC
89	ADDRESS4_AC	Character(55)	VARCHAR2(55) NOT NULL	Alternate Character Address 4.
90	CITY_AC	Character(30)	VARCHAR2(30) NOT NULL	CITY_AC
91	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Prompt Table: PSTIMEZONE
92	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
93	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
94	CLONED_FROM_OPP	Character(15)	VARCHAR2(15) NOT NULL	Cloned from Opportunity ID
95	CLONED_TO_OPP	Character(15)	VARCHAR2(15) NOT NULL	Cloned To Opportunity ID
96	CNSMR_CNTCT_SEQ	Number(3,0)	SMALLINT NOT NULL	Consumer Contact Row Seq#
97	CNSMR_CNTCT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Consumer Contact Row created? Y/N Table Edit Default Value: N
98	BILL_TO_FLG	Character(1)	VARCHAR2(1) NOT NULL	A boolean that flags whether or not the customer is a valid Bill To customer. Y/N Table Edit Default Value: N
99	SOLD_TO_FLG	Character(1)	VARCHAR2(1) NOT NULL	A boolean that flags whether or not the customer is a valid Sold To customer. Default Value: Y
100	SHIP_TO_FLG	Character(1)	VARCHAR2(1) NOT NULL	A flag indicating that the customer or address is a valid Ship To customer or address. Default Value: N
101	BUSINESS_UNIT_RA	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RA_NONVW
102	RA_CAMPAIGN_ID	Character(15)	VARCHAR2(15) NOT NULL	Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id. Prompt Table: RSF_CAMPAIGN_VW
103	RA_CMPGN_WAVE_ID	Character(15)	VARCHAR2(15) NOT NULL	Used to uniquely identify a Marketing - Campaign Activity (wave) ID Prompt Table: RSF_CMPGN_WA_VW
104	CHNL_PARTNER_ID	Character(30)	VARCHAR2(30) NOT NULL	Unique identifier for a Channel Partner Prompt Table: RSF_CHNL_PRT_VW
105	ALLIANC_PARTNER_ID	Character(30)	VARCHAR2(30) NOT NULL	Alliance Partner Prompt Table: RSF_ALLNC_PRT_V
106	LEAD_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Used by Sales Force Automation to indicate what type of Lead, IN=Inquiry LE=Lead QU=Qualified Lead TQ=Turnback Qualified Lead TU=Turnback Lead
107	ACCEPTED_DT	Date(10)	DATE	Accepted Date
108	REFERRED_DT	Date(10)	DATE	Referred Date
109	SURVEY_SETID	Character(5)	VARCHAR2(5) NOT NULL	Survey SetID
110	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
111	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Institution field to store institution information in campus solution system. Prompt Table: RD_USR_INS_VW
112	ACAD_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Academic career field coming from campus solution system. BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine Prompt Table: RD_USR_CAR_VW
113	ADMIT_TERM	Character(4)	VARCHAR2(4) NOT NULL	stores information about term attending. Prompt Table: RD_ACAD_ATE_VW
114	LAST_SCH_ATTEND	Character(11)	VARCHAR2(11) NOT NULL	Last school attended Prompt Table: EXT_ORG_TBL
115	RAE_EVENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id. Prompt Table: RSF_EVENT_VW
116	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
117	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
118	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
119	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
120	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
121	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.
122	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time