Adempiere3.4.0/en/ManPageW PerformanceColorSchema olh
Window: Performance Color Schema
Description : Maintain Performance Color Schema
Help : Visual representation of performance by color. The Schema has often three levels (e.g. red-yellow-green). Adempiere support 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 beween 0 and unlimited (i.e. above 100%).
Tab: Color Schema
Description : Performance Color Schema
Help : Visual representation of performance by color. The Schema has often three levels (e.g. red-yellow-green). Adempiere support 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 beween 0 and unlimited (i.e. above 100%).
Table Name : PA_ColorSchema
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
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
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) 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. |
IsActive
CHAR(1) YesNo |
Mark 1 Percent | Percentage up to this color is used | Example 50 - i.e. below 50% this color is used | Mark1Percent
NUMBER(10) Integer |
Color 1 | First color used | AD_PrintColor1_ID
NUMBER(10) Table | |
Mark 2 Percent | Percentage up to this color is used | Example 80 - e.g., if Mark 1 is 50 - this color is used between 50% and 80% | Mark2Percent
NUMBER(10) Integer |
Color 2 | Second color used | AD_PrintColor2_ID
NUMBER(10) Table | |
Mark 3 Percent | Percentage up to this color is used | Example 100 - e.g., if Mark 2 is 80 - this color is used between 80% and 100% | Mark3Percent
NUMBER(10) Integer |
Color 3 | Third color used | AD_PrintColor3_ID
NUMBER(10) Table | |
Mark 4 Percent | Percentage up to this color is used | Example 9999 - e.g., if Mark 3 is 100 - this color is used above 100% | Mark4Percent
NUMBER(10) Integer |
Color 4 | Forth color used | AD_PrintColor4_ID
NUMBER(10) Table | |
Entity Type | Dictionary Entity Type; Determines ownership and synchronization | The Entity Types "Dictionary", "Adempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten.
For customizations, copy the entity and select "User"! |
EntityType
VARCHAR2 Table |