BUSINESS_UNIT_RMARMA_IDRMA_LINE_NBRBUSINESS_UNIT_ININTERUNIT_IDINTERUNIT_LINEN=N
Y=Y
N=No
Y=Yes
N=N
Y=Y
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 |