6.3.9.3.6.3.12 Instrument Tables Accumulation
The first operation in the ledger migration process is to accumulate all individual detail rows from the Instrument tables into a single row for each unique combination of Org Unit and Product dimensions in the Virtual Memory Table (VMT).
In this example, Bal_x_TfrRate for Product 3 is calculated as follows:
(100 * 4.00) + (200 * 3.00) = 1,000.00 = Bal_x_TfrRate
The following table represents the VMT after Account table accumulation has taken place.
Table 6-33 VMT Post Instrument Table Accumulation
| ORG_UNIT_ID | PRODUCT_ID | Bal | Bal x TfrRate | LSBal x TfrRate |
|---|---|---|---|---|
| 1 | 3 | 300.00 | 1000.00 | |
| 1 | 4 | 125.00 | 562.50 | |
| 1 | 5 | 200.00 | 600.00 |