RMA_DATEBUSINESS_UNITRMA_IDRMA_LINE_NBRSOLD_TO_CUST_IDPrompt Table: %EDITTABLE5
PRODUCT_IDPPRC_PROMO_CDPrompt Table:
PPRC_PROMO_TBL
Set Control Field: BUSINESS_UNIT
LANGUAGE_CDRMA_PRMCDXSHLVW(SQL View) |
Index Back |
|---|---|
RMA Promo Code ViewDummy view used in dynamic SQLs RMA_PRMCDCSHCVW, RMA_PRMCDCSHLVW, RMA_PRMCDNSHCVW and RMA_PRMCDNSHLVW. |
| SELECT %CurrentDateIn , ' ' , ' ' , 0 , ' ' , ' ' , ' ' , ' ' FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RMA_DATE |
Date(10) | DATE | RMA Date |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | RMA_ID |
Character(10) | VARCHAR2(10) NOT NULL | RMA Number |
| 4 | RMA_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | RMA Line Number |
| 5 | SOLD_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table: %EDITTABLE5 |
| 6 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 7 | PPRC_PROMO_CD |
Character(20) | VARCHAR2(20) NOT NULL |
Price Promotion Code
Prompt Table:
PPRC_PROMO_TBL
|
| 8 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |