BUSINESS_UNITRMA_IDRMA_LINE_NBRPrompt Table: %RECNAME_EDIT
Prompt Table: %RECNAME_EDIT2
TD_RMAPROMO_VW(SQL View) |
Index Back |
|---|---|
RMA Promotion DetailRMA Promotion Detail |
| SELECT A.BUSINESS_UNIT , A.RMA_ID , A.RMA_LINE_NBR , A.PPRC_PROMO_CD , A.MERCH_TYPE , SUM(A.QTY_RETURNED) FROM PS_RMA_LINE_PROMO A GROUP BY A.BUSINESS_UNIT , A.RMA_ID , A.RMA_LINE_NBR , A.PPRC_PROMO_CD , A.MERCH_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | RMA_ID |
Character(10) | VARCHAR2(10) NOT NULL | RMA Number |
| 3 | RMA_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | RMA Line Number |
| 4 | PPRC_PROMO_CD | Character(20) | VARCHAR2(20) NOT NULL |
Price Promotion Code
Prompt Table: %RECNAME_EDIT |
| 5 | MERCH_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Merchandising Type
Prompt Table: %RECNAME_EDIT2 |
| 6 | QTY_RETURNED | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Returned |