 |
 |
|
|
This view presents fees postings corresponding to invoices, credit notes
and write offs by period, date, client and categorisation. Basic figures
are VAT inclusive, but the VAT amount is available within the view.
Since this view is steered by the presence of postings, after any aggregation there will be no rows present for accounts and/or period combinations that have no postings present. Absence of an expected row should be taken as implying zero figures.
This view is restricted to the current and previous calendar year as determined by today's date.
Type = End user business view, incorporating business logic
Inherits columns from view ibvClientCategorisation plus
| Year | Fees posting year |
| Period | Fees posting period in year |
| Posting | Unique posting number in period (to support logical primary keys for reporting services). |
| Date | Posting date |
| CalendarYear | Calendar year independant of period structure on ledger |
| CalendarMonth | Calendar month (1 = Jan, 2 = Feb etc) |
| Type | Posting Type |
| PostTypeDesc | Posting type in human readable form |
| AffectsWIP | 'Y' if the posting affects WIP |
| Amount | Posting amount (credit negative) |
| Matched | Current amount matched (same sign convention) |
| Outstanding | Current amount outstanding (same sign convention) |
| VAT | Amount of VAT (same sign convention, but note that this reflects what the user said and, if cash accounting this will appear on both the invoice AND the receipt). |
| NumVATPostings | The number of separate VAT postings associated with the Fees posting. |
| HighestVATRate | The highest VAT rate associated with the Fees posting. |
| Reference1 | Reference 1 from the posting |
| Reference2 | Reference 2 from the posting |
| CrossReference | Cross reference from the posting |
| Narrative | User narrative from the posting |