V_QUERY_REFUNDEDITEMS
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| CREDITID | uniqueidentifier | ||
| SALESORDERITEMID | uniqueidentifier | yes | |
| REVENUESPLITID | uniqueidentifier | yes | |
| GROUPID | uniqueidentifier | yes | |
| TYPE | nvarchar(40) | yes | |
| PRICE | money | ||
| FEES | money | ||
| QUANTITY | decimal(20, 4) | ||
| DISCOUNTS | money | ||
| DESCRIPTION | nvarchar(700) | ||
| TOTAL | decimal(38, 6) | 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 |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:09:11 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_REFUNDEDITEMS AS
select
LI.ID,
FT.ID as CREDITID,
EXT.SALESORDERITEMID,
LI.SOURCELINEITEMID as REVENUESPLITID,
EXT.GROUPID, -- RegistrantID for event registrations
EXT.TYPE,
LI.UNITVALUE as PRICE,
EXT.FEES,
LI.QUANTITY,
EXT.DISCOUNTS,
LI.DESCRIPTION,
((LI.QUANTITY * LI.UNITVALUE) - EXT.DISCOUNTS) as TOTAL,
[ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
[ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
[CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
[CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
LI.DATEADDED,
LI.DATECHANGED,
LI.TSLONG
from
dbo.FINANCIALTRANSACTION as FT
inner join
dbo.FINANCIALTRANSACTIONLINEITEM as LI on LI.FINANCIALTRANSACTIONID = FT.ID
inner join
dbo.CREDITITEM_EXT as EXT on EXT.ID = LI.ID
left join
dbo.CHANGEAGENT as [ADDEDBY] on LI.ADDEDBYID = [ADDEDBY].ID
left join
dbo.CHANGEAGENT as [CHANGEDBY] on LI.CHANGEDBYID = [CHANGEDBY].ID
where
FT.TYPECODE = 23 -- Refund
and not EXT.TYPECODE in (8,9,10); -- Exclude Group sales items, except Security deposit (12)