iDempiere 13 標準ウィンドウ(AD_Window_ID: 385)
メニュー: アプリケーション辞書 ▸ 情報検索ウィンドウ
Define Info and search/select Window
The Info window is used to search and select records as well as display information relevant to the selection.
| # | タブ | テーブル | 階層 | 説明 |
|---|
| 10 | 情報検索ウィンドウ | AD_InfoWindow | 0 | Info and search/select Window |
| 20 | カラム | AD_InfoColumn | 1 | 検索ウィンドウカラム |
| 30 | 翻訳 | AD_InfoColumn_Trl | 2 | Infow Window Column Translation |
| 40 | 翻訳 | AD_InfoWindow_Trl | 1 | Info Window Translation |
| 50 | 関連する検索ウィンドウ | AD_InfoRelated | 1 | |
| 60 | プロセス | AD_InfoProcess | 1 | |
| 70 | アクセス | AD_InfoWindow_Access | 1 | |
The Info window is used to search and select records as well as display information relevant to the selection.
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 説明 | Description | String | | Optional short description of the record |
| コメント | Help | Text | | Comment or Hint |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| エレメント有効 | IsValid | Yes-No | ✔ | エレメントは検証チェックに合格 |
| シーケンスNo | SeqNo | Integer | | Method of ordering records; lowest number comes first |
| エンティティタイプ | EntityType | Table | ✔ | Dictionary Entity Type; Determines ownership and synchronization |
| テーブル | AD_Table_ID | Table Direct | ✔ | Database Table information |
| SQL FROM句 | FromClause | Text | ✔ | SQL FROM clause |
| SQL WHERE句 | WhereClause | Text | | Fully qualified SQL WHERE clause |
| その他のSQL文 | OtherClause | Text | | Other SQL Clause |
| SQL ORDER BY句 | OrderByClause | Text | | Fully qualified ORDER BY clause |
| バリデート | Processing | Button | | Validate Info Window SQL |
| Distinct | IsDistinct | Yes-No | ✔ | Select Distinct |
| デフォルト | IsDefault | Yes-No | ✔ | Default value |
| Load Page Num | isLoadPageNum | Yes-No | | When load data for info window, also load number of paging |
| 最大クエリレコード | MaxQueryRecords | Integer | ✔ | If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records |
| Paging Size | PagingSize | Integer | ✔ | |
| ダッシュボードに表示 | IsShowInDashboard | Yes-No | ✔ | Show the dashlet in the dashboard |
| ヘルプ コンテキスト | AD_CtxHelp_ID | Search | | |
| 画像URL | ImageURL | String | | URL of image |
| ウィンドウ | AD_Window_ID | Table Direct | | Data entry or display window |
| 発注ウィンドウ | PO_Window_ID | Table | | Purchase Order Window |
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_InfoWindow_ID | Table Direct | ✔ | Info and search/select Window |
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| エレメント | AD_Element_ID | Search | | System Element enables the central maintenance of column description and help. |
| DBカラム名称 | ColumnName | String | ✔ | Name of the column in the database |
| シーケンスNo | SeqNo | Integer | ✔ | Method of ordering records; lowest number comes first |
| SQL SELECT句 | SelectClause | String | ✔ | SQL SELECT clause |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 説明 | Description | String | | Optional short description of the record |
| コメント | Help | Text | | Comment or Hint |
| Placeholder | Placeholder | String | | |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| 表示 | IsDisplayed | Yes-No | ✔ | Determines, if this field is displayed |
| クエリ検索条件 | IsQueryCriteria | Yes-No | ✔ | The column is also used as a query criteria |
| エレメント定義利用 | IsCentrallyMaintained | Yes-No | ✔ | Information maintained in System Element table |
| 必須 | IsMandatory | Yes-No | ✔ | Data entry is required in this column |
| Query After Change | IsQueryAfterChange | Yes-No | ✔ | Issues a query request after the user has made changes to the field |
| 読取専用 | IsReadOnly | Yes-No | ✔ | Field is read only |
| 識別子 | IsIdentifier | Yes-No | ✔ | This column is part of the record identifier |
| キーカラム | IsKey | Yes-No | | This column is the key in this table |
| 検索カラムシーケンスNo | SeqNoSelection | Integer | | Selection Column Sequence |
| 表示ロジック | DisplayLogic | Text | | If the Field is displayed, the result determines if the field is actually displayed |
| デフォルトロジック | DefaultValue | String | | Default value hierarchy, separated by ; |
| クエリ条件オペレーター | QueryOperator | List | | Operator for database query |
| クエリDB関数 | QueryFunction | String | | Database function for query |
| 範囲 | IsRange | Yes-No | ✔ | The parameter is a range of values |
| デフォルトロジック2 | DefaultValue2 | String | | Default value hierarchy, separated by ; |
| Placeholder2 | Placeholder2 | String | | |
| リファレンス | AD_Reference_ID | Table | ✔ | System Reference and Validation |
| リファレンスキー | AD_Reference_Value_ID | Table | | Required to specify, if data type is Table or List |
| ダイナミックバリデーション | AD_Val_Rule_ID | Table Direct | | Dynamic Validation Rule |
| エンティティタイプ | EntityType | Table | ✔ | Dictionary Entity Type; Determines ownership and synchronization |
| Input field validation | InputFieldValidation | Text | | Input field validaton query |
| Field Style | AD_FieldStyle_ID | Table | | Field CSS Style |
| 自動完成 | IsAutocomplete | Yes-No | ✔ | Auto complete |
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 検索ウィンドウカラム | AD_InfoColumn_ID | Table Direct | ✔ | Info Window Column |
| 言語 | AD_Language | Table | ✔ | Language for this entity |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 説明 | Description | String | | Optional short description of the record |
| コメント | Help | Text | | Comment or Hint |
| Placeholder | Placeholder | String | | |
| Placeholder2 | Placeholder2 | String | | |
| 翻訳する | IsTranslated | Yes-No | ✔ | This column is translated |
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 検索ウィンドウ | AD_InfoWindow_ID | Table Direct | ✔ | Info and search/select Window |
| 言語 | AD_Language | Table | ✔ | Language for this entity |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 説明 | Description | String | | Optional short description of the record |
| コメント | Help | Text | | Comment or Hint |
| 翻訳する | IsTranslated | Yes-No | ✔ | This column is translated |
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| 検索ウィンドウ | AD_InfoWindow_ID | Table Direct | ✔ | Info and search/select Window |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 説明 | Description | String | | Optional short description of the record |
| コメント | Help | Text | | Comment or Hint |
| Related Info Window | RelatedInfo_ID | Table | ✔ | |
| 関連カラム | RelatedColumn_ID | Table | ✔ | |
| 関連親カラム | ParentRelatedColumn_ID | Table | | column in parent info window, link with column in this relate info |
| シーケンスNo | SeqNo | Integer | ✔ | Method of ordering records; lowest number comes first |
| エンティティタイプ | EntityType | Table | ✔ | Dictionary Entity Type; Determines ownership and synchronization |
| 表示ロジック | DisplayLogic | Text | | If the Field is displayed, the result determines if the field is actually displayed |
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 検索ウィンドウ | AD_InfoWindow_ID | Table Direct | | Info and search/select Window |
| 画像URL | ImageURL | String | | URL of image |
| プロセス | AD_Process_ID | Table Direct | ✔ | Process or Report |
| シーケンスNo | SeqNo | Integer | ✔ | Method of ordering records; lowest number comes first |
| LayoutType | LayoutType | Radio Group List | ✔ | Layout type of info process |
| ViewID Column | AD_InfoColumn_ID | Table Direct | | Name of unique column in a view. value of this column will save to t_selection table |
| 表示ロジック | DisplayLogic | Text | | If the Field is displayed, the result determines if the field is actually displayed |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| エンティティタイプ | EntityType | Table | ✔ | Dictionary Entity Type; Determines ownership and synchronization |
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| ロール | AD_Role_ID | Table Direct | ✔ | Responsibility Role |
| 検索ウィンドウ | AD_InfoWindow_ID | Table Direct | ✔ | Info and search/select Window |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |