RMA_LNPRMO_TEO2(SQL Table) |
Index Back |
|---|---|
RMA Promotion DetailRMA Promotion Detail |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 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 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 6 | PPRC_PROMO_CD | Character(20) | VARCHAR2(20) NOT NULL |
Price Promotion Code
Prompt Table: %RECNAME_EDIT |
| 7 | MERCH_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Merchandising Type
Prompt Table: %RECNAME_EDIT2 |
| 8 | QTY_RETURNED | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Returned |
| 9 | OM_AMOUNT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Unit Adjustment |
| 10 | OM_AMOUNT_BSE | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Unit Adjustment (Base) |
| 11 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |