Adempiere3.4.0/en/ManPageW PerformanceRatio olh
Window: Performance Ratio
Description : Maintain Performance Ratios
Help : Calculation instruction for a ratio
Tab: Ratio
Description : Performance Ratio
Help : Calculation instruction set for a performance ratio
Table Name : PA_Ratio
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 |
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 |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
Accounting Schema | Rules for accounting | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | C_AcctSchema_ID
NUMBER(10) TableDir |
Tab: Element
Description : Performance Ratio Element
Help : Individual calculation instruction for a ratio
Table Name : PA_RatioElement
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 |
Ratio | Performace Ratio | Calculation instruction set for a perfomance ratio | PA_Ratio_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 |
Sequence | Method of ordering records; lowest number comes first | The Sequence indicates the order of records | SeqNo
NUMBER(10) Integer |
Operand | Ratio Operand | Operand how data is calculated. If it is the first in the series, 'minus' will create a negative value, otherwise ignored. | RatioOperand
CHAR(1) List |
Element Type | Ratio Element Type | Type of data used for the calculation | RatioElementType
CHAR(1) List |
Measure Calculation | Calculation method for measuring performance | The Measure Calculation indicates the method of measuring performance. | PA_MeasureCalc_ID
NUMBER(10) TableDir |
Constant Value | Constant value | ConstantValue
NUMBER Number | |
Ratio Used | Performace Ratio Used | Existing Performance Ratio to be used in the calculation. Make sure that the Ratio is not self-referencing (loop). | PA_RatioUsed_ID
NUMBER(10) Table |
Account | Account used | The (natural) account used | Account_ID
NUMBER(10) Table |
PostingType | The type of posted amount for the transaction | The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. | PostingType
CHAR(1) List |