BANK_RECON_SQL

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