RSFM_LEAD_SV_VW (SQL View)	Index Back
Sales - Leads Sales Leads. Used by Mobile Sales.

RSFM_LEAD_SV_VW

(SQL View)

Sales - Leads

Sales Leads. Used by Mobile Sales.

SELECT LEAD_ID , DESCR50 , BUSINESS_UNIT , PERSON_ID , SALES_USER_NAME , SETID , CUST_ID , BO_ID_CUST , BO_ID_SITE , SITE_NAME , ROLE_TYPE_ID_CUST , NAME1 , OPPORTUNITY_ID , LEAD_RATING , LEAD_STATUS , ASSIGN_GROUP , TERRITORY_ID , TREE_NAME , REGION_ID , CUST_SETID , PROD_SETID , PROD_GRP_SETID , FULFILL_SETID , SURVEY_SETID , LEAD_SOURCE_ID , BUSINESS_UNIT_RA , RA_CAMPAIGN_ID , RA_CMPGN_WAVE_ID , LEAD_TYPE , INDUSTRY_ID , EST_REVENUE , CURRENCY_CD , CUR_RT_TYPE , CHNL_PARTNER_ID , ALLIANC_PARTNER_ID , REFERRED_DT , ACCEPTED_DT , REJECTED_DT , NEXT_ACTIVITY_DT , PROFILE_CM_SEQ , CM_ID_ADDRESS , COUNTRY , ADDRESS1 , ADDRESS2 , ADDRESS3 , ADDRESS4 , CITY , NUM1 , NUM2 , HOUSE_TYPE , ADDR_FIELD1 , ADDR_FIELD2 , ADDR_FIELD3 , COUNTY , STATE , POSTAL , GEO_CODE , IN_CITY_LIMIT , ADDRESS1_AC , ADDRESS2_AC , ADDRESS3_AC , ADDRESS4_AC , CITY_AC , TIMEZONE , BILL_TO_FLG , SOLD_TO_FLG , SHIP_TO_FLG , CLONEDFROM_LEAD_ID , CLONEDTO_LEAD_ID , RC_BUS_UNIT , CASE_ID , AGREEMENT_CODE , AGR_RENEWAL_NUM , RC_PROSPECT_SW , RC_PROSPECT_STAT , FIRST_NAME , LAST_NAME , CNSMR_CNTCT_SEQ , CNSMR_CNTCT_FLG , SALES_PRIORITY , TEAM_ID , CONV_FROM_TLM_DTTM , OPRID_CONVERTED_BY , STATUS_CHANGE_DATE , LEAD_REJECT_CD , ROW_ADDED_DTTM , ROW_ADDED_OPRID , ROW_LASTMANT_DTTM , ROW_LASTMANT_OPRID , SYNCID , SYNCDTTM , MARKET , REJECTION_COMMENTS FROM PS_RSF_LEAD WHERE '1'='2'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
Default Value: NEXT

2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: RSF_OPR_DEF_VW.BUSINESS_UNIT
Prompt Table: SP_BU_RSF_NONVW

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

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

6 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

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

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

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

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

11 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

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

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

14 LEAD_RATING Character(2) VARCHAR2(2) NOT NULL Used by Sales Force Automation to indicate the value (rating) of a lead, i.e. whether it's a Hot Lead or a Cold Lead.
Prompt Table: RSF_LE_RATE_VW
Set Control Field: BUSINESS_UNIT

15 LEAD_STATUS Character(2) VARCHAR2(2) NOT NULL Used by Sales Force Automation to keep the status of a Sales Lead.
AC=Accepted
CD=Closed - Duplicate
CL=Closed - Won
CO=Converted to Opportunity
DE=Deferred
IM=Imported
LO=Closed - Lost
NE=New
OP=Open
RE=Referred
RJ=Rejected
TB=Turnback
WO=Working
Default Value: NE

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

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

18 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
Default Value: RSF_OPR_DEF_VW.TREE_NAME
Prompt Table: RSF_OPR_TREE_VW

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

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

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

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

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

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

25 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

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

27 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

28 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

29 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

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

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

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

33 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
Default Value: INSTALLATION.DEF_CUR_RT_TYPE
Prompt Table: RT_TYPE_TBL

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

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

36 REFERRED_DT Date(10) DATE Referred Date

37 ACCEPTED_DT Date(10) DATE Accepted Date

38 REJECTED_DT Date(10) DATE Rejected Date

39 NEXT_ACTIVITY_DT Date(10) DATE Next Task Date

40 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

65 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

66 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

67 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

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

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

70 RC_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

71 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.

72 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement

73 AGR_RENEWAL_NUM Number(4,0) SMALLINT NOT NULL This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)

74 RC_PROSPECT_SW Character(1) VARCHAR2(1) NOT NULL Outbound Marketing
Y/N Table Edit
Default Value: N

75 RC_PROSPECT_STAT Character(2) VARCHAR2(2) NOT NULL Prospect Status
A=Assigned
C=Callback
D=Done
N=New
R=Rejected

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

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

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

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

80 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

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

82 CONV_FROM_TLM_DTTM DateTime(26) TIMESTAMP Convert from TeleSales Date and Time

83 OPRID_CONVERTED_BY Character(30) VARCHAR2(30) NOT NULL Operator Id Converted By

84 STATUS_CHANGE_DATE DateTime(26) TIMESTAMP Status Change Date

85 LEAD_REJECT_CD Character(10) VARCHAR2(10) NOT NULL LEAD_REJECT_CD
Prompt Table: RSF_LE_RJCT_A_V

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

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

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

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

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

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

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

93 REJECTION_COMMENTS Long Character CLOB Rejection/Turnback Comments

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LEAD_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation, this field uniquely identifies a Sales Lead. Default Value: NEXT
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: RSF_OPR_DEF_VW.BUSINESS_UNIT Prompt Table: SP_BU_RSF_NONVW
4	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RSF_USER_BU_VW
5	SALES_USER_NAME	Character(50)	VARCHAR2(50) NOT NULL	Sales User Name field
6	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
7	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
8	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
9	BO_ID_SITE	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID Prompt Table: RD_SITE_VW
10	SITE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Site Name
11	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
12	NAME1	Character(50)	VARCHAR2(50) NOT NULL	Generic 50 character name field for storing names.
13	OPPORTUNITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Opportunity ID
14	LEAD_RATING	Character(2)	VARCHAR2(2) NOT NULL	Used by Sales Force Automation to indicate the value (rating) of a lead, i.e. whether it's a Hot Lead or a Cold Lead. Prompt Table: RSF_LE_RATE_VW Set Control Field: BUSINESS_UNIT
15	LEAD_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Used by Sales Force Automation to keep the status of a Sales Lead. AC=Accepted CD=Closed - Duplicate CL=Closed - Won CO=Converted to Opportunity DE=Deferred IM=Imported LO=Closed - Lost NE=New OP=Open RE=Referred RJ=Rejected TB=Turnback WO=Working Default Value: NE
16	ASSIGN_GROUP	Character(30)	VARCHAR2(30) NOT NULL	This field is used to specify assignment group name for Territory assignment. Default Value: RSF_OPR_DEF_VW.ASSIGN_GROUP Prompt Table: RSF_ASSIGN_GRP Set Control Field: BUSINESS_UNIT
17	TERRITORY_ID	Character(20)	VARCHAR2(20) NOT NULL	Territory ID Prompt Table: RSF_TER_NODE_VW
18	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Default Value: RSF_OPR_DEF_VW.TREE_NAME Prompt Table: RSF_OPR_TREE_VW
19	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value. Prompt Table: RSF_REGION_VW
20	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer Setid
21	PROD_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product SET ID
22	PROD_GRP_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product Group SetID
23	FULFILL_SETID	Character(5)	VARCHAR2(5) NOT NULL	FULFIL
24	SURVEY_SETID	Character(5)	VARCHAR2(5) NOT NULL	Survey SetID
25	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
26	BUSINESS_UNIT_RA	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RA_NONVW
27	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
28	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
29	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
30	INDUSTRY_ID	Character(30)	VARCHAR2(30) NOT NULL	Industry ID. Prompt Table: RSF_INDUSTRY_VW
31	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.
32	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value. Default Value: RSF_OPR_DEF_VW.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
33	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Default Value: INSTALLATION.DEF_CUR_RT_TYPE Prompt Table: RT_TYPE_TBL
34	CHNL_PARTNER_ID	Character(30)	VARCHAR2(30) NOT NULL	Unique identifier for a Channel Partner Prompt Table: RSF_CHNL_PRT_VW
35	ALLIANC_PARTNER_ID	Character(30)	VARCHAR2(30) NOT NULL	Alliance Partner Prompt Table: RSF_ALLNC_PRT_V
36	REFERRED_DT	Date(10)	DATE	Referred Date
37	ACCEPTED_DT	Date(10)	DATE	Accepted Date
38	REJECTED_DT	Date(10)	DATE	Rejected Date
39	NEXT_ACTIVITY_DT	Date(10)	DATE	Next Task Date
40	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
41	CM_ID_ADDRESS	Number(31,0)	DECIMAL(31) NOT NULL	Contact Method ID
42	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
43	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
44	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
45	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
46	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
47	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
48	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
49	NUM2	Character(4)	VARCHAR2(4) NOT NULL	Number 2
50	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
51	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
52	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
53	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
54	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
55	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
56	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
57	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
58	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit Default Value: Y
59	ADDRESS1_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS1_AC
60	ADDRESS2_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS2_AC
61	ADDRESS3_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS3_AC
62	ADDRESS4_AC	Character(55)	VARCHAR2(55) NOT NULL	Alternate Character Address 4.
63	CITY_AC	Character(30)	VARCHAR2(30) NOT NULL	CITY_AC
64	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Prompt Table: PSTIMEZONE
65	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
66	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
67	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
68	CLONEDFROM_LEAD_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
69	CLONEDTO_LEAD_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
70	RC_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
71	CASE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
72	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement
73	AGR_RENEWAL_NUM	Number(4,0)	SMALLINT NOT NULL	This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
74	RC_PROSPECT_SW	Character(1)	VARCHAR2(1) NOT NULL	Outbound Marketing Y/N Table Edit Default Value: N
75	RC_PROSPECT_STAT	Character(2)	VARCHAR2(2) NOT NULL	Prospect Status A=Assigned C=Callback D=Done N=New R=Rejected
76	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
77	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
78	CNSMR_CNTCT_SEQ	Number(3,0)	SMALLINT NOT NULL	Consumer Contact Row Seq#
79	CNSMR_CNTCT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Consumer Contact Row created? Y/N Table Edit Default Value: N
80	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
81	TEAM_ID	Character(15)	VARCHAR2(15) NOT NULL	Sales Team ID Prompt Table: RSF_TEAM_A_VW
82	CONV_FROM_TLM_DTTM	DateTime(26)	TIMESTAMP	Convert from TeleSales Date and Time
83	OPRID_CONVERTED_BY	Character(30)	VARCHAR2(30) NOT NULL	Operator Id Converted By
84	STATUS_CHANGE_DATE	DateTime(26)	TIMESTAMP	Status Change Date
85	LEAD_REJECT_CD	Character(10)	VARCHAR2(10) NOT NULL	LEAD_REJECT_CD Prompt Table: RSF_LE_RJCT_A_V
86	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
87	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
88	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
89	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
90	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.
91	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time
92	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
93	REJECTION_COMMENTS	Long Character	CLOB	Rejection/Turnback Comments