USP_DATAFORMTEMPLATE_EDITLOAD_RESERVATIONSECURITYDEPOSITREFUNDPAYMENT

The load procedure used by the edit dataform template "Reservation Security Deposit Refund Payment Edit Data 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.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@DATE	datetime	INOUT	Date
@AMOUNT	money	INOUT	Amount
@CHECKDATE	UDT_FUZZYDATE	INOUT	Check date
@CHECKNUMBER	nvarchar(20)	INOUT	Check number
@CONSTITUENTNAME	nvarchar(155)	INOUT
@ADDRESSBLOCK	nvarchar(300)	INOUT
@ITEMREFUNDED	nvarchar(150)	INOUT
@NOTES	nvarchar(255)	INOUT

Definition

Copy


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

    set nocount on;

    set @DATALOADED = 0;
    set @TSLONG = 0;

  select 
      @DATALOADED = 1,
      @DATE = CREDIT.TRANSACTIONDATE,
      @AMOUNT = CREDITPAYMENT.AMOUNT,
      @CHECKDATE = DETAIL.CHECKDATE,
      @CHECKNUMBER = DETAIL.CHECKNUMBER,
      @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(CREDIT.ID),
      @NOTES = DETAIL.NOTES,
      @TSLONG = CREDITPAYMENT.TSLONG 
  from dbo.CREDITPAYMENT 
    inner join dbo.CREDIT 
    on CREDITPAYMENT.CREDITID = CREDIT.ID 
    inner join dbo.CREDITPAYMENTCHECKPAYMENTMETHODDETAIL DETAIL
    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.ID = @ID;

    return 0;