V_QUERY_DOCUMENTPRINTINGRULESALESMETHOD

Provides the ability to query sales document printing rule sales methods.

Fields

Field	Field Type	Null	Description
DOCUMENTPRINTINGRULEID	uniqueidentifier		Documentprintingruleid
SALESMETHODID	uniqueidentifier		Salesmethodid
ID	uniqueidentifier		System record ID
DATEADDED	datetime		Date added
DATECHANGED	datetime		Date changed
TSLONG	bigint	yes	Timestamp value
ADDEDBY_APPLICATION	nvarchar(200)		Added by application
ADDEDBY_USERNAME	nvarchar(128)		Added by user name
CHANGEDBY_APPLICATION	nvarchar(200)		Changed by application
CHANGEDBY_USERNAME	nvarchar(128)		Changed by user name

Definition

Copy

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



                select
                    DOCUMENTPRINTINGRULESALESMETHOD.DOCUMENTPRINTINGRULEID,
                    DOCUMENTPRINTINGRULESALESMETHOD.SALESMETHODID,
                    DOCUMENTPRINTINGRULESALESMETHOD.ID,
                    DOCUMENTPRINTINGRULESALESMETHOD.DATEADDED,
                    DOCUMENTPRINTINGRULESALESMETHOD.DATECHANGED,
                    DOCUMENTPRINTINGRULESALESMETHOD.TSLONG,

                    ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
                    ADDEDBY.USERNAME as ADDEDBY_USERNAME,
                    CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
                    CHANGEDBY.USERNAME as CHANGEDBY_USERNAME
                    /*#EXTENSION*/ 
                from
                    dbo.DOCUMENTPRINTINGRULESALESMETHOD
                    inner join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = DOCUMENTPRINTINGRULESALESMETHOD.ADDEDBYID
                    inner join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = DOCUMENTPRINTINGRULESALESMETHOD.CHANGEDBYID