V_QUERY_RERECEIPTHISTORY
Provides ability to query the re-receipt history
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| REVENUEID | uniqueidentifier | REVENUEID | |
| CODE | nvarchar(10) | Reason code | |
| DESCRIPTION | nvarchar(50) | Reason code description | |
| DETAILS | nvarchar(300) | Re-receipt details | |
| NEWNUMBERONRERECEIPT | bit | New number on re-receipt | |
| UNIQUERECEIPTNUMBER | nvarchar(20) | yes | Unique receipt number |
| RECEIPTDATE | datetime | yes | Re-receipt date |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:11:39 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RERECEIPTHISTORY AS
select
RD.ID,
RR.REVENUEID,
RC.CODE,
RC.DESCRIPTION,
RD.DETAILS,
RD.NEWNUMBERONRERECEIPT,
RR.UNIQUERECEIPTNUMBER,
RR.RECEIPTDATE
from dbo.REVENUERECEIPTRERECEIPTDETAIL RD
inner join dbo.RERECEIPTREASONCODE RC on RD.RERECEIPTREASONCODEID = RC.ID
inner join dbo.REVENUERECEIPT RR on RR.ID = RD.REVENUERECEIPTID