BAS_CMP_IMG_LVW

(SQL View)
 Index Back

Image Prompt - Lang


SELECT DISTINCT A.CONTNAME , B.LANGUAGE_CD , B.DESCR FROM %Table(PSCONTDEFN) A , %Table(PSCONTDEFNLANG) B WHERE A.CONTNAME =B.CONTNAME AND A.ALTCONTNUM = B.ALTCONTNUM AND A.CONTTYPE = 1

  • Related Language Record for BAS_CMP_IMG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BAS_CMP_LOGO_IMGNM Character(30) VARCHAR2(30) NOT NULL Image

    Prompt Table: PTBR_IMG_PVW

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description