USP_DATAFORMTEMPLATE_EDIT_REVENUE_INSTALLMENTS
The save procedure used by the edit dataform template "Installment Edit Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | The input ID parameter indicating the ID of the record being edited. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @AMOUNT | money | IN | Revenue amount |
| @RESCHEDULEBALANCE | money | IN | Balance |
| @FREQUENCYCODE | tinyint | IN | Frequency |
| @NUMBEROFINSTALLMENTS | int | IN | No. installments remaining |
| @STARTDATE | datetime | IN | Next installment date |
| @INSTALLMENTS | xml | IN |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUE_INSTALLMENTS (
@ID uniqueidentifier
,@CHANGEAGENTID uniqueidentifier = null
,@AMOUNT money
,@RESCHEDULEBALANCE money
,@FREQUENCYCODE tinyint
,@NUMBEROFINSTALLMENTS int
,@STARTDATE datetime
,@INSTALLMENTS xml
)
as
begin
exec dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUE_INSTALLMENTS_2 @ID = @ID
,@CHANGEAGENTID = @CHANGEAGENTID
,@AMOUNT = @AMOUNT
,@RESCHEDULEBALANCE = @RESCHEDULEBALANCE
,@FREQUENCYCODE = @FREQUENCYCODE
,@NUMBEROFINSTALLMENTS = @NUMBEROFINSTALLMENTS
,@STARTDATE = @STARTDATE
,@INSTALLMENTS = @INSTALLMENTS
,@ADJPAYMENT_DATE = null
,@ADJPAYMENT_POSTDATE = null
,@ADJPAYMENT_REASONCODEID = null
,@ADJPAYMENT_DETAILS = null
return 0;
end