ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.currency/C Conversion Rate
Contents
|
C_Conversion_Rate
- Name:C_Conversion_Rate
- Classname:CurrencyConversionRate
This table contains the following columns:
Name | Nullable | Data Type | Description
|
IsActive | No | CHAR (1) | 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 reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions. |
AD_Client_ID | No | VARCHAR (32) | A Client is a company or a legal entity. You cannot share data between Clients. |
C_Conversion_Rate_ID | No | VARCHAR (32) | The Conversion Rate defines the rate (multiply or divide) to use when converting a source currency to an accounting currency. |
ConversionRateType | No | VARCHAR (60) | The Conversion Rate Type indicates the type of conversion rate. This allows you to enter multiple rates for the same currency pair. For example, one rate may be used for Spot conversions and a different rate for Revaluations. |
CreatedBy | No | VARCHAR (32) | The Created By field indicates the user who created this record. |
Created | No | TIMESTAMP (7) | The Created field indicates the date that this record was created. |
C_Currency_ID | No | VARCHAR (32) | Indicates the currency to be used when processing this document. |
DivideRate | No | DECIMAL | To convert Source number to Target number, the Source is divided by the divide rate. If you enter a Divide Rate, the Multiply Rate will be automatically calculated. |
MultiplyRate | No | DECIMAL | To convert Source number to Target number, the Source is multiplied by the multiply rate. If the Multiply Rate is entered, then the Divide Rate will be automatically calculated. |
AD_Org_ID | No | VARCHAR (32) | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. |
C_Currency_ID_To | No | VARCHAR (32) | The Currency To defines the target currency for this conversion rate. |
Updated | No | TIMESTAMP (7) | The Updated field indicates the date that this record was updated. |
UpdatedBy | No | VARCHAR (32) | The Updated By field indicates the user who updated this record. |
ValidFrom | No | TIMESTAMP (7) | The Valid From date indicates the first day of a date range |
ValidTo | Yes | TIMESTAMP (7) | The Valid To date indicates the last day of a date range |
Columns
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_ID)
It has a validation "AD_Client Security validation", with the following code
AD_Client.AD_Client_ID in (@#User_Client@)
Conversion Rate
- Physical column name: C_Conversion_Rate_ID
- Property Name: id
- Reference: ID
Conversion Rate Type
- Physical column name: ConversionRateType
- Property Name: conversionRateType
- Reference: List
List values: C_Conversion_Rate Types
The allowed values for this list are:
- A (Average): Average Rates
- C (Company): Company Rate
- U (User Type): User Rate Type
- M (Manual Rate): Manual Rate
- S (Spot): Spot Conversation Rate Type
- P (Period End): Period Conversion Type
- N (None): No Conversion Rate
- F (Fixed): Euro Fixed Currency
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Currency
- Physical column name: C_Currency_ID
- Property Name: currency
- Reference: Table
- This column is part of the table's identifier
- This column is a child for a business object (is Parent)
Foreign key column to C_Currency table, (column: C_Currency_ID)
Divide Rate by
- Physical column name: DivideRate
- Property Name: divideRateBy
- Reference: General Quantity
- Default value: 0
Callout: SL_Conversion_Rate
This column has a callout associated.
It is implemented by [1] Java Class.
Multiple Rate by
- Physical column name: MultiplyRate
- Property Name: multipleRateBy
- Reference: General Quantity
- Default value: 0
Callout: SL_Conversion_Rate
This column has a callout associated.
It is implemented by [2] Java Class.
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
To Currency
- Physical column name: C_Currency_ID_To
- Property Name: toCurrency
- Reference: Table
- This column is part of the table's identifier
Foreign key column to C_Currency table, (column: C_Currency_ID)
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Valid from Date
- Physical column name: ValidFrom
- Property Name: validFromDate
- Reference: Date
- This column is part of the table's identifier
Valid to Date
- Physical column name: ValidTo
- Property Name: validToDate
- Reference: Date
Other Info
Check Constraints
These are the check constraints for this table:
- C_CONVERSION_RA_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
- C_CONVERSION_RATE_RATE_CHECK: MULTIPLYRATE > 0 AND DIVIDERATE > 0