USP_TREASURYDEPOSITTEMPLATE_GETUNLINKEDCREDITPAYMENTS

Parameters

Parameter	Parameter Type	Mode
@SALESDEPOSITTEMPLATEID	uniqueidentifier	IN
@ISRECONCILEDPROCESS	bit	IN
@POSTSTATUSCODE	tinyint	IN
@PAYMENTMETHODCODE	tinyint	IN
@SALESMETHODTYPECODE	tinyint	IN
@TRANSACTIONDATE	date	IN
@PAYMENTDATE	date	IN

Definition

Copy



            CREATE procedure dbo.USP_TREASURYDEPOSITTEMPLATE_GETUNLINKEDCREDITPAYMENTS
            (
                @SALESDEPOSITTEMPLATEID uniqueidentifier = null,
                @ISRECONCILEDPROCESS bit = 1,
        @POSTSTATUSCODE tinyint = null,
                @PAYMENTMETHODCODE tinyint = null,
                @SALESMETHODTYPECODE tinyint = null,
                @TRANSACTIONDATE date = null,
        @PAYMENTDATE date = null
            )    
            as begin

                select
                    [ID],
                    [AMOUNT],
                    [SALESORDERNUMBER],
                    [PAYMENTMETHODCODE],
                    [PAYMENTTYPE],
                    [CREDITCARDPARTIALNUMBER]
                from dbo.[UFN_TREASURYDEPOSITTEMPLATE_GETUNLINKEDCREDITPAYMENTS](@SALESDEPOSITTEMPLATEID, @POSTSTATUSCODE, @PAYMENTMETHODCODE, @TRANSACTIONDATE, @PAYMENTDATE)
            end