PV_RTV_HDR_SRCH(SQL View) |
Index Back |
|---|---|
RTV (Supplier) Search View |
| Select DISTINCT H.BUSINESS_UNIT, H.RTV_ID, H.BUYER_ID, H.CARRIER_ID, H.FREIGHT_TERMS, L.PO_ID, L.RECEIVER_ID, L.RMA_ID, H.RTV_STATUS, H.SHIP_TYPE_ID, H.VENDOR_ID, H.VENDOR_SETID from PS_RTV_HDR H, PS_RTV_LN L where H.rtv_status in ('O','S') AND H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.RTV_ID = L.RTV_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PM.BUSINESS_UNIT_RECV Prompt Table: SP_BU_PM_NONVW |
| 2 | RTV_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Return To Vendor ID
Default Value: NEXT |
| 3 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 4 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table: CARRIER_ID_VW |
| 5 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table: FREIGHT_TERMS |
| 6 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 7 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 8 | RMA_ID | Character(10) | VARCHAR2(10) NOT NULL | RMA Number |
| 9 | RTV_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Return Status
C=Closed O=Open S=Shipped X=Cancelled Default Value: O |
| 10 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table: SHIP_METHOD_VW |
| 11 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_VW |
| 12 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |