USP_DATALIST_RECEIVABLEPAYMENTAPPLICATIONBYPAYER

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

Parameters

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

Definition

Copy



                create procedure dbo.USP_DATALIST_RECEIVABLEPAYMENTAPPLICATIONBYPAYER
                    (
                        @RECEIVABLEPAYMENTOWNERID uniqueidentifier
                    )
               as
                    set nocount on;

                    select APPLIEDTOLINEITEMID,
                            DATE,
                            NAME,
                            BILLINGITEMNAME,
                            CHARGEAMOUNT,
                            CHARGEAMOUNTREMAINING
                    from dbo.UFN_RECEIVABLEPAYMENTAPPLICATIONS(null, @RECEIVABLEPAYMENTOWNERID, 1);