This view combines fees ledger totals by type with client categorisation to give a set of cash flow figures that can be broken down by a wide variety of criteria.
See comments in ibvFeesTotalsByTypeCLY for the caution you must use when considering ex VAT figures.
This view is restricted to the current ledger year as determined by current ledger period.
Type = End user business view, incorporating business logic
Inherits columns from view ibvClientCategorisation plus
Inherits columns from view ibvFeesTotalsByTypeCLY plus
LastPeriodStatusChange |
The date and time of the last status change to the period. If the period is closed this is the date and time on which it was closed. |