LEAD_IDNOTE_SEQ_NBRLANGUAGE_CDRB_LE_NOTE_LVW(SQL View) |
Index Back |
|---|---|
Lead notes viewRelated language record Used in the notes list for notes that are created on a lead. |
| SELECT A.LEAD_ID , A.NOTE_SEQ_NBR ,E.LANGUAGE_CD , D.DESCR50 , E.DESCRLONG FROM PS_RSF_LE_NOTE A , PS_RSF_LEAD B , PS_RSF_LE_CONTACTS C ,PS_RSF_LEAD_LANG D ,PS_RSF_LE_NOTE_LNG E WHERE A.LEAD_ID = B.LEAD_ID AND A.LEAD_ID = C.LEAD_ID AND C.PRIMARY_FLAG = 'Y' AND B.LEAD_STATUS NOT IN ('CD','CL','CO','RJ') AND B.LEAD_ID = D.LEAD_ID AND A.LEAD_ID = E.LEAD_ID AND E.LANGUAGE_CD = D.LANGUAGE_CD |
| # | 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 | NOTE_SEQ_NBR |
Number(6,0) | INTEGER NOT NULL | Note ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | DESCRLONG | Long Character | CLOB | Long Description |