Window: Performance Ratio
[Created: 26/12/2005 - Updated: 04/01/2006 ]
Description: Maintain Performance Ratios
Help: Calculation instruction for a ratio
Tab: Ratio
[Created: 26/12/2005 - Updated: 26/12/2005 ]
Description: Performance Ratio
Help: Calculation instruction set for a performance ratio
Tab Level: 0
Table 10: Ratio - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| 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
[Created: 26/12/2005 - Updated: 26/12/2005 ]
Description: Performance Ratio Element
Help: Individual calculation instruction for a ratio
Tab Level: 1
Table 20: Element - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| 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 |