The Last Column
The last column contains the subtotals for each borrower and the asset total. The subtotal fields in data ID 505 are first-dimension arrays. Their indexes correspond to the borrowers in 501:
| Data ID 501 | Data ID 503 | Data ID 504 | Data ID 505 |
|---|---|---|---|
| (1) Borrower 1 |
(1,1) Asset 1 (1,2) Asset 2 (1,3) Asset 3 (1,4) Asset 4 (1,5) Asset 5 |
(1,1) Amount 1 (1,2) Amount 2 (1,3) Amount 3 (1,4) Amount 4 (1,5) Amount 5 |
(1) Asset Subtotal 1 |
| (2) Borrower 2 |
(2,1) Asset 1 (2,2) Asset 2 (2,3) Asset 3 (2,4) Asset 4 (2,5) Asset 5 |
(2,1) Amount 1 (2,2) Amount 2 (2,3) Amount 3 (2,4) Amount 4 (2,5) Amount 5 |
(2) Asset Subtotal 2 |
| (3) Borrower 3 |
(3,1) Asset 1 (3,2) Asset 2 (3,3) Asset 3 (3,4) Asset 4 (3,5) Asset 5 |
(3,1) Amount 1 (3,2) Amount 2 (3,3) Amount 3 (3,4) Amount 4 (3,5) Amount 5 |
(3) Asset Subtotal 3 |
| (4) Borrower 4 |
(4,1) Asset 1 (4,2) Asset 2 (4,3) Asset 3 (4,4) Asset 4 (4,5) Asset 5 |
(4,1) Amount 1 (4,2) Amount 2 (4,3) Amount 3 (4,4) Amount 4 (4,5) Amount 5 |
(4) Asset Subtotal 4 |
You would define the fields for data ID 505 just as you did for those in 501. The field for the asset total (Data ID 506) contains the grand total of all assets. It is not an arrayed field because there is only one value associated with it. It has a dimension of 0.