project QadFinancials > class BExchangeRate > dataset tApiExchangeRate


copy of class table tExchangeRate

table tApiExchangeRate


field namedata typedescription
ExchangeRate_IDintegerid
SharedSet_IDinteger
ExchangeRateValidDateFromdateValid from: The start date of the currency exchange relationship.
The effective period of an entry cannot overlap with another entry for the same relationship.
ExchangeRateValidDateTilldateValid to: This field specify the date after which the exchange rate type becomes inactive.
api annotation:When creating a new exchange rate type, the system proposes a default validity end date based on the value you entered in the Default Validity field in Exchange Rate Type Create for the exchange rate type. However, you can overwrite the default value.
ExchangeRatedecimal(10)Exchange Rate: This number is specified as the amount by which you multiply a single unit of a From Currency to reach the equivalent number of the To Currency units.
FromCurrency_IDinteger
ToCurrency_IDinteger
ExchangeRateType_IDinteger
ExchangeRateScaledecimal(10)Scale Factor: A number used in the exchange rate calculation to adjust the amount of the From Currency.
Typically used in hyperinflationary environments when the differences between currency values is large.
api annotation:Value for this field defaults to 1.0000000 .
tcExchangeRateTypeCodecharacterExchange Rate Type. The business area where the exchange rate is applicable.
tcFromCurrencyCodecharacterFrom Currency Code. The first currency of the exchange rate relationship.
The From Currency Code cannot be the same as the To Currency Code.
tcToCurrencyCodecharacterTo Currency Code. The second currency of the exchange rate relationship.
The To Currency Code cannot be the same as the From Currency Code.
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter


Internal usage


QadFinancials
method BExchangeRate.ApiExchangeRate
method BExchangeRate.ApiStdMaintainTT