V_QUERY_BBNCDONATIONBATCHCONTROLREPORT

View used for output by the Blackbaud Internet Solutions Donation Transaction Batch Control Report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
CONSTITUENTNAME	nvarchar(154)	yes	Constituent name
AMOUNT	money		Amount
ISO4217	nvarchar(3)		ISO4217
DECIMALDIGITS	tinyint		Decimal Digits
CURRENCYSYMBOL	nvarchar(5)		Currency Symbol
SYMBOLDISPLAYSETTINGCODE	tinyint		Symbol Display Setting Code

Definition

Copy

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



                select 
                    REVENUE.ID,
                    CONSTITUENT_NF.NAME as CONSTITUENTNAME,
                    REVENUE.TRANSACTIONAMOUNT as AMOUNT,
          CURRENCY.ISO4217,
                    CURRENCY.DECIMALDIGITS,
                    CURRENCY.CURRENCYSYMBOL,
                    CURRENCY.SYMBOLDISPLAYSETTINGCODE 
                from 
                    dbo.REVENUE
          inner join dbo.CURRENCY on REVENUE.TRANSACTIONCURRENCYID = CURRENCY.ID
          outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(REVENUE.CONSTITUENTID) CONSTITUENT_NF