V_QUERY_GIFTINKINDAPPRAISAL
Returns a list of appraisals for a gift-in-kind payment method detail.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| APPRAISERID | uniqueidentifier | yes | Appraiser system ID |
| DATE | date | yes | Date |
| DESCRIPTION | nvarchar(max) | Description | |
| AMOUNT | money | Amount | |
| BASECURRENCYID | uniqueidentifier | yes | Base currency ID |
| ORGANIZATIONAMOUNT | money | Amount (organization currency) | |
| TRANSACTIONAMOUNT | money | Amount (transaction currency) | |
| TRANSACTIONCURRENCYID | uniqueidentifier | yes | Transaction currency ID |
| REVENUEID | uniqueidentifier | Revenue system ID | |
| APPRAISALFEE | money | Appraisal fee | |
| TRANSACTIONAPPRAISALFEE | money | Appraisal fee (transaction currency) | |
| ORGANIZATIONAPPRAISALFEE | money | Appraisal fee (organization currency) |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:28:32 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_GIFTINKINDAPPRAISAL AS
select
GIFTINKINDAPPRAISAL.ID,
GIFTINKINDAPPRAISAL.APPRAISERID,
GIFTINKINDAPPRAISAL.DATE,
GIFTINKINDAPPRAISAL.DESCRIPTION,
GIFTINKINDAPPRAISAL.AMOUNT,
GIFTINKINDAPPRAISAL.BASECURRENCYID,
GIFTINKINDAPPRAISAL.ORGANIZATIONAMOUNT,
GIFTINKINDAPPRAISAL.TRANSACTIONAMOUNT,
GIFTINKINDAPPRAISAL.TRANSACTIONCURRENCYID,
REVENUEPAYMENTMETHOD.REVENUEID,
GIFTINKINDAPPRAISAL.APPRAISALFEE,
GIFTINKINDAPPRAISAL.TRANSACTIONAPPRAISALFEE,
GIFTINKINDAPPRAISAL.ORGANIZATIONAPPRAISALFEE
from dbo.GIFTINKINDAPPRAISAL
inner join dbo.GIFTINKINDPAYMENTMETHODDETAIL on GIFTINKINDAPPRAISAL.GIFTINKINDPAYMENTMETHODDETAILID = GIFTINKINDPAYMENTMETHODDETAIL.ID
inner join dbo.REVENUEPAYMENTMETHOD on GIFTINKINDPAYMENTMETHODDETAIL.ID = REVENUEPAYMENTMETHOD.ID