 |
 |
|
|
This view combines ibvWIPBalanceSOPLCPYC, ibvTimePostToColumnsLCPYC and ibvTimeInstToColumnsLCPYC to give a summary of WIP movements by time ledger account and period for the current ledger year (for chargeable accounts only).
Note that there will be no entries present in this view for accounts for which there were no postings in the period(s) concerned and no postings in any prior period.
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.
This view is restricted to the latest closed ledger period plus earlier periods in same ledger year plus the same set of periods in the previous ledger year.
Type = End user business view, incorporating business logic
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: