TR_FEE

(SQL Table)
 Index Back

Treasury Fees

Used to store all fees for the PeopleSoft Treasury System.

  • Parent Record Of TR_FEE_SEQ TR_FEE_SEQ_C TR_FEE_SEQ_E TR_FEE_SEQ_S TR_FEE_SEQ_TMP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_GL_NONVW

    2 TR_SOURCE_CD Character(1) VARCHAR2(1) NOT NULL Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Accounting only
    B=BSP
    D=Deals
    E=Deal Fees
    F=Facility Fees
    H=Hedges
    I=Interest
    M=Deal: Estimated Maturity Accr
    N=Netted Deal
    O=Other
    P=Investment Pools
    R=EFT Fees
    S=Securities
    T=LC Fees
    W=EFT Requests
    X=Bank Transfers

    Prompt Table: TR_FEESOURCE_VW

    3 TR_SOURCE_ID Character(12) VARCHAR2(12) NOT NULL An internal work field that represents a unique identifier for records depicting a given treasury po

    Prompt Table: %EDIT_EVENT_ID