USP_DATAFORMTEMPLATE_ADD_PDACCOUNTCODEMAPDEVELOPMENTGIFTAID_PRELOAD2

The load procedure used by the edit dataform template "Map Development Gift Aid Add Form 2"

Parameters

Parameter	Parameter Type	Mode	Description
@SYSTEMID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@REVENUETYPES	xml	INOUT	Transaction types
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT

Definition

Copy


        CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PDACCOUNTCODEMAPDEVELOPMENTGIFTAID_PRELOAD2
        (
            @SYSTEMID  uniqueidentifier,
            @REVENUETYPES xml = null output,
            @PDACCOUNTSYSTEMID uniqueidentifier = null output
        )
        as

        set nocount on;

        set @REVENUETYPES = (select 'B6431CCF-9C94-44E9-BED2-585F68BF2392' as REVENUETYPEID for xml raw('ITEM'), type, elements, root('REVENUETYPES'), BINARY BASE64)

        set @PDACCOUNTSYSTEMID = @SYSTEMID

        return 0;