Column
AD_Column
Column in the table
Overview
| Table Name | AD_Column |
|---|---|
| Access Level | System + Client |
| Entity Type | D |
| Is Document | No |
| Is View | No |
| Has UUID | Yes |
| Parent Table | AD_Chart |
| Wiki | View on iDempiere Wiki |
Columns (61)
| Column | Type | Required | Default | Description |
|---|---|---|---|---|
AD_Chart_ID |
Table Direct(22) | No | - | - |
AD_InfoWindow_ID |
Table Direct(10) | No | NULL | Info and search/select Window |
AD_Val_Rule_Lookup_ID |
Table(22) | No | - | Override Dynamic Validation Rule for Lookup Window |
AlwaysUpdatableLogic |
Text(2000) | No | - | Logic to determine if field is Updatable irrespective if record's active status or processed status. This logic Applicable only if Always Updatable is N. |
EntityType |
Table(40) | Yes | @SQL=SELECT CASE WHEN '@P|AdempiereSys:N@'='Y' THEN 'D' ELSE get_sysconfig('DEFAULT_ENTITYTYPE','U',0,0) END FROM Dual | Dictionary Entity Type; Determines ownership and synchronization |
FKConstraintName |
String(30) | No | - | - |
FKConstraintType |
List(1) | No | N | - |
FormatPattern |
String(22) | No | - | The pattern used to format a number or date. |
IsAllowCopy |
Yes-No(1) | Yes | Y | Determine if a column must be copied when pushing the button to copy record |
IsAllowLogging |
Yes-No(1) | No | Y | Determine if a column must be recorded into the change log |
IsAlwaysUpdateable |
Yes-No(1) | Yes | N | The column is always updateable, even if the record is not active or processed |
IsAutocomplete |
Yes-No(1) | Yes | N | Automatic completion for text fields |
IsHtml |
Yes-No(1) | No | N | Text has HTML tags |
IsPartitionKey |
Yes-No(1) | Yes | 'N' | This is a partition key |
IsSecure |
Yes-No(1) | Yes | N | Defines whether content must be treated as secure |
IsSelectionColumn |
Yes-No(1) | Yes | - | Is this column used for finding rows in windows |
IsSyncDatabase |
Button(1) | No | - | Change database table definition when changing dictionary definition |
IsToolbarButton |
List(1) | Yes | Y | Show the button on the toolbar, the window, or both |
MandatoryLogic |
Text(2000) | No | - | - |
PA_DashboardContent_ID |
Table Direct(22) | No | - | - |
PartitioningMethod |
List(2) | No | - | Indicates how the Table is partitioned |
Placeholder |
String(255) | No | - | - |
RangePartitionInterval |
String(30) | No | - | Indicates the interval used in a range partitioning |
ReadOnlyLogic |
Text(2000) | No | - | Logic to determine if field is read only (applies only when field is read-write) |
SeqNoPartition |
Integer(14) | No | @SQL=SELECT COALESCE(MAX(SeqNoPartition),0)+10 AS DefaultValue FROM AD_Column WHERE AD_Table_ID=@AD_Table_ID@ AND IsActive='Y' AND IsPartitionKey='Y' | Indicates the order of partition keys |
SeqNoSelection |
Integer(14) | No | - | Selection Column Sequence |
ColumnName |
String(63) | Yes | - | Name of the column in the database |
Name |
String(60) | Yes | - | Alphanumeric identifier of the entity |
AD_Client_ID |
Table Direct(22) | Yes | @AD_Client_ID@ | Tenant for this installation. |
AD_Column_ID |
ID(22) | Yes | - | Column in the table |
AD_Column_UU |
String(36) | No | - | - |
AD_Element_ID |
Search(22) | Yes | - | System Element enables the central maintenance of column description and help. |
AD_Org_ID |
Table Direct(22) | Yes | @AD_Org_ID@ | Organizational entity within tenant |
AD_Process_ID |
Table Direct(22) | No | - | Process or Report |
AD_Reference_ID |
Table(22) | Yes | - | System Reference and Validation |
AD_Reference_Value_ID |
Table(22) | No | - | Required to specify, if data type is Table or List |
AD_Table_ID |
Table Direct(22) | Yes | - | Database Table information |
AD_Val_Rule_ID |
Table Direct(22) | No | - | Dynamic Validation Rule |
Callout |
String(255) | No | - | Fully qualified class names and method - separated by semicolons |
ColumnSQL |
String(4000) | No | - | Virtual Column (r/o) |
Created |
Date+Time(7) | Yes | SYSDATE | Date this record was created |
CreatedBy |
Search(22) | Yes | - | User who created this records |
DefaultValue |
Text(2000) | No | - | Default value hierarchy, separated by ; |
Description |
String(255) | No | - | Optional short description of the record |
FieldLength |
Integer(22) | No | - | Length of the column in the database |
Help |
Text(2000) | No | - | Comment or Hint |
IsActive |
Yes-No(1) | Yes | Y | The record is active in the system |
IsEncrypted |
Button(1) | Yes | N | Display or Storage is encrypted |
IsIdentifier |
Yes-No(1) | Yes | - | This column is part of the record identifier |
IsKey |
Yes-No(1) | Yes | - | This column is the key in this table |
IsMandatory |
Yes-No(1) | Yes | - | Data entry is required in this column |
IsParent |
Yes-No(1) | Yes | - | This column is a link to the parent table (e.g. header from lines) - incl. Association key columns |
IsTranslated |
Yes-No(1) | Yes | - | This column is translated |
IsUpdateable |
Yes-No(1) | Yes | Y | Determines, if the field can be updated |
SeqNo |
Integer(22) | No | - | Method of ordering records; lowest number comes first |
Updated |
Date+Time(7) | Yes | SYSDATE | Date this record was updated |
UpdatedBy |
Search(22) | Yes | - | User who updated this records |
ValueMax |
String(20) | No | - | Maximum Value for a field |
ValueMin |
String(20) | No | - | Minimum Value for a field |
Version |
Amount(22) | Yes | - | Version of the table definition |
VFormat |
String(255) | No | - | Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09" |
Foreign Keys
| Column | References | Description |
|---|---|---|
AD_Chart_ID |
AD_Chart.AD_Chart_ID | - |
AD_InfoWindow_ID |
AD_InfoWindow.AD_InfoWindow_ID | Info and search/select Window |
AD_Val_Rule_Lookup_ID |
AD_Val_Rule_Lookup.AD_Val_Rule_Lookup_ID | Override Dynamic Validation Rule for Lookup Window |
PA_DashboardContent_ID |
PA_DashboardContent.PA_DashboardContent_ID | - |
AD_Client_ID |
AD_Client.AD_Client_ID | Tenant for this installation. |
AD_Element_ID |
AD_Element.AD_Element_ID | System Element enables the central maintenance of column description and help. |
AD_Org_ID |
AD_Org.AD_Org_ID | Organizational entity within tenant |
AD_Process_ID |
AD_Process.AD_Process_ID | Process or Report |
AD_Reference_ID |
AD_Reference.AD_Reference_ID | System Reference and Validation |
AD_Reference_Value_ID |
AD_Reference_Value.AD_Reference_Value_ID | Required to specify, if data type is Table or List |
AD_Table_ID |
AD_Table.AD_Table_ID | Database Table information |
AD_Val_Rule_ID |
AD_Val_Rule.AD_Val_Rule_ID | Dynamic Validation Rule |
Generated on 2026-05-03T15:21:17.115247185Z