BUSINESS_UNITRMA_IDRMA_LINE_NBRSEQ_NUMPrompt Table: %RECNAME_EDIT
Prompt Table: %RECNAME_EDIT2
RMA_LINE_PROMO(SQL Table) |
Index Back |
|---|---|
RMA Promotion DetailRMA Promotion Detail |
| # | 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 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | PPRC_PROMO_CD | Character(20) | VARCHAR2(20) NOT NULL |
Price Promotion Code
Prompt Table: %RECNAME_EDIT |
| 6 | MERCH_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Merchandising Type
Prompt Table: %RECNAME_EDIT2 |
| 7 | QTY_RETURNED | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Returned |
| 8 | OM_AMOUNT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Unit Adjustment |
| 9 | OM_AMOUNT_BSE | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Unit Adjustment (Base) |