Performance Ratio (Window ID-366)
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
Name | Description | Help | Technical Data |
---|---|---|---|
Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | PA_Ratio.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. | PA_Ratio.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. | PA_Ratio.Name character varying(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. |
PA_Ratio.IsActive character(1) Yes-No |
Description | Optional short description of the record | A description is limited to 255 characters. | PA_Ratio.Description character varying(255) String |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | PA_Ratio.Help character varying(2000) Text |
Accounting Schema | Rules for accounting | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | PA_Ratio.C_AcctSchema_ID numeric(10) Table Direct |
Tab: Element
Description: Performance Ratio Element
Help: Individual calculation instruction for a ratio
Name | Description | Help | Technical Data |
---|---|---|---|
Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | PA_RatioElement.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. | PA_RatioElement.AD_Org_ID numeric(10) Table Direct |
Ratio | Performance Ratio | Calculation instruction set for a performance ratio | PA_RatioElement.PA_Ratio_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. | PA_RatioElement.Name character varying(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | PA_RatioElement.Description character varying(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. |
PA_RatioElement.IsActive character(1) Yes-No |
Sequence | Method of ordering records; lowest number comes first | The Sequence indicates the order of records | PA_RatioElement.SeqNo numeric(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. | PA_RatioElement.RatioOperand character(1) List |
Element Type | Ratio Element Type | Type of data used for the calculation | PA_RatioElement.RatioElementType character(1) List |
Measure Calculation | Calculation method for measuring performance | The Measure Calculation indicates the method of measuring performance. | PA_RatioElement.PA_MeasureCalc_ID numeric(10) Table Direct |
Constant Value | Constant value | PA_RatioElement.ConstantValue numeric Number | |
Ratio Used | Performance Ratio Used | Existing Performance Ratio to be used in the calculation. Make sure that the Ratio is not self-referencing (loop). | PA_RatioElement.PA_RatioUsed_ID numeric(10) Table |
Account | Account used | The (natural) account used | PA_RatioElement.Account_ID numeric(10) Search |
Posting Type | The type of posted amount for the transaction | The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. | PA_RatioElement.PostingType character(1) List |