 |
 |
|
|
This view aggregates and summarises ibvTimeInstToColumnsCLY 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.
This view is restricted to the current ledger year as determined by current ledger period.
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). |