USP_DATAFORMTEMPLATE_ADD_PDACCOUNTCODEMAPDEVELOPMENTPLANNEDGIFTS_PRELOAD2

The load procedure used by the edit dataform template "Map Development Planned Gifts 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_PDACCOUNTCODEMAPDEVELOPMENTPLANNEDGIFTS_PRELOAD2
    (
        @SYSTEMID  uniqueidentifier,
        @REVENUETYPES xml = null output,
        @PDACCOUNTSYSTEMID uniqueidentifier = null output        
    )
    as

    set nocount on;

    set @REVENUETYPES = (select 'A1D75446-FF78-4E43-B98F-04B36A7513B0' as REVENUETYPEID for xml raw('ITEM'), type, elements, root('REVENUETYPES'), BINARY BASE64)

    set @PDACCOUNTSYSTEMID = @SYSTEMID

    return 0;