USP_DATAFORMTEMPLATE_ADD_RECEIVABLECREDITINDIVIDUAL_PRELOAD

The load procedure used by the edit dataform template "Credit Add to Individual Form"

Parameters

Parameter	Parameter Type	Mode	Description
@STUDENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CREDITDATE	date	INOUT	Credit date
@POSTDATE	date	INOUT	Post date
@LOADEDINDIVIDUALNAME	nvarchar(200)	INOUT	Name

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_RECEIVABLECREDITINDIVIDUAL_PRELOAD 
                (
                    @STUDENTID uniqueidentifier,
                    @CREDITDATE date = null output,                    
                    @POSTDATE date = null output,
                    @LOADEDINDIVIDUALNAME nvarchar(200) = null output
                ) as
                    set nocount on;

                    select @CREDITDATE = getdate(),
                            @POSTDATE = @CREDITDATE,
                            @LOADEDINDIVIDUALNAME = CONSTITUENT.NAME
                    from dbo.CONSTITUENT
                    where CONSTITUENT.ID = @STUDENTID;

                    return 0;