View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

ERP/2.50/Developers Guide/Database Model/org.openbravo.model.ad.datamodel/AD Column

Contents

AD_Column

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:

top

Indexes

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

Non Unique

Unique

top

Columns

Column

Link to the database column of the table

top

Client

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@)

top

Organization

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

top

Active

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.

top

Creation Date

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

top

Updated

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

top

Created By

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

top

Updated By

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

top

Name

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.

top

Description

A description is limited to 255 characters.

top

Help/Comment

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

top

DB Column Name

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

top

Table

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

top

Reference

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


Reference Table AD_Reference Data Types With the following where clause:

 
AD_Reference.IsBaseReference='Y'


top

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:

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

top

Validation

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

top

Length

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

top

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.

top

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.

top

Link to Parent Column

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

top

Mandatory

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

top

Updatable

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

top

Read Only Logic

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

top

Identifier

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

top

Sequence Number

The Sequence indicates the order of records

top

Translation

The Translated checkbox indicates if this column is translated.

top

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.

top

Callout Function

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

top

Value Format

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

top

Min. Value

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

top

Max. Value

The Maximum Value indicates the highest allowable value for a field

top

Filter Column


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

top

Application Element

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

top

Process

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

top

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.

top

Secondary Key

Is secondary key

top

De-encryptable

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

top

Callout

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

top

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:

top

Module

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'

top

Position

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

top

Transient

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

top

Transient Condition

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

top

Isautosave

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

top

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.

top

Related tables

Tables that link this table:

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP/2.50/Developers_Guide/Database_Model/org.openbravo.model.ad.datamodel/AD_Column"

This page has been accessed 9,136 times. This page was last modified on 2 July 2011, at 20:33. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.