USP_DATALIST_CLOSEDRAWER_OTHERTRANSACTIONS

CREATE procedure dbo.USP_DATALIST_CLOSEDRAWER_OTHERTRANSACTIONS(
@CONTEXTID uniqueidentifier,
@USERID uniqueidentifier = null,
@WORKSTATIONID uniqueidentifier = null
)
as
    set nocount on;

    select [ID], [PAYMENTMETHODCODE], [PAYMENTMETHOD], [CREDITTYPECODEID], [OTHERPAYMENTMETHODCODEID], [EXPECTED], [QUANTITY], [ISREFUND], [ISLABEL], [TOTALAMOUNT]
                                from dbo.[UFN_RECONCILIATION_GETOTHERRECEIPTS](@CONTEXTID, @USERID)
                                where ([PAYMENTMETHODCODE] <> 1 or [PAYMENTMETHODCODE] is null)
                                order by [ISREFUND] asc, [PAYMENTMETHODCODE]