BANK_TOLER_AMT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RULE_ID_RECON	Character(20)	VARCHAR2(20) NOT NULL	Reconciliation Rules Id
2	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
3	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 Default Value: A
4	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.
5	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.
6	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.
7	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.
8	LAST_MAINT_DTTM	DateTime(26)	TIMESTAMP	A system generated value that reflects the date and time a transaction was last modified
9	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
10	SYSTEM_MAINTAINED	Character(1)	VARCHAR2(1) NOT NULL	System Maintained