USP_DATALIST_TAXRATEFORGIFTAID
Returns a list of all Gift Aid tax rates
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_TAXRATEFORGIFTAID
(
@CURRENTAPPUSERID uniqueidentifier = null
)
as
set nocount on;
select
GIFTAIDTAXRATE.ID,
GIFTAIDTAXRATE.RATE,
GIFTAIDTAXRATE.TRANSITIONALRATE,
GIFTAIDTAXRATE.EFFECTIVEDATE
from
dbo.GIFTAIDTAXRATE
order by
GIFTAIDTAXRATE.EFFECTIVEDATE