USP_DATALIST_TAXID

This lists all tax IDs.

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEINACTIVE	smallint	IN	Include inactive
@ENTITYTYPECODE	smallint	IN	Entity type
@STATEID	uniqueidentifier	IN	State

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_TAXID
                (
                    @INCLUDEINACTIVE smallint = 1,
                    @ENTITYTYPECODE smallint = null,
                    @STATEID uniqueidentifier = null
                )
                as
                    set nocount on;
                    if @INCLUDEINACTIVE = 1
                        set @INCLUDEINACTIVE = 0
                    else
                        set @INCLUDEINACTIVE = 1

                    select
                        ID,
                        TAXINGAUTHORITY,
                        DESCRIPTION,
                        TAXIDNUMBER,
                        ENTITYTYPE,
                        dbo.UFN_STATE_GETABBREVIATION(STATEID),
                        STATUS,
                        STATUSCODE
                    from dbo.TAXID
                    where STATUSCODE in (1, @INCLUDEINACTIVE) and
                        (@ENTITYTYPECODE is null or ENTITYTYPECODE=@ENTITYTYPECODE) and
                        (@STATEID is null or STATEID=@STATEID)