V_QUERY_PLANNEDGIFTADDITIONDESIGNATION
Enables query on planned gift addition designation records.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| PLANNEDGIFTADDITIONID | uniqueidentifier | Planned gift addition ID | |
| DESIGNATIONID | uniqueidentifier | yes | Designation ID |
| AMOUNT | money | Amount | |
| USECODE | nvarchar(100) | yes | Use code |
| CATEGORY | nvarchar(100) | yes | Category |
| DATE | datetime | yes | Date |
| CAMPAIGNID | uniqueidentifier | yes | CAMPAIGNID |
| BASECURRENCYID | uniqueidentifier | yes | Base currency ID |
| BASEEXCHANGERATEID | uniqueidentifier | yes | Base exchange rate |
| ORGANIZATIONAMOUNT | money | Amount (organization currency) | |
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | Organization exchange rate |
| TRANSACTIONAMOUNT | money | Amount (transaction currency) | |
| TRANSACTIONCURRENCYID | uniqueidentifier | yes | Transaction currency ID |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | Changed by application |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | Changed by user name |
| CAMPAIGNSUBPRIORITYID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:45:37 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PLANNEDGIFTADDITIONDESIGNATION AS
select
PLANNEDGIFTADDITIONDESIGNATION.ID,
PLANNEDGIFTADDITIONDESIGNATION.PLANNEDGIFTADDITIONID,
PLANNEDGIFTADDITIONDESIGNATION.DESIGNATIONID,
PLANNEDGIFTADDITIONDESIGNATION.AMOUNT,
dbo.UFN_DESIGNATIONUSECODE_GETDESCRIPTION(PLANNEDGIFTADDITIONDESIGNATION.USECODEID) as USECODE,
dbo.UFN_PLANNEDGIFTDESCATEGORYCODE_GETDESCRIPTION(PLANNEDGIFTADDITIONDESIGNATION.CATEGORYCODEID) as CATEGORY,
PLANNEDGIFTADDITIONDESIGNATION.DATE,
PLANNEDGIFTADDITIONDESIGNATIONCAMPAIGN.CAMPAIGNID,
PLANNEDGIFTADDITIONDESIGNATION.BASECURRENCYID,
PLANNEDGIFTADDITIONDESIGNATION.BASEEXCHANGERATEID,
PLANNEDGIFTADDITIONDESIGNATION.ORGANIZATIONAMOUNT,
PLANNEDGIFTADDITIONDESIGNATION.ORGANIZATIONEXCHANGERATEID,
PLANNEDGIFTADDITIONDESIGNATION.TRANSACTIONAMOUNT,
PLANNEDGIFTADDITIONDESIGNATION.TRANSACTIONCURRENCYID,
PLANNEDGIFTADDITIONDESIGNATION.DATEADDED,
PLANNEDGIFTADDITIONDESIGNATION.DATECHANGED,
PLANNEDGIFTADDITIONDESIGNATION.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
PLANNEDGIFTADDITIONDESIGNATIONCAMPAIGN.CAMPAIGNSUBPRIORITYID
/*#EXTENSION*/
from dbo.PLANNEDGIFTADDITIONDESIGNATION
left join dbo.PLANNEDGIFTADDITIONDESIGNATIONCAMPAIGN on PLANNEDGIFTADDITIONDESIGNATION.ID = PLANNEDGIFTADDITIONDESIGNATIONCAMPAIGN.PLANNEDGIFTADDITIONDESIGNATIONID
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = PLANNEDGIFTADDITIONDESIGNATION.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = PLANNEDGIFTADDITIONDESIGNATION.CHANGEDBYID