V_QUERY_APPLICATION

Queries information about applications.

Fields

Field Field Type Null Description
ID uniqueidentifier System record ID
FINANCIALTRANSACTIONID uniqueidentifier Billing transaction ID
LINKEDFINANCIALTRANSACTIONID uniqueidentifier Linked billing transaction ID
AMOUNT money Amount applied
DATEAPPLIED datetimeoffset Date applied
ADDEDBY_APPLICATION nvarchar(200) yes Added by application
ADDEDBY_USERNAME nvarchar(128) yes Added by user name
CHANGEDBY_APPLICATION nvarchar(200) yes Changed by application
CHANGEDBY_USERNAME nvarchar(128) yes Changed by user name
DATEADDED datetime Date added
DATECHANGED datetime Date changed
TSLONG bigint yes Timestamp value

Definition

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



                select
                    FINANCIALTRANSACTIONLINEITEM.ID,
                    FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID,
                    FINANCIALTRANSACTION_TARGETORSOURCE.ID as LINKEDFINANCIALTRANSACTIONID,
                    FINANCIALTRANSACTIONLINEITEM_APPLICATION.TRANSACTIONAMOUNT as AMOUNT,
                    case when (FINANCIALTRANSACTION.DATE > FINANCIALTRANSACTION_TARGETORSOURCE.DATE) then
                        FINANCIALTRANSACTION.DATE
                    else
                        FINANCIALTRANSACTION_TARGETORSOURCE.DATE
                    end as DATEAPPLIED,

                    -- System fields

                    ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION],
                    ADDEDBY.USERNAME as [ADDEDBY_USERNAME],
                    CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION],
                    CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME],
                    dbo.FINANCIALTRANSACTIONLINEITEM.[DATEADDED],
                    dbo.FINANCIALTRANSACTIONLINEITEM.[DATECHANGED],
                    dbo.FINANCIALTRANSACTIONLINEITEM.[TSLONG]
                from dbo.FINANCIALTRANSACTION
                    inner join dbo.FINANCIALTRANSACTIONLINEITEM
                        on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
                    inner join dbo.FINANCIALTRANSACTIONLINEITEM as FINANCIALTRANSACTIONLINEITEM_APPLICATION
                        on ((FINANCIALTRANSACTION.TYPECODE = 104) and (FINANCIALTRANSACTIONLINEITEM_APPLICATION.TARGETLINEITEMID = FINANCIALTRANSACTIONLINEITEM.ID)) or 
                           ((FINANCIALTRANSACTION.TYPECODE in (105, 106)) and (FINANCIALTRANSACTIONLINEITEM_APPLICATION.SOURCELINEITEMID = FINANCIALTRANSACTIONLINEITEM.ID))                    
                    inner join dbo.FINANCIALTRANSACTIONLINEITEM as FINANCIALTRANSACTIONLINEITEM_TARGETORSOURCE
                        on ((FINANCIALTRANSACTION.TYPECODE = 104) and (FINANCIALTRANSACTIONLINEITEM_APPLICATION.SOURCELINEITEMID = FINANCIALTRANSACTIONLINEITEM_TARGETORSOURCE.ID)) or
                           ((FINANCIALTRANSACTION.TYPECODE in (105, 106)) and (FINANCIALTRANSACTIONLINEITEM_APPLICATION.TARGETLINEITEMID = FINANCIALTRANSACTIONLINEITEM_TARGETORSOURCE.ID))
                    inner join dbo.FINANCIALTRANSACTION as FINANCIALTRANSACTION_TARGETORSOURCE
                        on FINANCIALTRANSACTIONLINEITEM_TARGETORSOURCE.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION_TARGETORSOURCE.ID
                    left join dbo.CHANGEAGENT as [ADDEDBY] 
                        on [ADDEDBY].ID = FINANCIALTRANSACTIONLINEITEM_APPLICATION.[ADDEDBYID]
                    left join dbo.CHANGEAGENT as [CHANGEDBY] 
                        on [CHANGEDBY].ID = FINANCIALTRANSACTIONLINEITEM_APPLICATION.[CHANGEDBYID]
                where (FINANCIALTRANSACTIONLINEITEM.DELETEDON is null) and
                        (FINANCIALTRANSACTIONLINEITEM_APPLICATION.DELETEDON is null)