 |
 |
|
|
This view presents summary unmatched fees postings 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.
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 |
Type |
Posting type |
PostTypeDesc |
Posting type in human readable form |
AffectsWIP |
'Y' if the posting affects WIP |
PostCategory |
Posting category |
PostCatDesc |
Posting category in human readable form |
Amount |
Posting amount (credit negative) |
Matched |
Current amount matched (same sign convention) |
Outstanding |
Current amount outstanding (same sign convention) |
AgeInDays |
Posting age (in days) from today. |
AgeInMonths |
Posting age (in months) from today. 0 = current month, 1 = last month etc. There is no cutoff in the number of bands |
AgeBandDays |
As AgeInDays, but expressed as a string and with a cutoff of four bands (less than 30, less than 60, less than 90, greater than or equal to 90) |
AgeBandMonths |
As AgeInMonths, but expressed as a string and with a cutoff of four bands (less than 1, less than 2, less than 3, greater than or equal to 3) |
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 |