USP_POSTTOGLPROCESS_GETPARAMETERS

Retrieves parameter settings for a given post to GL process parameter set.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



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

                select    
                    NAME, 
                    POSTINGOPTIONCODE, 
                    IDSETREGISTERID, 
                    MARKASPOSTED, 
                    CREATEOUTPUTIDSET, 
                    OUTPUTIDSETNAME,
                    OVERWRITEOUTPUTIDSET,
                    BUSINESSPROCESSVIEWID,
                    DEPOSITPOSTINGOPTIONCODE,
                    ADJUSTMENTPOSTINGOPTIONCODE,
                    DEPOSITIDSETREGISTERID,
                    ADJUSTMENTIDSETREGISTERID,
                    ISACTIVE,
                    POSTDATEUPTOCODE,
                    SPECIFICPOSTDATEUPTO
                from    
                    dbo.POSTTOGLPROCESS 
                where 
                    ID = @ID;