ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.ui/AD Field
AD_Field
- Name:AD_Field
- Classname:ADField
This table contains the following columns:
Name | Nullable | Data Type | Description
|
IsActive | No | CHAR (1) | 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. |
IsCentrallyMaintained | No | CHAR (1) | The Centrally Maintained checkbox indicates if the Name, Description and Help maintained in 'System Element' table or 'Window' table. |
AD_Client_ID | No | VARCHAR (32) | A Client is a company or a legal entity. You cannot share data between Clients. |
Clientclass | Yes | NVARCHAR (255) | |
AD_Column_ID | Yes | VARCHAR (32) | Link to the database column of the table |
CreatedBy | No | VARCHAR (32) | The Created By field indicates the user who created this record. |
Created | No | TIMESTAMP (7) | The Created field indicates the date that this record was created. |
Description | Yes | NVARCHAR (255) | A description is limited to 255 characters. |
IsEncrypted | No | CHAR (1) | This option is deprecated. One of the new references "Password (decryptable)" or "Password (not-decryptable)" should be used instead. |
IsFieldOnly | Yes | CHAR (1) | The Field Only checkbox indicates that the column will display without a label. |
DisplayLogic | Yes | NVARCHAR (2000) | A specification of statements which, when evaluated as false, cause the field to appear hidden. |
Displaylogic_Server | Yes | NVARCHAR (2000) | A specification of statements which, when evaluated as false in the Server, cause the field to not appear at all in the Window generated. |
IsSameLine | No | CHAR (1) | An indication that the field will display on the same line as the previous one. |
IsDisplayed | No | CHAR (1) | If the field is displayed, the field Display Logic will determine at runtime, if it is actually displayed |
DisplayLength | Yes | DECIMAL (10,0) | Display length is the size that will be appear for the field, it can be different that the actual size of the column (note that if it is bigger than the column the data will be truncated to the column size). |
Displaylogicgrid | Yes | NVARCHAR (2000) | |
EM_Obuiapp_Showsummary | No | CHAR (1) | Defines if the Field should show a summary function at the end of the grid |
EM_Obuiapp_Colspan | Yes | DECIMAL (10,0) | This value can be used to define, multi-columns fields. So fields occupying more then one column. If this value is not set the normal calculation takes place. |
EM_Obuiapp_Default_Expression | Yes | NVARCHAR (2000) | Defines a JavaScript expression that will be evaluated in the server side and used as default value for the property. You can use any type of variable but it must match the property type, examples:
true - the property associated is a boolean "Hello" - the property associated is a string 5.3 - the property associated is a number You can also access the Openbravo API through the OB object and do some more complex expressions, e.g. OB.getSession().getAttribute("SESSIONVAR"); This will retrieve the session variable SESSIONVAR and use it as default value for the filter of this field. |
EM_Obuiapp_Rowspan | Yes | DECIMAL (10,0) | This value can be used to define, multi-row fields. So fields occupying more then one row. If this value is not set the normal calculation takes place. |
EM_Obuiapp_Summaryfn | Yes | VARCHAR (255) | Defines the summary function to use, valid values: sum, avg, max, min, count |
EM_Obuiapp_Validator | Yes | VARCHAR (255) | By default a field have a set of validation functions, isNumber, isBoolean, etc. The developer can define a custom validator function to check the value entered by a the user. |
EM_Obuisel_Outfield_ID | Yes | VARCHAR (32) | The new selector can define a field as 'Out Field'. If a column from a tab is using a selector with an out field it will get listed. A field from the tab can receive the value of an Selector Out Field when the user picks a record in the selector. This fields establishes the connection between a selector out field and a field in the tab. |
AD_Field_ID | No | VARCHAR (32) | The Field identifies a field on a database table. |
AD_FieldGroup_ID | Yes | VARCHAR (32) | The Field Group indicates the logical group that this field belongs to (History, Amounts, Quantities) |
Grid_Seqno | Yes | DECIMAL (10,0) | Position of the column in grid view. If there are fields shown in grid with this property set, they will be placed at first in grid ordered by this value, after them, the rest of fields ordered by their seqNo value. |
Help | Yes | NVARCHAR (2000) | The Help field contains a hint, comment or help about the use of this item. |
Ignoreinwad | Yes | CHAR (1) | |
Isfirstfocusedfield | Yes | CHAR (1) |
When it is active this field will be focused by default when the tab is opened. |
AD_Module_ID | No | VARCHAR (32) | Indicates the module the element forms part of. |
Name | No | NVARCHAR (60) | 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. |
Onchangefunction | Yes | NVARCHAR (255) | This function needs to be the global id of a javascript function which is called on the client whenever the value of the field changes. |
AD_Org_ID | No | VARCHAR (32) | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. |
Property | Yes | VARCHAR (255) | It is the "Configuration Property" this record sets value to.
Configuration Properties are defined by modules with the purpose other modules are capable to assign them values. |
IsReadOnly | No | CHAR (1) | The Read Only indicates that this field may only be Read. It may not be updated. |
SortNo | Yes | DECIMAL (10,0) | The Record Sort No indicates the ascending sort sequence of the records |
SeqNo | Yes | DECIMAL (10,0) | The Sequence indicates the order of records |
ShowInRelation | Yes | CHAR (1) | When this field is set as 'Y' the field will be shown in the grid view (as well as in the form view), otherwise it only will be displayed in the form view. |
isShownInStatusBar | No | CHAR (1) | Defines if the field is shown in the status bar. |
Startinoddcolumn | No | CHAR (1) | |
Startnewline | No | CHAR (1) | |
AD_Tab_ID | No | VARCHAR (32) | The Tab indicates a tab that displays within a window. |
Updated | No | TIMESTAMP (7) | The Updated field indicates the date that this record was updated. |
UpdatedBy | No | VARCHAR (32) | The Updated By field indicates the user who updated this record. |
Columns
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Central Maintenance
- Physical column name: IsCentrallyMaintained
- Property Name: centralMaintenance
- Reference: YesNo
- Default value: Y
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_ID)
It has a validation "AD_Client Security validation", with the following code
AD_Client.AD_Client_ID in (@#User_Client@)
Clientclass
- Physical column name: Clientclass
- Property Name: clientclass
- Reference: String
Column
- Physical column name: AD_Column_ID
- Property Name: column
- Reference: TableDir
Foreign key column to AD_Column table, (column: AD_Column_ID)
It has a validation "AD_Column must be in AD_Table", with the following code
AD_Column.AD_Table_ID=@AD_Table_ID@
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Description
- Physical column name: Description
- Property Name: description
- Reference: String
Display Encription
- Physical column name: IsEncrypted
- Property Name: displayEncription
- Reference: YesNo
- Default value: N
Display Field Only
- Physical column name: IsFieldOnly
- Property Name: displayFieldOnly
- Reference: YesNo
- Default value: N
Display Logic
- Physical column name: DisplayLogic
- Property Name: displayLogic
- Reference: Text
Display Logic evaluated in the Server
- Physical column name: Displaylogic_Server
- Property Name: displayLogicEvaluatedInTheServer
- Reference: Text
Display on Same Line
- Physical column name: IsSameLine
- Property Name: displayOnSameLine
- Reference: YesNo
- Default value: N
Displayed
- Physical column name: IsDisplayed
- Property Name: displayed
- Reference: YesNo
- Default value: Y
Displayed Length
- Physical column name: DisplayLength
- Property Name: displayedLength
- Reference: Integer
Displaylogicgrid
- Physical column name: Displaylogicgrid
- Property Name: displaylogicgrid
- Reference: Text
EM_OBUIAPP_ShowSummary
- Physical column name: EM_Obuiapp_Showsummary
- Property Name: oBUIAPPShowSummary
- Reference: YesNo
- Default value: N
EM_Obuiapp_Colspan
- Physical column name: EM_Obuiapp_Colspan
- Property Name: obuiappColspan
- Reference: Integer
EM_Obuiapp_Default_Expression
- Physical column name: EM_Obuiapp_Default_Expression
- Property Name: obuiappDefaultExpression
- Reference: String
EM_Obuiapp_Rowspan
- Physical column name: EM_Obuiapp_Rowspan
- Property Name: obuiappRowspan
- Reference: Integer
EM_Obuiapp_Summaryfn
- Physical column name: EM_Obuiapp_Summaryfn
- Property Name: obuiappSummaryfn
- Reference: String
EM_Obuiapp_Validator
- Physical column name: EM_Obuiapp_Validator
- Property Name: obuiappValidator
- Reference: String
EM_Obuisel_Outfield_ID
- Physical column name: EM_Obuisel_Outfield_ID
- Property Name: obuiselOutfield
- Reference: Table
Foreign key column to OBUISEL_Selector_Field table, (column: Obuisel_Selector_Field_ID)
Field
- Physical column name: AD_Field_ID
- Property Name: id
- Reference: ID
Field Group
- Physical column name: AD_FieldGroup_ID
- Property Name: fieldGroup
- Reference: TableDir
Foreign key column to AD_FieldGroup table, (column: AD_FieldGroup_ID)
Grid Position
- Physical column name: Grid_Seqno
- Property Name: gridPosition
- Reference: Integer
Help/Comment
- Physical column name: Help
- Property Name: helpComment
- Reference: Text
IgnoreInWad
- Physical column name: Ignoreinwad
- Property Name: ignoreInWad
- Reference: YesNo
- Default value: N
Is First Focused Field
- Physical column name: Isfirstfocusedfield
- Property Name: isFirstFocusedField
- Reference: YesNo
- Default value: N
Module
- Physical column name: AD_Module_ID
- Property Name: module
- Reference: TableDir
- Default value: 0
Foreign key column to AD_Module table, (column: AD_Module_ID)
It has a validation "Ad_Module_ID IsInDevelopment", with the following code
IsInDevelopment = 'Y' and type != 'T'
Name
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
OnChangeFunction
- Physical column name: Onchangefunction
- Property Name: onChangeFunction
- Reference: String
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Property
- Physical column name: Property
- Property Name: property
- Reference: OBUISEL_Selector Reference
Read Only
- Physical column name: IsReadOnly
- Property Name: readOnly
- Reference: YesNo
- Default value: N
Record Sort No.
- Physical column name: SortNo
- Property Name: recordSortNo
- Reference: Integer
Sequence Number
- Physical column name: SeqNo
- Property Name: sequenceNumber
- Reference: Integer
Show in Grid View
- Physical column name: ShowInRelation
- Property Name: showInGridView
- Reference: YesNo
- Default value: Y
Shown in Status Bar
- Physical column name: isShownInStatusBar
- Property Name: shownInStatusBar
- Reference: YesNo
- Default value: N
Callout: SL_StatusFieldDefaults
This column has a callout associated. Handles setting 'Read-only' flag when 'Show is Status Bar' flag is checked. It is implemented by [1] Java Class.
Startinoddcolumn
- Physical column name: Startinoddcolumn
- Property Name: startinoddcolumn
- Reference: YesNo
- Default value: N
Startnewline
- Physical column name: Startnewline
- Property Name: startnewline
- Reference: YesNo
- Default value: N
Tab
- Physical column name: AD_Tab_ID
- Property Name: tab
- Reference: TableDir
- This column is part of the table's identifier
- This column is a child for a business object (is Parent)
Foreign key column to AD_Tab table, (column: AD_Tab_ID)
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Other Info
Indices
These are the indices for this table (for each index there is a list of all the columns included within it):
- AD_FIELD_COLUMN Not Unique. Columns:
- AD_COLUMN_ID
- AD_FIELD_IGNOREINWAD Not Unique. Columns:
- IGNOREINWAD
- AD_FIELD_TAB Not Unique. Columns:
- AD_TAB_ID
Check Constraints
These are the check constraints for this table:
- AD_FIELD_ISACTIVE_CHK: ISACTIVE IN ('Y', 'N')
- AD_FIELD_ISCENTRALLYMAINTA_CHK: ISCENTRALLYMAINTAINED IN ('Y', 'N')
- AD_FIELD_ISDISPLAYED_CHK: ISDISPLAYED IN ('Y', 'N')
- AD_FIELD_ISENCRYPTED_CHK: ISENCRYPTED IN ('Y', 'N')
- AD_FIELD_ISFIELDONLY_CHK: ISFIELDONLY IN ('Y', 'N')
- AD_FIELD_ISREADONLY_CHK: ISREADONLY IN ('Y', 'N')
- AD_FIELD_ISSAMELINE_CHK: ISSAMELINE IN ('Y', 'N')
- AD_FIELD_ISSHOWNINSB_CHK: ISSHOWNINSTATUSBAR IN ('Y', 'N')
- AD_FIELD_STARTINODDCOLUMN_CHK: STARTINODDCOLUMN IN ('Y', 'N')
- AD_FIELD_STARTNEWLINE_CHK: STARTNEWLINE IN ('Y', 'N')
- EM_OBUIAPP_AD_FIELD_SUMMARY: EM_OBUIAPP_SHOWSUMMARY IN ('Y', 'N')
![]() | Back to org.openbravo.model.ad.ui |