Finance.Accounting.TrialBalanceDetailed (View)
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.
General
Namespace: Finance.Accounting
Repository: Finance.Accounting.TrialBalanceDetailed
Introduced In Version: 25.1.3.22
API access: ReadWrite
Visualization
Display Format: {FromDate}: {ToDate}
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 creditRequired |
| ClosingCreditBase | decimal (38, 2) | Closing balance in base currency when it is creditRequired |
| ClosingDebit | decimal (38, 2) | Closing balance when it is debitRequired |
| ClosingDebitBase | decimal (38, 2) | Closing balance in base currency when it is debitRequired |
| ClosingReporting | decimal (38, 2) | Closing balance in reporting currencyRequired |
| Credit | decimal (38, 2) | CreditRequired |
| CreditBase | decimal (38, 2) | Credit BaseRequired |
| CreditReporting | decimal (38, 2) | Credit ReportingRequired |
| Debit | decimal (38, 2) | DebitRequired |
| DebitBase | decimal (38, 2) | Debit BaseRequired |
| DebitReporting | decimal (38, 2) | Debit ReportingRequired |
| FromDate | date | Period Start Date - Should be filtered with exact dateRequired Filter(eq) |
| ItemKey | string (64) | Item KeyRequired Filter(eq;like) |
| ItemKeyLevel1Code | string (40) | Item Key Level 1 CodeRequired |
| ItemKeyLevel1Name | MultilanguageString (254) | Item Key Level 1 NameRequired |
| ItemKeyLevel2Code | string (40) | Item Key Level 2 CodeRequired |
| ItemKeyLevel2Name | MultilanguageString (254) | Item Key Level 2 NameRequired |
| ItemKeyLevel3Code | string (40) | Item Key Level 3 CodeRequired |
| ItemKeyLevel3Name | MultilanguageString (254) | Item Key Level 3 NameRequired |
| ItemKeyLevel4Code | string (40) | Item Key Level 4 CodeRequired |
| ItemKeyLevel4Name | MultilanguageString (254) | Item Key Level 4 NameRequired |
| ItemKeyLevel5Code | string (40) | Item Key Level 5 CodeRequired |
| ItemKeyLevel5Name | MultilanguageString (254) | Item Key Level 5 NameRequired |
| 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 creditRequired |
| OpeningCreditBase | decimal (38, 2) | Opening balance in base currency when it is creditRequired |
| OpeningDebit | decimal (38, 2) | Opening balance when it is debitRequired |
| OpeningDebitBase | decimal (38, 2) | Opening balance in base currency when it is debitRequired |
| OpeningReporting | decimal (38, 2) | Opening balance in reporting currencyRequired Introduced in version 25.1.3.29 |
| ToDate | date | Period End Date - Should be filtered with exact dateRequired Filter(eq) |
References
| Name | Type | Description |
|---|---|---|
| Account | Accounts | General Ledger Account |
| CostCenter | CostCenters | Cost Center |
| Currency | Currencies | Currency |
| EnterpriseCompany | EnterpriseCompanies | Enterprise Company |
| EnterpriseCompanyLocation | CompanyLocations | Company Location / Branch |
| 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. |
| Level1AccountGroup | AccountGroups | Level 1 Account Group |
| Level1AccountProperty | CustomProperties | Level 1 Account Property |
| Level2AccountGroup | AccountGroups | Level 2 Account Group |
| Level2AccountProperty | CustomProperties | Level 2 Account Property |
| Level3AccountGroup | AccountGroups | Level 3 Account Group |
| Level3AccountProperty | CustomProperties | Level 3 Account Property |
| Level4AccountGroup | AccountGroups | Level 4 Account Group |
| Level4AccountProperty | CustomProperties | Level 4 Account Property |
| Level5AccountGroup | AccountGroups | Level 5 Account Group |
| Level5AccountProperty | CustomProperties | Level 5 Account Property |
| Level6AccountGroup | AccountGroups | Level 6 Account Group |
| ProfitCenter | ProfitCenters | Profit Center |
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 creditRequired
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 creditRequired
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ClosingDebit
Closing balance when it is debitRequired
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 debitRequired
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ClosingReporting
Closing balance in reporting currencyRequired
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
Credit
CreditRequired
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
CreditBase
Credit BaseRequired
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
CreditReporting
Credit ReportingRequired
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
Debit
DebitRequired
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
DebitBase
Debit BaseRequired
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
DebitReporting
Debit ReportingRequired
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 dateRequired Filter(eq)
Type: date
Category: System
Supported Filters: Equals
Supports Order By: False
Show in UI: ShownByDefault
ItemKey
Item KeyRequired 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 CodeRequired
Type: string (40)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Maximum Length: 40
Show in UI: ShownByDefault
ItemKeyLevel1Name
Item Key Level 1 NameRequired
Type: MultilanguageString (254)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ItemKeyLevel2Code
Item Key Level 2 CodeRequired
Type: string (40)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Maximum Length: 40
Show in UI: ShownByDefault
ItemKeyLevel2Name
Item Key Level 2 NameRequired
Type: MultilanguageString (254)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ItemKeyLevel3Code
Item Key Level 3 CodeRequired
Type: string (40)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Maximum Length: 40
Show in UI: ShownByDefault
ItemKeyLevel3Name
Item Key Level 3 NameRequired
Type: MultilanguageString (254)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ItemKeyLevel4Code
Item Key Level 4 CodeRequired
Type: string (40)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Maximum Length: 40
Show in UI: ShownByDefault
ItemKeyLevel4Name
Item Key Level 4 NameRequired
Type: MultilanguageString (254)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ItemKeyLevel5Code
Item Key Level 5 CodeRequired
Type: string (40)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Maximum Length: 40
Show in UI: ShownByDefault
ItemKeyLevel5Name
Item Key Level 5 NameRequired
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 creditRequired
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 creditRequired
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
OpeningDebit
Opening balance when it is debitRequired
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 debitRequired
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
OpeningReporting
Opening balance in reporting currencyRequired 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 dateRequired Filter(eq)
Type: date
Category: System
Supported Filters: Equals
Supports Order By: False
Show in UI: ShownByDefault
Reference Details
Account
General Ledger Account
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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 Entity Set: Finance_Accounting_TrialBalanceDetailed
Domain API Entity Type: Finance_Accounting_TrialBalanceDetailedEntry
Domain API Query: https://testdb.my.erp.net/api/domain/odata/Finance_Accounting_TrialBalanceDetailed?$top=10
Domain API Query Builder: https://testdb.my.erp.net/api/domain/querybuilder#Finance_Accounting_TrialBalanceDetailed?$top=10