V_QUERY_DESIGNATIONLEVELFINANCIALINFOBATCHEXCEPTIONREPORT
View used for output for Designation Level Financial Info Batch Exception Report.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| NAME | nvarchar(100) | yes | Purpose |
| STARTDATE | datetime | Start date | |
| ENDDATE | datetime | End date | |
| BOOKVALUESTART | money | Book value start | |
| BOOKVALUEEND | money | Book value end | |
| MARKETVALUESTART | money | Market value start | |
| MARKETVALUEEND | money | Market value end | |
| TOTALGIFTREVENUE | money | Total gift revenue | |
| TOTALDISBURSEMENTS | money | Total disbursements | |
| PLEDGEBALANCE | money | Pledge balance | |
| BASECURRENCYID | uniqueidentifier | yes | Base currency |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:35:44 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_DESIGNATIONLEVELFINANCIALINFOBATCHEXCEPTIONREPORT AS
select
BATCHDESIGNATIONLEVELFINANCIALINFO.ID,
dbo.UFN_DESIGNATIONLEVEL_GETNAME(BATCHDESIGNATIONLEVELFINANCIALINFO.DESIGNATIONLEVELID) as [NAME],
BATCHDESIGNATIONLEVELFINANCIALINFO.STARTDATE,
BATCHDESIGNATIONLEVELFINANCIALINFO.ENDDATE,
BATCHDESIGNATIONLEVELFINANCIALINFO.BOOKVALUESTART,
BATCHDESIGNATIONLEVELFINANCIALINFO.BOOKVALUEEND,
BATCHDESIGNATIONLEVELFINANCIALINFO.MARKETVALUESTART,
BATCHDESIGNATIONLEVELFINANCIALINFO.MARKETVALUEEND,
BATCHDESIGNATIONLEVELFINANCIALINFO.TOTALGIFTREVENUE,
BATCHDESIGNATIONLEVELFINANCIALINFO.TOTALDISBURSEMENTS,
BATCHDESIGNATIONLEVELFINANCIALINFO.PLEDGEBALANCE,
BATCHDESIGNATIONLEVELFINANCIALINFO.BASECURRENCYID
from dbo.BATCHDESIGNATIONLEVELFINANCIALINFO