USP_DATALIST_GIFTINKINDSALESBYTRANSACTION

Returns a list of gift-in-kind sales for a transaction.

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_GIFTINKINDSALESBYTRANSACTION
(
    @REVENUEID uniqueidentifier
)
as
    set nocount on;

select
    GIFTINKINDSALE.ID,
    GIFTINKINDSALE.SALEDATE as [DATE],
    GIFTINKINDSALE.SALEAMOUNT as [AMOUNT],
    GIFTINKINDSALE.TRANSACTIONSALEAMOUNT as [TRANSACTIONAMOUNT],
    GIFTINKINDSALE.SALEAMOUNT as [BASEAMOUNT],
    GIFTINKINDSALE.ORGANIZATIONSALEAMOUNT as [ORGANIZATIONAMOUNT],
    GIFTINKINDSALE.SALEPOSTSTATUSCODE,
    case when exists (    select 1 from dbo.GIFTINKINDSALEADJUSTMENT
                        where GIFTINKINDSALEID = GIFTINKINDSALE.ID and 
                        GIFTINKINDSALEADJUSTMENT.POSTSTATUSCODE = 1) then 1
         else 0
    end HASUNPOSTEDADJUSTMENTS,
    GIFTINKINDSALE.TRANSACTIONCURRENCYID,
    GIFTINKINDSALE.BASECURRENCYID,
    dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY() ORGANIZATIONCURRENCYID,
    case
        when (    select top 1 POSTSTATUSCODE
                from dbo.GIFTINKINDSALEADJUSTMENT
                where GIFTINKINDSALEID = GIFTINKINDSALE.ID
                order by GIFTINKINDSALEADJUSTMENT.DATEADDED desc) = 2 then cast(1 as bit)
        else cast(0 as bit)
    end HASDONOTPOSTADJUSTMENT
from dbo.REVENUEPAYMENTMETHOD
    inner join dbo.GIFTINKINDPAYMENTMETHODDETAIL on REVENUEPAYMENTMETHOD.ID = GIFTINKINDPAYMENTMETHODDETAIL.ID
    inner join dbo.GIFTINKINDSALE on GIFTINKINDPAYMENTMETHODDETAIL.ID = GIFTINKINDSALE.GIFTINKINDPAYMENTMETHODDETAILID
where REVENUEPAYMENTMETHOD.REVENUEID = @REVENUEID
order by GIFTINKINDSALE.SALEDATE;