 |
 |
|
|
This view presents the outstanding WIP balance at end of period by job internal id and period.
The balance is deduced from the period totals. The opening balance and movements are used directly if available, failing that the period posting totals are summed.
Pending postings are not included in the balance.
This view may appear complex at first sight, especially in respect of the 'all periods' table to drive it. The reason is that, if it is used for open periods then, not only is no opening balance set but there will be no totals information AT ALL for that period for any account for which there were no postings in the period.
The cross join ensures all account period combinations are represented, even for pending periods with no postings. The join onto this cross join (as a derived table) will produce nulls for such account period combinations and they will revert to using the account totals by type aggregation. If this also produces nulls the coalesce function will convert this to zero.
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
JobInternalId |
The internal identifier of the client job that the balance is for. The balance is as at the end of the period specified by the next two columns |
Year |
Time ledger year |
Period |
Time ledger period in year |
Balance |
The actual balance |