BUSINESS_UNIT_RMARMA_IDRMA_LINE_NBRBUSINESS_UNIT_ININTERUNIT_IDINTERUNIT_LINESEQ_NUMINV_RECVINLT_VW(SQL View) |
Index Back |
|---|---|
RMA Lot/serial view-IN only |
| SELECT r.business_unit , r.rma_id , r.rma_line_nbr , ' ' , ' ' , 0 , r.seq_num , r.lot_id , r.qty , %Truncate(%DecMult(r.qty,(%DecMult(conv.conversion_rate,1))),4) , r.serial_id FROM ps_set_cntrl_rec sc , ps_inv_item_uom conv , ps_rma_line rl , PS_RMA_SERIAL_LOT r WHERE sc.recname = 'MASTER_ITEM_TBL' AND sc.setcntrlvalue = r.business_unit AND conv.setid = sc.setid AND conv.inv_item_id = rl.inv_item_id AND conv.unit_of_measure = rl.unit_of_measure AND rl.business_unit = r.business_unit AND rl.rma_id = r.rma_id AND rl.rma_line_nbr = r.rma_line_nbr AND rl.product_id = ' ' |
| # | 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 | BUSINESS_UNIT_IN |
Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 5 | INTERUNIT_ID |
Character(10) | VARCHAR2(10) NOT NULL | InterUnit Order ID |
| 6 | INTERUNIT_LINE |
Number(5,0) | INTEGER NOT NULL | InterUnit Order Line |
| 7 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 8 | LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 9 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 10 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Quantity |
| 11 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |