USP_SALESDEPOSITTEMPLATE_GETUNLINKEDCREDITPAYMENTS

Retrieves the unlinked credit payments handled by the sales deposit template.

Parameters

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

Definition

Copy



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

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