Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of this currency exchange rate download process.
 DESCRIPTION nvarchar(4000)   Default = '' A description of this currency exchange rate download process.
 PROVIDERAUTHENTICATION nvarchar(4000)   Default = '' Any information, such as a username or password, required to authenticate the call to the currency exchange rate provider's service.
 PROVIDERPARAMETERS xml Any provider-specific parameters indicating how the currency exchange rate provider's service should be accessed.
 TYPECODE tinyint   Default = 0 The type to assign to the currency exchange rates downloaded.
 TYPE nvarchar(9) (Computed) CASE [TYPECODE] WHEN 0 THEN N'Corporate' WHEN 1 THEN N'Daily' WHEN 2 THEN N'Spot' END Provides a translation for the 'TYPECODE' field.
 DELETEHISTORYTHRESHOLDCODE tinyint   Default = 2 Indicates how much of the process history should be deleted.
 DELETEHISTORYTHRESHOLD nvarchar(35) (Computed) CASE [DELETEHISTORYTHRESHOLDCODE] WHEN 0 THEN N'Do not delete history' WHEN 1 THEN N'Delete history older than one day' WHEN 2 THEN N'Delete history older than one week' WHEN 3 THEN N'Delete history older than one month' END Provides a translation for the 'DELETEHISTORYTHRESHOLDCODE' field.
 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.
 SETSOURCECODETOPROVIDER bit   Default = 1 Indicates whether or not to set the source on currency exchange rates downloaded to the provider's name.

Foreign Key Field Type Null Notes Description
 CURRENCYEXCHANGERATEPROVIDERID uniqueidentifier   CURRENCYEXCHANGERATEPROVIDER.ID The third-party provider from whom the currency exchange rates will be downloaded.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_CURRENCYEXCHANGERATEDOWNLOADPROCESS_DATEADDED DATEADDED    
 IX_CURRENCYEXCHANGERATEDOWNLOADPROCESS_DATECHANGED DATECHANGED      
 PK_CURRENCYEXCHANGERATEDOWNLOADPROCESS ID  
 UC_CURRENCYEXCHANGERATEDOWNLOADPROCESS_NAME NAME    

Trigger Name Description
 TR_CURRENCYEXCHANGERATEDOWNLOADPROCESS_AUDIT_UPDATE
 TR_CURRENCYEXCHANGERATEDOWNLOADPROCESS_AUDIT_DELETE

Referenced by Field
 CURRENCYEXCHANGERATEDOWNLOADPROCESSRATE CURRENCYEXCHANGERATEDOWNLOADPROCESSID
 CURRENCYEXCHANGERATEDOWNLOADPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table