V_QUERY_MKTACKNOWLEDGEMENTEXPORT
Includes acknowledgement fields for use in an export definition.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| RECEIPTNUMBER | nvarchar(20) | yes | Receipt number |
| RECEIPTDATE | datetime | yes | Receipt date |
| LETTER | nvarchar(100) | yes | Letter |
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_MKTACKNOWLEDGEMENTEXPORT AS
select
cast(null as nvarchar(20)) as [RECEIPTNUMBER], /*Placeholder*/
cast(null as datetime) as [RECEIPTDATE], /*Placeholder*/
cast(null as nvarchar(100)) as [LETTER] /*Placeholder*/