BUSINESS_UNIT_RMARMA_IDRMA_LINE_NBRN=N
Y=Y
N=N
Y=Y
INV_RECVINR2_VW(SQL View) |
Index Back |
|---|---|
RMA (IN) partial recv |
| SELECT r.business_unit , r.rma_id , r.rma_line_nbr , conv.conversion_rate , m.descr , r.inv_item_id , m.lot_control , ' ' , SUM(rcv.qty_std) , r.qty_returned , r.return_fr_cust_id , r.return_to_ibu , m.serial_control , m.unit_measure_std , r.unit_of_measure , r.distrib_type , r.return_from_bu , m.ship_serial_cntrl FROM ps_inv_item_uom conv , PS_MASTER_ITEM_TBL m , ps_inv_recv_ln rcv , ps_rma_line r , ps_rma_header h , ps_set_cntrl_rec sc WHERE r.rma_line_status = 'O' AND sc.recname = 'MASTER_ITEM_TBL' AND sc.setcntrlvalue = r.business_unit AND m.setid = sc.setid AND m.inv_item_id = r.inv_item_id AND conv.setid = m.setid AND conv.inv_item_id = m.inv_item_id AND conv.unit_of_measure = r.unit_of_measure AND rcv.source_bus_unit = r.business_unit AND rcv.rma_id = r.rma_id AND rcv.rma_line_nbr = r.rma_line_nbr AND r.business_unit = h.business_unit AND r.rma_id = h.rma_id AND h.rma_type = 'I' GROUP BY r.business_unit, r.rma_id, r.rma_line_nbr, conv.conversion_rate, m.descr, r.inv_item_id, m.lot_control, r.return_fr_cust_id, r.return_to_ibu, m.serial_control, m.unit_measure_std, r.unit_of_measure, r.distrib_type, r.qty_returned, r.return_from_bu, m.ship_serial_cntrl |
| # | 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 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 7 | LOT_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Lot Control
N=N Y=Y |
| 8 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 9 | QTY_RECEIPT | Number(16,4) | DECIMAL(15,4) NOT NULL | Receipt Quantity |
| 10 | QTY_RETURNED | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Returned |
| 11 | RETURN_FR_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Return From Cust ID |
| 12 | RETURN_TO_IBU | Character(5) | VARCHAR2(5) NOT NULL | Return To IBU |
| 13 | SERIAL_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Serial Control
N=N Y=Y |
| 14 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 15 | UOM_QTY_RETURN | Character(3) | VARCHAR2(3) NOT NULL | UOM of Qty Returned |
| 16 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Distrib. Type |
| 17 | RETURN_FROM_BU | Character(5) | VARCHAR2(5) NOT NULL | Return From Location |
| 18 | SHIP_SERIAL_CNTRL | Character(1) | VARCHAR2(1) NOT NULL | Shipping Serial Control |