FA_STMT_RTE_EC (SQL Table)	Index Back
Fee Analysis Statement/Rates Bank Fee Analysis Statement Rate Detail Section RJB 9/29/00 - Added ADJUST_DT to record

FA_STMT_RTE_EC

(SQL Table)

Fee Analysis Statement/Rates

Bank Fee Analysis Statement Rate Detail Section RJB 9/29/00 - Added ADJUST_DT to record

# 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 FA_SPEC_RATE Signed Number(9,4) DECIMAL(7,4) NOT NULL The value of the fee analysis statement specified rate expressed as a percentage. The number of decimal places shown should reflect the number of decimal places used in calculations.

11 FA_RATE_MULTIPLIER Signed Number(8,2) DECIMAL(6,2) NOT NULL The balance required to offset $1.00 of balance compensable service charges. This factor can be used to calculate the balance equivalent of balance compensable service charges. This multiplier is only relevant to earnings allowance rates.

12 FA_DAYS_IN_PERIOD Number(3,0) SMALLINT NOT NULL The number of days in the analysis period. (E.G. 31, 30 or 28 for monthly periods).

13 FA_DAYS_IN_YEAR Number(3,0) SMALLINT NOT NULL The number of days in the year. (E.G. 360, 365).

14 RATE_DATE Date(10) DATE Exchange Rate Date

15 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	FA_SPEC_RATE	Signed Number(9,4)	DECIMAL(7,4) NOT NULL	The value of the fee analysis statement specified rate expressed as a percentage. The number of decimal places shown should reflect the number of decimal places used in calculations.
11	FA_RATE_MULTIPLIER	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	The balance required to offset $1.00 of balance compensable service charges. This factor can be used to calculate the balance equivalent of balance compensable service charges. This multiplier is only relevant to earnings allowance rates.
12	FA_DAYS_IN_PERIOD	Number(3,0)	SMALLINT NOT NULL	The number of days in the analysis period. (E.G. 31, 30 or 28 for monthly periods).
13	FA_DAYS_IN_YEAR	Number(3,0)	SMALLINT NOT NULL	The number of days in the year. (E.G. 360, 365).
14	RATE_DATE	Date(10)	DATE	Exchange Rate Date
15	LOADED_SW	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that indicates whether a given treasury transaction successfully has been imp