V_QUERY_REVENUESPLITINFO
Provides the ability to query for details of a revenue split.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| TRANSACTIONPLEDGEBALANCE | money | yes | Pledge balance (transaction currency) |
| PLEDGEBALANCE | money | yes | Pledge balance |
| REVALUEDORGANIZATIONPLEDGEBALANCE | money | yes | Pledge balance (organization currency) |
| TRANSACTIONCURRENCYID | uniqueidentifier | Transaction currency ID | |
| BASECURRENCYID | uniqueidentifier | yes | Base currency ID |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:37:23 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_REVENUESPLITINFO AS
select
REVENUESPLIT.ID,
dbo.UFN_PLEDGE_GETDESIGNATIONBALANCE(REVENUESPLIT.FINANCIALTRANSACTIONID, REVENUESPLIT_EXT.DESIGNATIONID) TRANSACTIONPLEDGEBALANCE,
BALANCES.BASEBALANCE PLEDGEBALANCE,
BALANCES.ORGANIZATIONBALANCE REVALUEDORGANIZATIONPLEDGEBALANCE,
REVENUE.TRANSACTIONCURRENCYID,
isnull(REVENUE_EXT.NONPOSTABLEBASECURRENCYID, V.BASECURRENCYID) as BASECURRENCYID
from dbo.FINANCIALTRANSACTIONLINEITEM REVENUESPLIT
inner join dbo.REVENUESPLIT_EXT on REVENUESPLIT.ID = REVENUESPLIT_EXT.ID
inner join FINANCIALTRANSACTION REVENUE on REVENUESPLIT.FINANCIALTRANSACTIONID=REVENUE.ID
inner join dbo.REVENUE_EXT on REVENUE.ID = REVENUE_EXT.ID
left outer join dbo.V_BASECURRENCYFORFINANCIALTRANSACTION_I V with (noexpand) on REVENUE.ID = V.FINANCIALTRANSACTIONID
cross apply dbo.UFN_PLEDGE_GETREVALUEDSPLITBALANCES(REVENUE.ID, getdate(), 0) BALANCES
where REVENUE.TYPECODE=1
and REVENUESPLIT.DELETEDON is null
and REVENUESPLIT.TYPECODE <> 1
and REVENUE.DELETEDON is null
and BALANCES.ID = REVENUESPLIT.ID