Table of Contents

Finance.Accounting.TrialBalanceDetailed View

Namespace: Finance.Accounting

Shows debit and credit turnovers and balances per account, broken down by analytical dimensions, cost and profit centers. Designed for detailed analysis and managerial reporting. Entity: Acc_Trial_Balance_Detailed (Introduced in version 25.1.3.22)

Default Visualization

Default Display Text Format:
{FromDate}: {ToDate}
Default Search Members:
__
Category: Views
Show in UI: ShownByDefault

Aggregate

An aggregate is a cluster of domain objects that can be treated as a single unit.

Aggregate Tree

Attributes

Name Type Description
Closing decimal (38, 2) Closing Balance (debit balance is positive, credit - negative). Required
ClosingBase decimal (38, 2) Closing balance in base currency (debit balance is positive, credit - negative). Required
ClosingCredit decimal (38, 2) Closing balance when it is credit. Required
ClosingCreditBase decimal (38, 2) Closing balance in base currency when it is credit. Required
ClosingDebit decimal (38, 2) Closing balance when it is debit. Required
ClosingDebitBase decimal (38, 2) Closing balance in base currency when it is debit. Required
ClosingReporting decimal (38, 2) Closing balance in reporting currency. Required
Credit decimal (38, 2) Credit. Required
CreditBase decimal (38, 2) Credit Base. Required
CreditReporting decimal (38, 2) Credit Reporting. Required
Debit decimal (38, 2) Debit. Required
DebitBase decimal (38, 2) Debit Base. Required
DebitReporting decimal (38, 2) Debit Reporting. Required
FromDate date Period Start Date - Should be filtered with exact date. Required Filter(eq)
ItemKey string (64) Item Key. Required Filter(eq;like)
ItemKeyLevel1Code string (40) Item Key Level 1 Code. Required
ItemKeyLevel1Name MultilanguageString (254) Item Key Level 1 Name. Required
ItemKeyLevel2Code string (40) Item Key Level 2 Code. Required
ItemKeyLevel2Name MultilanguageString (254) Item Key Level 2 Name. Required
ItemKeyLevel3Code string (40) Item Key Level 3 Code. Required
ItemKeyLevel3Name MultilanguageString (254) Item Key Level 3 Name. Required
ItemKeyLevel4Code string (40) Item Key Level 4 Code. Required
ItemKeyLevel4Name MultilanguageString (254) Item Key Level 4 Name. Required
ItemKeyLevel5Code string (40) Item Key Level 5 Code. Required
ItemKeyLevel5Name MultilanguageString (254) Item Key Level 5 Name. Required
Opening decimal (38, 2) Opening balance (debit balance is positive, credit - negative). Required
OpeningBase decimal (38, 2) Opening balance in base currency (debit balance is positive, credit - negative). Required
OpeningCredit decimal (38, 2) Opening balance when it is credit. Required
OpeningCreditBase decimal (38, 2) Opening balance in base currency when it is credit. Required
OpeningDebit decimal (38, 2) Opening balance when it is debit. Required
OpeningDebitBase decimal (38, 2) Opening balance in base currency when it is debit. Required
OpeningReporting decimal (38, 2) Opening balance in reporting currency. Required Introduced in version 25.1.3.29
ToDate date Period End Date - Should be filtered with exact date. Required Filter(eq)

References

Name Type Description
Account Accounts General Ledger Account. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Accounts_Table.Account_Id Introduced in version 25.1.3.28
CostCenter CostCenters Cost Center. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Cost_Centers_Table.Cost_Center_Id Introduced in version 25.1.3.28
Currency Currencies Currency. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Currencies_Table.Currency_Id Introduced in version 25.1.3.28
EnterpriseCompany EnterpriseCompanies Enterprise Company. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Enterprise_<br />Companies_Table.Enterprise_Company_Id Introduced in version 25.1.3.28
EnterpriseCompanyLocation CompanyLocations Company Location / Branch. Required Default(New Guid) Filter(multi eq) Inherited from Cm_Company_Locations_Table.Company_Location_Id Introduced in version 25.1.3.28
ExampleVoucherLine AccountingVoucherLines This is one (any) of the voucher lines grouped for the current Item Key (it could be from the opening balances or transactions) - it will be used to display the user-defined characteristics of this line. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Voucher_Lines_Table.Voucher_Line_Id Introduced in version 25.1.3.28
Level1AccountGroup AccountGroups Level 1 Account Group. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Account_Groups_Table.Account_Group_Id Introduced in version 25.1.3.28
Level1AccountProperty CustomProperties Level 1 Account Property. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Properties_Table.Property_Id Introduced in version 25.1.3.28
Level2AccountGroup AccountGroups Level 2 Account Group. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Account_Groups_Table.Account_Group_Id Introduced in version 25.1.3.28
Level2AccountProperty CustomProperties Level 2 Account Property. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Properties_Table.Property_Id Introduced in version 25.1.3.28
Level3AccountGroup AccountGroups Level 3 Account Group. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Account_Groups_Table.Account_Group_Id Introduced in version 25.1.3.28
Level3AccountProperty CustomProperties Level 3 Account Property. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Properties_Table.Property_Id Introduced in version 25.1.3.28
Level4AccountGroup AccountGroups Level 4 Account Group. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Account_Groups_Table.Account_Group_Id Introduced in version 25.1.3.28
Level4AccountProperty CustomProperties Level 4 Account Property. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Properties_Table.Property_Id Introduced in version 25.1.3.28
Level5AccountGroup AccountGroups Level 5 Account Group. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Account_Groups_Table.Account_Group_Id Introduced in version 25.1.3.28
Level5AccountProperty CustomProperties Level 5 Account Property. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Properties_Table.Property_Id Introduced in version 25.1.3.28
Level6AccountGroup AccountGroups Level 6 Account Group. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Account_Groups_Table.Account_Group_Id Introduced in version 25.1.3.28
ProfitCenter ProfitCenters Profit Center. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Profit_Centers_Table.Profit_Center_Id Introduced in version 25.1.3.28

Attribute Details

Closing

Closing Balance (debit balance is positive, credit - negative). Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

ClosingBase

Closing balance in base currency (debit balance is positive, credit - negative). Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

ClosingCredit

Closing balance when it is credit. Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

ClosingCreditBase

Closing balance in base currency when it is credit. Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

ClosingDebit

Closing balance when it is debit. Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

ClosingDebitBase

Closing balance in base currency when it is debit. Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

ClosingReporting

Closing balance in reporting currency. Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

Credit

Credit. Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

CreditBase

Credit Base. Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

CreditReporting

Credit Reporting. Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

Debit

Debit. Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

DebitBase

Debit Base. Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

DebitReporting

Debit Reporting. Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

FromDate

Period Start Date - Should be filtered with exact date. Required Filter(eq)

Type: date
Category: System
Supported Filters: Equals
Supports Order By: False
Show in UI: ShownByDefault

ItemKey

Item Key. Required Filter(eq;like)

Type: string (64)
Category: System
Supported Filters: Equals, Like
Supports Order By: False
Maximum Length: 64
Show in UI: ShownByDefault

ItemKeyLevel1Code

Item Key Level 1 Code. Required

Type: string (40)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Maximum Length: 40
Show in UI: ShownByDefault

ItemKeyLevel1Name

Item Key Level 1 Name. Required

Type: MultilanguageString (254)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

ItemKeyLevel2Code

Item Key Level 2 Code. Required

Type: string (40)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Maximum Length: 40
Show in UI: ShownByDefault

ItemKeyLevel2Name

Item Key Level 2 Name. Required

Type: MultilanguageString (254)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

ItemKeyLevel3Code

Item Key Level 3 Code. Required

Type: string (40)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Maximum Length: 40
Show in UI: ShownByDefault

ItemKeyLevel3Name

Item Key Level 3 Name. Required

Type: MultilanguageString (254)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

ItemKeyLevel4Code

Item Key Level 4 Code. Required

Type: string (40)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Maximum Length: 40
Show in UI: ShownByDefault

ItemKeyLevel4Name

Item Key Level 4 Name. Required

Type: MultilanguageString (254)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

ItemKeyLevel5Code

Item Key Level 5 Code. Required

Type: string (40)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Maximum Length: 40
Show in UI: ShownByDefault

ItemKeyLevel5Name

Item Key Level 5 Name. Required

Type: MultilanguageString (254)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

Opening

Opening balance (debit balance is positive, credit - negative). Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

OpeningBase

Opening balance in base currency (debit balance is positive, credit - negative). Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

OpeningCredit

Opening balance when it is credit. Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

OpeningCreditBase

Opening balance in base currency when it is credit. Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

OpeningDebit

Opening balance when it is debit. Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

OpeningDebitBase

Opening balance in base currency when it is debit. Required

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

OpeningReporting

Opening balance in reporting currency. Required Introduced in version 25.1.3.29

Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

ToDate

Period End Date - Should be filtered with exact date. Required Filter(eq)

Type: date
Category: System
Supported Filters: Equals
Supports Order By: False
Show in UI: ShownByDefault

Reference Details

Account

General Ledger Account. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Accounts_Table.Account_Id Introduced in version 25.1.3.28

Type: Accounts
Category: System
Inherited From: Acc_Accounts_Table.Account_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

CostCenter

Cost Center. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Cost_Centers_Table.Cost_Center_Id Introduced in version 25.1.3.28

Type: CostCenters
Category: System
Inherited From: Acc_Cost_Centers_Table.Cost_Center_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

Currency

Currency. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Currencies_Table.Currency_Id Introduced in version 25.1.3.28

Type: Currencies
Category: System
Inherited From: Gen_Currencies_Table.Currency_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

EnterpriseCompany

Enterprise Company. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Enterprise_Companies_Table.Enterprise_Company_Id Introduced in version 25.1.3.28

Type: EnterpriseCompanies
Category: System
Inherited From: Gen_Enterprise_Companies_Table.Enterprise_Company_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

EnterpriseCompanyLocation

Company Location / Branch. Required Default(New Guid) Filter(multi eq) Inherited from Cm_Company_Locations_Table.Company_Location_Id Introduced in version 25.1.3.28

Type: CompanyLocations
Category: System
Inherited From: Cm_Company_Locations_Table.Company_Location_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

ExampleVoucherLine

This is one (any) of the voucher lines grouped for the current Item Key (it could be from the opening balances or transactions) - it will be used to display the user-defined characteristics of this line. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Voucher_Lines_Table.Voucher_Line_Id Introduced in version 25.1.3.28

Type: AccountingVoucherLines
Category: System
Inherited From: Acc_Voucher_Lines_Table.Voucher_Line_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

Level1AccountGroup

Level 1 Account Group. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Account_Groups_Table.Account_Group_Id Introduced in version 25.1.3.28

Type: AccountGroups
Category: System
Inherited From: Acc_Account_Groups_Table.Account_Group_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

Level1AccountProperty

Level 1 Account Property. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Properties_Table.Property_Id Introduced in version 25.1.3.28

Type: CustomProperties
Category: System
Inherited From: Gen_Properties_Table.Property_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

Level2AccountGroup

Level 2 Account Group. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Account_Groups_Table.Account_Group_Id Introduced in version 25.1.3.28

Type: AccountGroups
Category: System
Inherited From: Acc_Account_Groups_Table.Account_Group_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

Level2AccountProperty

Level 2 Account Property. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Properties_Table.Property_Id Introduced in version 25.1.3.28

Type: CustomProperties
Category: System
Inherited From: Gen_Properties_Table.Property_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

Level3AccountGroup

Level 3 Account Group. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Account_Groups_Table.Account_Group_Id Introduced in version 25.1.3.28

Type: AccountGroups
Category: System
Inherited From: Acc_Account_Groups_Table.Account_Group_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

Level3AccountProperty

Level 3 Account Property. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Properties_Table.Property_Id Introduced in version 25.1.3.28

Type: CustomProperties
Category: System
Inherited From: Gen_Properties_Table.Property_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

Level4AccountGroup

Level 4 Account Group. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Account_Groups_Table.Account_Group_Id Introduced in version 25.1.3.28

Type: AccountGroups
Category: System
Inherited From: Acc_Account_Groups_Table.Account_Group_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

Level4AccountProperty

Level 4 Account Property. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Properties_Table.Property_Id Introduced in version 25.1.3.28

Type: CustomProperties
Category: System
Inherited From: Gen_Properties_Table.Property_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

Level5AccountGroup

Level 5 Account Group. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Account_Groups_Table.Account_Group_Id Introduced in version 25.1.3.28

Type: AccountGroups
Category: System
Inherited From: Acc_Account_Groups_Table.Account_Group_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

Level5AccountProperty

Level 5 Account Property. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Properties_Table.Property_Id Introduced in version 25.1.3.28

Type: CustomProperties
Category: System
Inherited From: Gen_Properties_Table.Property_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

Level6AccountGroup

Level 6 Account Group. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Account_Groups_Table.Account_Group_Id Introduced in version 25.1.3.28

Type: AccountGroups
Category: System
Inherited From: Acc_Account_Groups_Table.Account_Group_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

ProfitCenter

Profit Center. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Profit_Centers_Table.Profit_Center_Id Introduced in version 25.1.3.28

Type: ProfitCenters
Category: System
Inherited From: Acc_Profit_Centers_Table.Profit_Center_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

API

Domain API Query: https://demodb.my.erp.net/api/domain/odata/Finance_Accounting_TrialBalanceDetailed?$top=10

Domain API Query Builder: https://demodb.my.erp.net/api/domain/querybuilder#Finance_Accounting_TrialBalanceDetailed?$top=10