USP_DATALIST_DISCOUNTTAX
Lists taxes assigned to a discount.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DISCOUNTID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
create procedure dbo.USP_DATALIST_DISCOUNTTAX
(
@DISCOUNTID uniqueidentifier
)
as
set nocount on;
select
DISCOUNTTAX.ID,
TAX.NAME,
TAX.TOTALTAX,
TAX.ISACTIVE,
TAX.[DESCRIPTION]
from
dbo.DISCOUNTTAX
left join
dbo.TAX on DISCOUNTTAX.TAXID = TAX.ID
where
DISCOUNTID = @DISCOUNTID
order by
TAX.NAME;
return 0;