V_QUERY_CHARGELINEITEMRESPONSIBILITY

Queries for charge line item responsibility information.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier	yes	System record ID
FINANCIALTRANSACTIONLINEITEMID	uniqueidentifier		Line item ID
CONSTITUENTID	uniqueidentifier	yes	Record ID
PERCENTAGE	decimal(7, 4)	yes	Percentage

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:35:23 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_CHARGELINEITEMRESPONSIBILITY AS



                select
                    CHARGELINEITEMRESPONSIBILITY.ID,
                    FINANCIALTRANSACTIONLINEITEM.ID as FINANCIALTRANSACTIONLINEITEMID,
                    case when CHARGELINEITEMRESPONSIBILITY.CONSTITUENTID is null then
                        FINANCIALTRANSACTION.CONSTITUENTID
                    else
                        CHARGELINEITEMRESPONSIBILITY.CONSTITUENTID
                    end as CONSTITUENTID,
                    case when CHARGELINEITEMRESPONSIBILITY.PERCENTAGE is null then
                        100
                    else
                        CHARGELINEITEMRESPONSIBILITY.PERCENTAGE
                    end as PERCENTAGE
                from dbo.FINANCIALTRANSACTION
                    inner join dbo.FINANCIALTRANSACTIONLINEITEM
                        on (FINANCIALTRANSACTION.ID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID) and
                            (FINANCIALTRANSACTION.TYPECODE = 104)  -- Only charges can do this now

                    left outer join dbo.CHARGELINEITEMRESPONSIBILITY
                        on CHARGELINEITEMRESPONSIBILITY.FINANCIALTRANSACTIONLINEITEMID = FINANCIALTRANSACTIONLINEITEM.ID