V_QUERY_REFUNDS
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| CONSTITUENTID | uniqueidentifier | yes | |
| SALESORDERID | uniqueidentifier | yes | |
| APPUSERID | uniqueidentifier | yes | |
| TRANSACTIONDATE | date | yes | |
| TRANSACTIONTIME | time | yes | |
| AMOUNT | money | ||
| COMMENT | nvarchar(700) | ||
| CREDITREASON | nvarchar(100) | 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:11:59 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_REFUNDS AS
select
FT.ID,
FT.CONSTITUENTID,
isnull(SALESORDER.ID, EXT.SALESORDERID) as SALESORDERID,
FT.APPUSERID,
FT.CALCULATEDDATE as TRANSACTIONDATE,
cast(FT.DATE as time) as TRANSACTIONTIME,
FT.TRANSACTIONAMOUNT as AMOUNT,
FT.DESCRIPTION as COMMENT,
CREDITREASONCODE.DESCRIPTION as CREDITREASON,
[ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
[ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
[CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
[CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
FT.DATEADDED,
FT.DATECHANGED,
FT.TSLONG
from
dbo.FINANCIALTRANSACTION as FT
inner join
dbo.CREDIT_EXT as EXT on EXT.ID = FT.ID
left outer join
dbo.SALESORDER on SALESORDER.REVENUEID = FT.PARENTID
left outer join
dbo.CREDITREASONCODE on CREDITREASONCODE.ID = EXT.CREDITREASONCODEID
left join
dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = FT.ADDEDBYID
left join
dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = FT.CHANGEDBYID