Table of Contents

View Acc_Trial_Balance_Detailed

Entity

Entity: Finance.Accounting.TrialBalanceDetailed

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)

Summary

Name Type Description
Account_Id uniqueidentifier General Ledger Account
Closing decimal(38, 2) Closing Balance (debit balance is positive, credit - negative)
Closing_Base decimal(38, 2) Closing balance in base currency (debit balance is positive, credit - negative)
Closing_Credit decimal(38, 2) Closing balance when it is credit
Closing_Credit_Base decimal(38, 2) Closing balance in base currency when it is credit
Closing_Debit decimal(38, 2) Closing balance when it is debit
Closing_Debit_Base decimal(38, 2) Closing balance in base currency when it is debit
Closing_Reporting decimal(38, 2) Closing balance in reporting currency
Cost_Center_Id uniqueidentifier Cost Center
Credit decimal(38, 2) Credit
Credit_Base decimal(38, 2) Credit Base
Credit_Reporting decimal(38, 2) Credit Reporting
Currency_Id uniqueidentifier Currency
Debit decimal(38, 2) Debit
Debit_Base decimal(38, 2) Debit Base
Debit_Reporting decimal(38, 2) Debit Reporting
Enterprise_Company_Id uniqueidentifier Enterprise Company
Enterprise_Company_Location_Id uniqueidentifier Company Location / Branch
Example_Voucher_Line_Id uniqueidentifier 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.
From_Date date Period Start Date - Should be filtered with exact date
Item_Key nvarchar(64) Item Key
Item_Key_Level_1_Code nvarchar(40) Item Key Level 1 Code
Item_Key_Level_1_Name nvarchar(254) ML Item Key Level 1 Name
Item_Key_Level_2_Code nvarchar(40) Item Key Level 2 Code
Item_Key_Level_2_Name nvarchar(254) ML Item Key Level 2 Name
Item_Key_Level_3_Code nvarchar(40) Item Key Level 3 Code
Item_Key_Level_3_Name nvarchar(254) ML Item Key Level 3 Name
Item_Key_Level_4_Code nvarchar(40) Item Key Level 4 Code
Item_Key_Level_4_Name nvarchar(254) ML Item Key Level 4 Name
Item_Key_Level_5_Code nvarchar(40) Item Key Level 5 Code
Item_Key_Level_5_Name nvarchar(254) ML Item Key Level 5 Name
Level_1_Account_Group_Id uniqueidentifier Level 1 Account Group
Level_1_Account_Property_Id uniqueidentifier Level 1 Account Property
Level_2_Account_Group_Id uniqueidentifier Level 2 Account Group
Level_2_Account_Property_Id uniqueidentifier Level 2 Account Property
Level_3_Account_Group_Id uniqueidentifier Level 3 Account Group
Level_3_Account_Property_Id uniqueidentifier Level 3 Account Property
Level_4_Account_Group_Id uniqueidentifier Level 4 Account Group
Level_4_Account_Property_Id uniqueidentifier Level 4 Account Property
Level_5_Account_Group_Id uniqueidentifier Level 5 Account Group
Level_5_Account_Property_Id uniqueidentifier Level 5 Account Property
Level_6_Account_Group_Id uniqueidentifier Level 6 Account Group
Opening decimal(38, 2) Opening balance (debit balance is positive, credit - negative)
Opening_Base decimal(38, 2) Opening balance in base currency (debit balance is positive, credit - negative)
Opening_Credit decimal(38, 2) Opening balance when it is credit
Opening_Credit_Base decimal(38, 2) Opening balance in base currency when it is credit
Opening_Debit decimal(38, 2) Opening balance when it is debit
Opening_Debit_Base decimal(38, 2) Opening balance in base currency when it is debit
Opening_Reporting decimal(38, 2) Opening balance in reporting currency
Profit_Center_Id uniqueidentifier Profit Center
To_Date date Period End Date - Should be filtered with exact date

Columns

Account_Id

General Ledger Account

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

Closing

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

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

Closing_Base

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

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

Closing_Credit

Closing balance when it is 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

Closing_Credit_Base

Closing balance in base currency when it is 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

Closing_Debit

Closing balance when it is debit

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

Closing_Debit_Base

Closing balance in base currency when it is debit

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

Closing_Reporting

Closing 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

Credit

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

Credit_Base

Credit Base

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

Credit_Reporting

Credit Reporting

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

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

Debit

Debit

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

Debit_Base

Debit Base

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

Debit_Reporting

Debit Reporting

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

Enterprise_Company_Id

Enterprise Company

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

Company Location / Branch

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

Example_Voucher_Line_Id

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.

Property Value
Auto Complete no
Base Table.Column Acc_Voucher_Lines.Voucher_Line_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

Example_Voucher_Line_Id - Supported Filters

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

From_Date

Period Start Date - Should be filtered with exact date

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 date
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

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

Item_Key - Supported Filters

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

Item_Key_Level_1_Code

Item Key Level 1 Code

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 40
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(40)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Item_Key_Level_1_Name

Item Key Level 1 Name

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 254
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(254) (MultiLanguage)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Item_Key_Level_2_Code

Item Key Level 2 Code

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 40
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(40)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Item_Key_Level_2_Name

Item Key Level 2 Name

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 254
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(254) (MultiLanguage)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Item_Key_Level_3_Code

Item Key Level 3 Code

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 40
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(40)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Item_Key_Level_3_Name

Item Key Level 3 Name

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 254
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(254) (MultiLanguage)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Item_Key_Level_4_Code

Item Key Level 4 Code

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 40
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(40)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Item_Key_Level_4_Name

Item Key Level 4 Name

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 254
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(254) (MultiLanguage)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Item_Key_Level_5_Code

Item Key Level 5 Code

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 40
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(40)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Item_Key_Level_5_Name

Item Key Level 5 Name

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 254
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(254) (MultiLanguage)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Level_1_Account_Group_Id

Level 1 Account Group

Property Value
Auto Complete no
Base Table.Column Acc_Account_Groups.Account_Group_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

Level_1_Account_Group_Id - Supported Filters

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

Level_1_Account_Property_Id

Level 1 Account Property

Property Value
Auto Complete no
Base Table.Column Gen_Properties.Property_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

Level_1_Account_Property_Id - Supported Filters

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

Level_2_Account_Group_Id

Level 2 Account Group

Property Value
Auto Complete no
Base Table.Column Acc_Account_Groups.Account_Group_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

Level_2_Account_Group_Id - Supported Filters

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

Level_2_Account_Property_Id

Level 2 Account Property

Property Value
Auto Complete no
Base Table.Column Gen_Properties.Property_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

Level_2_Account_Property_Id - Supported Filters

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

Level_3_Account_Group_Id

Level 3 Account Group

Property Value
Auto Complete no
Base Table.Column Acc_Account_Groups.Account_Group_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

Level_3_Account_Group_Id - Supported Filters

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

Level_3_Account_Property_Id

Level 3 Account Property

Property Value
Auto Complete no
Base Table.Column Gen_Properties.Property_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

Level_3_Account_Property_Id - Supported Filters

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

Level_4_Account_Group_Id

Level 4 Account Group

Property Value
Auto Complete no
Base Table.Column Acc_Account_Groups.Account_Group_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

Level_4_Account_Group_Id - Supported Filters

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

Level_4_Account_Property_Id

Level 4 Account Property

Property Value
Auto Complete no
Base Table.Column Gen_Properties.Property_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

Level_4_Account_Property_Id - Supported Filters

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

Level_5_Account_Group_Id

Level 5 Account Group

Property Value
Auto Complete no
Base Table.Column Acc_Account_Groups.Account_Group_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

Level_5_Account_Group_Id - Supported Filters

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

Level_5_Account_Property_Id

Level 5 Account Property

Property Value
Auto Complete no
Base Table.Column Gen_Properties.Property_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

Level_5_Account_Property_Id - Supported Filters

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

Level_6_Account_Group_Id

Level 6 Account Group

Property Value
Auto Complete no
Base Table.Column Acc_Account_Groups.Account_Group_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

Level_6_Account_Group_Id - Supported Filters

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

Opening

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

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

Opening_Base

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

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

Opening_Credit

Opening balance when it is 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

Opening_Credit_Base

Opening balance in base currency when it is 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

Opening_Debit

Opening balance when it is debit

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

Opening_Debit_Base

Opening balance in base currency when it is debit

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

Opening_Reporting

Opening 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

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

To_Date

Period End Date - Should be filtered with exact date

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 date
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

To_Date - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no
Suggest improvement to this page