BUSINESS_UNIT_RMARMA_IDRMA_LINE_NBRBUSINESS_UNIT_ININTERUNIT_IDINTERUNIT_LINEN=N
Y=Y
N=No
Y=Yes
N=N
Y=Y
INV_RECV2_VW(SQL View) |
Index Back |
|---|---|
Receipt IUT partials vs05/27/04 PWF Change reference from sched_line_no to sched_line_nbr 29/03/2013 VID PRJ16387113 - Non own flag value populates from ps_demand_phys_inv instead of ps_bu_items_inv. |
| SELECT DISTINCT ' ' , ' ' , 0 , inv.business_unit , inv.interunit_id , inv.interunit_line , conv.conversion_rate , itm.descr , inv.destin_bu , itm.inv_item_id , itm.lot_control , phys.non_own_flag , ' ' , rcv.qty_std , SUM(phys.qty_shipped_conv) , 0 , ' ' , ' ' , itm.serial_control , inv.source_bus_unit , itm.unit_measure_std , inv.unit_measure_ship , ' ' , inv.qty_ship_base , inv.config_code , inv.transfer_cost , rcv.receiver_id , itm.ship_serial_cntrl FROM PS_MASTER_ITEM_TBL itm , ps_inv_recv_ln rcv , ps_in_demand inv , ps_demand_phys_inv phys , ps_inv_item_uom conv , ps_set_cntrl_rec sc WHERE inv.interunit_id <> ' ' AND sc.setcntrlvalue = inv.business_unit AND sc.recname = 'MASTER_ITEM_TBL' AND itm.setid = sc.setid AND inv.inv_item_id = itm.inv_item_id AND inv.interunit_flg = 'Y' AND inv.interunit_stat = 'I' AND inv.in_fulfill_state BETWEEN '60' AND '70' AND conv.setid = itm.setid AND conv.inv_item_id = itm.inv_item_id AND conv.unit_of_measure = inv.unit_measure_ship AND rcv.source_bus_unit = inv.business_unit AND rcv.interunit_id = inv.interunit_id AND rcv.interunit_line = inv.interunit_line AND phys.business_unit = inv.business_unit AND phys.demand_source = inv.demand_source AND phys.source_bus_unit = inv.source_bus_unit AND phys.order_no = inv.order_no AND phys.order_int_line_no = inv.order_int_line_no AND phys.sched_line_nbr = inv.sched_line_nbr AND phys.demand_line_no = inv.demand_line_no AND phys.inv_item_id = inv.inv_item_id AND phys.qty_picked > 0 AND rcv.non_own_flag = phys.non_own_flag GROUP BY inv.business_unit, inv.interunit_id, inv.interunit_line, conv.conversion_rate, itm.descr, inv.destin_bu, itm.inv_item_id, itm.lot_control, itm.serial_control, phys.non_own_flag, inv.source_bus_unit, itm.unit_measure_std, inv.unit_measure_ship, inv.qty_ship_base, inv.config_code, inv.transfer_cost, rcv.qty_std, rcv.receiver_id, itm.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 | 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 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | DESTIN_BU | Character(5) | VARCHAR2(5) NOT NULL | Destination Unit |
| 10 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 11 | LOT_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Lot Control
N=N Y=Y |
| 12 | NON_OWN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No Y=Yes |
| 13 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 14 | QTY_RECEIPT | Number(16,4) | DECIMAL(15,4) NOT NULL | Receipt Quantity |
| 15 | QTY_SHIPPED_CONV | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Shipped |
| 16 | QTY_RETURNED | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Returned |
| 17 | RETURN_FR_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Return From Cust ID |
| 18 | RETURN_TO_IBU | Character(5) | VARCHAR2(5) NOT NULL | Return To IBU |
| 19 | SERIAL_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Serial Control
N=N Y=Y |
| 20 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 21 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 22 | UNIT_MEASURE_SHIP | Character(3) | VARCHAR2(3) NOT NULL | Shipment Unit of Measure |
| 23 | UOM_QTY_RETURN | Character(3) | VARCHAR2(3) NOT NULL | UOM of Qty Returned |
| 24 | QTY_SHIP_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Ship Base |
| 25 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 26 | TRANSFER_COST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Transfer Price |
| 27 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 28 | SHIP_SERIAL_CNTRL | Character(1) | VARCHAR2(1) NOT NULL | Shipping Serial Control |