Business View ibvTimePostMvtByClientLCPC

Description

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

 

Columns

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

 

  •