- Contents
Exchange Manager Help
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 |