FA_STMT_SVCA_EC (SQL Table)	Index Back
Fee Analysis Service Adjustmnt Bank Fee Analysis Statement Service Adjustment

FA_STMT_SVCA_EC

(SQL Table)

Fee Analysis Service Adjustmnt

Bank Fee Analysis Statement Service Adjustment

# 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 EFFECTIVE_DATE_FA Date(10) DATE Effective Dated Adjustments

9 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
Default Value: 1

10 DESCR Character(30) VARCHAR2(30) NOT NULL Description

11 ADJUST_DT Date(10) DATE Transaction Date

12 SERVICE_CHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Service Charge Amount

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

14 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

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	EFFECTIVE_DATE_FA	Date(10)	DATE	Effective Dated Adjustments
9	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number Default Value: 1
10	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
11	ADJUST_DT	Date(10)	DATE	Transaction Date
12	SERVICE_CHRG_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Service Charge Amount
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	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
15	LOADED_SW	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that indicates whether a given treasury transaction successfully has been imp