F00151GetConversionMethod

F00151 Get Conversion Method

Minor Business Rule

Object Name: B0000172

Parent DLL: CALLBSFN

Location: Client/Server

Language: C

Functional Description

Purpose
The purpose of this function is to return information stored in the Currency Exchange Rate table
(F0015) for the "From" and "To" currencies, and the transaction date of the transaction.  The F0015 record
is fetched using the szCurrencyCodeFrom, szCurrencyCodeTo and jdTransactionDate parameters.  If a
record is found then the calculation method (CXCLMETH) stored in the file is used to determine what type
of exchange rate has been setup. If the calculation method is '1' then the method is inverse and only
the currency spot rate flag (CXCSR) and the currency conversion method (CXCRCM) will be returned. If
the calculation method is other than '1' then the currency conversion method (CXCRCM), triangulation
currency (CXTRCR), and currency spot rate flag (CXCSR) will be returned from the F0015 record.  If no
record is found matching the "From" and "To" currency codes and the date passed in jdTransactioDate then
an error will be set and the program will not return any values.

Data Structure

D0000172 - F00151 Get Conversion Method

Parameter Name Data Item Data Type Req/Opt I/O/Both

szCurrencyCodeFrom CRCD char OPT NONE

A code that identifies the currency of a transaction.

szCurrencyCodeTo CRDC char OPT NONE

A code that identifies the domestic (base) currency of the company on a transaction.

cCurrencyConversionMethod CRCM char OPT NONE

A value that specifies which method to use when converting from one currency to another. Valid values are: Y Multiplier method. The
system multiplies the foreign amount by the multiplier exchange rate to calculate the domestic amount. Z Divisor method. The system divides the
foreign amount by the divisor exchange rate to calculate the domestic amount.

jdTransactionDate EFT JDEDATE OPT NONE

The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost
effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.

szTriangulationCurrency TRCR char OPT NONE

The currency code of the settling currency for triangulation calculations.

cCurrencySpotRate CSR char OPT NONE

An option that indicates whether a spot rate is applicable for a particular currency relationship. Spot rates are exchange rates entered at the
time of transaction entry.

Related Functions

None

Related Tables

F00151 Needed for upgrade for XE and below

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szCurrencyCodeFrom	CRCD	char	OPT	NONE
A code that identifies the currency of a transaction.
szCurrencyCodeTo	CRDC	char	OPT	NONE
A code that identifies the domestic (base) currency of the company on a transaction.
cCurrencyConversionMethod	CRCM	char	OPT	NONE
A value that specifies which method to use when converting from one currency to another. Valid values are: Y Multiplier method. The system multiplies the foreign amount by the multiplier exchange rate to calculate the domestic amount. Z Divisor method. The system divides the foreign amount by the divisor exchange rate to calculate the domestic amount.
jdTransactionDate	EFT	JDEDATE	OPT	NONE
The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
szTriangulationCurrency	TRCR	char	OPT	NONE
The currency code of the settling currency for triangulation calculations.
cCurrencySpotRate	CSR	char	OPT	NONE
An option that indicates whether a spot rate is applicable for a particular currency relationship. Spot rates are exchange rates entered at the time of transaction entry.