RSF_SLS_TSK_LVW

(SQL View)
 Index Back

View for Lead Task

Task view for Lead Component. Used by Lead Component.

SELECT B.LEAD_ID , A.TASK_ID ,D.LANGUAGE_CD , D.DESCR60 , D.DESCRLONG FROM PS_RB_TSK_TXN A , PS_RSF_LEAD B , PS_RB_TSK C , PS_RB_TSK_LANG D WHERE A.REL_TXN_SYNCID = B.SYNCID AND A.TASK_ID = C.TASK_ID AND A.TASK_ID = D.TASK_ID AND A.RB_TRANSACTION_ID = 'LEAD' AND A.TXN_MARKET = 'GBL'

  • Related Language Record for RSF_SLS_TSK_VW

    • # 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 TASK_ID Number(15,0) DECIMAL(15) NOT NULL TaskIID field. Key for RB_TSK record. Used by Task Management.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    5 DESCRLONG Long Character CLOB Long Description