Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of this currency exchange rate provider.
 WEBSITEURL UDT_WEBADDRESS   Default = '' The URL of this currency exchange rate provider's web site.
 ASSEMBLYNAME nvarchar(255)   Default = '' The name of the assembly providing the CurrencyExchangeRateProvider implementation for this provider.
 CLASSNAME nvarchar(255)   Default = '' The name of the class providing the CurrencyExchangeRateProvider implementation for this provider.
 DEFAULTAUTHENTICATION nvarchar(4000)   Default = '' Any information, such as a username or password, required to authenticate the call to the currency exchange rate provider's service; this will be used as the default authentication for any currency exchange rate download process parameter set using this provider, but can be overridden.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.

Foreign Key Field Type Null Notes Description
 TIMEZONEENTRYID uniqueidentifier   TIMEZONEENTRY.ID This is the time zone associated with any date/time values in this provider's data.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_CURRENCYEXCHANGERATEPROVIDER_DATEADDED DATEADDED    
 IX_CURRENCYEXCHANGERATEPROVIDER_DATECHANGED DATECHANGED      
 PK_CURRENCYEXCHANGERATEPROVIDER ID  
 UC_CURRENCYEXCHANGERATEPROVIDER_NAME NAME    

Trigger Name Description
 TR_CURRENCYEXCHANGERATEPROVIDER_AUDIT_UPDATE
 TR_CURRENCYEXCHANGERATEPROVIDER_AUDIT_DELETE

Referenced by Field
 CURRENCYEXCHANGERATEDOWNLOADPROCESS CURRENCYEXCHANGERATEPROVIDERID

Entity-Relationship diagram of this table