V_QUERY_WRITEOFFGLDISTRIBUTION

Provides the ability to query write-off GL distribution information.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		Write-off GL Distribution ID
WRITEOFFID	uniqueidentifier		Write-off ID
TRANSACTIONTYPE	nvarchar(6)	yes	Transaction type
ACCOUNT	nvarchar(100)		Account
PROJECT	nvarchar(100)		Project
AMOUNT	money		Amount
BASECURRENCYID	uniqueidentifier	yes	Base currency ID
BASEEXCHANGERATEID	uniqueidentifier	yes	Base exchange rate
ORGANIZATIONAMOUNT	money		Amount (organization currency)
ORGANIZATIONEXCHANGERATEID	uniqueidentifier	yes	Organization exchange rate
TRANSACTIONAMOUNT	money		Amount (transaction currency)
TRANSACTIONCURRENCYID	uniqueidentifier	yes	Transaction currency ID

Definition

Copy

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





                select 
                    WRITEOFFGLDISTRIBUTION.ID, 
                    WRITEOFFGLDISTRIBUTION.WRITEOFFID, 
                    WRITEOFFGLDISTRIBUTION.TRANSACTIONTYPE, 
                    WRITEOFFGLDISTRIBUTION.ACCOUNT, 
                    WRITEOFFGLDISTRIBUTION.PROJECT, 
                    WRITEOFFGLDISTRIBUTION.AMOUNT,
                    WRITEOFFGLDISTRIBUTION.BASECURRENCYID,
                    WRITEOFFGLDISTRIBUTION.BASEEXCHANGERATEID,
                    WRITEOFFGLDISTRIBUTION.ORGANIZATIONAMOUNT,
                    WRITEOFFGLDISTRIBUTION.ORGANIZATIONEXCHANGERATEID,
                    WRITEOFFGLDISTRIBUTION.TRANSACTIONAMOUNT,
                    WRITEOFFGLDISTRIBUTION.TRANSACTIONCURRENCYID
                from dbo.WRITEOFFGLDISTRIBUTION
                where OUTDATED = 0;