RI_RSF_LEADS_VW

(SQL View)
 Index Back

Sales Leads

CRM Sales - View of all Sales Leads

SELECT LEAD_ID , DESCR50 , BUSINESS_UNIT , PERSON_ID , SALES_USER_NAME , NAME1 , OPPORTUNITY_ID , LEAD_RATING , LEAD_STATUS , CUST_SETID , BO_ID_CUST , BO_ID_CONTACT , ROW_ADDED_DTTM FROM PS_RSF_LEAD_VW

  • Related Language Record: RI_RSF_LEAD_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.
    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 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
    7 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
    8 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

    9 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
    10 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    11 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    12 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    13 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.