 |
 |
|
|
This view aggregates and summarises ibvTimePostToColumns 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.
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 |