Window: Info Window
[Created: 17/06/2006 - Updated: 07/07/2006 ]
Description: Define Info and search/select Window
Help: The Info window is used to search and select records as well as display information relevant to the selection.
Tab: Window
[Created: 17/06/2006 - Updated: 04/01/2013 ]
Description: Info and search/select Window
Help: The Info window is used to search and select records as well as display information relevant to the selection.
Tab Level: 0
Table 10: Window - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_infowindow.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | ad_infowindow.AD_Org_ID numeric(10) Table Direct |
| Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | ad_infowindow.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | ad_infowindow.Description character varying(255) String |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | ad_infowindow.Help character varying(2000) Text |
| Active | The record is active in the system | 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 reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | ad_infowindow.IsActive character(1) Yes-No |
| Valid | Element is valid | The element passed the validation check | ad_infowindow.IsValid character(1) Yes-No |
| Sequence | Method of ordering records; lowest number comes first | The Sequence indicates the order of records | ad_infowindow.SeqNo numeric(10) Integer |
| Entity Type | Dictionary Entity Type; Determines ownership and synchronization | The Entity Types "Dictionary", "iDempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten. For customizations, copy the entity and select "User"! | ad_infowindow.EntityType character varying(40) Table |
| Table | Database Table information | The Database Table provides the information of the table definition | ad_infowindow.AD_Table_ID numeric(10) Table Direct |
| Sql FROM | SQL FROM clause | The Select Clause indicates the SQL FROM clause to use for selecting the record for a measure calculation. It can have JOIN clauses. Do not include the FROM itself. | ad_infowindow.FromClause character varying(2000) Text |
| Sql WHERE | Fully qualified 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". | ad_infowindow.WhereClause character varying(2000) Text |
| Other SQL Clause | Other SQL Clause | Any other complete clause like GROUP BY, HAVING, ORDER BY, etc. after WHERE clause. | ad_infowindow.OtherClause character varying(2000) Text |
| Sql ORDER BY | Fully qualified ORDER BY clause | The ORDER BY Clause indicates the SQL ORDER BY clause to use for record selection | ad_infowindow.OrderByClause character varying(2000) Text |
| Validate | Validate Info Window SQL | Validate generated Info Window SQL | ad_infowindow.Processing character(1) Button |
| Distinct | Select Distinct | ad_infowindow.IsDistinct character(1) Yes-No | |
| Default | Default value | The Default Checkbox indicates if this record will be used as a default value. | ad_infowindow.IsDefault character(1) Yes-No |
| Load Page Num | When load data for info window, also load number of paging | Load number of paging maybe affect to performance when info window is join of many table | ad_infowindow.isLoadPageNum character(1) Yes-No |
| Max Query Records | If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records | Enter the number of records a user will be able to query to avoid unnecessary system load. If 0, no restrictions are imposed. | ad_infowindow.MaxQueryRecords numeric(10) Integer |
| Paging Size | ad_infowindow.PagingSize numeric(10) Integer | ||
| Show in Dashboard | Show the dashlet in the dashboard | ad_infowindow.IsShowInDashboard character(1) Yes-No | |
| Context Help | ad_infowindow.AD_CtxHelp_ID numeric(10) Search | ||
| Image URL | URL of image | URL of image; The image is not stored in the database, but retrieved at runtime. The image can be a gif, jpeg or png. | ad_infowindow.ImageURL character varying(120) String |
| Window | Data entry or display window | The Window field identifies a unique Window in the system. | ad_infowindow.AD_Window_ID numeric(10) Table Direct |
| PO Window | Purchase Order Window | Window for Purchase Order (AP) Zooms | ad_infowindow.PO_Window_ID numeric(10) Table |
Tab: Column
[Created: 17/06/2006 - Updated: 01/01/2013 ]
Description: Info Window Column
Help: Column in the Info Window for display and/or selection. If used for selection, the column cannot be a SQL expression. The SQL clause must be fully qualified based on the FROM clause in the Info Window definition
Tab Level: 1
Table 20: Column - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Info Window | Info and search/select Window | The Info window is used to search and select records as well as display information relevant to the selection. | ad_infocolumn.AD_InfoWindow_ID numeric(10) Table Direct |
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_infocolumn.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | ad_infocolumn.AD_Org_ID numeric(10) Table Direct |
| System Element | System Element enables the central maintenance of column description and help. | The System Element allows for the central maintenance of help, descriptions and terminology for a database column. | ad_infocolumn.AD_Element_ID numeric(10) Search |
| DB Column Name | Name of the column in the database | The Column Name indicates the name of a column on a table as defined in the database. | ad_infocolumn.ColumnName character varying(63) String |
| Sequence | Method of ordering records; lowest number comes first | The Sequence indicates the order of records | ad_infocolumn.SeqNo numeric(10) Integer |
| Sql SELECT | SQL SELECT clause | The Select Clause indicates the SQL SELECT clause to use for selecting the record for a measure calculation. Do not include the SELECT itself. | ad_infocolumn.SelectClause character varying(2000) String |
| Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | ad_infocolumn.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | ad_infocolumn.Description character varying(255) String |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | ad_infocolumn.Help character varying(2000) Text |
| Placeholder | ad_infocolumn.Placeholder character varying(255) String | ||
| Active | The record is active in the system | 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 reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | ad_infocolumn.IsActive character(1) Yes-No |
| Displayed | Determines, if this field is displayed | If the field is displayed, the field Display Logic will determine at runtime, if it is actually displayed | ad_infocolumn.IsDisplayed character(1) Yes-No |
| Query Criteria | The column is also used as a query criteria | The column is used to enter queries - the SQL cannot be an expression | ad_infocolumn.IsQueryCriteria character(1) Yes-No |
| Centrally maintained | Information maintained in System Element table | The Centrally Maintained checkbox indicates if the Name, Description and Help maintained in 'System Element' table or 'Window' table. | ad_infocolumn.IsCentrallyMaintained character(1) Yes-No |
| Mandatory | Data entry is required in this column | The field must have a value for the record to be saved to the database. | ad_infocolumn.IsMandatory character(1) Yes-No |
| Query After Change | Issues a query request after the user has made changes to the field | ad_infocolumn.IsQueryAfterChange character(1) Yes-No | |
| Read Only | Field is read only | The Read Only indicates that this field may only be Read. It may not be updated. | ad_infocolumn.IsReadOnly character(1) Yes-No |
| Identifier | This column is part of the record identifier | The Identifier checkbox indicates that this column is part of the identifier or key for this table. | ad_infocolumn.IsIdentifier character(1) Yes-No |
| Key column | This column is the key in this table | The key column must also be display sequence 0 in the field definition and may be hidden. | ad_infocolumn.IsKey character(1) Yes-No |
| Selection Column Sequence | Selection Column Sequence | For ordering sequence of selection column | ad_infocolumn.SeqNoSelection numeric(10) Integer |
| Display Logic | If the Field is displayed, the result determines if the field is actually displayed | format := {expression} [{logic} {expression}] expression := @{context}@{operand}{value} or @{context}@{operand}{value} logic := { | } |
| Default Logic | Default value hierarchy, separated by ; | 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_Tenant_ID - Accounting Schema: e.g. , - 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, Tenant as well as Buttons. | ad_infocolumn.DefaultValue character varying(2000) String |
| Query Operator | Operator for database query | ad_infocolumn.QueryOperator character varying(10) List | |
| Query Function | Database function for query | Database function for user query. If the database function takes more than just the column name parameter, use ? to indicate where the column name should goes to. E.g: Upper, Trunc and To_Char(?,'MM') | ad_infocolumn.QueryFunction character varying(255) String |
| Range | The parameter is a range of values | The Range checkbox indicates that this parameter is a range of values. | ad_infocolumn.IsRange character(1) Yes-No |
| Default Logic 2 | Default value hierarchy, separated by ; | 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_Tenant_ID - Accounting Schema: e.g. , - 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, Tenant as well as Buttons. | ad_infocolumn.DefaultValue2 character varying(2000) String |
| Placeholder2 | ad_infocolumn.Placeholder2 character varying(255) String | ||
| Reference | System Reference and Validation | The Reference could be a display type, list or table validation. | ad_infocolumn.AD_Reference_ID numeric(10) Table |
| Reference Key | Required to specify, if data type is Table or List | The Reference Value indicates where the reference values are stored. It must be specified if the data type is Table or List. | ad_infocolumn.AD_Reference_Value_ID numeric(10) Table |
| Dynamic Validation | Dynamic Validation Rule | These rules define how an entry is determined to valid. You can use variables for dynamic (context sensitive) validation. | ad_infocolumn.AD_Val_Rule_ID numeric(10) Table Direct |
| Entity Type | Dictionary Entity Type; Determines ownership and synchronization | The Entity Types "Dictionary", "iDempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten. For customizations, copy the entity and select "User"! | ad_infocolumn.EntityType character varying(40) Table |
| Input field validation | Input field validation query | Input field validation query | ad_infocolumn.InputFieldValidation character varying(2000) Text |
| Field Style | Field CSS Style | ad_infocolumn.AD_FieldStyle_ID numeric(10) Table | |
| Auto complete | Automatic completion for text fields | The autocompletion uses all existing values (from the same tenant and organization) of the field. | ad_infocolumn.IsAutocomplete character(1) Yes-No |
Tab: Column Translation
[Created: 17/06/2006 - Updated: 27/10/2024 ]
Description: Infow Window Column Translation
Help:
Tab Level: 2
Table 30: Column Translation - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_infocolumn_trl.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | ad_infocolumn_trl.AD_Org_ID numeric(10) Table Direct |
| Info Column | Info Window Column | Column in the Info Window for display and/or selection. If used for selection, the column cannot be a SQL expression. The SQL clause must be fully qualified based on the FROM clause in the Info Window definition | ad_infocolumn_trl.AD_InfoColumn_ID numeric(10) Table Direct |
| Language | Language for this entity | The Language identifies the language to use for display and formatting | ad_infocolumn_trl.AD_Language character varying(6) Table |
| Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | ad_infocolumn_trl.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | ad_infocolumn_trl.Description character varying(255) String |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | ad_infocolumn_trl.Help character varying(2000) Text |
| Placeholder | ad_infocolumn_trl.Placeholder character varying(255) String | ||
| Placeholder2 | ad_infocolumn_trl.Placeholder2 character varying(255) String | ||
| Translated | This column is translated | The Translated checkbox indicates if this column is translated. | ad_infocolumn_trl.IsTranslated character(1) Yes-No |
Tab: Window Translation
[Created: 17/06/2006 - Updated: 27/10/2024 ]
Description: Info Window Translation
Help:
Tab Level: 1
Table 40: Window Translation - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_infowindow_trl.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | ad_infowindow_trl.AD_Org_ID numeric(10) Table Direct |
| Info Window | Info and search/select Window | The Info window is used to search and select records as well as display information relevant to the selection. | ad_infowindow_trl.AD_InfoWindow_ID numeric(10) Table Direct |
| Language | Language for this entity | The Language identifies the language to use for display and formatting | ad_infowindow_trl.AD_Language character varying(6) Table |
| Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | ad_infowindow_trl.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | ad_infowindow_trl.Description character varying(255) String |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | ad_infowindow_trl.Help character varying(2000) Text |
| Translated | This column is translated | The Translated checkbox indicates if this column is translated. | ad_infowindow_trl.IsTranslated character(1) Yes-No |
Tab: Related Info Window
[Created: 06/07/2013 - Updated: 26/01/2014 ]
Description:
Help:
Tab Level: 1
Table 50: Related Info Window - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_inforelated.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | ad_inforelated.AD_Org_ID numeric(10) Table Direct |
| Active | The record is active in the system | 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 reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | ad_inforelated.IsActive character(1) Yes-No |
| Info Window | Info and search/select Window | The Info window is used to search and select records as well as display information relevant to the selection. | ad_inforelated.AD_InfoWindow_ID numeric(10) Table Direct |
| Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | ad_inforelated.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | ad_inforelated.Description character varying(255) String |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | ad_inforelated.Help character varying(2000) Text |
| Related Info Window | ad_inforelated.RelatedInfo_ID numeric(10) Table | ||
| Related Info Column | ad_inforelated.RelatedColumn_ID numeric(10) Table | ||
| Parent Related Column | column in parent info window, link with column in this relate info | default column RelatedColumn in Relate Info window will link with key column of main info windowcolumn define in ParentRelatedColumn will replace key column | ad_inforelated.ParentRelatedColumn_ID numeric(10) Table |
| Sequence | Method of ordering records; lowest number comes first | The Sequence indicates the order of records | ad_inforelated.SeqNo numeric(10) Integer |
| Entity Type | Dictionary Entity Type; Determines ownership and synchronization | The Entity Types "Dictionary", "iDempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten. For customizations, copy the entity and select "User"! | ad_inforelated.EntityType character varying(40) Table |
| Display Logic | If the Field is displayed, the result determines if the field is actually displayed | format := {expression} [{logic} {expression}] expression := @{context}@{operand}{value} or @{context}@{operand}{value} logic := { | } |
Tab: Process
[Created: 26/05/2014 - Updated: 26/05/2014 ]
Description:
Help:
Tab Level: 1
Table 60: Process - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_infoprocess.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | ad_infoprocess.AD_Org_ID numeric(10) Table Direct |
| Info Window | Info and search/select Window | The Info window is used to search and select records as well as display information relevant to the selection. | ad_infoprocess.AD_InfoWindow_ID numeric(10) Table Direct |
| Image URL | URL of image | URL of image; The image is not stored in the database, but retrieved at runtime. The image can be a gif, jpeg or png. | ad_infoprocess.ImageURL character varying(120) String |
| Process | Process or Report | The Process field identifies a unique Process or Report in the system. | ad_infoprocess.AD_Process_ID numeric(10) Table Direct |
| Sequence | Method of ordering records; lowest number comes first | The Sequence indicates the order of records | ad_infoprocess.SeqNo numeric(10) Integer |
| Layout Type | Layout type of info process | Process info can display as button, list, menu | ad_infoprocess.LayoutType character varying(10) Radio Group List |
| ViewID Column | Name of unique column in a view. value of this column will save to t_selection table | Column to resolve issue in https://idempiere.atlassian.net/browse/IDEMPIERE-1970 | ad_infoprocess.AD_InfoColumn_ID numeric(10) Table Direct |
| Display Logic | If the Field is displayed, the result determines if the field is actually displayed | format := {expression} [{logic} {expression}] expression := @{context}@{operand}{value} or @{context}@{operand}{value} logic := { | } |
| Active | The record is active in the system | 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 reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | ad_infoprocess.IsActive character(1) Yes-No |
| Entity Type | Dictionary Entity Type; Determines ownership and synchronization | The Entity Types "Dictionary", "iDempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten. For customizations, copy the entity and select "User"! | ad_infoprocess.EntityType character varying(40) Table |
Tab: Role Access
[Created: 03/06/2014 - Updated: 03/06/2014 ]
Description:
Help:
Tab Level: 1
Table 70: Role Access - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_infowindow_access.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | ad_infowindow_access.AD_Org_ID numeric(10) Table Direct |
| Role | Responsibility Role | The Role determines security and access a user who has this Role will have in the System. | ad_infowindow_access.AD_Role_ID numeric(10) Table Direct |
| Info Window | Info and search/select Window | The Info window is used to search and select records as well as display information relevant to the selection. | ad_infowindow_access.AD_InfoWindow_ID numeric(10) Table Direct |
| Active | The record is active in the system | 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 reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | ad_infowindow_access.IsActive character(1) Yes-No |