This view aggregates and summarises ibvTimePostToColumnsCLY by client and period. It thus provides a movements summary for the client/period combination directly deduced from the postings 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 |
WIPAdded |
The amount of WIP added in the period (the sum of chargeable expenses plus chargeable time) credit negative. |
WIPWrittenOut |
The amount of WIP written out in the period credit negative. |
WIPWrittenOff |
The amount of WIP written off in the period credit negative. |
WIPAdjusted |
The sum of all other postings in the period not covered by the previous three columns credit negative |