BUSINESS_UNIT_PORTV_IDRTV_LN_NBRRTV_DISTRIB_NUMC=Closed
O=Open
S=Shipped
X=Cancelled
N=No
Y=Yes
INV_RTV_VW(SQL View) |
Index Back |
|---|---|
Inventory RTV Selection View - |
| SELECT C.BUSINESS_UNIT , C.RTV_ID , C.RTV_LN_NBR , C.RTV_DISTRIB_NUM , B.INV_ITEM_ID , B.ITM_SETID , C.LOT_ID , C.SERIAL_ID , (C.QTY_AM_RETRN_SUOM - C.QTY_AM_SHIP_SUOM) , C.QTY_AM_RETRN_SUOM , C.QTY_AM_RETRN_VUOM , B.UNIT_MEASURE_STD , B.CONVERSION_RATE , C.BUSINESS_UNIT_IN , C.BUSINESS_UNIT_RECV , C.RECV_SHIP_SEQ_NBR , C.REQUEST_DATE , A.VENDOR_SETID , A.VENDOR_ID , B.RMA_ID , B.RMA_LINE_NBR , C.SHIP_DATE , B.SHIP_TYPE_ID , C.RTV_DIST_STATUS , C.QTY_AM_SHIP_SUOM , C.QTY_AM_SHIP_VUOM , B.UNIT_MEASURE_VNDR , A.CARRIER_ID , B.PRICE_PO , B.IST_TXN_FLG FROM PS_RTV_HDR A , PS_RTV_LN B , PS_RTV_LN_DISTRIB C WHERE A.RTV_STATUS = 'O' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RTV_ID = B.RTV_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.RTV_ID = C.RTV_ID AND B.RTV_LN_NBR = C.RTV_LN_NBR AND B.INV_FLG = 'Y' AND B.RTV_LN_STATUS = 'O' AND B.DISPOSITION_TYPE = '1' AND C.RTV_DIST_STATUS = 'O' AND C.QTY_AM_RETRN_SUOM > C.QTY_AM_SHIP_SUOM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_PO |
Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 2 | RTV_ID |
Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |
| 3 | RTV_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Return To Vendor Line |
| 4 | RTV_DISTRIB_NUM |
Number(5,0) | INTEGER NOT NULL | RTV Distribution Number |
| 5 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 7 | LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 8 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 9 | QTY_RETRN_INV | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Inventory Return Qty |
| 10 | QTY_AM_RETRN_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Std Returned Qty |
| 11 | QTY_AM_RETRN_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Vendor Returned Qty |
| 12 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 13 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 14 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 15 | BUSINESS_UNIT_RECV | Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 16 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 17 | REQUEST_DATE | Date(10) | DATE | Requested |
| 18 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 19 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 20 | RMA_ID | Character(10) | VARCHAR2(10) NOT NULL | RMA Number |
| 21 | RMA_LINE_NBR | Number(5,0) | INTEGER NOT NULL | RMA Line Number |
| 22 | SHIP_DATE | Date(10) | DATE | Item Shipping Date |
| 23 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
| 24 | RTV_DIST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
RTV Distribution Status
C=Closed O=Open S=Shipped X=Cancelled |
| 25 | QTY_AM_SHIP_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Returned Base |
| 26 | QTY_AM_SHIP_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Supplier Shipped Qty |
| 27 | UNIT_MEASURE_VNDR | Character(3) | VARCHAR2(3) NOT NULL | Vendor Unit of Measure |
| 28 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
| 29 | PRICE_PO | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Purchase Order Price |
| 30 | IST_TXN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Transaction Flag
N=No Y=Yes |