V_QUERY_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY
Query to retrieve revenue function history for recurring gifts.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| REVENUEID | uniqueidentifier | REVENUEID | |
| DEVELOPMENTFUNCTION | nvarchar(100) | yes | Revenue function |
| SEQUENCE | int | Sequence | |
| TRANSACTIONDATE | date | Transaction date | |
| AMOUNT | money | New amount | |
| FREQUENCY | nvarchar(14) | yes | New frequency |
| PREVIOUSAMOUNT | money | Previous amount | |
| PREVIOUSFREQUENCY | nvarchar(14) | yes | Previous frequency |
| AMOUNTCHANGE | money | yes | Amount change |
| SOURCECODE | nvarchar(50) | Source | |
| FINDERNUMBER | bigint | Finder number | |
| APPEALID | uniqueidentifier | yes | APPEALID |
| MAILINGID | uniqueidentifier | yes | MAILINGID |
| CHANNEL | nvarchar(100) | yes | Inbound channel |
| BASECURRENCYID | uniqueidentifier | yes | Base currency ID |
| BASEEXCHANGERATEID | uniqueidentifier | yes | New base exchange rate |
| PREVIOUSBASEEXCHANGERATEID | uniqueidentifier | yes | Previous base exchange rate |
| ORGANIZATIONAMOUNT | money | New amount (organization currency) | |
| PREVIOUSORGANIZATIONAMOUNT | money | Previous amount (organization currency) | |
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | New organization exchange rate |
| PREVIOUSORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | Previous organization exchange rate |
| TRANSACTIONAMOUNT | money | New amount (transaction currency) | |
| PREVIOUSTRANSACTIONAMOUNT | money | Previous amount (transaction currency) | |
| TRANSACTIONCURRENCYID | uniqueidentifier | yes | Transaction currency ID |
| TRANSACTIONAMOUNTCHANGE | money | yes | Amount change (transaction currency) |
| ORGANIZATIONAMOUNTCHANGE | money | yes | Amount change (organization currency) |
| CHANNELCODEID | uniqueidentifier | yes | |
| REVENUEDEVELOPMENTFUNCTIONCODEID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 1/21/2016 5:07:40 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.154.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY AS
select
HISTORY.ID,
HISTORY.FINANCIALTRANSACTIONID as REVENUEID,
REVENUEDEVELOPMENTFUNCTIONCODE.DESCRIPTION as DEVELOPMENTFUNCTION,
1 as SEQUENCE,
HISTORY.DATE as TRANSACTIONDATE,
HISTORY.TRANSACTIONAMOUNT as AMOUNT,
HISTORY.FREQUENCY,
HISTORY.PREVIOUSTRANSACTIONAMOUNT as PREVIOUSAMOUNT,
HISTORY.PREVIOUSFREQUENCY,
HISTORY.TRANSACTIONAMOUNTCHANGE as AMOUNTCHANGE,
HISTORY.SOURCECODE,
HISTORY.FINDERNUMBER,
HISTORY.APPEALID,
HISTORY.MAILINGID,
CHANNELCODE.DESCRIPTION as CHANNEL,
HISTORY.BASECURRENCYID,
HISTORY.BASEEXCHANGERATEID,
HISTORY.PREVIOUSBASEEXCHANGERATEID,
HISTORY.ORGANIZATIONAMOUNT,
HISTORY.PREVIOUSORGANIZATIONAMOUNT,
HISTORY.ORGANIZATIONEXCHANGERATEID,
HISTORY.PREVIOUSORGANIZATIONEXCHANGERATEID,
HISTORY.TRANSACTIONAMOUNT,
HISTORY.PREVIOUSTRANSACTIONAMOUNT,
HISTORY.TRANSACTIONCURRENCYID,
HISTORY.TRANSACTIONAMOUNTCHANGE,
HISTORY.ORGANIZATIONAMOUNTCHANGE,
CHANNELCODE.ID as CHANNELCODEID,
REVENUEDEVELOPMENTFUNCTIONCODE.ID as REVENUEDEVELOPMENTFUNCTIONCODEID
from dbo.RECURRINGGIFTAMENDMENT as HISTORY
left join dbo.REVENUEDEVELOPMENTFUNCTION on REVENUEDEVELOPMENTFUNCTION.ID = HISTORY.REVENUEDEVELOPMENTFUNCTIONID
left join dbo.REVENUEDEVELOPMENTFUNCTIONCODE on REVENUEDEVELOPMENTFUNCTIONCODE.ID = REVENUEDEVELOPMENTFUNCTION.REVENUEDEVELOPMENTFUNCTIONCODEID
left join dbo.CHANNELCODE on CHANNELCODE.ID = HISTORY.CHANNELCODEID