USP_RECORDOPERATION_RECEIPTINGPROCESSSTATUS_DELETEPROMPT

Provides the prompt for the "Receipting Process Status: Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Represents information to be displayed in the record operation prompt.
@MESSAGE	nvarchar(150)	INOUT

Definition

Copy



                            CREATE procedure dbo.USP_RECORDOPERATION_RECEIPTINGPROCESSSTATUS_DELETEPROMPT
                            (
                                @ID uniqueidentifier,
                                @MESSAGE nvarchar(150) output
                            )
                            as
                                set nocount on;

                                if exists (select ID from dbo.REVENUERECEIPT where RECEIPTINGPROCESSSTATUSID = @ID and RECEIPTDATE is null)
                                    select @MESSAGE = 'Revenue in this receipt process has not been marked ''Receipted'' and results will be cleared.'
                                else
                                    select @MESSAGE = null;

                                return 0;