View source | Discuss this page | Page history | Printable version   

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.common.currency/C Conversion Rate

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.common.currency

Index

Contents

C_Conversion_Rate

The Conversion Rate defines the rates to use when converting a source currency to an accounting or reporting currency.
The Conversion Rates tab is used to define conversion rates to be used when converting document amounts from one currency to another. Conversion rates can be defined for multiple rate types. They can also be effective for a defined range of dates.

This table contains the following columns:

Name Nullable Data Type Description
C_Conversion_Rate_ID NVARCHAR2(32)The amount or quantity at which one unit of measure is changed to another.
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
IsActive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created NDATEThe date that this record is completed.
CreatedBy NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
UpdatedBy NVARCHAR2(32)User who updated this records
C_Currency_ID NVARCHAR2(32)An accepted medium of monetary exchange that may vary across countries.
C_Currency_ID_To NVARCHAR2(32)Target currency
ValidFrom NDATEA parameter stating the starting time of a specified request.
ValidTo YDATEA parameter stating the ending time of a specified request.
ConversionRateType NVARCHAR2(60)A distinct conversion rate characteristic used for processes.
MultiplyRate NNUMBERThe rate by which the base unit will be mutiplied by to create the converted unit.
DivideRate NNUMBERThe rate by which the base unit will be divided by to create the converted unit.

Other Info

Check constraints

These are the check constraints for this table:

top

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Unique

top

Columns

Conversion Rate

The Conversion Rate defines the rate (multiply or divide) to use when converting a source currency to an accounting currency.

top

Client

Foreign key column to AD_Client table, (column: AD_Client_ID)


Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:

 
AD_Client.AD_Client_ID IN (@#User_Client@)

top

Organization

Foreign key column to AD_Org table, (column: AD_Org_ID)

top

Active

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.

top

Creation Date

The Created field indicates the date that this record was created.

top

Created By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Updated

The Updated field indicates the date that this record was updated.

top

Updated By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Currency

Foreign key column to C_Currency table, (column: C_Currency_ID)


Reference Table C_Currency

top

To Currency

Foreign key column to C_Currency table, (column: C_Currency_ID)


Reference Table C_Currency

top

Valid from Date

The Valid From date indicates the first day of a date range

top

Valid to Date

The Valid To date indicates the last day of a date range

top

Conversion Rate Type

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.

List values: C_Conversion_Rate Types

The allowed values for this list are:

top

Multiple Rate by

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.

Callout: SL_Conversion_Rate

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Conversion_Rate Java class.

top

Divide Rate by

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.

Callout: SL_Conversion_Rate

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Conversion_Rate Java class.

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP_2.50:Developers_Guide/Database_Model/org.openbravo.model.common.currency/C_Conversion_Rate"

This page has been accessed 2,568 times. This page was last modified on 14 June 2011, at 11:03. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.