UFN_REVENUEBATCH_GETTAXDECLARATIONS

Returns the tax declarations for a constituent batch record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHREVENUEID	uniqueidentifier	IN

Definition

Copy



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