INV_RECV3_VW

(SQL View)
Index Back

Receipt IUT partials vs

05/27/04 PWF Change reference from sched_line_no to sched_line_nbr

SELECT DISTINCT ' ' , ' ' , 0 , business_unit_in , interunit_id , interunit_line , conversion_rate , descr , destin_bu , inv_item_id , lot_control , non_own_flag , ' ' , SUM(qty_receipt) , qty_shipped_conv , 0 , ' ' , ' ' , serial_control , source_bus_unit , unit_measure_std , unit_measure_ship , ' ' , qty_ship_base , config_code , transfer_cost , ' ' , ship_serial_cntrl FROM PS_INV_RECV2_VW GROUP BY business_unit_in , interunit_id , interunit_line , conversion_rate , descr , destin_bu , inv_item_id , lot_control , serial_control , non_own_flag , source_bus_unit , qty_shipped_conv , unit_measure_std , unit_measure_ship , qty_ship_base , config_code , transfer_cost , 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