V_QUERY_RE7_PLEDGESUMMARY
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PAYMENT_REVENUE_LOCALID | int | ||
| LOCALID | int | ||
| FREQUENCY | nvarchar(18) | yes | |
| STARTDATE | datetime | yes | |
| ENDDATE | datetime | yes | |
| INSTALLMENTCOUNT | int | yes | |
| PAYMENTCOUNT | int | yes | |
| MISSEDCOUNT | int | yes | |
| FUTURECOUNT | int | yes | |
| TOTALPAYMENT | money | yes | |
| BALANCE | money | yes | |
| LASTPAYMENTGIFTDATE | datetime | yes | |
| LASTPAYMENTFREQUENCYDATE | datetime | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/6/2025 8:50:39 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RE7_PLEDGESUMMARY AS
select
[IP].[PAYMENT_REVENUE_LOCALID],
[RI].[LOCALID],
[IFC].[DESCRIPTION] [FREQUENCY],
[RI].[STARTDATE],
[RI].[ENDDATE],
[RI].[INSTALLMENTCOUNT],
[RI].[PAYMENTCOUNT],
[RI].[MISSEDCOUNT],
[RI].[FUTURECOUNT],
[RI].[TOTALPAYMENT],
[RI].[BALANCE],
[RI].[LASTPAYMENTGIFTDATE],
[RI].[LASTPAYMENTFREQUENCYDATE]
from [RE7].[INSTALLMENTPAYMENT] [IP]
inner join [RE7].[REVENUEINSTALLMENT] [RI] on [IP].[PLEDGE_REVENUE_LOCALID] = [RI].[LOCALID]
left join dbo.[RE7_INSTALLMENTFREQUENCYCODE] [IFC] on [RI].[FREQUENCYCODE_LOCALID] = [IFC].[LOCALID];