V_QUERY_ACKNOWLEDGEMENTSEXPORTROOT
Export definition used with the acknowledgement process.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FINDERNUMBER | nvarchar(20) | yes | Finder number |
| BASECURRENCYID | uniqueidentifier | yes | Base currency ID |
| PROCESSEDDATE | datetime | yes | Process date |
| RECOGNITIONAMOUNT | money | yes | Recognition amount |
| REVENUEID_08BEBCA2_49AF_4451_BB21_8AAA46E96577 | uniqueidentifier | yes | Revenue Marketing |
| DONORID_08BEBCA2_49AF_4451_BB21_8AAA46E96577 | uniqueidentifier | yes | Constituent Marketing Information |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:33:27 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_ACKNOWLEDGEMENTSEXPORTROOT AS
select
cast('' as nvarchar(20)) as [FINDERNUMBER]
,cast(null as uniqueidentifier) as [BASECURRENCYID]
,cast(null as datetime) as [PROCESSEDDATE]
,cast(null as money) as [RECOGNITIONAMOUNT]
,cast(null as uniqueidentifier) as [REVENUEID_08BEBCA2_49AF_4451_BB21_8AAA46E96577]
,cast(null as uniqueidentifier) as [DONORID_08BEBCA2_49AF_4451_BB21_8AAA46E96577]