USP_DATAFORMTEMPLATE_EDIT_BENEFITGLDISTRIBUTIONBACKOUTADJUST
The save procedure used by the edit dataform template "Posted Benefit Backout GL Distribution Edit Form".
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ID | uniqueidentifier | IN | The input ID parameter indicating the ID of the record being edited. |
@GLDISTRIBUTION | xml | IN | Benefit GL distribution |
@ADJUSTMENTDATE | datetime | IN | Adjustment date |
@ADJUSTMENTPOSTDATE | datetime | IN | Adjustment post date |
@ADJUSTMENTREASON | nvarchar(300) | IN | Adjustment details |
@CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
@ADJUSTMENTREASONCODEID | uniqueidentifier | IN | Adjustment reason |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BENEFITGLDISTRIBUTIONBACKOUTADJUST
(
@ID uniqueidentifier,
@GLDISTRIBUTION xml,
@ADJUSTMENTDATE datetime,
@ADJUSTMENTPOSTDATE datetime,
@ADJUSTMENTREASON nvarchar(300),
@CHANGEAGENTID uniqueidentifier = null,
@ADJUSTMENTREASONCODEID uniqueidentifier
)
as
exec USP_SAVE_BENEFITGLDISTRIBUTION_ADJUSTMENT @ID, @GLDISTRIBUTION, @ADJUSTMENTDATE, @ADJUSTMENTPOSTDATE,
@ADJUSTMENTREASONCODEID, @ADJUSTMENTREASON, 3, @CHANGEAGENTID
return 0;