FA_FEE_DEAL_VW

(SQL View)
 Index Back

Deal Fee View

View over the fee code table to extract Deal Fees

SELECT setid ,FA_FEE_CODE , DESCR FROM PS_FA_FEE_CD_TBL WHERE FA_FEE_DEAL_IND = 'Y' AND (ACCTG_TMPL_ID_CF <> ' ' OR ACCTG_TMPL_ID_POS <> ' ')

  • Related Language Record: FA_FEE_VW_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 FA_FEE_CODE Character(20) VARCHAR2(20) NOT NULL Fee code mapped to Bank Fee code used for Fee Analysis.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description