USP_SIMPLEDATALIST_RECEIPTINGSTACKINFO
A simple data list of receipt stacks for the receipting process.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @INCLUDEINACTIVE | bit | IN |
Definition
Copy
create procedure dbo.USP_SIMPLEDATALIST_RECEIPTINGSTACKINFO @INCLUDEINACTIVE bit = 0
as
begin
set nocount on
select
ID as VALUE, NAME AS LABEL
from
DBO.RECEIPTSTACKINFO
where
(@INCLUDEINACTIVE = 1 or ISACTIVE = 1)
order by LABEL
end