V_QUERY_UNREALIZEDGAINLOSSGLDISTRIBUTION

Provides the ability to query on a revenue's unrealized gain/loss GL distributions.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		Unrealized Gain/Loss GL Distribution ID
REVENUEID	uniqueidentifier	yes	Revenue system ID
TRANSACTIONTYPE	nvarchar(6)	yes	Transaction type
ACCOUNT	nvarchar(100)		Account
PROJECT	nvarchar(100)		Project
AMOUNT	money		Amount
BASECURRENCYID	uniqueidentifier	yes	Base currency ID
ORGANIZATIONAMOUNT	money		Amount (organization currency)

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  11/30/2010 11:34:45 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.8.2022.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_UNREALIZEDGAINLOSSGLDISTRIBUTION AS




                select 
                    UNREALIZEDGAINLOSSGLDISTRIBUTION.ID, 
                    UNREALIZEDGAINLOSSGLDISTRIBUTION.REVENUEID, 
                    UNREALIZEDGAINLOSSGLDISTRIBUTION.TRANSACTIONTYPE, 
                    UNREALIZEDGAINLOSSGLDISTRIBUTION.ACCOUNT, 
                    UNREALIZEDGAINLOSSGLDISTRIBUTION.PROJECT, 
                    UNREALIZEDGAINLOSSGLDISTRIBUTION.AMOUNT,
                    UNREALIZEDGAINLOSSGLDISTRIBUTION.BASECURRENCYID,
                    UNREALIZEDGAINLOSSGLDISTRIBUTION.ORGANIZATIONAMOUNT
                from dbo.UNREALIZEDGAINLOSSGLDISTRIBUTION 
                where OUTDATED = 0;