V_QUERY_CREDITCARDPROCESSINGREJECTIONEXPORTROOT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | int | yes | |
| PAYMENTID | uniqueidentifier | yes | |
| PROCESSDATE | datetime | yes | |
| ATTEMPTS | tinyint | yes | |
| ISPERMANENTREJECTION | bit | yes | |
| MESSAGE | nvarchar(500) | yes | |
| TRANSACTIONAMOUNTAPPLIED | money | yes | |
| TRANSACTIONCURRENCYID | uniqueidentifier | yes | |
| COMMITMENTID | uniqueidentifier | yes | |
| CONSTITUENTID | uniqueidentifier | yes | |
| PARTIALCREDITCARDNUMBER | nvarchar(4) | yes | |
| CARDHOLDERNAME | nvarchar(255) | yes | |
| CREDITTYPE | nvarchar(100) | yes | |
| EXPIRESON | char(8) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:23:53 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_CREDITCARDPROCESSINGREJECTIONEXPORTROOT AS
select
cast(null as int) as [ID],
cast(null as uniqueidentifier) as [PAYMENTID],
cast(null as datetime) as [PROCESSDATE],
cast(null as tinyint) as [ATTEMPTS],
cast(null as bit) as [ISPERMANENTREJECTION],
cast('' as nvarchar(500)) as [MESSAGE],
cast(null as money) as [TRANSACTIONAMOUNTAPPLIED],
cast(null as uniqueidentifier) as [TRANSACTIONCURRENCYID],
cast(null as uniqueidentifier) as [COMMITMENTID],
cast(null as uniqueidentifier) as [CONSTITUENTID],
cast('' as nvarchar(4)) as [PARTIALCREDITCARDNUMBER],
cast('' as nvarchar(255)) as [CARDHOLDERNAME],
cast('' as nvarchar(100)) as [CREDITTYPE],
cast('' as char(8)) as [EXPIRESON]