Sales.CurrencyRate

Field Name Data Type Size Original Type Default Nullable Description Check

CurrencyRateID int identity int Not null Primary key for CurrencyRate records.

CurrencyRateDate datetime Not null Date and time the exchange rate was obtained.

FromCurrencyCode nchar 3 Not null Exchange rate was converted from this currency code.

ToCurrencyCode nchar 3 Not null Exchange rate was converted to this currency code.

AverageRate money 19,4 decimal(19,4) Not null Average exchange rate for the day.

EndOfDayRate money 19,4 decimal(19,4) Not null Final exchange rate for the day.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description
CurrencyRateID	int identity		int		Not null	Primary key for CurrencyRate records.
CurrencyRateDate	datetime				Not null	Date and time the exchange rate was obtained.
FromCurrencyCode	nchar	3			Not null	Exchange rate was converted from this currency code.
ToCurrencyCode	nchar	3			Not null	Exchange rate was converted to this currency code.
AverageRate	money	19,4	decimal(19,4)		Not null	Average exchange rate for the day.
EndOfDayRate	money	19,4	decimal(19,4)		Not null	Final exchange rate for the day.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.CurrencyRate'

Primary Key Name Field Name

PK_CurrencyRate_CurrencyRateID CurrencyRateID

Primary Key Name	Field Name
PK_CurrencyRate_CurrencyRateID	CurrencyRateID

Foreign keys for table 'Sales.CurrencyRate', 2 items

Foreign Primary Key Name

CurrencyRate.FromCurrencyCode Currency.CurrencyCode FK_CurrencyRate_Currency_FromCurrencyCode

CurrencyRate.ToCurrencyCode Currency.CurrencyCode FK_CurrencyRate_Currency_ToCurrencyCode

Foreign	Primary	Key Name
CurrencyRate.FromCurrencyCode	Currency.CurrencyCode	FK_CurrencyRate_Currency_FromCurrencyCode
CurrencyRate.ToCurrencyCode	Currency.CurrencyCode	FK_CurrencyRate_Currency_ToCurrencyCode

Indexes for table 'Sales.CurrencyRate', 2 items

Index Name Description Clustered Unique Fields

PK_CurrencyRate_CurrencyRateID Clustered index created by a primary key constraint. Yes Yes CurrencyRateID

AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode Unique nonclustered index. No Yes CurrencyRateDate, FromCurrencyCode, ToCurrencyCode

Index Name	Description	Clustered	Unique	Fields
PK_CurrencyRate_CurrencyRateID	Clustered index created by a primary key constraint.	Yes	Yes	CurrencyRateID
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode	Unique nonclustered index.	No	Yes	CurrencyRateDate, FromCurrencyCode, ToCurrencyCode

Triggers for table 'Sales.CurrencyRate', 1 item

Name Description Type Enabled

uCurrencyRate AFTER UPDATE trigger setting the ModifiedDate column in the CurrencyRate table to the current date. after Update Yes

Name	Description	Type	Enabled
uCurrencyRate	AFTER UPDATE trigger setting the ModifiedDate column in the CurrencyRate table to the current date.	after Update	Yes

Dependencies for table 'Sales.CurrencyRate', 1 item

Object Name Type Field Name

Sales.uCurrencyRate trigger N/A