USP_DOCUMENTPRINTFORGROUPSALESDISABLE_UPDATE

Executes the "Document Print For Group Sales Order Disallow Record Operation" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being updated.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the update.

Definition

Copy



CREATE procedure dbo.USP_DOCUMENTPRINTFORGROUPSALESDISABLE_UPDATE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin
    --check deletion rules, if any


    declare @CURRENTDATE datetime = getdate();

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

    UPDATE dbo.DOCUMENT 
        set PRINTFORGROUPSALES=0,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where ID = @ID    
    return 0;

end