PV_RTVLN_UPD_VW(SQL View) |
Index Back |
---|---|
RTV (Supplier) Line |
SELECT C.BUSINESS_UNIT , C.RTV_ID , C.ASSET_FLG , C.BUSINESS_UNIT_PO , C.BUSINESS_UNIT_RECV , C.DESCR254_MIXED , C.INV_FLG , C.INV_ITEM_ID , C.ITM_SETID , C.PO_ID , C.PRICE_PO , C.RECEIVER_ID , C.RECV_REQ , C.RETURN_ACTION , C.RETURN_REASON , C.RMA_ID , A.ENTERED_BY , A.ENTERED_DT , A.RETURN_SETID , A.RETURN_VENDOR , A.RTV_STATUS , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.BUYER_ID , B.NAME1 , COUNT(*) , SUM(C.QTY_LN_RETRN_VUOM) , SUM(C.QTY_LN_SHIP_VUOM) , ' ' FROM PS_RTV_HDR A , PS_VENDOR B , PS_RTV_LN C WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.RTV_ID = C.RTV_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT GROUP BY C.BUSINESS_UNIT , C.RTV_ID , C.ASSET_FLG , C.BUSINESS_UNIT_PO , C.BUSINESS_UNIT_RECV , C.DESCR254_MIXED , C.INV_FLG , C.INV_ITEM_ID ,C.ITM_SETID , C.PO_ID , C.PRICE_PO , C.RECEIVER_ID , C.RECV_REQ , C.RETURN_ACTION , C.RETURN_REASON , C.RMA_ID , A.ENTERED_BY , A.ENTERED_DT , A.RETURN_SETID , A.RETURN_VENDOR , A.RTV_STATUS , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC, A.BUYER_ID, B.NAME1, C.RTV_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | RTV_ID | Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |
3 | ASSET_FLG | Character(1) | VARCHAR2(1) NOT NULL | Assets Applicable |
4 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
5 | BUSINESS_UNIT_RECV | Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
6 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
7 | INV_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Inventory Applicable
N=No Y=Yes |
8 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
9 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
10 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
11 | PRICE_PO | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Purchase Order Price |
12 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
13 | RECV_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Receiving Required
N=Optional X=Do Not Y=Required |
14 | RETURN_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Return Action
C=Credit E=Exchange R=Replace |
15 | RETURN_REASON | Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
16 | RMA_ID | Character(10) | VARCHAR2(10) NOT NULL | RMA Number |
17 | ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL | Entered by |
18 | ENTERED_DT | Date(10) | DATE | Entered on |
19 | RETURN_SETID | Character(5) | VARCHAR2(5) NOT NULL | RTV (Supplier) SetID |
20 | RETURN_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Return to Vendor |
21 | RTV_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Return Status
C=Closed O=Open S=Shipped X=Cancelled |
22 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
23 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
24 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
25 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
26 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
27 | LINE_COUNT | Number(5,0) | INTEGER NOT NULL | Line Count |
28 | QTY_LN_RETRN_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Vndr Returned Qty |
29 | QTY_LN_SHIP_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Supp Shipped Qty |
30 | PV_NORECVROWS | Character(100) | VARCHAR2(100) NOT NULL | No Receipt Rows |