FA_FEE_MUL_TIER (SQL Table)	Index Back
Tier Fee Structure Detail Record quantities and prices for multiple tiers when calculating service charge with calculation type = "T".

FA_FEE_MUL_TIER

(SQL Table)

Tier Fee Structure Detail

Record quantities and prices for multiple tiers when calculating service charge with calculation type = "T".

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

3 FA_FEE_STRUCT_CD Character(10) VARCHAR2(10) NOT NULL Structure Code for Fee Analysis

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

5 FA_FEE_CODE Character(20) VARCHAR2(20) NOT NULL Fee code mapped to Bank Fee code used for Fee Analysis.
Prompt Table: FA_FEE_CD_TBL

6 FA_FEE_MT_FROM Number(10,0) DECIMAL(10) NOT NULL This is a number for calculating the service charge with calculation type is 'T'.

7 FA_FEE_MT_TO Number(10,0) DECIMAL(10) NOT NULL This is a number for calculating the service charge with calculation type is 'T'.

8 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
3	FA_FEE_STRUCT_CD	Character(10)	VARCHAR2(10) NOT NULL	Structure Code for Fee Analysis
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	FA_FEE_CODE	Character(20)	VARCHAR2(20) NOT NULL	Fee code mapped to Bank Fee code used for Fee Analysis. Prompt Table: FA_FEE_CD_TBL
6	FA_FEE_MT_FROM	Number(10,0)	DECIMAL(10) NOT NULL	This is a number for calculating the service charge with calculation type is 'T'.
7	FA_FEE_MT_TO	Number(10,0)	DECIMAL(10) NOT NULL	This is a number for calculating the service charge with calculation type is 'T'.
8	PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This is price per unit for calculating the service charge.