USP_SIMPLEDATALIST_GIFTFEEOVERRIDEREASONCODES
Returns a list of gift fee override reason codes and descriptions.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @INCLUDEINACTIVE | bit | IN | Include inactive |
Definition
Copy
create procedure dbo.USP_SIMPLEDATALIST_GIFTFEEOVERRIDEREASONCODES
(
@INCLUDEINACTIVE bit = 0
)
as
set nocount on
select
ID as VALUE,
CODE + ' - ' + DESCRIPTION as LABEL
from dbo.GIFTFEEOVERRIDEREASONCODE
where
ACTIVE = 1 or @INCLUDEINACTIVE = 1
order by LABEL