USP_DATAFORMTEMPLATE_VIEW_CREDITMEMO

The load procedure used by the view dataform template "Credit Memo 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.
@AMOUNT	money	INOUT	Credit memo amount
@BALANCE	money	INOUT	Balance
@CREDITMEMODATE	datetime	INOUT	Credit memo date
@POSTSTATUS	nvarchar(14)	INOUT	Post status
@POSTDATE	datetime	INOUT	Post date
@PURCHASEORDERID	nvarchar(20)	INOUT	PO number
@ISLOCKED	bit	INOUT	Credit memo is locked

Definition

Copy


            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CREDITMEMO 
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @AMOUNT money = null output,
                @BALANCE money = null output,
                @CREDITMEMODATE datetime = null output,
                @POSTSTATUS nvarchar(14) = null output,
                @POSTDATE datetime = null output,
                @PURCHASEORDERID nvarchar(20) = null output,
                @ISLOCKED bit = 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 top 1
                    @DATALOADED = 1,
                    @AMOUNT = F.TRANSACTIONAMOUNT,
                    @BALANCE = CM.BALANCE,
                    @CREDITMEMODATE = F.[DATE],
              @POSTSTATUS = F.POSTSTATUS,
                    @POSTDATE = F.POSTDATE,
                    @PURCHASEORDERID = CM.PURCHASEORDERID,
                    @ISLOCKED = case when CM.DISBURSEMENTPROCESSID is null then 0 else 1 end
                from dbo.CREDITMEMO CM
                    inner join dbo.FINANCIALTRANSACTION F on F.ID = CM.ID and F.TYPECODE = 102
                    inner join dbo.CONSTITUENT C on F.CONSTITUENTID = C.ID
          inner join dbo.VENDOR PV on PV.ID = C.ID
                where F.ID = @ID

                return 0;