V_QUERY_CREDITCARDUPDATES
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| STATUS | nvarchar(11) | yes | |
| ACTION | nvarchar(20) | yes | |
| DATEPROCESSED | datetime | ||
| OLDLASTFOUR | nvarchar(4) | ||
| NEWLASTFOUR | nvarchar(4) | ||
| OLDEXPIRY | UDT_FUZZYDATE | ||
| NEWEXPIRY | UDT_FUZZYDATE | ||
| REVENUEID | uniqueidentifier | ||
| CONSTITUENTID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/29/2016 3:35:09 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.163.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_CREDITCARDUPDATES AS
select
CCU.ID,
CCU.STATUS,
CCU.ACTION,
CCU.DATEPROCESSED,
CCU.OLDLASTFOUR,
CCU.NEWLASTFOUR,
CCU.OLDEXPIRY,
CCU.NEWEXPIRY,
FT.ID as REVENUEID,
FT.CONSTITUENTID
from
dbo.CREDITCARDUPDATE CCU
inner join dbo.CREDITCARD CC on CC.ID = CCU.CREDITCARDID
inner join dbo.REVENUESCHEDULE RS on RS.CREDITCARDID = CC.ID
inner join dbo.FINANCIALTRANSACTION FT on FT.ID = RS.ID
inner join dbo.CONSTITUENT C on C.ID = FT.CONSTITUENTID