USP_DATALIST_RECEIVABLECREDITAPPLICATION

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

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_RECEIVABLECREDITAPPLICATION
                    (
                        @RECEIVABLECREDITID uniqueidentifier
                    )
                as
                    set nocount on;

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

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