报表视图 (窗口 ID-180)

窗口: 报表视图

描述: 维护报表视图

幫助: The Report View Window defines the views used when generating reports. This window is for System Admin use only.

TAB: 报表视图

描述: 定义报表视图

幫助 The Define Report View defines the views used in report generation

File:报表视图 - 报表视图 - 窗口 (iDempiere 1.0.0).png

名稱	名稱	描述	幫助	產品規格
Report View	报表视图	View used to generate this report	The Report View indicates the view used to generate this report.	AD_ReportView_ID numeric(10) NOT NULL ID
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
Table	表	字段所在表	The Table indicates the table in which a field or fields reside.	AD_Table_ID numeric(10) NOT NULL Table Direct
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) String
Sql ORDER BY	SQL的Order By子句	Fully qualified ORDER BY clause	The ORDER BY Clause indicates the SQL ORDER BY clause to use for record selection	OrderByClause character varying(2000) String

TAB: 报表视图列

描述: 报表视图列

幫助 The Report View Column Tab defines any columns which will be overridden in the generation of the select SQL

File:报表视图 - 报表视图列 - 窗口 (iDempiere 1.0.0).png

名稱	名稱	描述	幫助	產品規格
Report view Column	报表视图列	null	null	AD_ReportView_Col_ID numeric(10) NOT NULL ID
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
Report View	报表视图	View used to generate this report	The Report View indicates the view used to generate this report.	AD_ReportView_ID numeric(10) NOT NULL Table Direct
Column	列	在表中的列	链接到数据库表中的列。	AD_Column_ID numeric(10) Table Direct
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
Function Column	函数列	Overwrite Column with Function	The Function Column indicates that the column will be overridden with a function	FunctionColumn character varying(60) NOT NULL String
SQL Group Function	SQL组函数	此函数将产生一个Group By子句	The SQL Group Function checkbox indicates that this function will generate a Group by Clause in the resulting SQL.	IsGroupFunction character(1) NOT NULL Yes-No