 |
 |
|
|
This view shows the outstanding Fees balance at start of a period by
job internal id and period for the lates closed period plus the same period
from the previous year.
The balance is deduced from the period totals. The opening balance is
used directly if available, failing that the period posting totals are
summed.
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 the current period and the previous period is in reconciliation 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. All account period combinations are represented, even for these circumstances.
This view is suitable for any user wanting access to the client fees ledger start balances.
ClientObjectType |
The object type of the client job that the balance is for. |
ClientInternalId |
The internal identifier of the client job that the balance is for. The balance is as at the start of the period specified by the next two columns |
Year |
Fees ledger year |
Period |
Fees ledger period in year |
Balance |
The actual balance |