UFN_REVENUE_GETGIFTINKINDSALEGLDISTRIBUTION

Gets a table of sold gift-in-kind GL distribution (Actual or Projected).

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@GIFTINKINDSALEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_REVENUE_GETGIFTINKINDSALEGLDISTRIBUTION
            (
                @GIFTINKINDSALEID uniqueidentifier
            )
            returns table
            as
            return

            select
                GIFTINKINDSALEGLDISTRIBUTION.ID
                ,GIFTINKINDSALEGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID
                ,GIFTINKINDSALEGLDISTRIBUTION.TRANSACTIONTYPECODE
                ,GIFTINKINDSALEGLDISTRIBUTION.TRANSACTIONTYPE as DEBITCREDIT
                ,GIFTINKINDSALEGLDISTRIBUTION.ACCOUNT
                ,GIFTINKINDSALEGLDISTRIBUTION.PROJECT
                ,GIFTINKINDSALEGLDISTRIBUTION.AMOUNT
                ,GIFTINKINDSALEGLDISTRIBUTION.REFERENCE
                ,GIFTINKINDSALEGLDISTRIBUTION.GIFTINKINDSALEID
                ,MAP.DESCRIPTION as MAPPINGTYPE
                ,GIFTINKINDSALEGLDISTRIBUTION.ORGANIZATIONAMOUNT
                ,GIFTINKINDSALEGLDISTRIBUTION.BASECURRENCYID
                ,GIFTINKINDSALEGLDISTRIBUTION.TRANSACTIONAMOUNT
                ,GIFTINKINDSALEGLDISTRIBUTION.TRANSACTIONCURRENCYID
                ,GIFTINKINDSALEGLDISTRIBUTION.BASEEXCHANGERATEID
                ,GIFTINKINDSALEGLDISTRIBUTION.ORGANIZATIONEXCHANGERATEID
            from dbo.GIFTINKINDSALEGLDISTRIBUTION
                inner join dbo.GLPAYMENTMETHODREVENUETYPEMAPPING as MAP on GIFTINKINDSALEGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID = MAP.ID
            where (GIFTINKINDSALEID = @GIFTINKINDSALEID)
                and (GIFTINKINDSALEGLDISTRIBUTION.OUTDATED = 0);