 |
 |
|
|
view exposes the rows in TFPostTypeFigs that give totals of fees postings by Account, period and posting type.
This view also supports the overall ledger totals - with owning object type = 0
The job and non charge internal identifiers are for convenience when navigating from this view to the parent account. For efficiency you are recommended to use AccountObjectType and AccountInternalId when querying into this table for a particular account.
Rows in this view are not guaranteed to cover all combinations of accounts and periods. In particular, if the period has no opening balance (for example, because the previous period is in reconciliation rather than closed), and there has been no activity on the account in the new period, then no row will be present for that account/period combination.
Other circumstances that can give rise to absent rows include transient ones, such as an account being posted to at the time that the last close period was run.
Type = Base view suitable for advanced end user use
| AccountObjectType | The object type of the object this account is for (3 = non charge activity, 57 = job). |
| AccountInternalId | The internal id of the object this account is for |
| JobInternalId | Internal identifier of job the totals are for |
| NonChargeInternalId | Internal identifier of non charge activity the totals are for |
| Year | The year part of the time period |
| Period | The time period number within the year |
| Type | The type of postings - see idvTimePostingType |
| PostCategory | The category of posting - see idvTimePostingCategory |
| WIPTotal | Total WIP posted for this account, period and type (credit negative) |
| CostTotal | Total cost posted for this account, period and type (credit negative, and if costs are recorded) |
| InstructionTotal | Total of memo amounts on instructions for this account, period and type |
This view is directly inherited by the following views: