V_QUERY_AUCTIONITEMGAINLOSS
Provides the ability to query gain/loss information for auction items.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| AUCTIONDONATIONID | uniqueidentifier | yes | Auction donation revenue ID |
| GAINLOSS | money | yes | Gain/Loss |
| TRANSACTIONGAINLOSS | money | yes | |
| ORGANIZATIONGAINLOSS | money | yes | |
| BASECURRENCYID | uniqueidentifier | yes | |
| TRANSACTIONCURRENCYID | uniqueidentifier | yes | |
| BASEEXCHANGERATEID | uniqueidentifier | yes | |
| BASETOORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | |
| ORIGINTOORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:44:07 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_AUCTIONITEMGAINLOSS AS
select
AUCTIONITEM.ID,
AUCTIONITEM.REVENUEAUCTIONDONATIONID as AUCTIONDONATIONID,
([PURCHASEPRICES].PURCHASEPRICE - AUCTIONITEM.VALUE) as GAINLOSS,
([PURCHASEPRICES].TRANSACTIONPURCHASEPRICE - AUCTIONITEM.TRANSACTIONVALUE) as TRANSACTIONGAINLOSS,
([PURCHASEPRICES].ORGANIZATIONPURCHASEPRICE - AUCTIONITEM.ORGANIZATIONVALUE) as ORGANIZATIONGAINLOSS,
case
when AUCTIONITEM.TYPECODE = 0 then
AUCTIONITEM.BASECURRENCYID
else
(select top 1 [PACKAGEITEMS].BASECURRENCYID
from
dbo.AUCTIONITEM [PACKAGEITEMS]
where
[PACKAGEITEMS].PACKAGEID = AUCTIONITEM.ID)
end as BASECURRENCYID,
AUCTIONITEM.TRANSACTIONCURRENCYID,
AUCTIONITEM.BASEEXCHANGERATEID,
AUCTIONITEM.BASETOORGANIZATIONEXCHANGERATEID,
AUCTIONITEM.ORIGINTOORGANIZATIONEXCHANGERATEID
from
AUCTIONITEM
join
REVENUE on REVENUE.ID = AUCTIONITEM.REVENUEAUCTIONDONATIONID
outer apply
dbo.UFN_AUCTIONITEM_GETPURCHASEPRICES_INCURRENCY(AUCTIONITEM.ID) [PURCHASEPRICES]