Base View idvTimeTotalsByPeriod

Description

This view exposes aggregates idvTimeTotalsByType over all types to be just by Account and period.

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

 

Columns

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
WIPTotal Total of WIP - see idvTimeTotalsBytype
CostTotal Total of cost - see idvTimeTotalsBytype
InstructionTotal Instruction total - see idvTimeTotalsBytype

 

This view is directly inherited by the following views: