USP_SIMPLEDATALIST_DOCUMENT

Lists all sales documents in the system

Parameters

Parameter	Parameter Type	Mode	Description
@SHOWINACTIVE	bit	IN	Show inactive templates
@TYPECODE	tinyint	IN	Type

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_DOCUMENT
(
    @SHOWINACTIVE bit = 1,
    @TYPECODE tinyint = null
)as
    select 
        ID as VALUE, 
        NAME as LABEL
    from dbo.DOCUMENT
    where
        (@SHOWINACTIVE = 1 or ISACTIVE = 1) and
        (@TYPECODE is null or TYPECODE = @TYPECODE)
    order by NAME