USP_DATALIST_RECEIVABLEPAYMENTCREDITAPPLICATION

Returns all of the applications possible for a given payer.

Parameters

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

Definition

Copy



                create procedure dbo.USP_DATALIST_RECEIVABLEPAYMENTCREDITAPPLICATION
                    (
                        @RECEIVABLEPAYMENTCREDITID uniqueidentifier
                    )
                as
                    set nocount on;

                    declare @RECEIVABLEPAYMENTCREDITLINEITEMID uniqueidentifier;
                    select top 1 @RECEIVABLEPAYMENTCREDITLINEITEMID = FINANCIALTRANSACTIONLINEITEM.ID
                    from FINANCIALTRANSACTION
                        inner join FINANCIALTRANSACTIONLINEITEM
                            on FINANCIALTRANSACTION.ID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
                    where (FINANCIALTRANSACTION.ID = @RECEIVABLEPAYMENTCREDITID) and
                            (FINANCIALTRANSACTIONLINEITEM.DELETED = 0) and
                            (FINANCIALTRANSACTIONLINEITEM.TYPECODE = 0);

                    select APPLIEDTOLINEITEMID,
                            APPLIEDTOID,
                            BILLINGITEMNAME,
                            DESCRIPTION,
                            DUEDATE,
                            APPLICATIONDATE,
                            AMOUNT
                    from dbo.UFN_RECEIVABLEPAYMENTCREDITAPPLICATIONS(@RECEIVABLEPAYMENTCREDITLINEITEMID, null, 0)