RTV_HDR_SRCH(SQL View) |
Index Back |
|---|---|
RTV (Supplier) Search View |
| SELECT DISTINCT H.BUSINESS_UNIT , H.RTV_ID , H.BUYER_ID ,O.OPRDEFNDESC , H.CARRIER_ID , H.FREIGHT_TERMS , L.BUSINESS_UNIT_PO , L.PO_ID , L.BUSINESS_UNIT_RECV , 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 ,PSOPRDEFN O WHERE H.rtv_status IN ('O','S') AND H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.RTV_ID = L.RTV_ID AND H.BUYER_ID = O.OPRID |
| # | 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
Prompt Table: BUYER_ACTIVE_VW |
| 4 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 5 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table: CARRIER_ID_VW |
| 6 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table: FREIGHT_TERMS |
| 7 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL |
PO Business Unit
Prompt Table: RECV_BU_PO_VW |
| 8 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Purchase Order
Prompt Table: RECV_PO_HDR_VW |
| 9 | BUSINESS_UNIT_RECV | Character(5) | VARCHAR2(5) NOT NULL |
Receiving Business Unit
Prompt Table: BUS_UNIT_PM_VW |
| 10 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Receiver number
Prompt Table: RECV_HDR_BU_VW |
| 11 | RMA_ID | Character(10) | VARCHAR2(10) NOT NULL |
RMA Number
Prompt Table: RTV_RMA_VW |
| 12 | RTV_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Return Status
C=Closed O=Open S=Shipped X=Cancelled Default Value: O |
| 13 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table: SHIP_METHOD_VW |
| 14 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_VW |
| 15 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |