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

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.ad.ui/AD Tab

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.ad.ui

Index

Contents

AD_Tab

The Tab Tab defines each Tab within a Window. Each Tab contains a discrete selection of fields.

This table contains the following columns:

Name Nullable Data Type Description
AD_Tab_ID NVARCHAR2(32)An indication that a tab is displayed within a window.
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.
CreatedBy NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
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.
AD_Table_ID NVARCHAR2(32)A dictionary table used for this tab that points to the database table.
AD_Window_ID NVARCHAR2(32)A work area which can be used to create, view, edit, and process a record.
SeqNo NNUMBER(10, 0)The order of records in a specified document.
TabLevel NNUMBER(10, 0)Hierarchical Tab Level (0 = top)
IsSingleRow NCHAR(1)Default for toggle between Single- and Multi-Row (Grid) Layout
IsInfoTab YCHAR(1)This tab contain accounting information
IsTranslationTab NCHAR(1)This tab contains translation information
AD_Column_ID YVARCHAR2(32)A link to the database column of the table.
HasTree NCHAR(1)Window has Tree Graph
WhereClause YNVARCHAR2(2000)A specification of the SQL WHERE clause used for permanently filtering displayed data.
OrderByClause YNVARCHAR2(2000)A specification of the SQL ORDER BY clause used for a displayed default sort of records.
CommitWarning YNVARCHAR2(2000)A warning or information displayed when saving the record.
AD_Process_ID YVARCHAR2(32)A series of actions carried out in sequential order.
Processing YCHAR(1)A request to process the respective document or task.
AD_Image_ID YVARCHAR2(32)A visual picture used to describe an item.
ImportFields YCHAR(1)Create Fields from Table Columns
AD_ColumnSortOrder_ID YVARCHAR2(32)Column determining the order
AD_ColumnSortYesNo_ID YVARCHAR2(32)Column determining if a Table Column is included in Ordering
IsSortTab NCHAR(1)The Tab determines the Order
Included_Tab_ID YVARCHAR2(32)Included Tab in this Tab (Master Dateail)
FilterClause YNVARCHAR2(2000)Filter clause
EditReference YVARCHAR2(32)The form referenced in the edition command
AD_Module_ID NVARCHAR2(32)Module
UIPattern NVARCHAR2(60)Defines the UI Pattern
Hqlwhereclause YVARCHAR2(2000)null
Hqlorderbyclause YVARCHAR2(2000)null
Hqlfilterclause YVARCHAR2(2000)null

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

Tab

The Tab indicates a tab that displays within a window.

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

Created By

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

top

Updated

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

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

Table

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

top

Window

Foreign key column to AD_Window table, (column: AD_Window_ID)

top

Sequence Number

The Sequence indicates the order of records

top

Tab Level

Hierarchical level of the tab. If the level is 0, it is the top entity. Level 1 entries are dependent on level 0, etc.

top

Default Edit Mode

The Single Row Layout checkbox indicates if the default display type for this window is a single row as opposed to multi row.

top

Accounting Tab

The Accounting Tab checkbox indicates if this window contains accounting information.

top

Translation Tab

The Translation Tab checkbox indicate if a tab contains translation information.

top

Column

Foreign key column to AD_Column table, (column: AD_Column_ID)


Validation Rule AD_Column must be in AD_Table: Table must be previously defined. With the following code:

 
AD_Column.AD_Table_ID=@AD_Table_ID@

top

Tree Included

The Has Tree checkbox indicates if this window displays a tree metaphor.

top

SQL Where Clause

The Where Clause indicates the SQL WHERE clause to use for record selection. The WHERE clause is added to the query. Fully qualified means "tablename.columnname".

top

SQL Order by Clause

The ORDER BY Clause indicates the SQL ORDER BY clause to use for record selection

top

Confirmation Message

Warning or information displayed when committing the record

top

Process

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


Validation Rule AD_Process Reports: null. With the following code:

 
AD_Process.IsReport='Y'

top

Process Now

When this field is set as 'Y' a process is being performed on this record.

top

Image

Foreign key column to AD_Image table, (column: AD_Image_ID)

top

Import Fields

Create Fields from Table Columns, this process will create the fields that don't exists in the tab but which exist in the correspondent table.

top

Order Column

Foreign key column to AD_Column table, (column: AD_Column_ID)


Reference Table AD_Column Integer With the following where clause:

 
AD_Column.AD_Reference_ID='11'


Validation Rule AD_Column must be in AD_Table: Table must be previously defined. With the following code:

 
AD_Column.AD_Table_ID=@AD_Table_ID@

top

Included Column

Foreign key column to AD_Column table, (column: AD_Column_ID)


Reference Table AD_Column YesNo With the following where clause:

 
AD_Column.AD_Reference_ID='20'


Validation Rule AD_Column must be in AD_Table: Table must be previously defined. With the following code:

 
AD_Column.AD_Table_ID=@AD_Table_ID@

top

Sequence Tab

The Tab determines the Order.

top

Included Tab

Foreign key column to AD_Tab table, (column: AD_Tab_ID)


Reference Table AD_Tab


Validation Rule AD_Tab in Window: null. With the following code:

 
AD_Tab.AD_Window_ID=@AD_Window_ID@

top

Filter Clause

Filter clause

top

Master Detail Form

Foreign key column to AD_Form table, (column: AD_Form_ID)


Reference Table AD_Form With the following where clause:

 
AD_Form.isActive = 'Y'


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

UI Pattern

Defines the UI Pattern that the object implements.

List values: Tab UI Pattern

The allowed values for this list are:

top

Hqlwhereclause

top

Hqlorderbyclause

top

Hqlfilterclause

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.ui/AD_Tab"

This page has been accessed 4,362 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.