USP_DATALIST_RECEIPTSTACKINFO

Returns a list of receipt stacks.

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEINACTIVE	bit	IN	Include inactive

Definition

Copy



CREATE procedure dbo.USP_DATALIST_RECEIPTSTACKINFO  @INCLUDEINACTIVE bit = 0

        as
        set nocount on;

          select
            RS.ID,
            RS.NAME, 
            RS.SHORTNAME, 
            RS.NEXTRECEIPTNUMBER, 
            SC.DESCRIPTION,
            RS.ISACTIVE, 
            RS.ISDEFAULT
          from
           DBO.RECEIPTSTACKINFO RS
           LEFT JOIN DBO.RECEIPTSTACKCODE SC ON SC.ID = RS.RECEIPTSTACKCODEID
          where
            (@INCLUDEINACTIVE = 1 or RS.ISACTIVE = 1);