BUSINESS_UNIT_RMARMA_IDRMA_LINE_NBRSEQ_NUMRMA_RCV_RMLT_VW(SQL View) |
Index Back |
|---|---|
RMA Lot/serial view |
| select business_unit, rma_id, rma_line_nbr, seq_num, lot_id, qty, serial_id from PS_RMA_SERIAL_LOT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_RMA |
Character(5) | VARCHAR2(5) NOT NULL | RMA 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 | LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 6 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 7 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |