USP_DATAFORMTEMPLATE_VIEW_DISBURSEMENTPROCESSTEMPLATE_TRANSACTIONCRITERIA

The load procedure used by the view dataform template "Disbursement Process Template Transaction Criteria"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@DUEDATE	nvarchar(100)	INOUT	Include by due date through
@DISCOUNTEXPIRATIONDATE	nvarchar(100)	INOUT	Include by discount expiration date through
@INCLUDEUNPAID	bit	INOUT	Include all unpaid transactions
@INCLUDESELECTED	nvarchar(300)	INOUT	Include selected transactions
@CALCULATEDISCOUNTDATE	nvarchar(100)	INOUT	Calculate discounts as of

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DISBURSEMENTPROCESSTEMPLATE_TRANSACTIONCRITERIA
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @DUEDATE nvarchar(100) = null output,
    @DISCOUNTEXPIRATIONDATE nvarchar(100) = null output,
    @INCLUDEUNPAID bit = null output,
  @INCLUDESELECTED nvarchar(300) = null output,
  @CALCULATEDISCOUNTDATE nvarchar(100) = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 0;

    -- populate the output parameters, which correspond to fields on the form.  Note that

    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system

    -- will display a "no data loaded" message.

    select @DATALOADED = 1,
           @DUEDATE = CASE WHEN T.FILTERCODE = 0 THEN dbo.UFN_DISBURSEMENTPROCESSTEMPLATE_GETDATESTRING(T.DUEDATENUMBEROFDAYS, T.DUEDATECODE) ELSE 'No' END,
           @DISCOUNTEXPIRATIONDATE = CASE WHEN (T.FILTERCODE = 0) AND (T.INCLUDEINVOICESWITHDISCOUNT = 1) THEN dbo.UFN_DISBURSEMENTPROCESSTEMPLATE_GETDATESTRING(T.DISCOUNTDATENUMBEROFDAYS, T.DISCOUNTDATECODE) ELSE 'No' END,
           @INCLUDEUNPAID = CASE WHEN T.FILTERCODE = 1 THEN 1 ELSE 0 END,
       @INCLUDESELECTED = CASE WHEN T.FILTERCODE = 2 THEN S.NAME ELSE 'No' END,
       @CALCULATEDISCOUNTDATE = dbo.UFN_DISBURSEMENTPROCESSTEMPLATE_GETDATESTRING(T.CALCULATEDISCOUNTDAYS, 1)
    from dbo.DISBURSEMENTPROCESSTEMPLATE T
  left outer join dbo.IDSETREGISTER S on S.ID = T.IDSETREGISTERID
    where T.ID = @ID

    return 0;