USP_PLEDGEWRITEOFFPROCESS_GETPARAMETERS

Retrieves parameter settings for a given pledge write-off process parameter set.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_PLEDGEWRITEOFFPROCESS_GETPARAMETERS
            (
                @ID uniqueidentifier = null
            )
            as
                set nocount on;

                select 
                    NAME, 
                    IDSETREGISTERID, 
                    CREATEOUTPUTIDSET, 
                    POSTSTATUSCODE, 
                    POSTDATE, 
                    REASON, 
                    OUTPUTIDSETNAME, 
                    OVERWRITEOUTPUTIDSET,
                    REASONCODEID,
                    RECOGNITIONCREDITADJUSTMENTCODE
                from 
                    dbo.PLEDGEWRITEOFFPROCESS 
                where 
                    ID = @ID;