RSF_OPPO_HST (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_OPPO_HST

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

3 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
Default Value: NEXT

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

5 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

6 TEAM_ID Character(15) VARCHAR2(15) NOT NULL Sales Team ID
Prompt Table: RSF_TEAM_A_VW

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

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

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

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

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

12 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

27 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

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

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

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

31 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

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

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

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

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

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

37 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

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

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

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

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

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

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

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

45 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

60 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

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

62 NEXT_ACTIVITY_DT Date(10) DATE Next Activity Date

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

101 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: N

102 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

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

104 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

105 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

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

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

108 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

109 ACCEPTED_DT Date(10) DATE Accepted Date

110 REFERRED_DT Date(10) DATE Referred Date

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

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

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

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

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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	OPPORTUNITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Opportunity ID Default Value: NEXT
4	OPPORTUNITY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Opportunity Name - User Enters this field in Mixed Case.
5	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
6	TEAM_ID	Character(15)	VARCHAR2(15) NOT NULL	Sales Team ID Prompt Table: RSF_TEAM_A_VW
7	TEAM_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Sales Team
8	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer Setid
9	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RSF_NONVW
10	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
11	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
12	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
13	BO_ID_PARTNER	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID of Partner Company.
14	ROLE_TYPE_ID_PART	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the partner
15	BO_ID_PART_CONT	Signed Number(32,0)	DECIMAL(31) NOT NULL	This is the business object identifier for the partner contact.
16	ROLE_TYPE_ID_PARTC	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the partner contact
17	BO_ID_PERSON	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
18	ROLE_TYPE_ID_USER	Number(12,0)	DECIMAL(12) NOT NULL	Self service user role type id
19	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
20	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
21	BO_ID_SITE	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID Prompt Table: RD_SITE_VW
22	ROLE_TYPE_ID_SITE	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
23	SITE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Site Name
24	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RSF_USER_BU_VW
25	SALES_USER_NAME	Character(50)	VARCHAR2(50) NOT NULL	Sales User Name field
26	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Default Value: INSTALLATION.DEF_CUR_RT_TYPE
27	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
28	NAME1	Character(50)	VARCHAR2(50) NOT NULL	Generic 50 character name field for storing names.
29	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value. Prompt Table: RSF_REGION_VW
30	REGIONDESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
31	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
32	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Prompt Table: RSF_OPR_TREE1VW
33	TERRITORY_ID	Character(20)	VARCHAR2(20) NOT NULL	Territory ID Prompt Table: RSF_TER_NODE_VW
34	TERRITORYDESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
35	PERSON_ID_PARTNER	Character(15)	VARCHAR2(15) NOT NULL	Partner Rep
36	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: RSF_CNTCT_BC_VW
37	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
38	PHONE	Character(24)	VARCHAR2(24) NOT NULL	This field stores the Telephone number.
39	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Prompt Table: RD_PERSON
40	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email.
41	SALES_MODEL	Character(18)	VARCHAR2(18) NOT NULL	Sales Model Id Prompt Table: RSF_SLSMDL_A_VW
42	SALES_STAGE	Character(24)	VARCHAR2(24) NOT NULL	Sales Stage Identifier Prompt Table: RSF_SALES_STG_V
43	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
44	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
45	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
46	SALES_TASK	Character(24)	VARCHAR2(24) NOT NULL	Sales Stage Task Identifier Prompt Table: RSF_SALES_TSK_V
47	INDUSTRY_ID	Character(30)	VARCHAR2(30) NOT NULL	Industry ID. Prompt Table: RSF_INDUSTRY_VW
48	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.
49	ACT_REVENUE	Number(27,3)	DECIMAL(26,3) NOT NULL	Actual Revenue
50	PREV_REVENUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Estimated Revenue
51	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value. Prompt Table: CURRENCY_CD_TBL
52	CONFIDENCE_PCT	Number(3,0)	SMALLINT NOT NULL	Confidence Percentage
53	STAGE_PCT_CLOSE	Number(3,0)	SMALLINT NOT NULL	To indicate a % of how much a stage is completed Default Value: 0
54	ACT_CLOSE_DT	Date(10)	DATE	Actual Close Date of an Opportunity
55	EST_CLOSE_DT	Date(10)	DATE	Estimated Close Date of an Opportunity
56	PREV_CLOSE_DT	Date(10)	DATE	Estimated Close Date of an Opportunity
57	FORECAST	Character(1)	VARCHAR2(1) NOT NULL	Include in Cash Forecast N=Not Forecasted Y=Forecasted Y/N Table Edit Default Value: N
58	FORECAST_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Type of forecast, eg 'Open' or 'closed' Prompt Table: RSF_FCAST_TO_VW
59	FORECAST_TOTAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Forecast Total
60	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
61	LEAD_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
62	NEXT_ACTIVITY_DT	Date(10)	DATE	Next Activity Date
63	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	PRoduct Group Prompt Table: RSF_PRODGRP_VW
64	PRODGROUPDESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
65	PROD_GRP_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product Group SetID
66	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: RSF_PROD_VW
67	PRODUCTDESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
68	PROD_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product SET ID
69	FULFILL_SETID	Character(5)	VARCHAR2(5) NOT NULL	FULFIL
70	CM_ID_ADDRESS	Number(31,0)	DECIMAL(31) NOT NULL	Contact Method ID
71	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
72	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
73	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
74	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
75	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
76	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
77	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
78	NUM2	Character(4)	VARCHAR2(4) NOT NULL	Number 2
79	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
80	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
81	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
82	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
83	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
84	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
85	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
86	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
87	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit Default Value: Y
88	ADDRESS1_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS1_AC
89	ADDRESS2_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS2_AC
90	ADDRESS3_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS3_AC
91	ADDRESS4_AC	Character(55)	VARCHAR2(55) NOT NULL	Alternate Character Address 4.
92	CITY_AC	Character(30)	VARCHAR2(30) NOT NULL	CITY_AC
93	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Prompt Table: PSTIMEZONE
94	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
95	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
96	CLONED_FROM_OPP	Character(15)	VARCHAR2(15) NOT NULL	Cloned from Opportunity ID
97	CLONED_TO_OPP	Character(15)	VARCHAR2(15) NOT NULL	Cloned To Opportunity ID
98	CNSMR_CNTCT_SEQ	Number(3,0)	SMALLINT NOT NULL	Consumer Contact Row Seq#
99	CNSMR_CNTCT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Consumer Contact Row created? Y/N Table Edit Default Value: N
100	BILL_TO_FLG	Character(1)	VARCHAR2(1) NOT NULL	A boolean that flags whether or not the customer is a valid Bill To customer. Default Value: N
101	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: N
102	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
103	BUSINESS_UNIT_RA	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RA_NONVW
104	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
105	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
106	CHNL_PARTNER_ID	Character(30)	VARCHAR2(30) NOT NULL	Unique identifier for a Channel Partner Prompt Table: RSF_CHNL_PRT_VW
107	ALLIANC_PARTNER_ID	Character(30)	VARCHAR2(30) NOT NULL	Alliance Partner Prompt Table: RSF_ALLNC_PRT_V
108	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
109	ACCEPTED_DT	Date(10)	DATE	Accepted Date
110	REFERRED_DT	Date(10)	DATE	Referred Date
111	SURVEY_SETID	Character(5)	VARCHAR2(5) NOT NULL	Survey SetID
112	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
113	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
114	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
115	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
116	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
117	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.
118	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time