USP_SALESORDERADJUSTABLEDISCOUNT_DELETE
Executes the "Sales Order Adjustable Discount: Delete" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Input parameter indicating the ID of the record being deleted. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the delete. |
Definition
Copy
CREATE procedure dbo.USP_SALESORDERADJUSTABLEDISCOUNT_DELETE
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier
)
as begin
declare @SALESORDERADJUSTABLEDISCOUNTID uniqueidentifier
declare @SALESORDERID uniqueidentifier
select
@SALESORDERID = [SALESORDERITEM].[SALESORDERID],
@SALESORDERADJUSTABLEDISCOUNTID = [SALESORDERADJUSTABLEDISCOUNT].ID
from
dbo.[SALESORDERITEM] inner join dbo.[SALESORDERADJUSTABLEDISCOUNT] on
SALESORDERITEM.SALESORDERID = SALESORDERADJUSTABLEDISCOUNT.SALESORDERID
where
SALESORDERITEM.ID = @ID
begin try
exec dbo.USP_SALESORDER_ISCOMPLETE_RAISERROR @SALESORDERID, @EXCLUDEGROUPSALES = 1;
exec dbo.USP_SALESORDERITEM_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
exec dbo.USP_SALESORDERADJUSTABLEDISCOUNT_DELETEBYID_WITHCHANGEAGENTID @SALESORDERADJUSTABLEDISCOUNTID, @CHANGEAGENTID
exec dbo.USP_SALESORDER_APPLYORDERDISCOUNTS @SALESORDERID, @CHANGEAGENTID;
exec dbo.USP_SALESORDER_CALCULATETAXES @SALESORDERID, @CHANGEAGENTID;
end try
begin catch
exec dbo.USP_RAISE_ERROR
return 1
end catch
return 0;
end