V_QUERY_RECEIVABLECREDIT

Queries the receivable credit objects in the system.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
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:  8/2/2010 7:16:07 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.7.1654.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RECEIVABLECREDIT AS



                select RECEIVABLECREDIT.ID,
                        -- System fields

                        ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION],
                        ADDEDBY.USERNAME as [ADDEDBY_USERNAME],
                        CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION],
                        CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME],
                        dbo.RECEIVABLECREDIT.[DATEADDED],
                        dbo.RECEIVABLECREDIT.[DATECHANGED],
                        dbo.RECEIVABLECREDIT.[TSLONG]
                from dbo.RECEIVABLECREDIT
                    left join dbo.CHANGEAGENT as [ADDEDBY] 
                        on [ADDEDBY].ID = dbo.RECEIVABLECREDIT.[ADDEDBYID]
                    left join dbo.CHANGEAGENT as [CHANGEDBY] 
                        on [CHANGEDBY].ID = dbo.RECEIVABLECREDIT.[CHANGEDBYID]