V_QUERY_SALESORDERITEMMEMBERSHIPADDON
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| SALESORDERITEMMEMBERSHIPID | uniqueidentifier | yes | |
| ADDONTYPE | nvarchar(17) | yes | |
| DESCRIPTION | nvarchar(255) | ||
| QUANTITY | decimal(20, 4) | ||
| PRICE | money | ||
| TOTAL | money | yes | |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | |
| ADDEDBY_USERNAME | nvarchar(128) | yes | |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | |
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TSLONG | bigint | yes | |
| ADDONID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:19:35 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_SALESORDERITEMMEMBERSHIPADDON AS
select [SALESORDERITEMMEMBERSHIPADDON].[ID],
[SALESORDERITEMMEMBERSHIPADDON].[SALESORDERITEMMEMBERSHIPID],
[SALESORDERITEMMEMBERSHIPADDON].[ADDONTYPE],
[SALESORDERITEM].[DESCRIPTION],
[SALESORDERITEM].[QUANTITY],
[SALESORDERITEM].[PRICE],
[SALESORDERITEM].[TOTAL],
[ADDEDBY].[APPLICATIONNAME] as [ADDEDBY_APPLICATION],
[ADDEDBY].[USERNAME] as [ADDEDBY_USERNAME],
[CHANGEDBY].[APPLICATIONNAME] as [CHANGEDBY_APPLICATION],
[CHANGEDBY].[USERNAME] as [CHANGEDBY_USERNAME],
[SALESORDERITEMMEMBERSHIPADDON].[DATEADDED],
[SALESORDERITEMMEMBERSHIPADDON].[DATECHANGED],
[SALESORDERITEMMEMBERSHIPADDON].[TSLONG],
[SALESORDERITEMMEMBERSHIPADDON].ADDONID
from dbo.[SALESORDERITEMMEMBERSHIPADDON]
inner join dbo.[SALESORDERITEM] on [SALESORDERITEMMEMBERSHIPADDON].[ID] = [SALESORDERITEM].[ID]
left outer join
dbo.[CHANGEAGENT] as [ADDEDBY] on [SALESORDERITEMMEMBERSHIPADDON].[ADDEDBYID] = [ADDEDBY].[ID]
left outer join
dbo.[CHANGEAGENT] as [CHANGEDBY] on [SALESORDERITEMMEMBERSHIPADDON].[CHANGEDBYID] = [CHANGEDBY].[ID]