ERP/3.0/Developers Guide/Database Model/org.openbravo.userinterface.selector/OBUISEL Selector Field
OBUISEL_Selector_Field
- Name:OBUISEL_Selector_Field
- Classname:OBUISEL_Selector_Field
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. |
| Clause_Left_Part | Yes | VARCHAR (255) | Left part of a clause to be used on the where or order by clauses of the HQL. |
| AD_Client_ID | No | VARCHAR (32) | A Client is a company or a legal entity. You cannot share data between Clients. |
| 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. |
| Default_Expression | Yes | VARCHAR (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 boolean "Hello" - the propery associated is string 5.3 - the property associated is numeric 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 selector field |
| Description | Yes | NVARCHAR (255) | A description is limited to 255 characters. |
| Display_Expression | Yes | VARCHAR (255) | Alias of the HQL query column to be shown |
| Filter | No | CHAR (1) | Make it possible to filter in the grid using this field. |
| Help | Yes | NVARCHAR (2000) | The Help field contains a hint, comment or help about the use of this item. |
| Isoutfield | No | CHAR (1) | |
| 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. |
| Obserds_Datasource_Field_ID | Yes | VARCHAR (32) | The datasource field is part of the datasource definition. |
| Obuisel_Selector_Field_ID | No | VARCHAR (32) | Unique identifying key for the selector field record. |
| Obuisel_Selector_ID | No | VARCHAR (32) | The unique identifying key for the selector. |
| 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) | Path/name of the property to show in the selector |
| AD_Reference_ID | Yes | VARCHAR (32) | The Reference indicates the type of reference field |
| Searchinsuggestionbox | No | CHAR (1) | Defines if the field is used to search when retrieving values in the suggestion box. |
| Showinpicklist | No | CHAR (1) | Sets additional fields to appear on the selectors pick list. |
| Showingrid | No | CHAR (1) | Defines if the field is shown in the popup grid. |
| Sort | No | CHAR (1) | Allow sorting by this field in the popup grid. |
| Sortno | No | DECIMAL (10,0) | |
| Suffix | Yes | VARCHAR (60) | The Suffix indicates the characters to append to the document number. |
| 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
Clause Left Part
- Physical column name: Clause_Left_Part
- Property Name: clauseLeftPart
- Reference: String
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@)
Column
- Physical column name: AD_Column_ID
- Property Name: column
- Reference: TableDir
Foreign key column to AD_Column table, (column: AD_Column_ID)
Callout: DefaultExpression
This column has a callout associated. Tests if the default expression used in a selector field is valid It is implemented by [1] Java Class.
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
Default_Expression
- Physical column name: Default_Expression
- Property Name: defaultExpression
- Reference: Memo
Callout: DefaultExpression
This column has a callout associated. Tests if the default expression used in a selector field is valid It is implemented by [2] Java Class.
Description
- Physical column name: Description
- Property Name: description
- Reference: String
Display Column Alias
- Physical column name: Display_Expression
- Property Name: displayColumnAlias
- Reference: String
Filterable
- Physical column name: Filter
- Property Name: filterable
- Reference: YesNo
- Default value: N
Help/Comment
- Physical column name: Help
- Property Name: helpComment
- Reference: String
Isoutfield
- Physical column name: Isoutfield
- Property Name: isoutfield
- Reference: YesNo
- Default value: N
Module
- Physical column name: AD_Module_ID
- Property Name: module
- Reference: TableDir
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
Obserds_Datasource_Field_ID
- Physical column name: Obserds_Datasource_Field_ID
- Property Name: obserdsDatasourceField
- Reference: TableDir
Foreign key column to OBSERDS_Datasource_Field table, (column: Obserds_Datasource_Field_ID)
It has a validation "DataSource Field must be in DataSource", with the following code
OBSERDS_DATASOURCE_FIELD.OBSERDS_DATASOURCE_ID=@OBSERDS_DATASOURCE_ID@
Obuisel_Selector_Field_ID
- Physical column name: Obuisel_Selector_Field_ID
- Property Name: id
- Reference: ID
Obuisel_Selector_ID
- Physical column name: Obuisel_Selector_ID
- Property Name: obuiselSelector
- 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 OBUISEL_Selector table, (column: Obuisel_Selector_ID)
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
It has a validation "AD_Org Security validation", with the following code
(@AD_Client_ID@='0' AND AD_Org.AD_Org_ID='0') OR (@AD_Client_ID@!='0' AND ((AD_Org.AD_Client_ID IN (@#User_Client@) AND AD_Org.AD_Org_ID IN (@#User_Org@)) OR AD_Org.AD_Org_ID='0' AND AD_Org.IsSummary='N'))
Property
- Physical column name: Property
- Property Name: property
- Reference: OBUISEL_Selector Reference
Callout: Selector_Field_Property_Callout
This column has a callout associated. Computes selector field ad_column_id after change in select field property. It is implemented by [3] Java Class.
Reference
- Physical column name: AD_Reference_ID
- Property Name: reference
- Reference: TableDir
Foreign key column to AD_Reference table, (column: AD_Reference_ID)
Searchinsuggestionbox
- Physical column name: Searchinsuggestionbox
- Property Name: searchinsuggestionbox
- Reference: YesNo
- Default value: N
Show In Picklist
- Physical column name: Showinpicklist
- Property Name: showInPicklist
- Reference: YesNo
- Default value: N
Showingrid
- Physical column name: Showingrid
- Property Name: showingrid
- Reference: YesNo
- Default value: N
Sortable
- Physical column name: Sort
- Property Name: sortable
- Reference: YesNo
- Default value: N
Sortno
- Physical column name: Sortno
- Property Name: sortno
- Reference: Integer
Suffix
- Physical column name: Suffix
- Property Name: suffix
- Reference: String
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):
- OBUISEL_SELECTFLD_SELECTOR_IDX Not Unique. Columns:
- OBUISEL_SELECTOR_ID
Check Constraints
These are the check constraints for this table:
- OBUISEL_SF_CM_CHECK: ISCENTRALLYMAINTAINED IN ('Y', 'N')
- OBUISEL_SF_FILTER_CHECK: FILTER IN ('Y', 'N')
- OBUISEL_SF_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
- OBUISEL_SF_SBOX_CHECK: SEARCHINSUGGESTIONBOX IN ('Y', 'N')
- OBUISEL_SF_SHOWINGRID_CHECK: SHOWINGRID IN ('Y', 'N')
- OBUISEL_SF_SHOWINPICKLIST_CHK: SHOWINPICKLIST IN ('Y', 'N')
- OBUISEL_SF_SORT_CHECK: SORT IN ('Y', 'N')