Business View ibvWIPPdSummaryLCPC

Description

This view combines ibvWIPBalanceSOPLCPC, ibvTimePostToColumnsLCPC and ibvTimeInstToColumnsLCPC to give a summary of WIP movements by time ledger account and period for the current ledger year (for chargeable accounts only).

 

The order of joins in the view is predicated on the fact that the start of period balance views will always have an entry present for each account and period combination, even if there are no postings in the period itself.

Type = End user business view, incorporating business logic

 

Columns

Year

The time ledger year to which the figures apply

Period

The time ledger period to which the figures apply

ACJobInternalId

The internal identifier of the job to which the figures apply (the name is changed to aid subsequent joins to categorisation)

Balance

See ibvWIPBalanceSOP - i.e. this is the balance at the START of the period

ChargeableTime

See ibvTimePostToColumns

ChargeableExpenses

See ibvTimePostToColumns

WriteOutThisPd

See ibvTimePostToColumns

WriteOffThisPd

See ibvTimePostToColumns

WriteBackThisPd

See ibvTimePostToColumns

WriteOutOtherPd

See ibvTimePostToColumns

WriteOffOtherPd

See ibvTimePostToColumns

WriteBackOtherPd

See ibvTimePostToColumns

OtherPostings

See ibvTimePostToColumns

ChargeableMinutes

See ibvTimePostToColumns

Billed

See ibvTimeInstToColumns

InterimBilled

See ibvTimeInstToColumns

CreditNote

See ibvTimeInstToColumns

 

This view is directly inherited by the following views: