USP_DATALIST_DISBURSEMENTPROCESSFORMATS

Lists the disbursement formats assigned to a disbursement process.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_DISBURSEMENTPROCESSFORMATS
                (
                    @CONTEXTID uniqueidentifier
                )
                as
                set nocount on;

                select 
                    PT.ID,
                    F.NAME as 'FORMATNAME',
                    F.DESCRIPTION,
                    F.PAYMENTMETHOD,
                    RC.NAME as 'REPORTNAME',
                    F.TYPE,
                    P.PRINTERNAME as [PRINTERID]
                from dbo.DISBURSEMENTFORMAT F
                    inner join dbo.DISBURSEMENTPROCESSFORMAT  PT on F.ID = PT.DISBURSEMENTFORMATID
                    inner join dbo.REPORTCATALOG RC on F.REPORTCATALOGID = RC.ID
                    inner join dbo.SECUREPRINTER P on P.ID = PT.PRINTERID
                where PT.DISBURSEMENTPROCESSID = @CONTEXTID