绩效度量计算 (窗口 ID-213)

来自iDempiere zh
跳转至:导航搜索



窗口: 绩效度量计算

描述: Define how you calculate your performance measures

幫助: Please test the statement in SQL*Plus first. The select statement needs to return a single value! Any restrictions for Date range, Organizations, Business Partners, Products should be done via the "Performance Measure" window. This is the generic calculation. As this tends to be somewhat technical, the system has a few examples predefined.




TAB: 经营度量计算

描述: Maintain your Performance Measure Calculation


幫助 The Performance Measure Calculation defines how performance measures will be calculated. Please test the statement in SQL*Plus first. The select statement needs to return a single value! Any restrictions for Date range, Organizations, Business Partners, Products should be done via the "Performance Measure" window. This is the generic calculation. As this tends to be somewhat technical, the system has a few examples predefined.


File:绩效度量计算 - 经营度量计算 - 窗口 (iDempiere 1.0.0).png




名稱 名稱 描述 幫助 產品規格
Client 客户 安装此软件的客户 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization 机构 客户内的机构实体。 An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
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. Name
character varying(60) NOT NULL
String
Description 描述 该记录的可选描述 描述最多为 255 个字符。 Description
character varying(255)
String
Active 有效 本记录有效 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.

IsActive
character(1) NOT NULL
Yes-No
Entity Type 实体类型 字典实体类型; 确定所有者和同步性 实体类型"字典/Dictionary", "Adempiere" 和 "应用/Application" 能够自动的同步因此客户化的工作将被删除或覆盖

要客户化,请复制实体并选择"用户/User"!

EntityType
character varying(40) NOT NULL
Table
Sql SELECT select子句 SQL select子句 The Select Clause indicates the SQL SELECT clause to use for selecting the record for a measure calculation. SelectClause
character varying(2000) NOT NULL
Text
Sql WHERE SQL的Where子句 Fully qualified 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". WhereClause
character varying(2000) NOT NULL
Text
Date Column 日期列 完全合格日期列 The Date Column indicates the date to be used when calculating this measurement DateColumn
character varying(60) NOT NULL
String
Org Column 组织 列 Fully qualified Organization column (AD_Org_ID) The Organization Column indicates the organization to be used in calculating this measurement. OrgColumn
character varying(60)
String
B.Partner Column B.Partner Column Fully qualified Business Partner key column (C_BPartner_ID) The Business Partner Column indicates the Business Partner to use when calculating this measurement BPartnerColumn
character varying(60)
String
Product Column 产品列 Fully qualified Product column (M_Product_ID) The Product Column indicates the product to use to use when calculating this measurement. ProductColumn
character varying(60)
String
Table 字段所在表 The Table indicates the table in which a field or fields reside. AD_Table_ID
numeric(10) NOT NULL
Table Direct
Key Column Key Column Key Column for Table null KeyColumn
character varying(60) NOT NULL
String


Contributions / Posts

Cookie帮助我们提供我们的服务。通过使用我们的服务,您同意我们使用cookie。