Window: Chart
[Created: 23/08/2010 - Updated: 23/08/2010 ]
Description: Chart Definition
Help:
Tab: Chart
[Created: 23/08/2010 - Updated: 23/08/2010 ]
Description:
Help:
Tab Level: 0
Table 10: Chart - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_chart.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | ad_chart.AD_Org_ID numeric(10) 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. | ad_chart.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | ad_chart.Description character varying(255) String |
| Chart Type | Type of chart to render | ad_chart.ChartType character varying(2) List | |
| Window Height | ad_chart.WinHeight numeric(10) Integer | ||
| Display Legend | Display chart legend | Toggles the display of the chart legend | ad_chart.IsDisplayLegend character(1) Yes-No |
| Orientation | The orientation of the chart. | ad_chart.ChartOrientation character(1) List | |
| Domain Label | Label for the domain axis. | ad_chart.DomainLabel character varying(60) String | |
| Range Label | Label for the range axis. | ad_chart.RangeLabel character varying(60) String | |
| Time Series | The domain data for the chart is organised by time. | A time series chart will automatically group and restrict the data by the time unit and scope specified. | ad_chart.IsTimeSeries character(1) Yes-No |
| Time Unit | The unit of time for grouping chart data. | ad_chart.TimeUnit character(1) List | |
| Time Scope | The number of time units to include the chart result. | ad_chart.TimeScope numeric(10) Integer | |
| Entity Type | Dictionary Entity Type; Determines ownership and synchronization | The Entity Types "Dictionary", "iDempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten. For customizations, copy the entity and select "User"! | ad_chart.EntityType character varying(40) Table |
| Active | The record is active in the system | 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. | ad_chart.IsActive character(1) Yes-No |
Tab: Datasource
[Created: 23/08/2010 - Updated: 12/09/2022 ]
Description:
Help:
Tab Level: 1
Table 20: Datasource - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_chartdatasource.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | ad_chartdatasource.AD_Org_ID numeric(10) Table Direct |
| Chart | ad_chartdatasource.AD_Chart_ID numeric(10) 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. | ad_chartdatasource.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | ad_chartdatasource.Description character varying(255) String |
| Entity Type | Dictionary Entity Type; Determines ownership and synchronization | The Entity Types "Dictionary", "iDempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten. For customizations, copy the entity and select "User"! | ad_chartdatasource.EntityType character varying(40) Table |
| Sql FROM | SQL FROM clause | The Select Clause indicates the SQL FROM clause to use for selecting the record for a measure calculation. It can have JOIN clauses. Do not include the FROM itself. | ad_chartdatasource.FromClause character varying(2000) Text |
| Sql WHERE | Fully qualified SQL 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". | ad_chartdatasource.WhereClause character varying(2000) Text |
| Series Column | ad_chartdatasource.SeriesColumn character varying(124) String | ||
| Category Column | Fully qualified data category column | The Category Column determines how the chart data is grouped | ad_chartdatasource.CategoryColumn character varying(124) String |
| Date Column | Fully qualified date column | The Date Column indicates the date to be used when calculating this measurement | ad_chartdatasource.DateColumn character varying(124) String |
| Time Offset | Number of time units to offset displayed chart data from the current date. | For example an offset of -12 with a chart time unit of Month will result in previous year data being displayed. | ad_chartdatasource.TimeOffset numeric(10) Integer |
| Value Column | Fully qualified data value column | The Value Column contains the value data for the chart | ad_chartdatasource.ValueColumn character varying(124) String |
| Table | Database Table information | The Database Table provides the information of the table definition | ad_chartdatasource.AD_Table_ID numeric(10) Table Direct |
| Key Column | Key Column for Table | ad_chartdatasource.KeyColumn character varying(124) String | |
| Active | The record is active in the system | 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. | ad_chartdatasource.IsActive character(1) Yes-No |
Tab: Datasource Translation
[Created: 12/09/2022 - Updated: 27/10/2024 ]
Description:
Help:
Tab Level: 2
Table 30: Datasource Translation - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_chartdatasource_trl.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | ad_chartdatasource_trl.AD_Org_ID numeric(10) Table Direct |
| Chart Datasource | ad_chartdatasource_trl.AD_ChartDatasource_ID numeric(10) Search | ||
| Language | Language for this entity | The Language identifies the language to use for display and formatting | ad_chartdatasource_trl.AD_Language character varying(6) Table |
| 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. | ad_chartdatasource_trl.Name character varying(60) String |
| Translated | This column is translated | The Translated checkbox indicates if this column is translated. | ad_chartdatasource_trl.IsTranslated character(1) Yes-No |
| Active | The record is active in the system | 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. | ad_chartdatasource_trl.IsActive character(1) Yes-No |
Tab: Translation
[Created: 21/03/2014 - Updated: 27/10/2024 ]
Description:
Help:
Tab Level: 1
Table 40: Translation - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_chart_trl.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | ad_chart_trl.AD_Org_ID numeric(10) Table Direct |
| Chart | ad_chart_trl.AD_Chart_ID numeric(10) Search | ||
| Language | Language for this entity | The Language identifies the language to use for display and formatting | ad_chart_trl.AD_Language character varying(6) Table |
| Active | The record is active in the system | 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. | ad_chart_trl.IsActive character(1) Yes-No |
| Translated | This column is translated | The Translated checkbox indicates if this column is translated. | ad_chart_trl.IsTranslated character(1) Yes-No |
| 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. | ad_chart_trl.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | ad_chart_trl.Description character varying(255) String |
| Domain Label | Label for the domain axis. | ad_chart_trl.DomainLabel character varying(60) String | |
| Range Label | Label for the range axis. | ad_chart_trl.RangeLabel character varying(60) String |