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

窗口: 绩效度量计算

描述: 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