UFN_GIFTFEE_GETGIFTFEESTRUCTURE_2

Returns gift fee structure with currency info.

Return

Return Type
table

Definition

Copy



            CREATE function dbo.UFN_GIFTFEE_GETGIFTFEESTRUCTURE_2()
            returns table
            as
            return
            (
                select
                    ID,
                    FROMAMOUNT,
                    FEE,
                    BASECURRENCYID,
                    ORGANIZATIONFROMAMOUNT,
                    ORGANIZATIONEXCHANGERATEID
                from
                    dbo.GIFTFEESTRUCTURE
            );