V_QUERY_REFUNDPAYMENT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| CREDITID | uniqueidentifier | ||
| ADDRESSID | uniqueidentifier | yes | |
| AMOUNT | money | ||
| PAYMENTMETHOD | nvarchar(14) | yes | |
| OTHERPAYMENTMETHOD | nvarchar(100) | yes | |
| DESCRIPTION | nvarchar(1000) | ||
| REFUNDPROCESSED | bit | ||
| STATUS | nvarchar(255) | ||
| SETTLEMENTTYPE | nvarchar(14) | yes | |
| SETTLEMENTDATE | datetime | yes | |
| DEPOSITED | bit | ||
| CHECKDATE | char(8) | yes | |
| CHECKNUMBER | nvarchar(20) | yes | |
| NOTES | nvarchar(255) | 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:12 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_REFUNDPAYMENT AS
select
CREDITPAYMENT.ID,
CREDITPAYMENT.CREDITID,
CREDITPAYMENTCHECKPAYMENTMETHODDETAIL.ADDRESSID,
CREDITPAYMENT.AMOUNT,
CREDITPAYMENT.PAYMENTMETHOD,
OTHERPAYMENTMETHODCODE.DESCRIPTION OTHERPAYMENTMETHOD,
CREDITPAYMENT.DESCRIPTION,
CREDITPAYMENT.REFUNDPROCESSED,
CREDITPAYMENT.STATUS,
CREDITPAYMENT.SETTLEMENTTYPE,
CREDITPAYMENT.SETTLEMENTDATE,
CREDITPAYMENT.DEPOSITED,
case CREDITPAYMENT.PAYMENTMETHODCODE
when 1 then CREDITPAYMENTCHECKPAYMENTMETHODDETAIL.CHECKDATE
else null
end as CHECKDATE,
case CREDITPAYMENT.PAYMENTMETHODCODE
when 1 then CREDITPAYMENTCHECKPAYMENTMETHODDETAIL.CHECKNUMBER
else null
end as CHECKNUMBER,
CREDITPAYMENTCHECKPAYMENTMETHODDETAIL.NOTES,
[ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
[ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
[CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
[CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
CREDITPAYMENT.DATEADDED,
CREDITPAYMENT.DATECHANGED,
CREDITPAYMENT.TSLONG
from dbo.CREDITPAYMENT
inner join dbo.CREDIT_EXT
on CREDITPAYMENT.CREDITID = CREDIT_EXT.ID
left outer join dbo.OTHERPAYMENTMETHODCODE
on CREDITPAYMENT.OTHERPAYMENTMETHODCODEID = OTHERPAYMENTMETHODCODE.ID
left outer join dbo.CREDITPAYMENTCHECKPAYMENTMETHODDETAIL
on CREDITPAYMENT.ID = CREDITPAYMENTCHECKPAYMENTMETHODDETAIL.ID
left join dbo.CHANGEAGENT as [ADDEDBY]
on CREDITPAYMENT.ADDEDBYID = [ADDEDBY].ID
left join dbo.CHANGEAGENT as [CHANGEDBY]
on CREDITPAYMENT.CHANGEDBYID = [CHANGEDBY].ID