BANK_RECON_FSQL (SQL Table)	Index Back
Bank Recon Filter SQL Store filter fields that are defined for Recon Rule

BANK_RECON_FSQL

(SQL Table)

Bank Recon Filter SQL

Store filter fields that are defined for Recon Rule

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECON_SOURCE Character(2) VARCHAR2(2) NOT NULL Represents the source system table(s) for reconciling items.
00=Bank Statement
01=Receivables Deposits
02=Payables
03=Treasury
04=Receivables Drafts
05=External Transactions
06=Receivables Payments
07=Direct Debits

2 RULE_ID_RECON Character(20) VARCHAR2(20) NOT NULL Reconciliation Rules Id

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

4 FSQL_STMT Long Character(8192) CLOB An internal work field that contains SQL text that is to be utilized in treasury application processing.

5 ASQL_STMT Long Character(8192) CLOB An internal work field that contains SQL text that is to be utilized in treasury application processing.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECON_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Represents the source system table(s) for reconciling items. 00=Bank Statement 01=Receivables Deposits 02=Payables 03=Treasury 04=Receivables Drafts 05=External Transactions 06=Receivables Payments 07=Direct Debits
2	RULE_ID_RECON	Character(20)	VARCHAR2(20) NOT NULL	Reconciliation Rules Id
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	FSQL_STMT	Long Character(8192)	CLOB	An internal work field that contains SQL text that is to be utilized in treasury application processing.
5	ASQL_STMT	Long Character(8192)	CLOB	An internal work field that contains SQL text that is to be utilized in treasury application processing.