 |
 |
|
|
This view aggregates totals in ibvTimeInstToColumns by year and period.
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 latest closed ledger period plus earlier periods in same ledger year.
Type = End user business view, incorporating business logic
JobInternalId |
The internal identifier of the client job that the aggregated totals apply to |
Year |
The time ledger year that the aggregated totals apply to |
Period |
The time ledger period that the aggregated totals apply to |
Billed |
The aggregated total of Billed from ibvTimeInstToColumns (QV) |
InterimBilled |
The aggregated total of InterimBilled from ibvTimeInstToColumns (QV) |
CreditNote |
The aggregated total of CreditNote from ibvTimeInstToColumns (QV) |
CurrentWriteOut |
The aggregated total of CurrentWriteOut from ibvTimeInstToColumns (QV) |