UFN_PAYMENT_GETDETAILS

Returns all revenue for a given payment.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@TRANSACTIONID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PAYMENT_GETDETAILS
            (
                @TRANSACTIONID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    REVENUE.ID,
                    REVENUE.TYPECODE,
                    REVENUE.AMOUNT,
                    dbo.UFN_REVENUE_GETACKNOWLEDGESTATUS(REVENUE.ID) as ACKNOWLEDGESTATUS,
                    dbo.UFN_REVENUE_GETRECEIPTSTATUS(REVENUE.ID) as RECEIPTSTATUS,
                    REVENUERECEIPT.RECEIPTDATE,
                    REVENUE.RECEIPTAMOUNT
                from
                    dbo.REVENUE
                left join
                    dbo.REVENUERECEIPT on REVENUE.ID = REVENUERECEIPT.ID
                where
                    TRANSACTIONID = @TRANSACTIONID
            );