Table Acc_Accounts
Entity
Entity: Finance.Accounting.Accounts
Contains the leaf level of the chart of accounts. Entity: Acc_Accounts
Summary
Name |
Type |
Description |
Account_Full_Number |
nvarchar(30) Readonly |
The full number of the account, unique among all accounts. It consists of the group number, concatenated with the account number |
Account_Group_Id |
uniqueidentifier |
The account group to which this account belongs |
Account_Id |
uniqueidentifier PK |
|
Account_Name |
nvarchar(254) ML |
The account name |
Account_Number |
nvarchar(30) |
The number of the account, unique within the account group |
Currency_Id |
uniqueidentifier |
The primary currency of the account. All movements on the account are stored in this currency. If there are movements on the account, the currency cannot be changed |
Currency_Valuation_Method |
nvarchar(3) Allowed: ACB , DCD , BRD |
Method for base currency valuation of non base currency amounts. ACB = Account_Current_Balance, DCD = Document_Currency_Directory, BRD=Balance_Reference_Document |
Description |
nvarchar(254) |
|
Discontinued |
bit |
1 means that the account won't be used any more and should not appear in combo boxes |
Enterprise_Company_Id |
uniqueidentifier |
|
Row_Version |
timestamp |
|
Columns
Account_Full_Number
The full number of the account, unique among all accounts. It consists of the group number, concatenated with the account number
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 |
30 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
yes |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
no |
Type |
nvarchar(30) |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Account_Full_Number - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Like |
None |
no |
no |
Account_Group_Id
The account group to which this account belongs
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
no |
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 |
Referenced Table |
Acc_Account_Groups |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
yes |
Type |
uniqueidentifier |
UI Memo Editor |
no |
UI Width |
50 |
User Login |
no |
Visible |
yes |
Account_Group_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Account_Id
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 |
yes (order: 1) |
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 |
no |
Account_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Account_Name
The account 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 |
Long |
User Login |
no |
Visible |
yes |
Account_Name - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Like |
None |
no |
no |
Account_Number
The number of the account, unique within the account group
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 |
30 |
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(30) |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Account_Number - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Like |
None |
no |
no |
Currency_Id
The primary currency of the account. All movements on the account are stored in this currency. If there are movements on the account, the currency cannot be changed
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
no |
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 |
Referenced Table |
Gen_Currencies |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
yes |
Type |
uniqueidentifier (Allows NULL) |
UI Memo Editor |
no |
UI Width |
50 |
User Login |
no |
Visible |
yes |
Currency_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
yes |
yes |
Currency_Valuation_Method
Method for base currency valuation of non base currency amounts. ACB = Account_Current_Balance, DCD = Document_Currency_Directory, BRD=Balance_Reference_Document
Property |
Value |
Allowed Values |
ACB , DCD , BRD |
Auto Complete |
no |
Data Filter |
no |
Default Value |
ACB |
Enter Stop |
no |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
3 |
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(3) |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Description
Property |
Value |
Attributes |
IsLongString |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
no |
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) (Allows NULL) |
UI Memo Editor |
no |
UI Width |
100 |
User Login |
no |
Visible |
yes |
Discontinued
1 means that the account won't be used any more and should not appear in combo boxes
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
False |
Enter Stop |
no |
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 |
bit |
UI Memo Editor |
no |
UI Width |
100 |
User Login |
no |
Visible |
yes |
Discontinued - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Enterprise_Company_Id
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
no |
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 |
Referenced Table |
Gen_Enterprise_Companies |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
yes |
Type |
uniqueidentifier (Allows NULL) |
UI Memo Editor |
no |
UI Width |
100 |
User Login |
no |
Visible |
yes |
Enterprise_Company_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
yes |
no |
Row_Version
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 |
timestamp |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
no |