Import Currency Rate (Window ID-296)

From iDempiere en

Table of Contents

Window: Import Currency Rate

Description: Import Currency Conversion Rates

Help: The rates are imported after validation of currencies and conversion rate type as well as rates. The multiply rate is used. If a reciprocal rate is to be created, the divide rate is used.

Tab: Import Currency Rate

Description: Import Currency Conversion Rate

Help:

Import Currency Rate - Import Currency Rate - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Import Conversion Rate Import Currency Conversion Rate I_Conversion_Rate.I_Conversion_Rate_ID
numeric(10)
ID
Imported Has this import been processed The Imported check box indicates if this import has been processed. I_Conversion_Rate.I_IsImported
character(1)
Yes-No
Conversion Rate Rate used for converting currencies The Conversion Rate defines the rate (multiply or divide) to use when converting a source currency to an accounting currency. I_Conversion_Rate.C_Conversion_Rate_ID
numeric(10)
Table Direct
Import Error Message Messages generated from import process The Import Error Message displays any error messages generated during the import process. I_Conversion_Rate.I_ErrorMsg
character varying(2000)
String
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. I_Conversion_Rate.AD_Client_ID
numeric(10)
Table Direct
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. I_Conversion_Rate.AD_Org_ID
numeric(10)
Table Direct
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.

I_Conversion_Rate.IsActive
character(1)
Yes-No
ISO Currency Code Three letter ISO 4217 Code of the Currency For details - http://www.unece.org/trade/rec/rec09en.htm I_Conversion_Rate.ISO_Code
character(3)
String
Currency The Currency for this record Indicates the Currency to be used when processing or reporting on this record I_Conversion_Rate.C_Currency_ID
numeric(10)
Table Direct
ISO Currency To Code Three letter ISO 4217 Code of the To Currency For details - http://www.unece.org/trade/rec/rec09en.htm I_Conversion_Rate.ISO_Code_To
character(3)
String
Currency To Target currency The Currency To defines the target currency for this conversion rate. I_Conversion_Rate.C_Currency_ID_To
numeric(10)
Table
Currency Type Key Key value for the Currency Conversion Rate Type The date type key for the conversion of foreign currency transactions I_Conversion_Rate.ConversionTypeValue
character varying(40)
String
Currency Type Currency Conversion Rate Type The Currency Conversion Rate Type lets you define different type of rates, e.g. Spot, Corporate and/or Sell/Buy rates. I_Conversion_Rate.C_ConversionType_ID
numeric(10)
Table Direct
Multiply Rate Rate to multiple the source by to calculate the target. 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. I_Conversion_Rate.MultiplyRate
numeric
Number
Divide Rate To convert Source number to Target number, the Source is divided 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. I_Conversion_Rate.DivideRate
numeric
Number
Valid from Valid from including this date (first day) The Valid From date indicates the first day of a date range I_Conversion_Rate.ValidFrom
timestamp without time zone
Date
Valid to Valid to including this date (last day) The Valid To date indicates the last day of a date range I_Conversion_Rate.ValidTo
timestamp without time zone
Date
Create Reciprocal Rate Create Reciprocal Rate from current information If selected, the imported USD->EUR rate is used to create/calculate the reciprocal rate EUR->USD. I_Conversion_Rate.CreateReciprocalRate
character(1)
Yes-No
Import Conversion Rate Import Currency Conversion Rate I_Conversion_Rate.Processing
character(1)
Button
Processed The document has been processed The Processed checkbox indicates that a document has been processed. I_Conversion_Rate.Processed
character(1)
Yes-No


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.