RSF_OPP_LEAD_VW

(SQL View)
 Index Back

Leads Associated to Oppy

Leads Associated to Opportunity

SELECT LEAD_ID , BUSINESS_UNIT , DESCR50 , OPPORTUNITY_ID , PERSON_ID , EST_REVENUE , ACCEPTED_DT , RA_CAMPAIGN_ID , RA_CMPGN_WAVE_ID FROM PS_RSF_LEAD

  • Related Language Record: RSF_OPPLEAD_LVW

    • # 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_RSF_NONVW

    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    4 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
    5 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

    Prompt Table: RSF_USER_BU_VW

    6 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.
    7 ACCEPTED_DT Date(10) DATE Accepted Date
    8 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.
    9 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID