5.3.1.3.8 Examples of Field Allocations

In the Instrument Table context, Field Allocations perform Arithmetic Operations on different columns within the same row of data. For example, you might use a Field Allocation Rule to multiply Instrument-level balance times a rate times an accrual basis factor to update a Rate-related income or expense column. Such an Allocation could update a single row or millions of rows depending on your filtering criteria.

In the Management Ledger context, Field Allocations are rarely used. When they are used, Field Allocations perform Arithmetic Operations on different columns within the same “logical” row of data. For example, to generate a result set of rows in the Management Ledger that represent changes in asset values from month-to-month, build a Field Allocation that used the < Current Amount > macro for all Management Ledger asset balances as your Source and that subtracted the < Last Month Amount > in the Driver. In this example, you would suppress the Credit output and write the Debit output to a user-defined Financial Element. If your Source Financial Element were 100 (Ending Balance), post your results to a user-defined Financial Element whose name was Month-Over-Month Change.