ERP/3.0/Developers Guide/Database Model/org.openbravo.client.application/OBUIAPP Parameter
OBUIAPP_Parameter
- Name:OBUIAPP_Parameter
- Classname:OBUIAPP_Parameter
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. |
AD_Element_ID | Yes | VARCHAR (32) | The System Element allows for the central maintenance of help, descriptions and terminology for a database column. |
C_Attachment_Method_ID | Yes | VARCHAR (32) | Identifies an Attachment Method available in the System. |
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. |
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. |
Columnname | No | VARCHAR (40) | The Column Name indicates the name of a column on a table as defined in the database. |
Defaultvalue | Yes | NVARCHAR (1000) | 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. |
Description | Yes | NVARCHAR (255) | A description is limited to 255 characters. |
Displaylogic | Yes | VARCHAR (2000) | A specification of statements which, when evaluated as false, cause the field to appear hidden. |
EM_Obkmo_Widget_Class_ID | Yes | VARCHAR (32) | Identifies a Widget Class definition |
EvaluateFixedValue | No | CHAR (1) | When the flag is enabled the Fixed Value is evaluated as a JS expression. |
AD_Fieldgroup_ID | Yes | VARCHAR (32) | The Field Group indicates the logical group that this field belongs to (History, Amounts, Quantities) |
Isfixed | No | CHAR (1) | Is fixed |
Fixedvalue | Yes | NVARCHAR (1000) | |
Help | Yes | NVARCHAR (2000) | The Help field contains a hint, comment or help about the use of this item. |
Fieldlength | No | DECIMAL (10,0) | The Length indicates the length of a column as defined in the database. |
Ismandatory | No | CHAR (1) | The Mandatory checkbox indicates if the field is required for a record to be save to the database. |
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. |
NumColumn | Yes | DECIMAL (10,0) | Column number in which the current field is set (allowed values ??between 1 and 4)
|
Obuiapp_Parameter_ID | No | VARCHAR (32) | |
Obuiapp_Process_ID | Yes | VARCHAR (32) | Process Defintion is a re implementation of Process with 3.0 infrastructure. |
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. |
ATT_Propertypath | Yes | VARCHAR (255) | Defines the property path taken for this parameter. |
Readonlylogic | Yes | VARCHAR (2000) | Logic to determine if field is read only (applies only when field is read-write) |
AD_Reference_ID | No | VARCHAR (32) | The Reference indicates the type of reference field |
AD_Reference_Value_ID | Yes | VARCHAR (32) | The Reference Value indicates where the reference values are stored. It must be specified if the data type is Table or List. |
Seqno | No | DECIMAL (10,0) | The Sequence indicates the order of records |
ATT_Showindescription | No | CHAR (1) | Defines if this parameter is relevant in Text column on C_File table. |
Startinnewline | Yes | CHAR (1) | |
AD_Tab_ID | Yes | 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. |
AD_Val_Rule_ID | Yes | VARCHAR (32) | The Validation Rule indicates a unique validation rule. These rules define how an entry is determined to valid or invalid. |
displayTitle | No | CHAR (1) | This field allows to specify whether the title of a grid form item should be displayed |
displayedRows | Yes | DECIMAL (10,0) | The height of the grid will be adjusted to display the number of rows specified in this field. |
Ongridloadfunction | Yes | NVARCHAR (255) | This function is invoked when the grid parameter is loaded for the first time. |
Columns
Active
- Physical column name: Isactive
- Property Name: active
- Reference: YesNo
- Default value: Y
Application Element
- Physical column name: AD_Element_ID
- Property Name: applicationElement
- Reference: TableDir
Foreign key column to AD_Element table, (column: AD_Element_ID)
Attachment Method
- Physical column name: C_Attachment_Method_ID
- Property Name: attachmentMethod
- Reference: TableDir
- This column is a child for a business object (is Parent)
Foreign key column to C_Attachment_Method table, (column: C_Attachment_Method_ID)
Callout: MetadataOnTab
This column has a callout associated. This callout is executed when a metadata is being added to a Tab. It populates the sequence number based on the existing metadata assigned to the tab. It is implemented by [1] Java Class.
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@)
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
DB Column Name
- Physical column name: Columnname
- Property Name: dBColumnName
- Reference: String
Default Value
- Physical column name: Defaultvalue
- Property Name: defaultValue
- Reference: Text
Description
- Physical column name: Description
- Property Name: description
- Reference: String
Display Logic
- Physical column name: Displaylogic
- Property Name: displayLogic
- Reference: Text
EM_Obkmo_Widget_Class_ID
- Physical column name: EM_Obkmo_Widget_Class_ID
- Property Name: obkmoWidgetClass
- Reference: Table
- This column is a child for a business object (is Parent)
Foreign key column to OBKMO_Widget_Class table, (column: OBKMO_Widget_Class_ID)
Evaluate Fixed Value
- Physical column name: EvaluateFixedValue
- Property Name: evaluateFixedValue
- Reference: YesNo
- Default value: N
Field Group
- Physical column name: AD_Fieldgroup_ID
- Property Name: fieldGroup
- Reference: TableDir
Foreign key column to AD_FieldGroup table, (column: AD_FieldGroup_ID)
Fixed
- Physical column name: Isfixed
- Property Name: fixed
- Reference: YesNo
- Default value: Y
Fixed Value
- Physical column name: Fixedvalue
- Property Name: fixedValue
- Reference: Text
Callout: FixedValueExpression
This column has a callout associated.
It is implemented by [2] Java Class.
Help/Comment
- Physical column name: Help
- Property Name: helpComment
- Reference: Text
Length
- Physical column name: Fieldlength
- Property Name: length
- Reference: Integer
Mandatory
- Physical column name: Ismandatory
- Property Name: mandatory
- Reference: YesNo
- Default value: N
Module
- Physical column name: AD_Module_ID
- Property Name: module
- Reference: TableDir
- This column is a child for a business object (is Parent)
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
NumColumn
- Physical column name: NumColumn
- Property Name: numColumn
- Reference: Integer
Obuiapp_Parameter_ID
- Physical column name: Obuiapp_Parameter_ID
- Property Name: id
- Reference: ID
Obuiapp_Process_ID
- Physical column name: Obuiapp_Process_ID
- Property Name: obuiappProcess
- Reference: TableDir
- This column is a child for a business object (is Parent)
Foreign key column to OBUIAPP_Process table, (column: Obuiapp_Process_ID)
On Change Function
- 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)
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 Path
- Physical column name: ATT_Propertypath
- Property Name: propertyPath
- Reference: OBUISEL_Selector Reference
Read Only Logic
- Physical column name: Readonlylogic
- Property Name: readOnlyLogic
- Reference: Text
Reference
- Physical column name: AD_Reference_ID
- Property Name: reference
- Reference: Table
Foreign key column to AD_Reference table, (column: AD_Reference_ID)
It has a validation "Validation for Reference parameters in Process Definition", with the following code
AD_Reference.AD_Reference_ID NOT IN ('18','19','28','32','8C57A4A2E05F4261A1FADF47C30398AD','52529102938F41D5B84D3DE1F8892249')
Reference Search Key
- Physical column name: AD_Reference_Value_ID
- Property Name: referenceSearchKey
- Reference: Table
Foreign key column to AD_Reference table, (column: AD_Reference_ID)
It has a validation "AD_Reference Subreference", with the following code
AD_Reference.ParentReference_ID=@AD_Reference_ID@
OR (@AD_Reference_ID@ = '28' and AD_Reference.ParentReference_ID='17')
Sequence Number
- Physical column name: Seqno
- Property Name: sequenceNumber
- Reference: Integer
Show In Description
- Physical column name: ATT_Showindescription
- Property Name: showInDescription
- Reference: YesNo
- Default value: N
Startinnewline
- Physical column name: Startinnewline
- Property Name: startinnewline
- Reference: YesNo
- Default value: N
Tab
- Physical column name: AD_Tab_ID
- Property Name: tab
- Reference: TableDir
- 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)
Validation
- Physical column name: AD_Val_Rule_ID
- Property Name: validation
- Reference: TableDir
Foreign key column to AD_Val_Rule table, (column: AD_Val_Rule_ID)
It has a validation "Validation type for Parameter Windows", with the following code
type in ('HQL_JS')
displayTitle
- Physical column name: displayTitle
- Property Name: displayTitle
- Reference: YesNo
- Default value: Y
displayedRows
- Physical column name: displayedRows
- Property Name: displayedRows
- Reference: Integer
onGridLoadFunction
- Physical column name: Ongridloadfunction
- Property Name: onGridLoadFunction
- Reference: String
Other Info
Indices
These are the indices for this table (for each index there is a list of all the columns included within it):
- OBUIAPP_PARAMETER_ATTMET_IDX Not Unique. Columns:
- C_ATTACHMENT_METHOD_ID
- OBUIAPP_PARAMETER_PROCESS Not Unique. Columns:
- OBUIAPP_PROCESS_ID
- OBUIAPP_PARAMETER_TAB_IDX Not Unique. Columns:
- AD_TAB_ID
- EM_OBKMO_PARAM_WIDGET Not Unique. Columns:
- EM_OBKMO_WIDGET_CLASS_ID
Check Constraints
These are the check constraints for this table:
- OBUIAPP_PARAM_SHOWTITLE_CHK: DISPLAYTITLE IN ('Y', 'N')
- OBUIAPP_PARAMETER_CENTR_CHK: ISCENTRALLYMAINTAINED IN ('Y', 'N')
- OBUIAPP_PARAMETER_EVFIXVAL_CHK: EVALUATEFIXEDVALUE IN ('Y', 'N')
- OBUIAPP_PARAMETER_ISACTIVE_CHK: ISACTIVE IN ('Y', 'N')
- OBUIAPP_PARAMETER_ISFIXED_CHK: ISFIXED IN ('Y', 'N')
- OBUIAPP_PARAMETER_MANDAT_CHK: ISMANDATORY IN ('Y', 'N')
- OBUIAPP_PARAMETER_METADATA_CHK: AD_TAB_ID IS NULL OR AD_TAB_ID IS NOT NULL AND C_ATTACHMENT_METHOD_ID IS NOT NULL
- OBUIAPP_PARAMETER_NEWLINE_CHK: STARTINNEWLINE IN ('Y', 'N')
- OBUIAPP_PARAMETER_NUMCOL_CHK: NUMCOLUMN >= 1 AND NUMCOLUMN <= 4
- OBUIAPP_PARAMETER_SHOWDESC_CHK: ATT_SHOWINDESCRIPTION IN ('Y', 'N')
![]() | Back to org.openbravo.client.application |