FA_STMT_HDR_EC (SQL Table)	Index Back
Fee Analysis Statement Header Fee analysis statement header information from the 822.

FA_STMT_HDR_EC

(SQL Table)

Fee Analysis Statement Header

Fee analysis statement header information from the 822.

# 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_STMT_DT Date(10) DATE The statement date used for fee analysis statements. This date distinguishes an original statement from a reissued statement.

9 FA_START_DT Date(10) DATE The date used for the start of the period. This date is defaulted to the first of the month for monthly analysis statements since it is not provided for those types. It is explicitly provided for statements that arrive off cycle or on a different period.

10 FA_END_DT Date(10) DATE The date used for the end of the period. This date is provided in the statement no matter what cycle the statements are on (EG Monthly or otherwise). If monthly, it is the last day of the month.

11 FA_STLMNT_MTHD Character(1) VARCHAR2(1) NOT NULL Settlement Method for Service Charges.
D=Debit
I=Invoice

12 FA_FEE_STRUCT_TIME Date(10) DATE This date is used for getting the correct effective dated fee structure.

13 BNK_LOAD_DTTM DateTime(26) TIMESTAMP The time and date a bank statement is loaded into the system.

14 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_STMT_DT	Date(10)	DATE	The statement date used for fee analysis statements. This date distinguishes an original statement from a reissued statement.
9	FA_START_DT	Date(10)	DATE	The date used for the start of the period. This date is defaulted to the first of the month for monthly analysis statements since it is not provided for those types. It is explicitly provided for statements that arrive off cycle or on a different period.
10	FA_END_DT	Date(10)	DATE	The date used for the end of the period. This date is provided in the statement no matter what cycle the statements are on (EG Monthly or otherwise). If monthly, it is the last day of the month.
11	FA_STLMNT_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Settlement Method for Service Charges. D=Debit I=Invoice
12	FA_FEE_STRUCT_TIME	Date(10)	DATE	This date is used for getting the correct effective dated fee structure.
13	BNK_LOAD_DTTM	DateTime(26)	TIMESTAMP	The time and date a bank statement is loaded into the system.
14	LOADED_SW	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that indicates whether a given treasury transaction successfully has been imp