- Contents
Exchange Manager Help
AIM Ledger Table
The AIM Ledger table contains expenditures and receipts for purchased accounts. Each account can have multiple ledger records.
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 |