V_QUERY_INSTALLMENTPLANINSTALLMENTSPLITS

Fields

Field	Field Type	Null
ID	uniqueidentifier
PLANINSTALLMENTID	uniqueidentifier
AMOUNT	money
TRANSACTIONPLANBALANCE	money	yes
AMOUNTAPPLIED	money	yes
WRITEOFFAMOUNT	money	yes
DESIGNATIONID	uniqueidentifier	yes
DESIGNATIONNAME	nvarchar(512)	yes
DATEADDED	datetime
DATECHANGED	datetime
TSLONG	bigint	yes
ADDEDBY_APPLICATION	nvarchar(200)	yes
ADDEDBY_USERNAME	nvarchar(128)	yes
CHANGEDBY_APPLICATION	nvarchar(200)	yes
CHANGEDBY_USERNAME	nvarchar(128)	yes
TRANSACTIONAMOUNT	money
ORGANIZATIONAMOUNT	money
BALANCE	money	yes
REVALUEDORGANIZATIONPLANBALANCE	money	yes
TRANSACTIONCURRENCYID	uniqueidentifier	yes
BASECURRENCYID	uniqueidentifier	yes
BASEEXCHANGERATEID	uniqueidentifier	yes
ORGANIZATIONEXCHANGERATEID	uniqueidentifier	yes

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  3/19/2013 1:37:46 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_INSTALLMENTPLANINSTALLMENTSPLITS AS



                select
                    PLANINSTALLMENTSPLIT.ID,
                    INSTALLMENT.ID PLANINSTALLMENTID,
                    PLANINSTALLMENTSPLIT.AMOUNT,
                    dbo.UFN_INSTALLMENT_GETINSTALLMENTSPLITBALANCE(PLANINSTALLMENTSPLIT.ID) TRANSACTIONPLANBALANCE,
                    dbo.UFN_INSTALLMENT_GETINSTALLMENTSPLITAMOUNTAPPLIED(PLANINSTALLMENTSPLIT.ID) AMOUNTAPPLIED,
                    dbo.UFN_INSTALLMENT_GETINSTALLMENTSPLITWRITEOFFAMOUNT(PLANINSTALLMENTSPLIT.ID) WRITEOFFAMOUNT,
                    DESIGNATION.ID DESIGNATIONID,
                    DESIGNATION.NAME DESIGNATIONNAME,
                    PLANINSTALLMENTSPLIT.DATEADDED,
                    PLANINSTALLMENTSPLIT.DATECHANGED,
                    PLANINSTALLMENTSPLIT.TSLONG,
                    [ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
                    [ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
                    [CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
                    [CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
                    PLANINSTALLMENTSPLIT.TRANSACTIONAMOUNT,
                    PLANINSTALLMENTSPLIT.ORGANIZATIONAMOUNT,
                    (select top 1 BALANCES.BASEBALANCE from dbo.UFN_PLEDGE_GETREVALUEDINSTALLMENTSPLITBALANCES(FINANCIALTRANSACTION.ID, getdate(), 0) BALANCES where BALANCES.ID = PLANINSTALLMENTSPLIT.ID) BALANCE,
                    (select top 1 BALANCES.ORGANIZATIONBALANCE from dbo.UFN_PLEDGE_GETREVALUEDINSTALLMENTSPLITBALANCES(FINANCIALTRANSACTION.ID, getdate(), 0) BALANCES where BALANCES.ID = PLANINSTALLMENTSPLIT.ID) REVALUEDORGANIZATIONPLANBALANCE,
                    PLANINSTALLMENTSPLIT.TRANSACTIONCURRENCYID,
                    PLANINSTALLMENTSPLIT.BASECURRENCYID,
                    PLANINSTALLMENTSPLIT.BASEEXCHANGERATEID,
                    PLANINSTALLMENTSPLIT.ORGANIZATIONEXCHANGERATEID
                    /*#EXTENSION*/ 
                from dbo.INSTALLMENTSPLIT as PLANINSTALLMENTSPLIT
                    inner join dbo.INSTALLMENT
                        on PLANINSTALLMENTSPLIT.INSTALLMENTID = INSTALLMENT.ID
                    inner join dbo.FINANCIALTRANSACTION
                        on INSTALLMENT.REVENUEID = FINANCIALTRANSACTION.ID and FINANCIALTRANSACTION.TYPECODE = 15
                    left outer join
                        dbo.DESIGNATION on DESIGNATION.ID = PLANINSTALLMENTSPLIT.DESIGNATIONID
                    left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = PLANINSTALLMENTSPLIT.ADDEDBYID
                    left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = PLANINSTALLMENTSPLIT.CHANGEDBYID