Feedback

  • Contents
 

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

Related Topics

Destination Fields