FA_STMT_SVCDTL (SQL Table)	Index Back
Fee Analysis Statement/Service Bank Fee Analysis Statement Service Detail Section RJB 4/28/2000 Added Currency_CD as Currency Control field for following: FA_BNK_SVC_CHG FA_BNK_BAL_EQUIV FA_CALC_SVC_CHG FA_CALC_BAL_EQUIV RJB 9/21/2000 - Added Reference Number key field to allow multiple lines of same fee code with different reference numbers.

FA_STMT_SVCDTL

(SQL Table)

Fee Analysis Statement/Service

Bank Fee Analysis Statement Service Detail Section RJB 4/28/2000 Added Currency_CD as Currency Control field for following: FA_BNK_SVC_CHG FA_BNK_BAL_EQUIV FA_CALC_SVC_CHG FA_CALC_BAL_EQUIV RJB 9/21/2000 - Added Reference Number key field to allow multiple lines of same fee code with different reference numbers.

Parent record: FA_STMT_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
Prompt Table: BANK_ID_VW

2 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

3 FA_FEE_CYCLE_NUM Character(10) VARCHAR2(10) NOT NULL RJB 4/5/01 Added Analysis ID to label

4 FA_FEE_CD_SEQ_NUM Number(9,0) DECIMAL(9) NOT NULL This sequence number is used for preserving the order in the bank statement.

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 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
Default Value: 0

7 REFERENCE_NUM Character(30) VARCHAR2(30) NOT NULL Reference

8 FA_BNK_VOLUME Signed Number(16,0) DECIMAL(15) NOT NULL Volume count of each sevice item.

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

10 FA_BNK_SVC_CHG Signed Number(28,3) DECIMAL(26,3) NOT NULL Field which refers to the total service charge (Price * Quantity) levied by a bank.

11 FA_FEE_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Used to determine how the fee will be calculated. Driven off translates since we should support a finite amount of calc types
B=Base Fee
D=Discounted Price
F=Flat Fee
H=Threshold Price
M=Minimum Fee
R=Rate Based Charge
T=Tiered Price
X=Maximum Fee
Z=Total/Balance

12 FA_BNK_BAL_EQUIV Signed Number(28,3) DECIMAL(26,3) NOT NULL The balance required to offset a compensable service charge. Calculated by multiplying the service charge by the analysis period multiplier.

13 FA_BNK_PYMNT_MTHD Character(1) VARCHAR2(1) NOT NULL Fee Payment method for non-balance compensable fees
B=Compensation by Balance
D=Debited Hard charged
F=Free (No Charge)
I=Invoiced Separately
N=Non-Balance Compensable
P=Previously Charged
W=Waived
X=Not Assessed Through Anaylsis

14 FA_FEE_COUNT Signed Number(16,0) DECIMAL(15) NOT NULL Item count as reported by the bank on the Fee Analysis Statement

15 FA_CALC_SVC_CHG Signed Number(28,3) DECIMAL(26,3) NOT NULL Fee Analysis Calculated Service Charges.

16 FA_CALC_BAL_EQUIV Signed Number(28,3) DECIMAL(26,3) NOT NULL The balance required to offset a compensable service charge. Calculated by multiplying the service charge by the analysis period multiplier.

17 FA_FEE_STATUS Character(3) VARCHAR2(3) NOT NULL This is the recon status for each fee item in the fee statement.
BAL=Balance
CHG=Charge
CNT=Count
REC=Reconciled
UNR=Unreconciled

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. Prompt Table: BANK_ID_VW
2	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
3	FA_FEE_CYCLE_NUM	Character(10)	VARCHAR2(10) NOT NULL	RJB 4/5/01 Added Analysis ID to label
4	FA_FEE_CD_SEQ_NUM	Number(9,0)	DECIMAL(9) NOT NULL	This sequence number is used for preserving the order in the bank statement.
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	UNIT_PRICE	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Unit Price Default Value: 0
7	REFERENCE_NUM	Character(30)	VARCHAR2(30) NOT NULL	Reference
8	FA_BNK_VOLUME	Signed Number(16,0)	DECIMAL(15) NOT NULL	Volume count of each sevice item.
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
10	FA_BNK_SVC_CHG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Field which refers to the total service charge (Price * Quantity) levied by a bank.
11	FA_FEE_CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Used to determine how the fee will be calculated. Driven off translates since we should support a finite amount of calc types B=Base Fee D=Discounted Price F=Flat Fee H=Threshold Price M=Minimum Fee R=Rate Based Charge T=Tiered Price X=Maximum Fee Z=Total/Balance
12	FA_BNK_BAL_EQUIV	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The balance required to offset a compensable service charge. Calculated by multiplying the service charge by the analysis period multiplier.
13	FA_BNK_PYMNT_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Fee Payment method for non-balance compensable fees B=Compensation by Balance D=Debited Hard charged F=Free (No Charge) I=Invoiced Separately N=Non-Balance Compensable P=Previously Charged W=Waived X=Not Assessed Through Anaylsis
14	FA_FEE_COUNT	Signed Number(16,0)	DECIMAL(15) NOT NULL	Item count as reported by the bank on the Fee Analysis Statement
15	FA_CALC_SVC_CHG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Fee Analysis Calculated Service Charges.
16	FA_CALC_BAL_EQUIV	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The balance required to offset a compensable service charge. Calculated by multiplying the service charge by the analysis period multiplier.
17	FA_FEE_STATUS	Character(3)	VARCHAR2(3) NOT NULL	This is the recon status for each fee item in the fee statement. BAL=Balance CHG=Charge CNT=Count REC=Reconciled UNR=Unreconciled