Account Element
C_ElementValue
Account Element
Overview
| Table Name | C_ElementValue |
|---|---|
| Access Level | Client + Organization |
| Entity Type | D |
| Is Document | No |
| Is View | No |
| Has UUID | Yes |
| Parent Table | AD_Org |
| Wiki | View on iDempiere Wiki |
Columns (32)
| Column | Type | Required | Default | Description |
|---|---|---|---|---|
BPartnerType |
List(1) | No | - | - |
IsDetailBPartner |
Yes-No(1) | Yes | N | - |
IsDetailProduct |
Yes-No(1) | Yes | N | - |
isNonTaxable |
Yes-No(1) | No | N | Indicates account is taxable or non-taxable |
IsTransferBankAccount |
Yes-No(1) | Yes | N | Indicates if this is the Bank Account Transfer |
Value |
String(40) | Yes | - | Search key for the record in the format required - must be unique |
Name |
String(120) | Yes | - | Alphanumeric identifier of the entity |
AD_Org_ID |
Table Direct(22) | Yes | @AD_Org_ID@ | Organizational entity within tenant |
AccountSign |
List(1) | Yes | N | Indicates the Natural Sign of the Account as a Debit or Credit |
AccountType |
List(1) | Yes | E | Indicates the type of account |
AD_Client_ID |
Table Direct(22) | Yes | @AD_Client_ID@ | Tenant for this installation. |
C_BankAccount_ID |
Table Direct(22) | No | - | Account at the Bank |
C_Currency_ID |
Table Direct(22) | No | - | The Currency for this record |
C_Element_ID |
Table Direct(22) | Yes | - | Accounting Element |
C_ElementValue_ID |
ID(22) | Yes | - | Account Element |
C_ElementValue_UU |
String(36) | No | - | - |
Created |
Date+Time(7) | Yes | SYSDATE | Date this record was created |
CreatedBy |
Search(22) | Yes | - | User who created this records |
Description |
String(255) | No | - | Optional short description of the record |
IsActive |
Yes-No(1) | Yes | Y | The record is active in the system |
IsBankAccount |
Yes-No(1) | No | - | Indicates if this is the Bank Account |
IsDocControlled |
Yes-No(1) | No | - | Control account - If an account is controlled by a document, you cannot post manually to it |
IsForeignCurrency |
Yes-No(1) | No | - | Balances in foreign currency accounts are held in the nominated currency |
IsSummary |
Yes-No(1) | Yes | - | This is a summary entity |
PostActual |
Yes-No(1) | Yes | Y | Actual Values can be posted |
PostBudget |
Yes-No(1) | Yes | Y | Budget values can be posted |
PostEncumbrance |
Yes-No(1) | Yes | Y | Post commitments to this account |
PostStatistical |
Yes-No(1) | Yes | Y | Post statistical quantities to this account? |
Updated |
Date+Time(7) | Yes | SYSDATE | Date this record was updated |
UpdatedBy |
Search(22) | Yes | - | User who updated this records |
ValidFrom |
Date(7) | No | - | Valid from including this date (first day) |
ValidTo |
Date(7) | No | - | Valid to including this date (last day) |
Foreign Keys
| Column | References | Description |
|---|---|---|
AD_Org_ID |
AD_Org.AD_Org_ID | Organizational entity within tenant |
AD_Client_ID |
AD_Client.AD_Client_ID | Tenant for this installation. |
C_BankAccount_ID |
C_BankAccount.C_BankAccount_ID | Account at the Bank |
C_Currency_ID |
C_Currency.C_Currency_ID | The Currency for this record |
C_Element_ID |
C_Element.C_Element_ID | Accounting Element |
Generated on 2026-05-03T17:57:00.851102127Z