USP_SALESORDERITEM_DELETE_FEE

Executes the "Sales Order Item Fee 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_SALESORDERITEM_DELETE_FEE
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier
                )
                as begin

                    declare @CURRENTDATE datetime
                    set @CURRENTDATE = getdate()

                    declare @ORDERID uniqueidentifier
                    declare @FEEID uniqueidentifier

                    select @ORDERID = SALESORDERID,    @FEEID = FEEID
                    from dbo.SALESORDERITEM 
                    inner join dbo.SALESORDERITEMFEE on 
                        SALESORDERITEM.ID = SALESORDERITEMFEE.ID
                    where SALESORDERITEM.ID = @ID;

                    insert into dbo.SALESORDERFEEDELETED
                    ( ID, SALESORDERID, FEEID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED )
                    values
                    (newid(),@ORDERID,@FEEID,@CHANGEAGENTID,@CHANGEAGENTID,@CURRENTDATE,@CURRENTDATE)    

                    -- use the system generated delete routine to allow proper recording of the deleting agent

                    exec USP_SALESORDERITEM_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;

                    exec dbo.USP_SALESORDER_CALCULATETAXES @ORDERID, @CHANGEAGENTID;

                    return 0;

                end