USP_DATAFORMTEMPLATE_VIEW_CREDITREFUND_SUMMARY

The load procedure used by the view dataform template "Credit Refund Page Summary View Form"

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.
@CREDITTOTAL	money	INOUT	Refund total
@USERNAME	nvarchar(100)	INOUT	Created by
@TRANSACTIONDATE	datetime	INOUT	Refund date
@CREDITREASONCODE	nvarchar(100)	INOUT	Reason
@COMMENTS	nvarchar(500)	INOUT	Comments
@RECONCILIATIONSTATUS	nvarchar(100)	INOUT	Reconciliation status
@HASINCOMPLETEREFUND	bit	INOUT	Has a refund that has not been processed
@CHECKDETAILS	xml	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CREDITREFUND_SUMMARY
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @CREDITTOTAL money = null output,
    @USERNAME nvarchar(100) = null output,
    @TRANSACTIONDATE datetime = null output,
    @CREDITREASONCODE nvarchar(100) = null output,
    @COMMENTS nvarchar(500) = null output,
    @RECONCILIATIONSTATUS nvarchar(100) = null output,
    @HASINCOMPLETEREFUND bit = null output,
    @CHECKDETAILS xml = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select
        @DATALOADED = 1,
        @CREDITTOTAL = FT.TRANSACTIONAMOUNT,
        @USERNAME = dbo.UFN_APPUSER_GETNAME(FT.APPUSERID),
        @TRANSACTIONDATE = cast(FT.DATE as datetime),
        @CREDITREASONCODE = CREDITREASONCODE.DESCRIPTION,
        @COMMENTS = FT.DESCRIPTION,
        @CHECKDETAILS = dbo.UFN_CREDIT_REFUND_GETCHECKDETAILS_TOITEMLISTXML(@ID)
    from
        dbo.FINANCIALTRANSACTION as FT
    inner join
        dbo.CREDIT_EXT as EXT on EXT.ID = FT.ID
    left outer join
        dbo.CREDITREASONCODE on CREDITREASONCODE.ID = EXT.CREDITREASONCODEID
    where
        FT.ID = @ID

    if exists (select * from dbo.CREDITPAYMENT where CREDITPAYMENT.CREDITID = @ID) begin
        set @RECONCILIATIONSTATUS = dbo.UFN_RECONCILIATION_STATUSCODE_GETDESCRIPTION_FORREFUND(@ID)
    end

    set @HASINCOMPLETEREFUND = 0;

    if exists (
        select *
        from dbo.CREDITPAYMENT
        where 
            CREDITPAYMENT.CREDITID = @ID and
            CREDITPAYMENT.REFUNDPROCESSED = 0
    ) begin
        set @HASINCOMPLETEREFUND = 1;
    end

    return 0;