BANK_TOLER_RULE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	RULE_ID_RECON	Character(20)	VARCHAR2(20) NOT NULL	Reconciliation Rules Id
3	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
4	HOLIDAY_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	This is used to identify what holiday calendar to use. This is the access field for all financials groups.
5	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
6	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.
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	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.
9	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.
10	BNK_LIMIT_HIGH_DAY	Number(3,0)	SMALLINT NOT NULL	Upper Day Limit
11	BNK_LIMIT_LOW_DAY	Number(3,0)	SMALLINT NOT NULL	Lower Day Limit
12	ACCTG_TMPL_ID	Character(15)	VARCHAR2(15) NOT NULL	A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits. Prompt Table: TRA_BSP_TMPL_VW
13	LAST_MAINT_DTTM	DateTime(26)	TIMESTAMP	A system generated value that reflects the date and time a transaction was last modified
14	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID