RTV_HDR_VW2

(SQL View)
 Index Back

RTV (Supplier) Search View


SELECT DISTINCT H.VENDOR_SETID , H.VENDOR_ID , H.BUSINESS_UNIT , H.RTV_ID , H.BUYER_ID , A.NAME1 , A.VENDOR_NAME_SHORT , H.CARRIER_ID , H.FREIGHT_TERMS , L.PO_ID , L.RECEIVER_ID , L.RMA_ID , H.RTV_STATUS , H.SHIP_TYPE_ID FROM PS_RTV_HDR H ,PS_RTV_LN L ,PS_VENDOR A WHERE H.rtv_status IN ('O','S') AND H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.RTV_ID = L.RTV_ID AND H.VENDOR_SETID = A.SETID AND H.VENDOR_ID = A.VENDOR_ID

  • Related Language Record: RTV_HDR_VW2LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_VW

    3 BUSINESS_UNIT_RTV Character(5) VARCHAR2(5) NOT NULL RTV Business Unit
    4 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID

    Default Value: NEXT

    5 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
    6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    7 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    8 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

    Prompt Table: CARRIER_ID_VW

    9 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

    Prompt Table: FREIGHT_TERMS

    10 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    11 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
    12 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
    13 RTV_STATUS Character(1) VARCHAR2(1) NOT NULL Return Status
    C=Closed
    O=Open
    S=Shipped
    X=Cancelled

    Default Value: O

    14 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

    Prompt Table: SHIP_METHOD_VW