Open topic with navigation

CURRENCYEXCHANGERATEDOWNLOADPROCESS (4.0SP17)

no changes

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

Stores information pertaining to a currency exchange rate download process parameter set.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

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

Fields
Field	Field Type	Null	Notes	Description
NAME	nvarchar(100)	false	''	The name of this currency exchange rate download process.
DESCRIPTION	nvarchar(4000)	false	''	A description of this currency exchange rate download process.
PROVIDERAUTHENTICATION	nvarchar(4000)	false	''	Any information, such as a username or password, required to authenticate the call to the currency exchange rate provider's service.
PROVIDERPARAMETERS	xml	true		Any provider-specific parameters indicating how the currency exchange rate provider's service should be accessed.
TYPECODE	tinyint	false	0	The type to assign to the currency exchange rates downloaded.
TYPE	nvarchar(9) (Computed)	true		Provides a translation for the 'TYPECODE' field.
DELETEHISTORYTHRESHOLDCODE	tinyint	false	2	Indicates how much of the process history should be deleted.
DELETEHISTORYTHRESHOLD	nvarchar(35) (Computed)	true		Provides a translation for the 'DELETEHISTORYTHRESHOLDCODE' field.
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
SETSOURCECODETOPROVIDER	bit	false	1	Indicates whether or not to set the source on currency exchange rates downloaded to the provider's name.

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

Triggers
Trigger Name	Description
TR_CURRENCYEXCHANGERATEDOWNLOADPROCESS_AUDIT_UPDATE
TR_CURRENCYEXCHANGERATEDOWNLOADPROCESS_AUDIT_DELETE

Referenced by
Referenced by	Field
CURRENCYEXCHANGERATEDOWNLOADPROCESSRATE	CURRENCYEXCHANGERATEDOWNLOADPROCESSID
CURRENCYEXCHANGERATEDOWNLOADPROCESSSTATUS	PARAMETERSETID