PO_RTV_RC_VW(SQL View) |
Index Back |
---|---|
RTV Header Line |
SELECT H.BUSINESS_UNIT , H.BUYER_ID , H.VENDOR_SETID , H.VENDOR_ID , L.PO_ID , H.RTV_ID , H.RTV_STATUS , L.RTV_LN_NBR , L.INV_ITEM_ID , L.DESCR254_MIXED , L.RETURN_ACTION , L.RETURN_REASON , L.QTY_LN_RETRN_VUOM , L.UNIT_MEASURE_VNDR , L.RTV_LN_STATUS , L.RMA_ID , L.BUSINESS_UNIT_PO , L.BUSINESS_UNIT_RECV , L.RECEIVER_ID FROM PS_RTV_HDR H , PS_RTV_LN L WHERE H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.RTV_ID = L.RTV_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
2 | Character(30) | VARCHAR2(30) NOT NULL | Buyer | |
3 | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID | |
4 | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier | |
5 | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order | |
6 | RTV_ID | Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |
7 | RTV_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Return Status
C=Closed O=Open S=Shipped X=Cancelled |
8 | RTV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Return To Vendor Line |
9 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
10 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
11 | RETURN_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Return Action
C=Credit E=Exchange R=Replace |
12 | RETURN_REASON | Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
13 | QTY_LN_RETRN_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Vndr Returned Qty |
14 | UNIT_MEASURE_VNDR | Character(3) | VARCHAR2(3) NOT NULL | Vendor Unit of Measure |
15 | RTV_LN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
RTV Line Status
C=Closed O=Open S=Shipped X=Cancelled |
16 | RMA_ID | Character(10) | VARCHAR2(10) NOT NULL | RMA Number |
17 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
18 | BUSINESS_UNIT_RECV | Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
19 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |