Account Interest Settings Table

The Account Interest table contains interest settings for accounts. Each account can have multiple interest records.

Field Name	Description	Length	Data Type	Parent Table and Field	Import Types
AccountID	Code that Latitude assigns to identify the account. To ensure that Exchange Manager locates the correct account, you must map this field.	4	Integer	Master/Number	M
Customer	Client name.	7	VarChar	None	M
Effective	Date the interest takes effect.	4	SmallDate	None	M
InterestRate	Interest rate as a whole number.	9	Numeric	None	M
Buckets	Account-level override to specify which money buckets to use as the principal value when calculating interest. This field overrides the same field on the Customer table, which overrides the system default of only using the principal bucket Current1. Interest accrues based on the values of Current1 and Current3. Exchange doesn't support Current2 as Latitude doesn't calculate compounded interest.	2	SmallInt	None	M
Deferred	Flag that indicates whether the interest is deferred. 1 = Yes 0 = No	1	Bit	None	M
UserID	Code that identifies the user who modified the interest record. You must have already created this code in Latitude.	4	Integer	None	M
Entered	Date the user created the interest record.	8	DateTime	None	M