USP_DATALIST_ORDERPAYMENTREVENUEDETAIL

Returns a list of revenue items associated with an order payment.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_ORDERPAYMENTREVENUEDETAIL
(
    @CONTEXTID uniqueidentifier
)
as
    set nocount on;

    select 
        FINANCIALTRANSACTION.ID REVENUEID,
        REVENUESPLIT_EXT.APPLICATION APPLICATION,
        FINANCIALTRANSACTION.TRANSACTIONAMOUNT AMOUNT,
        dbo.UFN_REVENUE_ISPOSTED(FINANCIALTRANSACTION.ID) ISPOSTED,
        0 ALLOWDELETE,
        FINANCIALTRANSACTION.TYPECODE TRANSACTIONTYPECODE
    from
        dbo.FINANCIALTRANSACTION
    inner join
        dbo.FINANCIALTRANSACTIONLINEITEM on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
    inner join
        dbo.REVENUESPLIT_EXT on REVENUESPLIT_EXT.ID = FINANCIALTRANSACTIONLINEITEM.ID
    where 
        FINANCIALTRANSACTION.ID = @CONTEXTID
        and REVENUESPLIT_EXT.APPLICATIONCODE = 10 -- Order

    group by 
        FINANCIALTRANSACTION.ID, FINANCIALTRANSACTION.TRANSACTIONAMOUNT, REVENUESPLIT_EXT.APPLICATION, FINANCIALTRANSACTION.TYPECODE