ManPageW PerformanceColorSchema

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



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

Contributions

Personal tools