V_QUERY_BILLINGITEM

Allows the user to query for information about billing items.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
NAME	nvarchar(100)		Name
DESCRIPTION	nvarchar(255)		Description
ISINACTIVE	bit		Inactive
PRICETYPE	nvarchar(19)	yes	Type

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/2/2010 7:10:23 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.7.1654.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_BILLINGITEM AS



                select
                    BILLINGITEM.ID,
                    PRODUCT.NAME,
                    PRODUCT.DESCRIPTION,
                    BILLINGITEM.ISINACTIVE,
                    BILLINGITEM.PRICETYPE
                from dbo.PRODUCT
                    inner join dbo.BILLINGITEM
                        on PRODUCT.ID = BILLINGITEM.ID