BNK_RCN2_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	BNK_LIMIT_HIGH_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	This field contains the upper amount when added to a transaction amount that will still reconcile.
5	RECON_TRANS_CODE	Character(3)	VARCHAR2(3) NOT NULL	The PeopleSoft-specific bank transaction code ACH=Automated Clearing House B=Direct Debit BA=Bank Adjustments BOE=Bill of Exchange - Disburse BOO=Bill of Order - Disburse C=Trade Receipt CHK=Check D=Deposits DD=Direct Debit - Disburse EFT=Electronic Funds Transfer F=Fee Expense G=General Transaction I=Interest Expense M=Miscellaneous Transaction MAN=Manual Check P=Payment R=Drafts S=Stop Pay TRW=Treasury Wire U=Funding Receipt V=Voided Payment WIR=Wire - Disbursement WRI=Wire - Incoming
6	BNK_ACTIVE_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	This field determines the type of tolerance on a transaction's amount A=Amount D=Date N=None P=Percent
7	BNK_LIMIT_HIGH_DAY	Number(3,0)	SMALLINT NOT NULL	Upper Day Limit
8	BNK_LIMIT_HIGH_PCT	Number(8,2)	DECIMAL(7,2) NOT NULL	This field contains the high percent limit that when multiplied by the transaction amount and then added to the transaction amount will still allow the transaction to reconcile.
9	BNK_LIMIT_LOW_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	This field contains the lower amount when subtracted from a transaction amount that will still reconcile.
10	BNK_LIMIT_LOW_DAY	Number(3,0)	SMALLINT NOT NULL	Lower Day Limit
11	BNK_LIMIT_LOW_PCT	Number(8,2)	DECIMAL(7,2) NOT NULL	This field contains the low percent limit that when multiplied by the transaction amount and then subtracted to the transaction amount will still allow the transaction to reconcile.