Skip to main content

Window: Performance Color Schema

[Created: 23/12/2005 - Updated: 15/01/2024 ]
Description: Maintain Performance Color Schema
Help: Visual representation of performance by color. The Schema has often three levels (e.g. red-yellow-green). iDempiere supports two levels (e.g. red-green) or four levels (e.g. gray-bronce-silver-gold). Note that Measures without a goal are represented white. The percentages could be between 0 and unlimited (i.e. above 100%).

Tab: Color Schema​

[Created: 23/12/2005 - Updated: 15/01/2024 ]
Description: Performance Color Schema
Help: Visual representation of performance by color. The Schema has often three levels (e.g. red-yellow-green). iDempiere supports two levels (e.g. red-green) or four levels (e.g. gray-bronce-silver-gold). Note that Measures without a goal are represented white. The percentages could be between 0 and unlimited (i.e. above 100%).
Tab Level: 0

Table 10: Color Schema - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.pa_colorschema.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.pa_colorschema.AD_Org_ID numeric(10)
Table Direct
NameAlphanumeric identifier of the entityThe 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.pa_colorschema.Name character varying(60)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.pa_colorschema.Description character varying(255)
String
ActiveThe record is active in the systemThere 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.pa_colorschema.IsActive character(1)
Yes-No
Mark 1 PercentPercentage up to this color is usedExample 50 - i.e. below 50% this color is usedpa_colorschema.Mark1Percent numeric(10)
Integer
Color 1First color usedpa_colorschema.AD_PrintColor1_ID numeric(10)
Table
Mark 2 PercentPercentage up to this color is usedExample 80 - e.g., if Mark 1 is 50 - this color is used between 50% and 80%pa_colorschema.Mark2Percent numeric(10)
Integer
Color 2Second color usedpa_colorschema.AD_PrintColor2_ID numeric(10)
Table
Mark 3 PercentPercentage up to this color is usedExample 100 - e.g., if Mark 2 is 80 - this color is used between 80% and 100%pa_colorschema.Mark3Percent numeric(10)
Integer
Color 3Third color usedpa_colorschema.AD_PrintColor3_ID numeric(10)
Table
Mark 4 PercentPercentage up to this color is usedExample 9999 - e.g., if Mark 3 is 100 - this color is used above 100%pa_colorschema.Mark4Percent numeric(10)
Integer
Color 4Forth color usedpa_colorschema.AD_PrintColor4_ID numeric(10)
Table
Entity TypeDictionary Entity Type; Determines ownership and synchronizationThe Entity Types "Dictionary", "iDempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten. For customizations, copy the entity and select "User"!pa_colorschema.EntityType character varying(40)
Table