Business View ibvTimePostToColumnsLCPC

Description

This view aggregates totals in ibvTimePostToColumns by year and period.

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

JobInternalId

The internal identifier of the client job that the aggregated totals apply to

Year

The time ledger year that the aggregated totals apply to

Period

The time ledger period that the aggregated totals apply to

ChargeableTime

The aggregated total of ChargeableTime from ibvTimePostToColumns (QV)

ChargeableExpenses

The aggregated total of ChargeableExpenses from ibvTimePostToColumns (QV)

OtherPostings

The aggregated total of OtherPostings from ibvTimePostToColumns (QV)

ActualMinutes

The aggregated total of ActualMinutes from ibvTimePostToColumns (QV)

Matched

The aggregated total of Matched from ibvTimePostToColumns (QV)

WriteOutThisPd

The aggregated total of WriteOutThisPd from ibvTimePostToColumns (QV)

WriteOffThisPd

The aggregated total of WriteOffThisPd from ibvTimePostToColumns (QV)

WriteBackThisPd

The aggregated total of WriteBackThisPd from ibvTimePostToColumns (QV)

WriteOutOtherPd

The aggregated total of WriteOutOtherPd from ibvTimePostToColumns (QV)

WriteOffOtherPd

The aggregated total of WriteOffOtherPd from ibvTimePostToColumns (QV)

WriteBackOtherPd

The aggregated total of WriteBackOtherPd from ibvTimePostToColumns (QV)

 

  •