Info Window (Window ID-385)

From iDempiere en

Table of Contents

Window: Info Window

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

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.

Info Window - Window - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_InfoWindow.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client 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

Tab: Column

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

Info Window - Column - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
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
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_InfoColumn.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client 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(30)
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
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 := {|}|{&}
context := any global or window context
value := strings or numbers
logic operators := AND or OR with the previous result from left to right
operand := eq{=}, gt{>}, le{<}, not{~^!}
Examples:

  • @AD_Table_ID@=14 | @Language@!GERGER
  • @PriceLimit@>10 | @PriceList@>@PriceActual@
  • @Name@>J

Strings may be in single quotes (optional)

AD_InfoColumn.DisplayLogic
character varying(2000)
Text
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_Client_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, Client 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
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 validaton query Input field validaton query AD_InfoColumn.InputFieldValidation
character varying(2000)
Text
Field Style Field CSS Style AD_InfoColumn.AD_FieldStyle_ID
numeric(10)
Table
Autocomplete Automatic completion for textfields The autocompletion uses all existing values (from the same client and organization) of the field. AD_InfoColumn.IsAutocomplete
character(1)
Yes-No

Tab: Column Translation

Description: Infow Window Column Translation

Help:

File:Info Window - Column Translation - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_InfoColumn_Trl.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client 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
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

Description: Info Window Translation

Help:

File:Info Window - Window Translation - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_InfoWindow_Trl.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client 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

Description:

Help:

File:Info Window - Related Info Window - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_InfoRelated.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client 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 window

column 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 := {|}|{&}
context := any global or window context
value := strings or numbers
logic operators := AND or OR with the previous result from left to right
operand := eq{=}, gt{>}, le{<}, not{~^!}
Examples:

  • @AD_Table_ID@=14 | @Language@!GERGER
  • @PriceLimit@>10 | @PriceList@>@PriceActual@
  • @Name@>J

Strings may be in single quotes (optional)

AD_InfoRelated.DisplayLogic
character varying(2000)
Text

Tab: Process

Description:

Help:

File:Info Window - Process - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_InfoProcess.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client 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
LayoutType 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 := {|}|{&}
context := any global or window context
value := strings or numbers
logic operators := AND or OR with the previous result from left to right
operand := eq{=}, gt{>}, le{<}, not{~^!}
Examples:

  • @AD_Table_ID@=14 | @Language@!GERGER
  • @PriceLimit@>10 | @PriceList@>@PriceActual@
  • @Name@>J

Strings may be in single quotes (optional)

AD_InfoProcess.DisplayLogic
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_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

Description:

Help:

File:Info Window - Role Access - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_InfoWindow_Access.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client 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


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.