TR_WR_FLDLST_VW

(SQL View)
 Index Back

View of Template Fields

View of all fields in the Wire Template panelgroup that may be identified as gray or non-gray. CMH : 02/17/99 : Changed logic so as to eliminate LIKE operator

SELECT FIELDNAME ,LBLTEXT ,RECNAME ,PNLNAME FROM PSPNLFIELD WHERE 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', 'EO_ADDRESS_SBP', 'BANK_ACCT_AC1_SEC', 'BANK_ACCT_AC2_SEC', 'BUSINESS_PHONE_SBP', 'STL_ADDENDA_SP', 'STL_ADDENDA2_SP') AND FIELDUSE IN (0, 8, 8192, 8200) AND FIELDTYPE NOT IN (2, 11, 12,21) AND FIELDNAME NOT IN ('TMPL_EXPIRATION_DT', 'REPETITVE_TRNFR_SW', 'REPETITVE_TRNFR_CD', 'DRAWDOWN_FLG', 'ACTIVE_STATUS', 'DESCR', ' ', 'PRENOTE_FLAG') AND ((FIELDNAME <> 'BANK_ID_QUAL') OR (FIELDNAME = 'BANK_ID_QUAL' AND RECNAME <> 'TR_WR_TO_SBR'))

  • Related Language Record: TR_WR_FLD_LNGVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    2 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    4 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).