BUSINESS_UNIT_RMARMA_IDRMA_LINE_NBRN=N
Y=Y
N=N
Y=Y
INV_RECV_RM2_VW(SQL View) |
Index Back |
|---|---|
RMA partial recvd |
| SELECT r.business_unit , r.rma_id , r.rma_line_nbr , conv.conversion_rate , m.descr , r.inv_item_id , m.lot_control , r.product_id , p.product_kit_flag , SUM(rcv.qty_inv_recv) , 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 FROM ps_inv_item_uom conv , PS_MASTER_ITEM_TBL m , ps_prod_item p , ps_inv_recv_ln rcv , ps_rma_line r , ps_set_cntrl_rec sc WHERE r.rma_line_status = 'O' AND sc.recname = 'PROD_ITEM' AND sc.setcntrlvalue = r.business_unit AND p.setid = sc.setid AND p.product_id = r.product_id AND p.product_kit_flag <> 'Y' AND m.setid = p.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 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.product_id, p.product_kit_flag, r.return_fr_cust_id, r.return_to_ibu, m.serial_control, m.unit_measure_std, r.unit_of_measure, r.qty_returned, r.distrib_type, r.return_from_bu |
| # | 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 | PRODUCT_KIT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Product Kit |
| 10 | QTY_RECEIPT | Number(16,4) | DECIMAL(15,4) NOT NULL | Receipt Quantity |
| 11 | QTY_RETURNED | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Returned |
| 12 | RETURN_FR_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Return From Cust ID |
| 13 | RETURN_TO_IBU | Character(5) | VARCHAR2(5) NOT NULL | Return To IBU |
| 14 | SERIAL_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Serial Control
N=N Y=Y |
| 15 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 16 | UOM_QTY_RETURN | Character(3) | VARCHAR2(3) NOT NULL | UOM of Qty Returned |
| 17 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Distrib. Type |
| 18 | RETURN_FROM_BU | Character(5) | VARCHAR2(5) NOT NULL | Return From Location |