 |
 |
|
|
This view presents the current up to date outstanding WIP balance by job internal id
The balance is deduced by adding up all unmatched posting amounts. Although it might not seem so at first sight this turns out to be more efficient than algorithms based on period totals.
Pending postings are not included in the balance.
It is the nature of this view that NO entry will be present for any job that has unmatched postings present. Such absence should be taken to imply a balance of zero
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
JobInternalId |
The internal identifier of the client job that the balance is for. |
Balance |
The actual balance |