TRA_PL_TMPL_VW

(SQL View)
 Index Back

TR Acctg Int Tmpl Prompt Tbl

Prompt View for Treasury Accounting Templates that are applicable for Investment Pools.

SELECT SETID , ACCTG_TMPL_ID , DESCR60 , SOURCE_TYPE FROM PS_TRA_TMPL_HDR WHERE SOURCE_TYPE = 'P' AND ACCTG_TMPL_STATUS = 'A'

  • Related Language Record: TRA_TMPL_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 ACCTG_TMPL_ID Character(15) VARCHAR2(15) NOT NULL A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits.
    3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    4 SOURCE_TYPE Character(1) VARCHAR2(1) NOT NULL Categorizes Treasury Accounting Templates according to the type of transaction they process (badly named field). Keep this field in sync with TR_SOURCE_CD and TRA_SOURCE_CD. 01/11/99 - CMH - Removed 'A' from XLAT, will use 'W' for TR Wires 11/20/99 - MC - Added 'H' for Hedge Accounting 06/29/00 - RV - Changed 'F' to Fees. Fees now cover Deal Fees, LC Fees, Facility Fees, etc. 09/08/00 - RV - Changed Treasury Wires to EFT Requests. 07/15/04 - SD - Added 'P' for Investment Pools
    B=BSP
    D=Deals
    F=Fees
    H=Hedge Accounting
    I=Interest
    P=Investment Pools
    W=EFT Requests