UFN_CONSTITUENTBATCH_GETTAXDECLARATIONS

Returns the tax declarations for a constituent batch record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHCONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_CONSTITUENTBATCH_GETTAXDECLARATIONS
            (
                @BATCHCONSTITUENTID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    ID,
                    DECLARATIONMADE,
                    DECLARATIONSTARTS,
                    DECLARATIONENDS,
                    DECLARATIONINDICATORCODE,
                    DECLARATIONSOURCECODEID,
                    CHARITYCLAIMREFERENCENUMBERID,
                    PAYSTAXCODE
                from dbo.BATCHCONSTITUENTTAXDECLARATION
                where BATCHCONSTITUENTID = @BATCHCONSTITUENTID
            )