ウィンドウ/タブ/フィールド(Window, Tab and Field)|iDempiere 13 画面リファレンス
ウィンドウ/タブ/フィールド(Window, Tab and Field)
Section titled “ウィンドウ/タブ/フィールド(Window, Tab and Field)”iDempiere 13 標準ウィンドウ(AD_Window_ID: 102)
メニュー: アプリケーション辞書 ▸ ウィンドウ/タブ/フィールド
Maintain Windows, Tabs & Fields
The Window, Tab & Field Window defines the presentation of tables and columns within each window.
| # | タブ | テーブル | 階層 | 説明 |
|---|---|---|---|---|
| 10 | ウィンドウ | AD_Window | 0 | Window header definitions |
| 20 | タブ | AD_Tab | 1 | Tab definition within a window holds fields |
| 30 | フィールド | AD_Field | 2 | Field definitions in tabs in windows |
| 40 | 翻訳 | AD_Field_Trl | 3 | Menu Translation - May not need to be translated |
| 50 | フィールドシーケンス | AD_Field | 2 | Sequence if the Fields in a Tab |
| 60 | グリッドシーケンス | AD_Field | 2 | Defined field order for grid layout |
| 70 | 翻訳 | AD_Tab_Trl | 2 | |
| 80 | ツールバーボタン | AD_ToolBarButton | 2 | |
| 90 | 翻訳 | AD_Window_Trl | 1 | |
| 100 | アクセス | AD_Window_Access | 1 | Window Access |
ウィンドウ タブのフィールド
Section titled “ウィンドウ タブのフィールド”The Window Tab defines each window in the system. The default flag indicates that this window should be used as the default Zoom windows for the tables in this window.
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | 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 |
| ベータ機能 | IsBetaFunctionality | Yes-No | ✔ | This functionality is considered Beta |
| ウィンドウタイプ | WindowType | List | ✔ | Type or classification of a Window |
| 販売(ON) / 購買(OFF) | IsSOTrx | Yes-No | ✔ | This is a Sales Transaction |
| システムカラー | AD_Color_ID | Table Direct | Color for backgrounds or indicators | |
| 画像 | AD_Image_ID | Table Direct | Image or Icon | |
| エンティティタイプ | EntityType | Table | ✔ | Dictionary Entity Type; Determines ownership and synchronization |
| デフォルト | IsDefault | Yes-No | ✔ | Default value |
| ウィンドウ幅 | WinWidth | Integer | ||
| ウィンドウ高さ | WinHeight | Integer | ||
| タイトルロジック | TitleLogic | String | The result determines the title to be displayed for this window | |
| ウィンドウコピー | Processing | Button | 選択したウィンドウのタブやフィールドの設定をコピーします。 | |
| Predefined Context Variables | PredefinedContextVariables | String | Predefined context variables to inject when opening a menu entry or a window |
タブ タブのフィールド
Section titled “タブ タブのフィールド”The Tab Tab defines each Tab within a Window. Each Tab contains a discrete selection of fields. Note that the display and read only logic is evaluated when loading the window.
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| ウィンドウ | AD_Window_ID | Table Direct | ✔ | Data entry or display window |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 説明 | Description | String | Optional short description of the record | |
| コメント | Help | Text | Comment or Hint | |
| テーブル | AD_Table_ID | Table Direct | ✔ | Database Table information |
| エンティティタイプ | EntityType | Table | ✔ | Dictionary Entity Type; Determines ownership and synchronization |
| シーケンスNo | SeqNo | Integer | ✔ | Method of ordering records; lowest number comes first |
| タブレベル | TabLevel | Integer | ✔ | Hierarchical Tab Level (0 = top) |
| Tab Type | AD_TabType | List | Defines Tab Type | |
| 単票表示 | IsSingleRow | Yes-No | ✔ | Default for toggle between Single- and Multi-Row (Grid) Layout |
| ツリー表示 | HasTree | Yes-No | ✔ | Window has Tree Graph |
| ツリー表示方式 | TreeDisplayedOn | List | ✔ | The tree can be displayed on master tab, detail tab or both |
| 上級タブ | IsAdvancedTab | Yes-No | ✔ | This Tab contains advanced Functionality |
| 会計タブ | IsInfoTab | Yes-No | This Tab contains accounting information | |
| 翻訳タブ | IsTranslationTab | Yes-No | ✔ | This Tab contains translation information |
| Lookup Only Selection Columns | IsLookupOnlySelection | Yes-No | When defined to true Lookup panel will display only selection columns. Default to false. | |
| Allow Advanced Lookup | IsAllowAdvancedLookup | Yes-No | ||
| ソート基準カラム | AD_ColumnSortOrder_ID | Table | Column determining the order | |
| ソート対象判定カラム | AD_ColumnSortYesNo_ID | Table | Column determining if a Table Column is included in Ordering | |
| リンクカラム | AD_Column_ID | Table Direct | Link Column for Multi-Parent tables | |
| 最大クエリレコード | MaxQueryRecords | Integer | If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records | |
| 親リンクカラム | Parent_Column_ID | Table | The link column on the parent tab. | |
| プロセス | AD_Process_ID | Table Direct | Process or Report | |
| 大量データ | IsHighVolume | List | Use Search instead of Pick list | |
| 表示ロジック | DisplayLogic | String | If the Field is displayed, the result determines if the field is actually displayed | |
| 読取専用 | IsReadOnly | Yes-No | ✔ | Field is read only |
| レコード追加 | IsInsertRecord | Yes-No | ✔ | The user can insert a new Record |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| 読取専用ロジック | ReadOnlyLogic | String | Logic to determine if field is read only (applies only when field is read-write) | |
| Delete Confirmation Logic | DeleteConfirmationLogic | String | ||
| コミット警告 | CommitWarning | Text | Warning displayed when saving | |
| SQL WHERE句 | WhereClause | String | Fully qualified SQL WHERE clause | |
| SQL ORDER BY句 | OrderByClause | String | Fully qualified ORDER BY clause | |
| 画像 | AD_Image_ID | Table Direct | Image or Icon | |
| ヘルプ コンテキスト | AD_CtxHelp_ID | Search | ||
| カラムからフィールドの作成 | ImportFields | Button | Create Field from Table Column, which do not exist in the Tab yet | |
| フィールドコピー | Processing | Button | 同じテーブルから作られている他のタブからフィールドの設定をコピーします。 |
フィールド タブのフィールド
Section titled “フィールド タブのフィールド”The Field Tab defines the Fields displayed within a tab. Changes made to the Field Tab become visible after restart due to caching. If the Sequence is negative, the record are ordered descending. Note that the name, description and help is automatically synchronized if centrally maintained.
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| タブ | AD_Tab_ID | Table Direct | ✔ | Tab within a Window |
| 名称 | 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 |
| Placeholder | Placeholder | String | ||
| カラム | AD_Column_ID | Table Direct | ✔ | Column in the table |
| エンティティタイプ | EntityType | Table | ✔ | Dictionary Entity Type; Determines ownership and synchronization |
| フィールドグループ | AD_FieldGroup_ID | Table Direct | Logical grouping of fields | |
| エレメント定義利用 | IsCentrallyMaintained | Yes-No | ✔ | Information maintained in System Element table |
| インクルードタブ | Included_Tab_ID | Table | Included Tab in this Tab (Master Detail) | |
| 表示 | IsDisplayed | Yes-No | ✔ | Determines, if this field is displayed |
| グリッド表示 | IsDisplayedGrid | Yes-No | ||
| クイック入力 | IsQuickEntry | Yes-No | ✔ | |
| Quick Form | IsQuickForm | Yes-No | ✔ | Display in Quick Form |
| 読取専用 | IsReadOnly | Yes-No | ✔ | Field is read only |
| 表示ロジック | DisplayLogic | Text | If the Field is displayed, the result determines if the field is actually displayed | |
| シーケンスNo | SeqNo | Integer | Method of ordering records; lowest number comes first | |
| グリッドシーケンスNo | SeqNoGrid | Integer | ||
| ソートNo | SortNo | Number | Determines in what order the records are displayed | |
| 上級フィールド | IsAdvancedField | Yes-No | ||
| 暗号化 | IsEncrypted | Yes-No | ✔ | Display or Storage is encrypted |
| 隠しタイプ | ObscureType | List | Type of obscuring the data (limiting the display) | |
| ラベルのみ | IsHeading | Yes-No | ✔ | Field without Column - Only label is displayed |
| デフォルト フォーカス | IsDefaultFocus | Yes-No | ✔ | |
| ラベルなし | IsFieldOnly | Yes-No | ✔ | Label is not displayed |
| X ポジション | XPosition | Integer | Absolute X (horizontal) position in 1/72 of an inch | |
| カラムスパン | ColumnSpan | Integer | Number of column for a box of field | |
| 行数 | NumLines | Integer | Number of lines for a field | |
| Label Style | AD_LabelStyle_ID | Table | Label CSS Style | |
| Field Style | AD_FieldStyle_ID | Table | Field CSS Style | |
| リファレンス上書き | AD_Reference_ID | Table | System Reference - optional Overwrite | |
| ツールバーボタン | IsToolbarButton | List | Show the button on the toolbar, the window, or both | |
| リファレンスキー | AD_Reference_Value_ID | Table | Required to specify, if data type is Table or List | |
| ダイナミックバリデーション | AD_Val_Rule_ID | Table Direct | Dynamic Validation Rule | |
| Dynamic Validation (Lookup) | AD_Val_Rule_Lookup_ID | Table | Override Dynamic Validation Rule for Lookup Window | |
| 更新可能 | IsUpdateable | List | Determines, if the field can be updated | |
| 常時更新可能 | IsAlwaysUpdateable | List | The column is always updateable, even if the record is not active or processed | |
| 常時更新可能ロジック | AlwaysUpdatableLogic | Text | Logic to determine if field is Updatable irrespective if record’s active status or processed status. This logic Applicable only if Always Updatable is N. | |
| 必須 | IsMandatory | List | Overwrite Field Mandatory status | |
| コピー許可 | IsAllowCopy | List | Determine if a column must be copied when pushing the button to copy record | |
| 検索カラム | IsSelectionColumn | List | Is this column used for finding rows in windows | |
| SQLカラム | ColumnSQL | String | Virtual Column (r/o) | |
| チャート | AD_Chart_ID | Table Direct | ||
| HTML | IsHtml | List | Text has HTML tags | |
| デフォルトロジック | DefaultValue | Text | Default value hierarchy, separated by ; | |
| 値フォーマット | VFormat | String | Format of the value; Can contain fixed format elements, Variables: “_lLoOaAcCa09”, or ~regex | |
| 読取専用ロジック | ReadOnlyLogic | Text | Logic to determine if field is read only (applies only when field is read-write) | |
| 必須ロジック | MandatoryLogic | Text | ||
| 表示長さ | DisplayLength | Integer | Length of the display in characters | |
| 同一行 | IsSameLine | Yes-No | ✔ | Displayed on same line as previous field |
翻訳 タブのフィールド
Section titled “翻訳 タブのフィールド”Fields are automatically translated, if centrally maintained. You only need to translate not centrally maintained Fields.
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| フィールド | AD_Field_ID | Table Direct | ✔ | Field on a database table |
| 言語 | AD_Language | Table | ✔ | Language for this entity |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| 翻訳する | IsTranslated | Yes-No | ✔ | This column is translated |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 説明 | Description | String | Optional short description of the record | |
| コメント | Help | Text | Comment or Hint | |
| Placeholder | Placeholder | String |
翻訳 タブのフィールド
Section titled “翻訳 タブのフィールド”| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| タブ | AD_Tab_ID | Table Direct | ✔ | Tab within a Window |
| 言語 | AD_Language | Table | ✔ | Language for this entity |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| 翻訳する | IsTranslated | Yes-No | ✔ | This column is translated |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 説明 | Description | String | Optional short description of the record | |
| コメント | Help | Text | Comment or Hint | |
| コミット警告 | CommitWarning | Text | Warning displayed when saving |
ツールバーボタン タブのフィールド
Section titled “ツールバーボタン タブのフィールド”| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| タブ | AD_Tab_ID | Search | Tab within a Window | |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| Component Name | ComponentName | String | ✔ | |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| シーケンスNo | SeqNo | Integer | Method of ordering records; lowest number comes first | |
| エンティティタイプ | EntityType | Table | ✔ | Dictionary Entity Type; Determines ownership and synchronization |
| プロセス | AD_Process_ID | Table Direct | Process or Report | |
| 表示ロジック | DisplayLogic | Text | If the Field is displayed, the result determines if the field is actually displayed | |
| Pressed Logic | PressedLogic | Text | ||
| 読取専用ロジック | ReadOnlyLogic | Text | Logic to determine if field is read only (applies only when field is read-write) |
翻訳 タブのフィールド
Section titled “翻訳 タブのフィールド”| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| ウィンドウ | AD_Window_ID | Table Direct | ✔ | Data entry or display window |
| 言語 | AD_Language | Table | ✔ | Language for this entity |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| 翻訳する | IsTranslated | Yes-No | ✔ | This column is translated |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 説明 | Description | String | Optional short description of the record | |
| コメント | Help | Text | Comment or Hint |
アクセス タブのフィールド
Section titled “アクセス タブのフィールド”The Window Access Tab defines the Roles which have access to this Window.
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| ウィンドウ | AD_Window_ID | Table Direct | ✔ | Data entry or display window |
| ロール | AD_Role_ID | Table Direct | ✔ | Responsibility Role |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| 読み書き可能 | IsReadWrite | Yes-No | ✔ | Field is read / write |