USP_DATAFORMTEMPLATE_EDITLOAD_CREDITREFUNDMARKSENT

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@CONSTITUENTNAME	nvarchar(155)	INOUT
@ADDRESSBLOCK	nvarchar(300)	INOUT
@ITEMREFUNDED	nvarchar(max)	INOUT
@AMOUNT	money	INOUT
@CHECKDATE	UDT_FUZZYDATE	INOUT
@CHECKNUMBER	nvarchar(20)	INOUT
@NOTES	nvarchar(255)	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CREDITREFUNDMARKSENT
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @CONSTITUENTNAME nvarchar(155) = null output,
    @ADDRESSBLOCK nvarchar(300) = null output,
    @ITEMREFUNDED nvarchar(max) = null output,
    @AMOUNT money = null output,
    @CHECKDATE dbo.UDT_FUZZYDATE = null output,
    @CHECKNUMBER nvarchar(20) = null output,
    @NOTES nvarchar(255) = null output
)
as

    set nocount on;

    set @DATALOADED = 0
    set @TSLONG = 0

    select top(1)
        @DATALOADED = 1,
        @TSLONG = DETAIL.TSLONG,
        @CONSTITUENTNAME = dbo.UFN_CONSTITUENT_BUILDNAME(REVENUE.CONSTITUENTID),
        @ADDRESSBLOCK = dbo.UFN_BUILDFULLADDRESS(ADDRESS.ID, ADDRESS.ADDRESSBLOCK, ADDRESS.CITY, ADDRESS.STATEID, ADDRESS.POSTCODE, ADDRESS.COUNTRYID),
        @ITEMREFUNDED = dbo.UFN_CREDIT_GETITEMLIST(CREDITPAYMENT.CREDITID),
        @AMOUNT = CREDITPAYMENT.AMOUNT,
        @CHECKDATE = DETAIL.CHECKDATE,
        @CHECKNUMBER = DETAIL.CHECKNUMBER,
        @NOTES = DETAIL.NOTES
    from
        dbo.CREDITPAYMENTCHECKPAYMENTMETHODDETAIL DETAIL
    inner join
        dbo.CREDITPAYMENT on DETAIL.ID = CREDITPAYMENT.ID
    left join
        dbo.REVENUESPLIT on CREDITPAYMENT.REVENUESPLITID = REVENUESPLIT.ID
    left join
        dbo.REVENUE on REVENUESPLIT.REVENUEID = REVENUE.ID or CREDITPAYMENT.REVENUEID = REVENUE.ID
    left join
        dbo.ADDRESS on DETAIL.ADDRESSID = ADDRESS.ID
    where
        CREDITPAYMENT.CREDITID = @ID

    return 0;