V_QUERY_PLANNEDGIFTADDITIONASSET
Enables query on planned gift addition asset records.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| PLANNEDGIFTADDITIONID | uniqueidentifier | Planned gift addition ID | |
| ASSETTYPE | nvarchar(100) | yes | Asset type |
| DESCRIPTION | nvarchar(1000) | Description | |
| VALUE | money | Value | |
| COSTBASIS | money | Cost basis | |
| ASSETVALUATIONMETHOD | nvarchar(100) | yes | Valuation method |
| VALUATIONSOURCE | nvarchar(200) | Valuation source | |
| ADDRESSID | uniqueidentifier | yes | Address ID |
| BASECURRENCYID | uniqueidentifier | yes | Base currency ID |
| BASEEXCHANGERATEID | uniqueidentifier | yes | Base exchange rate |
| ORGANIZATIONVALUE | money | Value (organization currency) | |
| ORGANIZATIONCOSTBASIS | money | Cost basis (organization currency) | |
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | Organization exchange rate |
| TRANSACTIONVALUE | money | Value (transaction currency) | |
| TRANSACTIONCOSTBASIS | money | Cost basis (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 |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:38:24 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PLANNEDGIFTADDITIONASSET AS
select
PLANNEDGIFTADDITIONASSET.ID,
PLANNEDGIFTADDITIONASSET.PLANNEDGIFTADDITIONID,
dbo.UFN_ASSETTYPECODE_GETDESCRIPTION(PLANNEDGIFTADDITIONASSET.ASSETTYPECODEID) ASSETTYPE,
PLANNEDGIFTADDITIONASSET.DESCRIPTION,
PLANNEDGIFTADDITIONASSET.VALUE,
PLANNEDGIFTADDITIONASSET.COSTBASIS,
dbo.UFN_ASSETVALUATIONMETHODCODE_GETDESCRIPTION(PLANNEDGIFTADDITIONASSET.ASSETVALUATIONMETHODCODEID) ASSETVALUATIONMETHOD,
PLANNEDGIFTADDITIONASSET.VALUATIONSOURCE,
PLANNEDGIFTADDITIONASSET.ADDRESSID,
PLANNEDGIFTADDITIONASSET.BASECURRENCYID,
PLANNEDGIFTADDITIONASSET.BASEEXCHANGERATEID,
PLANNEDGIFTADDITIONASSET.ORGANIZATIONVALUE,
PLANNEDGIFTADDITIONASSET.ORGANIZATIONCOSTBASIS,
PLANNEDGIFTADDITIONASSET.ORGANIZATIONEXCHANGERATEID,
PLANNEDGIFTADDITIONASSET.TRANSACTIONVALUE,
PLANNEDGIFTADDITIONASSET.TRANSACTIONCOSTBASIS,
PLANNEDGIFTADDITIONASSET.TRANSACTIONCURRENCYID,
PLANNEDGIFTADDITIONASSET.DATEADDED,
PLANNEDGIFTADDITIONASSET.DATECHANGED,
PLANNEDGIFTADDITIONASSET.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME
/*#EXTENSION*/
from dbo.PLANNEDGIFTADDITIONASSET
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = PLANNEDGIFTADDITIONASSET.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = PLANNEDGIFTADDITIONASSET.CHANGEDBYID