V_QUERY_RE7_REVENUEINSTALLMENT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| 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: 6/23/2025 4:35:38 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.4000.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RE7_REVENUEINSTALLMENT AS
select
[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 dbo.[RE7_REVENUEINSTALLMENT] [RI]
left outer join dbo.[RE7_INSTALLMENTFREQUENCYCODE] [IFC] on [RI].[FREQUENCYCODE_LOCALID] = [IFC].[LOCALID];