USP_DATALIST_CHARGEAPPLICATION

Returns all of the applications possible for a given charge.

Parameters

Parameter	Parameter Type	Mode	Description
@CHARGEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_CHARGEAPPLICATION
                    (
                        @CHARGEID uniqueidentifier
                    )
                as
                    set nocount on;

                    declare @CHARGELINEITEMID uniqueidentifier;
                    select top 1 @CHARGELINEITEMID = FINANCIALTRANSACTIONLINEITEM.ID
                    from FINANCIALTRANSACTION
                        inner join FINANCIALTRANSACTIONLINEITEM
                            on FINANCIALTRANSACTION.ID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
                    where (FINANCIALTRANSACTION.ID = @CHARGEID) and
                            (FINANCIALTRANSACTIONLINEITEM.DELETEDON is null) and
                            (FINANCIALTRANSACTIONLINEITEM.TYPECODE = 0);

                    select SOURCELINEITEMID,
                            SOURCEID,
                            NAME,
                            APPLICATIONDATE,
                            AMOUNT
                    from dbo.UFN_CHARGEAPPLICATIONS(@CHARGELINEITEMID, null, 0)