INV_RECV3_VW(SQL View) |
Index Back |
---|---|
Receipt IUT partials vs05/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 |