Info Window

AD_InfoWindow

Overview

Table NameAD_InfoWindow
Access LevelSystem Only
Entity TypeD
Is DocumentNo
Is ViewNo
Has UUIDYes
Parent TableAD_CtxHelp
WikiView on iDempiere Wiki

Columns (31)

Column Type Required Default Description
AD_CtxHelp_ID Search(10) No - -
AD_Window_ID Table Direct(22) No - Data entry or display window
ImageURL String(120) No - URL of image
IsDefault Yes-No(1) Yes N Default value
IsDistinct Yes-No(1) Yes N Select Distinct
isLoadPageNum Yes-No(1) No Y When load data for info window, also load number of paging
IsShowInDashboard Yes-No(1) Yes Y Show the dashlet in the dashboard
IsValid Yes-No(1) Yes N Element is valid
MaxQueryRecords Integer(10) Yes 0 If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records
OrderByClause Text(2000) No - Fully qualified ORDER BY clause
PagingSize Integer(10) Yes 0 -
PO_Window_ID Table(22) No - Purchase Order Window
SeqNo Integer(22) No @SQL=SELECT NVL(MAX(SeqNo),0)+10 AS DefaultValue FROM AD_InfoWindow WHERE AD_InfoWindow_ID=@AD_InfoWindow_ID@ Method of ordering records; lowest number comes first
WhereClause Text(2000) No - Fully qualified SQL WHERE clause
Name String(60) Yes - Alphanumeric identifier of the entity
AD_Client_ID Table Direct(10) Yes - Tenant for this installation.
AD_InfoWindow_ID ID(10) Yes - Info and search/select Window
AD_InfoWindow_UU String(36) No - -
AD_Org_ID Table Direct(10) Yes - Organizational entity within tenant
AD_Table_ID Table(10) Yes - Database Table information
Created Date+Time(7) Yes SYSDATE Date this record was created
CreatedBy Search(10) Yes - User who created this records
Description String(255) No - Optional short description of the record
EntityType Table(40) Yes @SQL=SELECT CASE WHEN '@P|AdempiereSys:N@'='Y' THEN 'D' ELSE get_sysconfig('DEFAULT_ENTITYTYPE','U',0,0) END FROM Dual Dictionary Entity Type; Determines ownership and synchronization
FromClause Text(2000) Yes - SQL FROM clause
Help Text(2000) No - Comment or Hint
IsActive Yes-No(1) Yes - The record is active in the system
OtherClause Text(2000) No - Other SQL Clause
Processing Button(1) No - -
Updated Date+Time(7) Yes SYSDATE Date this record was updated
UpdatedBy Search(10) Yes - User who updated this records

Foreign Keys

Column References Description
AD_CtxHelp_ID AD_CtxHelp.AD_CtxHelp_ID -
AD_Window_ID AD_Window.AD_Window_ID Data entry or display window
PO_Window_ID PO_Window.PO_Window_ID Purchase Order Window
AD_Client_ID AD_Client.AD_Client_ID Tenant for this installation.
AD_Org_ID AD_Org.AD_Org_ID Organizational entity within tenant
AD_Table_ID AD_Table.AD_Table_ID Database Table information

Generated on 2026-05-03T16:37:23.914642539Z