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 ibvFeesTotalsByTypeLCP for the caution you must use when considering ex VAT figures
This view is restricted to the latest closed ledger period.
Type = End user business view, incorporating business logic
Inherits columns from view ibvClientCategorisation plus
Inherits columns from view ibvFeesTotalsByTypeLCP 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. |