V_QUERY_MKTACKNOWLEDGEMENTMAILINGEXPORTROOT
Export definitions used with marketing acknowledgement exports are based on this query view.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FINDERNUMBER | nvarchar(20) | yes | Finder number |
| UNIFIEDSEGMENTATIONSEGMENTID | uniqueidentifier | yes | Unified marketing effort segment ID |
| SOURCECODE | nvarchar(50) | yes | Source code |
| APPEALSYSTEMID | nvarchar(36) | yes | Appeal system ID |
| APPEALID | nvarchar(100) | yes | Appeal ID |
| APPEALDESCRIPTION | nvarchar(255) | yes | Appeal description |
| ASKLADDERENTRYAMOUNT | money | yes | Entry amount |
| ASKLADDERNAME | nvarchar(100) | yes | Ask ladder |
| ASKLADDERASK1 | money | yes | Ask 1 |
| ASKLADDERASK2 | money | yes | Ask 2 |
| ASKLADDERASK3 | money | yes | Ask 3 |
| ASKLADDERASK4 | money | yes | Ask 4 |
| ASKLADDERASK5 | money | yes | Ask 5 |
| ASKLADDERWRITEINPROMPT | nvarchar(255) | yes | Write in prompt |
| RECEIPTNUMBER | nvarchar(20) | yes | Receipt number |
| RECEIPTDATE | datetime | yes | Receipt date |
| LETTER | nvarchar(100) | yes | Letter |
| BASECURRENCYID | uniqueidentifier | yes | Base currency ID |
| REVENUEID_EB67DCAC_60B8_4D81_BA86_C2C08C96CC1D | int | yes | |
| DONORID_EB67DCAC_60B8_4D81_BA86_C2C08C96CC1D | int | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/6/2025 8:51:00 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MKTACKNOWLEDGEMENTMAILINGEXPORTROOT AS
select
cast('' as nvarchar(20)) as [FINDERNUMBER],
cast(null as uniqueidentifier) as [UNIFIEDSEGMENTATIONSEGMENTID],
cast('' as nvarchar(50)) as [SOURCECODE],
cast('' as nvarchar(36)) as [APPEALSYSTEMID],
cast('' as nvarchar(100)) as [APPEALID],
cast('' as nvarchar(255)) as [APPEALDESCRIPTION],
cast(0 as money) as [ASKLADDERENTRYAMOUNT],
cast('' as nvarchar(100)) as [ASKLADDERNAME],
cast(0 as money) as [ASKLADDERASK1],
cast(0 as money) as [ASKLADDERASK2],
cast(0 as money) as [ASKLADDERASK3],
cast(0 as money) as [ASKLADDERASK4],
cast(0 as money) as [ASKLADDERASK5],
cast('' as nvarchar(255)) as [ASKLADDERWRITEINPROMPT],
cast('' as nvarchar(20)) as [RECEIPTNUMBER],
cast(null as datetime) as [RECEIPTDATE],
cast('' as nvarchar(100)) as [LETTER],
cast(null as uniqueidentifier) as [BASECURRENCYID]
,cast(null as int) as [REVENUEID_EB67DCAC_60B8_4D81_BA86_C2C08C96CC1D]
,cast(null as int) as [DONORID_EB67DCAC_60B8_4D81_BA86_C2C08C96CC1D]