USP_DATALIST_RECEIVABLEPAYMENTAPPLICATION

Returns all of the applications and possible applications for a given payment.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_RECEIVABLEPAYMENTAPPLICATION
                    (
                        @RECEIVABLEPAYMENTID uniqueidentifier
                    )
                as
                    set nocount on;

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

                    select TARGETLINEITEMID,
                            TARGETID,
                            BILLINGITEMNAME,
                            DESCRIPTION,
                            AMOUNT,
                            DUEDATE,
                            APPLICATIONDATE
                    from dbo.UFN_RECEIVABLEPAYMENTCREDITAPPLICATIONS(@RECEIVABLEPAYMENTLINEITEMID, null, 0)