UFN_CREDITCARD_EXISTINGTOKENGET

Returns the token of a credit card that has the same values as the card details passed in.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode
@CARDHOLDERNAME	nvarchar(255)	IN
@CREDITCARDPARTIALNUMBER	nvarchar(4)	IN
@EXPIRESON	UDT_FUZZYDATE	IN
@VALIDFROM	UDT_FUZZYDATE	IN
@ISSUENUMBER	nvarchar(3)	IN

Definition

Copy



            CREATE function dbo.UFN_CREDITCARD_EXISTINGTOKENGET
            (
                @CARDHOLDERNAME nvarchar(255),
                @CREDITCARDPARTIALNUMBER nvarchar(4),
                @EXPIRESON dbo.UDT_FUZZYDATE,
                @VALIDFROM dbo.UDT_FUZZYDATE,
                @ISSUENUMBER nvarchar(3)
            )
            returns uniqueidentifier
            as
            begin
                declare @CREDITCARDTOKEN uniqueidentifier

                select @CREDITCARDTOKEN = CREDITCARDTOKEN
                from dbo.CREDITCARD
                where
                    CARDHOLDERNAME = @CARDHOLDERNAME and
                    CREDITCARDPARTIALNUMBER = @CREDITCARDPARTIALNUMBER and
                    EXPIRESON = @EXPIRESON and
                    VALIDFROM = coalesce(@VALIDFROM, '00000000') and
                    ISSUENUMBER = coalesce(@ISSUENUMBER, '') and
                    CREDITCARDTOKEN is not null and
                    ISTRANSIENT = 0

                return @CREDITCARDTOKEN
            end