USP_DATALIST_RECEIVABLEPAYMENTCREDITAPPLICATIONBYPAYER

Returns all of the applications associated with a given receivable payment or credit line item.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_RECEIVABLEPAYMENTCREDITAPPLICATIONBYPAYER
                    (
                        @RECEIVABLEPAYMENTCREDITOWNERID uniqueidentifier
                    )
               as
                    set nocount on;

                    select TARGETLINEITEMID,
                            DATE,
                            NAME,
                            BILLINGITEMNAME,
                            TOTALAMOUNT,
                            TOTALAMOUNTREMAINING,
                            DUEON,
                            AMOUNT,
                            POSTDATE,
                            POSTSTATUSCODE
                    from dbo.UFN_RECEIVABLEPAYMENTCREDITAPPLICATIONS(null, @RECEIVABLEPAYMENTCREDITOWNERID, 1)
                  order by DATE ASC;