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
API access: ReadWrite
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