パフォーマンス測定計算（Performance Measure Calculation）｜iDempiere 13 画面リファレンス
パフォーマンス測定計算（Performance Measure Calculation）
Section titled “パフォーマンス測定計算（Performance Measure Calculation）”iDempiere 13 標準ウィンドウ（AD_Window_ID: 213）
メニュー: 会計管理 ▸ パフォーマンス測定 ▸ パフォーマンス測定計算
Define how you calculate your performance measures
The Performance Measure Calculation defines how performance measures will be calculated.
The sql needs to return a single value. Please check examples.
The date restriction is defined in the Goal.
Any restrictions for Organizations, Business Partners, Products, etc. are as Performance Goal Restrictions.
| # | タブ | テーブル | 階層 | 説明 |
|---|---|---|---|---|
| 10 | 測定計算 | PA_MeasureCalc | 0 | Maintain your Performance Measure Calculation |
測定計算 タブのフィールド
Section titled “測定計算 タブのフィールド”The Performance Measure Calculation defines how performance measures will be calculated. See examples.
The SELECT definition must contain the SELECT and FROM keywords in upper case. The WHERE clause can only contain values of the main table (e.g. when selecting from Header and lines, only header variables can be used in the where clause) and be fully qualified if there is more then one table.
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | 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 | |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| エンティティタイプ | EntityType | Table | ✔ | Dictionary Entity Type; Determines ownership and synchronization |
| SQL SELECT句 | SelectClause | Text | ✔ | SQL SELECT clause |
| SQL WHERE句 | WhereClause | Text | ✔ | Fully qualified SQL WHERE clause |
| 日付カラム | DateColumn | String | ✔ | Fully qualified date column |
| 組織カラム | OrgColumn | String | ✔ | Fully qualified Organization column (AD_Org_ID) |
| 取引先カラム | BPartnerColumn | String | Fully qualified Business Partner key column (C_BPartner_ID) | |
| 品目カラム | ProductColumn | String | Fully qualified Product column (M_Product_ID) | |
| テーブル | AD_Table_ID | Table Direct | ✔ | Database Table information |
| キーカラム | KeyColumn | String | ✔ | Key Column for Table |