BUSINESS_UNIT_RMARMA_IDRMA_LINE_NBRBUSINESS_UNIT_ININTERUNIT_IDINTERUNIT_LINESEQ_NUMN=No
Y=Yes
INV_RECV_SER2VW(SQL View) |
Index Back |
|---|---|
Inv recv serial/lot view |
| SELECT ' ' , ' ' , 0 , s.business_unit , s.interunit_id , s.interunit_line , 0 , d.container_id , d.inv_lot_id , l.expiration_date , st.non_own_flag , 0 , d.qty_base , d.serial_id , conv.conversion_rate FROM ps_stor_loc_inv st , ps_demand_phys_inv d , ps_set_cntrl_rec sc , ps_inv_item_uom conv ,PS_IN_DEMAND s ,ps_lot_control_inv l WHERE s.in_fulfill_state >= '50' AND st.business_unit = d.business_unit AND st.storage_area = d.storage_area AND st.stor_level_1 = d.stor_level_1 AND st.stor_level_2 = d.stor_level_2 AND st.stor_level_3 = d.stor_level_3 AND st.stor_level_4 = d.stor_level_4 AND sc.recname = 'MASTER_ITEM_TBL' AND sc.setcntrlvalue = s.business_unit AND conv.setid = sc.setid AND conv.inv_item_id = s.inv_item_id AND conv.unit_of_measure = s.unit_measure_ship AND d.business_unit = s.business_unit AND d.demand_source = s.demand_source AND d.source_bus_unit = s.source_bus_unit AND d.order_no = s.order_no AND d.order_int_line_no = s.order_int_line_no AND d.sched_line_nbr = s.sched_line_nbr AND d.inv_item_id = s.inv_item_id AND d.business_unit = l.business_unit AND d.inv_item_id = l.inv_item_id AND d.inv_lot_id = l.inv_lot_id |
| # | 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 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 8 | CONTAINER_ID | Character(10) | VARCHAR2(10) NOT NULL | Container ID |
| 9 | LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 10 | EXPIRATION_DATE | Date(10) | DATE | Expiration Date |
| 11 | 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 |
| 12 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 13 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Quantity |
| 14 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 15 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |