 |
 |
|
|
This view aggregates and summarises ibvTimeInstToColumns by client and period. It thus provides a movements summary for the client/period combination directly deduced from the instructions themselves.
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
ClientObjectType |
The object type of the client that the WIP totals are for |
ClientInternalId |
The internal identifier of the client that the WIP totals are for. |
Year |
The time ledger year that the totals apply to |
Period |
The time ledger period that the totals apply to |
WIPBilled |
The total amount of bills allocated against the time ledger (ex VAT and credit positive - i.e. a bill is positive a credit note is negative). |
WIPCreditNote |
The total amount of credit notes allocated against the time ledger (ex VAT and credit positive - i.e. a bill is positive a credit note is negative). |