CNTRCT_ACT_V1LV

(SQL View)
 Index Back

Contract Activity Supplier LVW


SELECT DISTINCT A.SETID , A.VENDOR_ID , C.LANGUAGE_CD , C.VENDOR_NAME_SHORT , C.NAME1 , C.NAME2 FROM PS_VENDOR A , PS_CNTRCT_HDR B , PS_VENDOR_LANG C WHERE B.VENDOR_SETID = A.SETID AND B.VENDOR_ID = A.VENDOR_ID AND B.VERSION_STATUS = 'C' AND C.SETID = A.SETID AND C.VENDOR_ID = A.VENDOR_ID

  • Related Language Record for CNTRCT_ACT_V1_V

    • # 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
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    6 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2