USP_DATAFORMTEMPLATE_ADD_PDACCOUNTCODEMAPDEVELOPMENTGIFTFEE_PRELOAD

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

Parameters

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

Definition

Copy


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

                set nocount on;

                set @REVENUETYPES = (
                    select '07CCD463-7AD6-4E31-B185-A2CBDABAE95E' as REVENUETYPEID
                    for xml raw('ITEM'), type, elements, root('REVENUETYPES'), BINARY BASE64
                )

                set @PDACCOUNTSYSTEMID = @SYSTEMID

                return 0;