JRNL_CODE_VW1L

(SQL View)
Index Back

Journal Code View


SELECT DISTINCT A.JRNL_CODE , B.LANGUAGE_CD , B.DESCR FROM PS_JRNL_CODE_TBL A , PS_JRNL_CODE_LANG B WHERE A.JRNL_CODE = B.JRNL_CODE

  • Related Language Record for JRNL_CODE_VW1
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JRNL_CODE Character(8) VARCHAR2(8) NOT NULL Journal Code
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description