 |
 |
|
|
This view exposes a combined view of fees movements on a period from idvFeesPeriodSummary and idvFeesTotalsByPeriod. See the two underlying views for a description of the columns.
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
Inherits columns from view idvFeesPeriodSummary plus:
| Total | Amount total - see idvFeesTotalsByPeriod |
| ExVATTotal | Ex VAT total - see idvFeesTotalsByPeriod |
| ItemCount | Total number of items - see idvFeesTotalsByPeriod |
This view is directly inherited by the following views: