Business View ibvTimeInstMvtByClientCLY

Description

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.

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

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).

 

  •