DetermineXPICurrExchangeRates

Determine XPI Currency Exchange Rates

Minor Business Rule

Object Name: B0000710

Parent DLL: CFIN

Location: Client/Server

Language: C

Retrieve XPI Currency Exchange Rates BSFN    (B0000710)
    This business function is used to determine the correct
  multiplier and divisor rates for F0015 currency exchange
  rate records for returning those values in XPI Query
  Results.
    If either the multiplier rate or the divisor rate
  is specified on the F0015 currency exchange rate
  record, but the other rate is not specified, this
  business function will calulate the inverse of the
  existing rate to plug into the missing multiplier or
  divisor rate to be returned to XPI.
    If both the multiplier and divisor rates do not exist
  as is the case when using triangulation methods, this
  function will call B0000033 "Get Exchange Rate" which
  will return the corresponding triangulation rates.
  These triangulation rates will then be used to calculate
  the correct multiplier and divisor cross rates to be
  returned to XPI.
    If both multiplier and divisor rates already exist
  for a currency exchange rate, those existing rates will
  be returned to XPI.

Retrieve XPI Currency Exchange Rates DSTR    (D0000710)
    This data structure is used in B0000710 (above).
  The values required to be passed in from F0015 are:
  Currency Code From, Currency Code To, Effective Date,
  Address Book number, Multiplier Rate In, and Divisor
  Rate In.  The derived values that will subsequently be
  returned to XPI are Multiplier Rate Out and Divisor
  Rate out.

Data Structure

D0000710 - Determine XPI Currency Exchange Rates

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szCurrencyCodeFrom_CRCD	CRCD	char	REQ	INPUT
A code that identifies the currency of a transaction.
szCurrencyCodeTo_CRDC	CRDC	char	REQ	INPUT
A code that identifies the domestic (base) currency of the company on a transaction.
jdDateEffective_EFT	EFT	JDEDATE	REQ	INPUT
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.
mnAddressNumber_AN8	AN8	MATH_NUMERIC	REQ	INPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
mnCurrConverRateMult_CRR_IN	CRR	MATH_NUMERIC	REQ	INPUT
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount. The number in this field can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.
mnCurrConverRateDiv_CRRD_IN	CRRD	MATH_NUMERIC	REQ	INPUT
A number (exchange rate) that a foreign currency amount is divided by to calculate a domestic currency amount. The number you enter in this field can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.
mnCurrConverRateMult_CRR_OUT	CRR	MATH_NUMERIC	OPT	OUTPUT
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount. The number in this field can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.
mnCurrConverRateDiv_CRRD_OUT	CRRD	MATH_NUMERIC	OPT	OUTPUT
A number (exchange rate) that a foreign currency amount is divided by to calculate a domestic currency amount. The number you enter in this field can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.

Related Functions

None

Related Tables

None