USP_DATALIST_REVENUETRANSACTIONPAYMENTMETHODS

Returns a list of payment methods for a transaction.

Parameters

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

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_REVENUETRANSACTIONPAYMENTMETHODS
                    (
                        @REVENUEID uniqueidentifier
                    )
                    as
                        set nocount on

                        select
                            REVENUEPAYMENTMETHOD.ID,
                            REVENUEPAYMENTMETHOD.PAYMENTMETHOD,
                            REVENUEPAYMENTMETHOD.AMOUNT,
                            REVENUE.BASECURRENCYID
                        from dbo.REVENUEPAYMENTMETHOD
                        inner join
                            dbo.REVENUE on REVENUE.ID = REVENUEPAYMENTMETHOD.REVENUEID
                        where REVENUEID = @REVENUEID