USP_DATAFORMTEMPLATE_ADD_RECEIVABLEPAYMENTINDIVIDUAL_PRELOAD
The load procedure used by the edit dataform template "Payment Add to Individual Data Form"
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@STUDENTID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
@ACCOUNTINGMETHODCODE | tinyint | INOUT | |
@AUTOAPPLYPAYMENTS | bit | INOUT | |
@LOADEDINDIVIDUALNAME | nvarchar(200) | INOUT | Student |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_RECEIVABLEPAYMENTINDIVIDUAL_PRELOAD
(
@STUDENTID uniqueidentifier,
@ACCOUNTINGMETHODCODE tinyint = null output,
@AUTOAPPLYPAYMENTS bit = null output,
@LOADEDINDIVIDUALNAME nvarchar(200) = null output
)
as
set nocount on;
exec dbo.USP_DATAFORMTEMPLATE_VIEW_APPLICATIONRULES @ACCOUNTINGMETHODCODE = @ACCOUNTINGMETHODCODE output, @PAYMENT = @AUTOAPPLYPAYMENTS output;
select @LOADEDINDIVIDUALNAME = CONSTITUENT.NAME
from dbo.CONSTITUENT
where CONSTITUENT.ID = @STUDENTID;
return 0;