V_QUERY_AUCTIONITEMBATCHCONTROLREPORT
View used for output of the Auction Item Batch Control Report.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| ITEMNAME | nvarchar(100) | Item name | |
| AUCTIONITEMCATEGORY | nvarchar(100) | yes | Category |
| AUCTIONITEMSUBCATEGORY | nvarchar(100) | yes | Subcategory |
| DONOR | nvarchar(154) | yes | Donor |
| DONORLOOKUPID | nvarchar(100) | yes | Donor lookup ID |
| VALUE | money | Value | |
| AUCTION | nvarchar(100) | yes | Auction |
| DONATIONDATE | datetime | yes | Donation date |
| DESIGNATION | nvarchar(512) | yes | DESIGNATION |
| ISOCURRENCYCODE | nvarchar(3) | yes | ISO currency code |
| CURRENCYSYMBOL | nvarchar(5) | yes | Currency symbol |
| SYMBOLDISPLAYSETTINGCODE | tinyint | yes | Symbol display setting code |
| DECIMALDIGITS | tinyint | yes | Decimal digits |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:36:01 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_AUCTIONITEMBATCHCONTROLREPORT AS
select
AUCTIONITEM.ID,
AUCTIONITEM.NAME as [ITEMNAME],
(select NAME from dbo.AUCTIONITEMCATEGORY where AUCTIONITEMCATEGORY.ID = AUCTIONITEM.AUCTIONITEMCATEGORYID) as [AUCTIONITEMCATEGORY],
(select NAME from dbo.AUCTIONITEMSUBCATEGORY where AUCTIONITEMSUBCATEGORY.ID = AUCTIONITEM.AUCTIONITEMSUBCATEGORYID) as [AUCTIONITEMSUBCATEGORY],
CONSTITUENT.NAME as [DONOR],
CONSTITUENT.LOOKUPID as [DONORLOOKUPID],
AUCTIONITEM.TRANSACTIONVALUE as [VALUE],
(select NAME from dbo.EVENT where EVENT.ID = AUCTIONITEM.EVENTAUCTIONID) as [AUCTION],
REVENUE.DATE as [DONATIONDATE],
(
select DESIGNATION.NAME
from dbo.DESIGNATION
where DESIGNATION.ID = (
select top 1 DESIGNATIONID
from dbo.REVENUESPLIT
where REVENUESPLIT.REVENUEID = REVENUE.ID
order by REVENUESPLIT.DATEADDED asc
)
) as [DESIGNATION],
CURRENCYPROPERTIES.ISO4217 as ISOCURRENCYCODE,
CURRENCYPROPERTIES.CURRENCYSYMBOL,
CURRENCYPROPERTIES.SYMBOLDISPLAYSETTINGCODE,
CURRENCYPROPERTIES.DECIMALDIGITS
from dbo.AUCTIONITEM
inner join dbo.REVENUE on REVENUE.ID = AUCTIONITEM.REVENUEAUCTIONDONATIONID
inner join dbo.CONSTITUENT on CONSTITUENT.ID = REVENUE.CONSTITUENTID
outer apply dbo.UFN_CURRENCY_GETPROPERTIES(AUCTIONITEM.TRANSACTIONCURRENCYID) CURRENCYPROPERTIES