ExchangeRate

Entity Definition

Logical Name : ExchangeRate
Physical Name : CO_RT_EXC

Expresses the quantitative conversion factor between two kinds of CURRENCY, one which must be the store's home currency.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
SequenceNumber (PK) A sequence number denoting the order in which Exchange rate records were created for this pairing of currencies. AI_EXC_RT LineNumber smallint
From (FK)(PK) Currency code designated by ISO to identify national currency CD_CNY_ISO_4217_FM ISO_4217_CurrencyCode_char(3) char(3) ISO4217-CurrencyType(LU_CNY_ISO_4217)
To (FK)(PK) Currency code designated by ISO to identify national currency CD_CNY_ISO_4217_TO ISO_4217_CurrencyCode_char(3) char(3) ISO4217-CurrencyType(LU_CNY_ISO_4217)
ExchangeRateEffectiveDate The date on which a specific exchange rate becomes effective. DC_RT_EXC_EF EffectiveDate date
ExchangeRateExpirationDate Date on which the exchange rate expires and is no longer valid. DC_RT_EXC_EP ExpirationDate date
ToBuyAmount The buying rate (in monetary units) of the tender type, based on the store's local currency. MO_RT_TO_BUY ExchangeRate decimal(14,9)
ToSellAmount The selling rate(in monetary units) of the tender type, based on the store's local currency MO_RT_TO_SL ExchangeRate decimal(14,9)
ServiceFeeAmount The add-on fee, in local currency amounts, imposed on the exchange MO_FE_SV_EXC Money decimal(16,5)
MinimumCurrencyAmount The minimum monetary amount the store will either purchase or sell foreign tender. LL_CNY_EXC Money decimal(16,5)

Relationships

Parent Entity Verb Phrase Child Entity
ISO4217-CurrencyType exchange from ExchangeRate
ISO4217-CurrencyType exchange to ExchangeRate

Logical Views containing ExchangeRate

Logical View
Logical 02330 - Retail Transaction - Tender - Macro View
Logical 10104 - Enterprise Currency