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
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