V_QUERY_CURRENCYEXCHANGERATEBATCHCONTROLREPORT

View used for output for the currency exchange rate batch control report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
FROMCURRENCY	nvarchar(110)	yes	From currency
TOCURRENCY	nvarchar(110)	yes	To currency
RATE	decimal(20, 8)		Rate
ASOFDATE	datetimeoffset		As of
TYPE	nvarchar(9)	yes	Type
SOURCECODE	nvarchar(100)	yes	Source code

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:20:41 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_CURRENCYEXCHANGERATEBATCHCONTROLREPORT AS



                select
                    CURRENCYEXCHANGERATE.ID,
                    dbo.UFN_CURRENCY_GETDESCRIPTION(CURRENCYEXCHANGERATE.FROMCURRENCYID) FROMCURRENCY,
                    dbo.UFN_CURRENCY_GETDESCRIPTION(CURRENCYEXCHANGERATE.TOCURRENCYID) TOCURRENCY,
                    CURRENCYEXCHANGERATE.RATE,
                    CURRENCYEXCHANGERATE.ASOFDATE,
                    CURRENCYEXCHANGERATE.TYPE,
                    CURRENCYEXCHANGERATESOURCECODE.DESCRIPTION as SOURCECODE
                from 
                    dbo.CURRENCYEXCHANGERATE
                    left join dbo.CURRENCYEXCHANGERATESOURCECODE on CURRENCYEXCHANGERATE.SOURCECODEID = CURRENCYEXCHANGERATESOURCECODE.ID