ETL Import - Itemization Transaction, Account and Client Data

Itemization Transactions

Itemization Transactions are owing or received adjustments and received payments or credits associated with account validation itemization data following the assignment of an account in ACE. 

The itemization balance of an account combined with any unassigned transactions and adjustments posted to the account will typically match the current account balance. Itemization Transactions can be loaded using the itemizationTransactions ETL Layout.

Itemization Balances

Itemization Balances are total amounts that can be loaded with the accounts or as updates using the account ETL Layout. 

When values are loaded this way as itemization interest, fees, payments or credits, associated itemization transactions will be automatically created in ACE.

Using the Client ETL Layout, defaults for the Itemization Date Source and the Itemization Description can be loaded to each client profile.

ETL Layouts

The following ETL Layouts with related fields mentioned above can be downloaded:

Account document layout

Client layout

Itemization transaction layout