RSF_LEAD_VW

(SQL View)
 Index Back

Sales Force Automation - Leads

Used by Sales Force Automation to keep Sales Leads

SELECT L.LEAD_ID ,L.BUSINESS_UNIT ,L.TREE_NAME ,L.TERRITORY_ID ,L.REGION_ID ,L.DESCR50 ,L.BO_ID_SITE ,L.CUST_SETID ,L.PRODUCT_ID ,L.PROD_SETID ,L.FULFILL_SETID ,L.NAME1 , L.FIRST_NAME , L.LAST_NAME ,L.OPPORTUNITY_ID ,L.LEAD_SOURCE_ID ,L.BUSINESS_UNIT_RA ,L.RA_CAMPAIGN_ID ,L.RA_CMPGN_WAVE_ID ,L.LEAD_RATING ,L.LEAD_TYPE ,L.LEAD_STATUS ,L.INDUSTRY_ID ,L.EST_REVENUE ,L.PERSON_ID , L.BO_ID_PERSON ,L.SALES_USER_NAME ,L.CURRENCY_CD ,L.CHNL_PARTNER_ID ,L.ALLIANC_PARTNER_ID ,L.REFERRED_DT ,L.ACCEPTED_DT ,L.NEXT_ACTIVITY_DT ,L.ADDRESS1 ,L.COUNTRY ,L.CITY ,L.STATE ,L.POSTAL ,L.BO_ID_CUST ,L.ROLE_TYPE_ID_CUST ,L.LEAD_REJECT_CD ,L.REJECTION_COMMENTS ,L.SALES_PRIORITY ,' ' ,' ' ,' ' ,' ' ,' ' ,L.BO_ID_CONTACT ,L.RC_BUS_UNIT ,L.CASE_ID ,L.AGREEMENT_CODE ,L.AGR_RENEWAL_NUM ,L.BO_ID_REFERRED_BY ,L.REFERRAL_FLG ,L.BO_ID_PARTNER ,L.BO_ID_PART_CONT ,L.PERSON_ID_PARTNER ,%subrec(RB_AUDIT_SBR, L) FROM PS_RSF_LEAD L WHERE L.RC_PROSPECT_SW = 'N'

  • Related Language Record: 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_RSF_NONVW

    3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

    Prompt Table: RSF_OPR_TREE_VW

    4 TERRITORY_ID Character(20) VARCHAR2(20) NOT NULL Territory ID
    5 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.

    Prompt Table: RSF_TREE_VW

    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    7 BO_ID_SITE Number(31,0) DECIMAL(31) NOT NULL Business Object ID
    8 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer Setid
    9 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    10 PROD_SETID Character(5) VARCHAR2(5) NOT NULL Product SET ID
    11 FULFILL_SETID Character(5) VARCHAR2(5) NOT NULL FULFIL
    12 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
    13 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    14 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    15 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
    16 LEAD_SOURCE_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation to identify the source of a Sales Lead.

    Prompt Table: RSF_LE_SRC_TBL

    17 BUSINESS_UNIT_RA Character(5) VARCHAR2(5) NOT NULL Business Unit
    18 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.
    19 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID
    20 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

    21 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
    22 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
    23 INDUSTRY_ID Character(30) VARCHAR2(30) NOT NULL Industry ID.

    Prompt Table: RSF_INDUSTRY

    24 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.
    25 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

    Prompt Table: RSF_USER_BU_VW

    26 BO_ID_PERSON Number(31,0) DECIMAL(31) NOT NULL Business Object ID
    27 SALES_USER_NAME Character(50) VARCHAR2(50) NOT NULL Sales User Name field
    28 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

    Prompt Table: CURRENCY_CD_TBL

    29 CHNL_PARTNER_ID Character(30) VARCHAR2(30) NOT NULL Unique identifier for a Channel Partner
    30 ALLIANC_PARTNER_ID Character(30) VARCHAR2(30) NOT NULL Alliance Partner
    31 REFERRED_DT Date(10) DATE Referred Date
    32 ACCEPTED_DT Date(10) DATE Accepted Date
    33 NEXT_ACTIVITY_DT Date(10) DATE Next Activity Date
    34 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    35 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    36 CITY Character(30) VARCHAR2(30) NOT NULL City
    37 STATE Character(6) VARCHAR2(6) NOT NULL State
    38 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    39 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    40 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

    Prompt Table: RSF_BO_ROLTY_VW

    41 LEAD_REJECT_CD Character(10) VARCHAR2(10) NOT NULL LEAD_REJECT_CD

    Prompt Table: RSF_LE_RJCT_A_V

    42 REJECTION_COMMENTS Long Character CLOB Rejection/Turnback Comments
    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 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
    45 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
    46 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.
    47 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL This field stores the Country Code values.
    48 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    49 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    50 RC_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    51 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.
    52 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement
    53 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)
    54 BO_ID_REFERRED_BY Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID of Referred By (for Partners).
    55 REFERRAL_FLG Character(1) VARCHAR2(1) NOT NULL Field used as an indicator for identifying referral type of leads.

    Y/N Table Edit

    Default Value: N

    56 BO_ID_PARTNER Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID of Partner Company.
    57 BO_ID_PART_CONT Signed Number(32,0) DECIMAL(31) NOT NULL This is the business object identifier for the partner contact.
    58 PERSON_ID_PARTNER Character(15) VARCHAR2(15) NOT NULL Partner Rep
    59 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    60 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    61 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    62 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    63 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.
    64 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time