FA_STMT_SVCD_EC (SQL Table)	Index Back
Fee Analysis Statement/Service Bank Fee Analysis Statement Service Detail Section

FA_STMT_SVCD_EC

(SQL Table)

Fee Analysis Statement/Service

Bank Fee Analysis Statement Service Detail Section

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.

2 ECFILEROWID Character(3) VARCHAR2(3) NOT NULL Electronic Commerce File Row ID. Used in EDI Manager. There must be one work record for every PeopleSoft Business Document file. The first field in the record is the Record_Id and the rest of the fields must match the corresponding business document, in the same order and length.

3 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)

4 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound

5 ECACTIONCD Character(3) VARCHAR2(3) NOT NULL EC Action Code

6 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

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

8 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.

9 FA_FEE_CODE Character(20) VARCHAR2(20) NOT NULL Fee code mapped to Bank Fee code used for Fee Analysis.

10 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price

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

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

13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

14 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.

15 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

16 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.

17 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

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

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

20 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.

21 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

22 LOADED_SW Character(1) VARCHAR2(1) NOT NULL An internal work field that indicates whether a given treasury transaction successfully has been imp

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ECQUEUEINSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
2	ECFILEROWID	Character(3)	VARCHAR2(3) NOT NULL	Electronic Commerce File Row ID. Used in EDI Manager. There must be one work record for every PeopleSoft Business Document file. The first field in the record is the Record_Id and the rest of the fields must match the corresponding business document, in the same order and length.
3	ECTRANSID	Character(15)	VARCHAR2(15) NOT NULL	Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
4	ECTRANSINOUTSW	Character(1)	VARCHAR2(1) NOT NULL	Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound. I=Inbound O=Outbound
5	ECACTIONCD	Character(3)	VARCHAR2(3) NOT NULL	EC Action Code
6	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
7	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
8	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.
9	FA_FEE_CODE	Character(20)	VARCHAR2(20) NOT NULL	Fee code mapped to Bank Fee code used for Fee Analysis.
10	UNIT_PRICE	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Unit Price
11	REFERENCE_NUM	Character(30)	VARCHAR2(30) NOT NULL	Reference
12	FA_BNK_VOLUME	Signed Number(16,0)	DECIMAL(15) NOT NULL	Volume count of each sevice item.
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	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.
15	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
16	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.
17	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
18	FA_FEE_COUNT	Signed Number(16,0)	DECIMAL(15) NOT NULL	Item count as reported by the bank on the Fee Analysis Statement
19	FA_CALC_SVC_CHG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Fee Analysis Calculated Service Charges.
20	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.
21	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
22	LOADED_SW	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that indicates whether a given treasury transaction successfully has been imp