PMT_FRMT_PV_LNG

(SQL View)
Index Back

Format Definition Prop Lang

Format Definition Properties Lang

SELECT A.FORMAT_ID , A.PROP_CODE , B.LANGUAGE_CD , A.DESCR254 FROM PS_PMT_FORMAT_PROP A , PS_PMT_FRMT_PR_LNG B WHERE A.FORMAT_ID =B.FORMAT_ID AND A.PROP_CODE=B.PROP_CODE

  • Related Language Record for PMT_FRMT_PRP_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EFT_LAYOUT_CD Character(10) VARCHAR2(10) NOT NULL EFT Layout Code
    2 PROP_CODE Character(15) VARCHAR2(15) NOT NULL Property code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254