Table of Contents

View Acc_Current_Balances

Entity

Entity: Finance.Accounting.CurrentBalances

Contains live account balances calculated from all released accounting vouchers in the system. Reflects the up-to-date financial position, including transactions with future dates. Entity: Acc_Current_Balances (Introduced in version 25.1.3.29)

Summary

Name Type Description
Account_Id uniqueidentifier Account reference
Balance decimal(38, 2) Net current balance (Debit - Credit)
Balance_Base decimal(38, 2) Current balance in base currency
Balance_Reporting decimal(38, 2) Current balance in reporting currency
Cost_Center_Id uniqueidentifier Cost Center
Currency_Id uniqueidentifier Currency
Enterprise_Company_Id uniqueidentifier Legal entity
Enterprise_Company_Location_Id uniqueidentifier Optional location/branch filter
Item_Key nvarchar(64) Item Key
Profit_Center_Id uniqueidentifier Profit Center

Columns

Account_Id

Account reference

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Account_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Balance

Net current balance (Debit - Credit)

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Balance_Base

Current balance in base currency

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Balance_Reporting

Current balance in reporting currency

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Cost_Center_Id

Cost Center

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Cost_Center_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Currency_Id

Currency

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Currency_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Enterprise_Company_Id

Legal entity

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Enterprise_Company_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Enterprise_Company_Location_Id

Optional location/branch filter

Property Value
Auto Complete no
Base Table.Column Cm_Company_Locations.Company_Location_Id
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Enterprise_Company_Location_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Item_Key

Item Key

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 64
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(64)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Profit_Center_Id

Profit Center

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Profit_Center_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no