OPPORTUNITY_IDPrompt Table: RSF_OPPORTUNITY
ORDER_NOLANGUAGE_CDRSF_OPPQTE_HDLN(SQL View) |
Index Back |
|---|---|
Opportunity QuotesOpportunity Quote/Sales Order table |
| SELECT A.OPPORTUNITY_ID ,%Substring(B.CAPTURE_ID , 1 , 10) ,A.LANGUAGE_CD ,A.DESCR50 ,A.DESCR50 FROM PS_RO_RSF_LOPP_LVW A , PS_RO_RSF_LOPPY_VW B WHERE A.OPPORTUNITY_ID=B.OPPORTUNITY_ID AND A.LEAD_ID=B.LEAD_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPPORTUNITY_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Opportunity ID
Prompt Table: RSF_OPPORTUNITY |
| 2 | ORDER_NO |
Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 5 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |