VNDRNAME_SES_VW

(SQL View)
 Index Back

Supplier Name PTSF view

Supplier Name PTSF view

SELECT A.SETID , A.VENDOR_ID , A.NAME1 , A.NAME2 , A.VENDOR_NAME_SHORT , R1.NAME1 , R1.NAME2 , R1.VENDOR_NAME_SHORT , I1.NAME1 , I1.NAME2 , I1.VENDOR_NAME_SHORT , C1.NAME1 , C1.NAME2 , C1.VENDOR_NAME_SHORT , C2.NAME1 , C2.NAME2 , C2.NAME3 , C2.NAMESHORT , %Cast(A.NAME1 %Concat ' ' %Concat A.NAME2 %Concat ' ' %Concat A.VENDOR_NAME_SHORT %Concat ' ' %Concat R1.NAME1 %Concat ' ' %Concat R1.NAME2 %Concat ' ' %Concat R1.VENDOR_NAME_SHORT %Concat ' ' %Concat I1.NAME1 %Concat ' ' %Concat I1.NAME2 %Concat ' ' %Concat I1.VENDOR_NAME_SHORT %Concat ' ' %Concat C1.NAME1 %Concat ' ' %Concat C1.NAME2 %Concat ' ' %Concat C1.VENDOR_NAME_SHORT , LONG , CHARACTER) FROM PS_VENDOR A LEFT OUTER JOIN PS_VENDOR R1 ON R1.SETID = A.REMIT_SETID AND R1.VENDOR_ID = A.REMIT_VENDOR LEFT OUTER JOIN PS_VENDOR I1 ON I1.SETID = A.SETID AND I1.VENDOR_ID = A.PRIMARY_VENDOR LEFT OUTER JOIN PS_VENDOR C1 ON C1.SETID = A.CORPORATE_SETID AND C1.VENDOR_ID = A.CORPORATE_VENDOR LEFT OUTER JOIN PS_CUSTOMER C2 ON C2.SETID = A.CUST_SETID AND C2.CUST_ID = A.CUST_ID

  • Related Language Record: VNDRNAM_SES_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SETID_TBL

    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    4 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    5 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    6 NAME1_UPPER Character(40) VARCHAR2(40) NOT NULL Uppercase Name
    7 NAME2_UPPER Character(40) VARCHAR2(40) NOT NULL Uppercase Name
    8 VENDOR_NAME_SH_PUR Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    9 NAME1_VNDR Character(40) VARCHAR2(40) NOT NULL Vendor Name
    10 NAME2_VNDR Character(40) VARCHAR2(40) NOT NULL Vendor Name
    11 VENDOR_NAME_SHORT2 Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    12 NAME1_CORP Character(40) VARCHAR2(40) NOT NULL Corporate Vendor Name1
    13 NAME2_CORP Character(40) VARCHAR2(40) NOT NULL Customer Name2
    14 VENDOR_NAME_CORP Character(14) VARCHAR2(14) NOT NULL corporate vendor name short
    15 NAME1_CUST Character(40) VARCHAR2(40) NOT NULL Customer Name1
    16 NAME2_CUST Character(40) VARCHAR2(40) NOT NULL Customer Name2
    17 NAME3 Character(40) VARCHAR2(40) NOT NULL Name 3
    18 VENDOR_NAME_CUST Character(14) VARCHAR2(14) NOT NULL customer vendor name short
    19 SES_VN_NAME_CONCAT Long Character CLOB All Vendor Names