TR_WR_TMPL_VW

(SQL View)
 Index Back

Approved TR Wire Templates

View over the wire template table returning only those templates which have been approved.

SELECT SETID , TR_WR_TEMPLATE_ID , DESCR , REPETITVE_TRNFR_SW , REPETITVE_TRNFR_CD FROM PS_TR_WR_TEMPLATE WHERE APPR_STATUS = 'A' AND TRANSFER_CLASS = '2' AND ACTIVE_STATUS = 'A' AND ((PRENOTE_FLAG = 'Y' AND PRENOTE_STATUS = 'C') OR PRENOTE_FLAG = 'N') AND (TMPL_EXPIRATION_DT IS NULL OR (TMPL_EXPIRATION_DT >= %CurrentDateIn AND TMPL_EXPIRATION_DT IS NOT NULL))

  • Related Language Record: TR_WR_TMPL_VW_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 TR_WR_TEMPLATE_ID Character(12) VARCHAR2(12) NOT NULL Treasury Wires / Treasury Wire Templates This uniquely identifies templates within a Business Unit.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 REPETITVE_TRNFR_SW Character(1) VARCHAR2(1) NOT NULL Repetitive Transfer Switch for Transfer Templates

    Y/N Table Edit

    Default Value: N

    5 REPETITVE_TRNFR_CD Character(15) VARCHAR2(15) NOT NULL Repetitive Transfer Code assigned by customers Bank