FEE_CD_TBL

(SQL Table)
 Index Back

Fee Code Table

Fee codes for Treasury Fees

  • Related Language Record: FEE_CD_TBL_LNG

    • # 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 FEE_CD Character(5) VARCHAR2(5) NOT NULL A unique key identifier that describes a grouping of fee types.

    Prompt Table: FEE_CD_TBL

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 ACCTG_TREATMENT Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether a treasury facility fee is to be expensed or amortized over time or accrued over time
    A=Amortized
    C=Accrued
    E=Expensed

    Default Value: A

    5 ACCTG_TMPL_ID_CF Character(15) VARCHAR2(15) NOT NULL The treasury accounting template associated with a treasury facility fee that is to be expensed.

    Prompt Table: TRA_FAC_TMPL_VW

    6 ACCTG_TMPL_ID_POS Character(15) VARCHAR2(15) NOT NULL The treasury accounting template associated with a treasury facility fee that is to be amortized

    Prompt Table: TRA_FAC_TMPL_VW