RSF_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 | Character(15) | VARCHAR2(15) NOT NULL |
Opportunity ID
Prompt Table: RSF_OPPORTUNITY |
|
2 | 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 | 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 |