AIM Ledger Table

Field Name

Description

Length

Data Type

Parent Table and Field

Import Types

Number

Code that Latitude assigned to identify the account. To ensure that Exchange Manager locates the correct account, you must map this field.

4

Integer

Master/Number

M

LedgerTypeID

Code that identifies the ledger type. You must have already created this code in Latitude.

4

Integer

None

M

DateEntered

Date of debit or credit.

8

DateTime

None

M

Debit

Amount debited from the account.

8

Money

None

M

Credit

Amount credited to the account.

8

Money

None

M

Comments

Comments regarding the ledger entry.

16

Text

None

M

Status

Ledger entry status, such as sent, received, pending, or approved.

50

VarChar

None

M

PortfolioID

Code that identifies the purchased portfolio. You must have already created this code in Portfolio Manager.

4

Integer

None

M

ToGroupID

Code that identifies the group receiving the credit or debit. 

4

Integer

None

M

FromGroupID

Code that identifies the group sending the credit or debit. 

4

Integer

None

M

InvoiceID

Code that identifies the invoice that includes the credit or debit. This code must exist in Latitude.

4

Integer

None

M

LedgerID

Code that Latitude assigned to identify the ledger record.

4

Integer

None

M