AccountingRegister.<Accounting register name>.Turnovers
Syntax
Fields
<Dimension name>
<Dimension name>Balanced
<Resource name>BalancedTurnover
<Resource name>BalancedTurnoverCr
<Resource name>BalancedTurnoverDr
<Resource name>Turnover
<Resource name>TurnoverCr
<Resource name>TurnoverDr
Account
BalancedAccount
BalancedExtDimension<ExtDimension number>
DayPeriod
ExtDimension<ExtDimension number>
HalfYearPeriod
HourPeriod
LineNumber
MinutePeriod
MonthPeriod
Period
QuarterPeriod
Recorder
SecondPeriod
TenDaysPeriod
WeekPeriod
YearPeriod
Parameters
End of period
Periodicity
Account condition
Extra dimensions
Condition
Balanced account condition
Balanced extra dimensions
Description:
Aggregation is made by account field, dimensions and extra dimensions specified in query.
The Extra dimensions parameter defines the ExtDimension breakdown for which balances will be obtained. If the Extra dimensions parameter is not specified, the ExtDimensions are defined positionally. In other words, the ExtDimensions type for the corresponding account is taken from the corresponding position.
Hence, if the ExtDimension types are not defined and a query is done on an account for which the first ExtDimension type is defined as Materials and the second as Warehouse, the ExDimensions1 field will contain materials and the ExtDimensions2 field will contain warehouses. If a query is run on two accounts, where one is set to the Materials, Warehouse ExtDimension and the other to Warehouse, Material and the ExtDimensions type parameter is not specified, then the ExtDimensions1 field will contain both materials for the first account and warehouses for the second. The ExtDimensions2 field will contain warehouses for the first account and materials for the second.
If the Extra dimensions parameter is assigned, then data are selected only for those account that have all of the indicated ExtDimensions types defined. When this is the case, the ExtDimension<ExtDimension number> field will contain values matching the ExtDimensions types transmitted. For example, if the ExtDimension setting for one account is Materials, Warehouse but the second account is set to "Warehouse, Materials", and the Extra dimensions parameter is assigned as a Materials, Warehouse array, then the ExtDimensions1 field will contain materials, but the ExtDimensions2 field will contain warehouses, regardless of the account.