OPPORTUNITY_IDPrompt Table: RSF_OPPORTUNITY
ORDER_NOQUO=Quote
SO=Order
Prompt Table: CURRENCY_CD_TBL
RSF_OPP_QT_X_VW(SQL View) |
Index Back |
|---|---|
OppQuote left join to OT xlatFor Opportunity REPORT - RSF1005 , the sub-report on quote can now use left join to obtain name for order type field value. |
| SELECT A.OPPORTUNITY_ID , A.ORDER_NO , A.CAPTURE_TYPE_CD , A.ROW_ADDED_DTTM , A.QUOTE_EXPIRE_DT , A.COST , A.CURRENCY_CD , D.XLATSHORTNAME FROM PS_RSF_OPP_QTE_HDR A , PSXLATITEM D WHERE A.OPPORTUNITY_ID <> ' ' AND A.CAPTURE_TYPE_CD = D.FIELDVALUE (+) AND D.FIELDNAME = 'CAPTURE_TYPE_CD' AND %EffdtCheck(PSXLATITEM B, D, %CurrentDateIn) |
| # | 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 | CAPTURE_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Capture Type
QUO=Quote SO=Order |
| 4 | QUOTE_DATETIME | DateTime(26) | TIMESTAMP | When quote was added to record |
| 5 | QUOTE_EXPIRE_DT | Date(10) | DATE | Quote Expire Date |
| 6 | COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Prompt Table: CURRENCY_CD_TBL |
| 8 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |