View source | Discuss this page | Page history | Printable version   

ERP 2.50:Developers Guide/Database Model/ Column

ERP 2.50:Developers Guide/Database Model/




Defines the columns of a table
The Used in Column Tab defines the table and column this element resides in.

This table contains the following columns:

Name Nullable Data Type Description
AD_Column_ID NVARCHAR2(32)A link to the database column of the table.
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
IsActive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created NDATEThe date that this record is completed.
Updated NDATEx not implemented
CreatedBy NVARCHAR2(32)User who created this records
UpdatedBy NVARCHAR2(32)User who updated this records
Name NNVARCHAR2(60)A non-unique identifier for a record/document often used as a search tool.
Description YNVARCHAR2(255)A space to write additional related information.
Help YNVARCHAR2(2000)A comment that adds additional information to help users work with fields.
ColumnName NVARCHAR2(40)The name of a column within the database.
AD_Table_ID NVARCHAR2(32)A dictionary table used for this tab that points to the database table.
AD_Reference_ID NVARCHAR2(32)The data type of this field.
AD_Reference_Value_ID YVARCHAR2(32)The exact reference specification for a list or a table.
AD_Val_Rule_ID YVARCHAR2(32)A validation rule that defines how an entry is determined to be valid or invalid.
FieldLength NNUMBER(10, 0)An indication of the column length as defined in the database.
DefaultValue YNVARCHAR2(2000)The first non-null value in a set of values. It is used as a default value for a field when creating a record.
IsKey NCHAR(1)This column is the key in this table
IsParent NCHAR(1)This column is a link to the parent table (e.g. header from lines) - incl. Association key columns
IsMandatory NCHAR(1)An indication noting that completing in a field is required to proceed.
IsUpdateable NCHAR(1)An indication that an item can be updated by the user.
ReadOnlyLogic YNVARCHAR2(2000)Logic to determine if field is read only (applies only when field is read-write)
IsIdentifier NCHAR(1)This column is part of the record identifier
SeqNo YNUMBER(10, 0)The order of records in a specified document.
IsTranslated NCHAR(1)An indication that an item is translated.
IsEncrypted NCHAR(1)An indication noting if the input box of a field will present full text or just asterisks.
Callout YNVARCHAR2(60)A series of actions that occur when data is modified.
VFormat YNVARCHAR2(60)x not implemented
ValueMin YNVARCHAR2(20)The lowest possible value an object can take.
ValueMax YNVARCHAR2(20)The highest possible value an item can have.
IsSelectionColumn NCHAR(1)Is this column used for finding rows in windows
AD_Element_ID YVARCHAR2(32)An element that consolidates help, descriptions and terms for a database column and allows for a central maintenance.
AD_Process_ID YVARCHAR2(32)A series of actions carried out in sequential order.
IsSessionAttr YCHAR(1)Is session attribute
IsSecondaryKey YCHAR(1)Is secondary key
IsDesencryptable YCHAR(1)Is desencryptable
AD_Callout_ID YVARCHAR2(32)A series of actions that occur when data is modified.
Developmentstatus YVARCHAR2(60)Development Status
AD_Module_ID NVARCHAR2(32)Module
Position YNUMBERDetermines the physical column position
IsTransient YCHAR(1)Mark if a column is transient and will be ignored when comparing data
isTransientCondition YVARCHAR2(2000)Java expression that will be evaluated and if the result is false, the column will be marked as transient
Isautosave NCHAR(1)Defines if a button triggers autosave or not
ValidateOnNew NCHAR(1)Validations and callouts are executed when a new record is created.

Other Info

Check constraints

These are the check constraints for this table:



These are the indexes for this table (for each index there is a list of all the columns included within it):

Non Unique





Link to the database column of the table



Foreign key column to AD_Client table, (column: AD_Client_ID)

Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:

AD_Client.AD_Client_ID IN (@#User_Client@)



Foreign key column to AD_Org table, (column: AD_Org_ID)



There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.


Creation Date

The Created field indicates the date that this record was created.



The Updated field indicates the date that this record was updated.


Created By

Foreign key column to AD_User table, (column: AD_User_ID)


Updated By

Foreign key column to AD_User table, (column: AD_User_ID)



A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.



A description is limited to 255 characters.



The Help field contains a hint, comment or help about the use of this item.


DB Column Name

The Column Name indicates the name of a column on a table as defined in the database.



Foreign key column to AD_Table table, (column: AD_Table_ID)



Foreign key column to AD_Reference table, (column: AD_Reference_ID)

Reference Table AD_Reference Data Types With the following where clause:



Reference Search Key

Foreign key column to AD_Reference table, (column: AD_Reference_ID)

Reference Table AD_Reference Subreferences : (not DataType and Independent). With the following where clause:

AD_Reference.IsBaseReference = 'N'

Validation Rule AD_Reference Subreference: Subreference validation choices. With the following code:

OR (@AD_Reference_ID@ = '28' AND AD_Reference.ParentReference_ID='17')



Foreign key column to AD_Val_Rule table, (column: AD_Val_Rule_ID)



The Length indicates the length of a column as defined in the database.


Default Value

The defaults are evaluated in the order of definition, the first not null value becomes the default value of the column. The values are separated by comma or semicolon. a) Literals:. 'Text' or 123 b) Variables - in format @Variable@ - Login e.g. #Date, #AD_Org_ID, #AD_Client_ID - Accounting Schema: e.g. $C_AcctSchema_ID, $C_Calendar_ID - Global defaults: e.g. DateFormat - Window values (all Picks, CheckBoxes, RadioButtons, and DateDoc/DateAcct) c) SQL code with the tag: @SQL=SELECT something AS DefaultValue FROM ... The SQL statement can contain variables. There can be no other value other than the SQL statement. The default is only evaluated, if no user preference is defined. Default definitions are ignored for record columns as Key, Parent, Client as well as Buttons.


Key Column

The key column must also be display sequence 0 in the field definition and may be hidden.

Callout: SL_Column

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Column Java class.


Link to Parent Column

The Parent checkbox indicates if this column is a link to the parent table.



The Mandatory checkbox indicates if the field is required for a record to be save to the database.



The Updateable checkbox indicates if a field can be updated by the user.


Read Only Logic

Logic to determine if field is read only (applies only when field is read-write)



The Identifier checkbox indicates that this column is part of the identifier or key for this table


Sequence Number

The Sequence indicates the order of records



The Translated checkbox indicates if this column is translated.


Display Encription

Display encryption - all characters are displayed as '*'. Data storage encryption (i.e. you will not be able to report the data via report tools) is set in the Column definition.


Callout Function

Function Calls separated by semicolons; SE_/SL_/UE_/UL_ - 1st: System/User; 2nd: Enter/Leave; 3rd: _ Underscore, - then Function Name


Value Format

Value Format is the format the value will be displayed with.


Min. Value

The Minimum Value indicates the lowest allowable value for a field.


Max. Value

The Maximum Value indicates the highest allowable value for a field


Filter Column

If selected, this column will be used in the Search Window as an available filter criteria.


Application Element

Foreign key column to AD_Element table, (column: AD_Element_ID)



Foreign key column to AD_Process table, (column: AD_Process_ID)


Stored in Session

Checking this field the data for this column will be stored as session attribute so its content will be accessible from other tab.


Secondary Key

Is secondary key



When Is Desencryptable field is 'Y' the content of this column will be saved in a desencryptable way.



Foreign key column to AD_Callout table, (column: AD_Callout_ID)


Development Status

Development Status defines the status of a table or a column. Ready means that this object is in use, Not Implemented Yet indicates that currently it is not in use but it is planned to be implemented and Deprecated are the objects that are going to be removed from the application in future versions.

List values: Development Status

The allowed values for this list are:



Foreign key column to AD_Module table, (column: AD_Module_ID)

Validation Rule Ad_Module_ID IsInDevelopment: AD_Module_ID IsInDevelopment. With the following code:

IsInDevelopment = 'Y' AND type != 'T'



Determines the physical column position in database. It is a mandatory field which value is unique for all the columns within the same table.



Mark if a column is transient and will be ignored when comparing data


Transient Condition

Java expression that will be evaluated and if the result is false, the column will be marked as transient



If the value is 'Y' the autosave flag will be put in the form and the Autosave process will be triggered


Validate on New

Indicates whether validations and callouts are executed when a new record is created. In general is should be set to Y. It makes sense to disable only in case there are callouts or validations associated to this column and it is known that when a new record is created they do not change any value; in this case this check allows to bypass their execution improving performance.


Related tables

Tables that link this table:


Retrieved from ""

This page has been accessed 6,383 times. This page was last modified on 14 June 2011, at 11:03. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.