TR_WR_FLD_LNGVW

(SQL View)
Index Back

View of Template Fields


SELECT F.FIELDNAME ,R.LANGUAGE_CD ,R.LONGNAME FROM PSPNLFIELD F ,PSDBFLDLABLLANG R WHERE R.FIELDNAME=F.FIELDNAME AND R.LABEL_ID=F.LABEL_ID AND F.PNLNAME IN ('TR_WR_TEMPLATE_FR', 'TR_WR_TEMPLATE_TO', 'TR_WR_TO_SBP', 'TR_INTR_TBL_SEC', 'TR_EFT_OPT_SEC', 'TR_WR_DESC_SEC' , 'TR_WR_ALTC1_SEC', 'TR_WR_ALTC2_SEC', 'ADDRESS_SBP', 'BANK_ACCT_AC1_SEC', 'BANK_ACCT_AC2_SEC', 'BUSINESS_PHONE_SBP', 'STL_ADDENDA_SP', 'STL_ADDENDA2_SP', 'TRP_POOL_WR_SEC') AND F.FIELDUSE IN (0, 8, 8192, 8200) AND F.FIELDTYPE NOT IN (2, 11, 12) AND F.FIELDNAME NOT IN ('TMPL_EXPIRATION_DT', 'REPETITVE_TRNFR_SW', 'REPETITVE_TRNFR_CD', 'DRAWDOWN_FLG', 'ACTIVE_STATUS', 'DESCR', ' ', 'PRENOTE_FLAG')

  • Related Language Record for TR_WR_FLDLST_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text