 |
 |
|
|
This view exposes the rows in TFPeriodTotals that represent movement information on the fees ledger. This view does not give the full story, for that idvFeesTotalsByType must be included.
This view also supports the overall ledger totals - with owning object type = 0
The 'MatchedMovement' figure represents movements on matching for the postings in the period. The actual matching is taken to occur in the matching period, which is not necessarily the same as the posting period. Hence the MatchedMovement figure is NOT fixed even if the posting period is closed!
Rows in this view are not guaranteed to cover all combinations of accounts and periods. In particular, if the period has no opening balance (for example, because the previous period is in reconciliation rather than closed), and there has been no activity on the account in the new period, then no row will be present for that account/period combination.
Other circumstances that can give rise to absent rows include transient ones, such as an account being posted to at the time that the last close period was run.
Type = Base view suitable for advanced end user use
| ClientObjectType | The object type of the client object that the account is for |
| ClientInternalId | The internal id of the client object that the account is for |
| Year | The year part of the fees period |
| Period | The fees period number within the year |
| OpeningBalanceSet | 'Y' if previous periods are closed and the opening balance has been set, 'N' = opening balance not yet set |
| OpeningBalance | The balance as at the start of the period |
| VATTransfers | this figure represents the amount transferred from VAT reserve into VAT outputs as a result of matching in the period. The sign convention is credit negative using DR/CR convention as per the nominal ledger on the basis of postings into the VAT ouput account (not VAT reserve). This is the opposite sign to that appearing on the Iris practice summary screen. |
| MatchedMovement | The current net change of matched amount for postings in the period. |
This view is directly inherited by the following views: