V_QUERY_REFUND
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| REFUNDID | uniqueidentifier | ||
| TRANSACTIONAMOUNT | money | ||
| TRANSACTIONCURRENCYID | uniqueidentifier | ||
| DATE | date | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/28/2016 5:44:47 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.158.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_REFUND AS
select
PAYMENT.ID as ID,
REFUND.ID as REFUNDID,
REFUND.TRANSACTIONAMOUNT,
REFUND.TRANSACTIONCURRENCYID,
cast(REFUND.[DATE] as date) as [DATE]
from FINANCIALTRANSACTION as REFUND
inner join CREDITPAYMENT on CREDITPAYMENT.CREDITID = REFUND.ID
inner join FINANCIALTRANSACTION as PAYMENT on PAYMENT.ID = CREDITPAYMENT.REVENUEID
where REFUND.TYPECODE = 23