USP_DATALIST_DISBURSEMENTPROCESSTEMPLATEFORMATS

Lists the disbursement formats assigned to a disbursement process template.

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_DISBURSEMENTPROCESSTEMPLATEFORMATS(
  @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.DISBURSEMENTPROCESSTEMPLATEFORMAT  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.DISBURSEMENTPROCESSTEMPLATEID = @CONTEXTID