USE [AlexisPTSTest]
GO

SET QUOTED_IDENTIFIER ON
GO

SET IDENTITY_INSERT [dbo].[ProductType] ON 
GO

INSERT INTO [dbo].[ProductType]
           ([ProductID]
		   ,[SchemeID]
           ,[Product]
           ,[AccountNo]
           ,[ProductCode]
           ,[ProductType]
           ,[CrdProduct]
           ,[ProgramID]
           ,[ServiceCode]
           ,[Active]
           ,[StartPAN]
           ,[ProductType_XML]
           ,[gps_validity]
           ,[cash_withdrawal_limit]
           ,[branchCode]
           ,[EmbossName]
           ,[Currency]
           ,[SubBinLow]
           ,[SubBinHigh]
           ,[Currency_Native]
           ,[TransactionDays]
           ,[BankID]
           ,[GroupID]
           ,[flBreakage_Fee]
           ,[AuthIdResponse_De038]
           ,[Limit]
           ,[FeeGroupID]
           ,[IsVisa]
           ,[ImageId]
           ,[EmbossLine4]
           ,[CardDesignID]
           ,[Group_Usage_DefaultID]
           ,[Group_MCC_DefaultID]
           ,[Group_AuthFee_DefaultID]
           ,[Group_RecurringFees_DefaultID]
           ,[Group_Limited_Net_ID]
           ,[Group_WSFee_DefaultID]
           ,[QRCode]
           ,[fx_paddingpercent]
           ,[ProductDesc]
           ,[UserName]
           ,[CountryofIssue]
           ,[cvv_yyMM]
           ,[Short_Name]
           ,[GroupCardLinkageID]
           ,[LimitCount]
           ,[RestockQuantity]
           ,[White_List_ID]
           ,[FXGroupID]
           ,[AuthCalendarGroupID]
           ,[TransArchiveDaysAfter]
           ,[Black_List_ID]
           ,[SeparateCardFile]
           ,[IsUnlimited_LimitGroup]
           ,[flg_Sanction]
           ,[BillingRef]
           ,[ATCLength]
           ,[ATCPosition]
           ,[CVVLength]
           ,[CVVPosition]
           ,[UNLength]
           ,[UNPosition]
           ,[InitialValuesfromCard]
           ,[Enable3DSecureWS]
           ,[Autocard_Gen]
           ,[AlternateSMSURL]
           ,[ARPCKey]
           ,[PinLength]
           ,[SessionKeyIndex]
           ,[GPSSanctionCheck]
           ,[W2SanctionCheck]
           ,[MatchItems]
           ,[CheckLevel]
           ,[GPSProtectDataFeed]
           ,[flCCAProcessing]
           ,[Does_Not_Expire]
           ,[ShortNameStatus]
           ,[TransactionDays_Preauth]
           ,[payment_token_usage_defaultId]
           ,[CVC2_max_tries]
           ,[PinLength_Max]
           ,[Supplier_3DS]
           ,[ReturnedBalConfig]
           ,[Supplier_3DS_Version]
           ,[cb_credittocard_flag]
           ,[PSD_Compliance]
           ,[TxnCountLimit]
           ,[AccumValueLimit]
           ,[SingleValLimit]
           ,[SubBINRangeLow]
           ,[SubBINRangeHigh]
           ,[flSecPreCreditsFirstCB]
           ,[DefaultAuthenticationType]
           ,[FallbackAuthenticationType]
           ,[AutoEnrol3DSBiometrics]
           ,[InitialBiometricCredential]
           ,[BiometricValidationTimeout]
           ,[PSD2DLRDSTxnIDDecision]
           ,[PSD2DLRDSTxnIDVariance20Decision]
           ,[PSD2DLRDSTxnIDVarianceDecision]
           ,[PSD2DLRVariance20Decision]
           ,[PSD2DLRVarianceDecision]
           ,[PSD2DLRDSTxnIDFailDecision]
           ,[PSD2DLRCurrMatchDecision]
           ,[MultiFXProduct])
     VALUES
            (9830
            ,1028
            ,'TestHSMAuto VISA'
            ,01
            ,NULL
            ,0
            ,'VISA'
            ,'GPS'
            ,221
            ,1
            ,NULL
            ,1
            ,9999
            ,NULL
            ,NULL
            ,'N/A'
            ,'GBP'
            ,40123400
            ,40123400
            ,'GBP'
            ,7
            ,2
            ,1053
            ,0
            ,4
            ,50
            ,NULL
            ,1
            ,-1
            ,NULL
            ,2
            ,17
            ,0
            ,0
            ,0
            ,0
            ,-1
            ,NULL
            ,0
            ,'TestHSMAuto VISA'
            ,'AdrianC'
            ,826
            ,1
            ,'N/A'
            ,0
            ,1000
            ,2000
            ,0
            ,0
            ,0
            ,90
            ,0
            ,0
            ,0
            ,0
            ,0
            ,0
            ,0
            ,0
            ,0
            ,0
            ,0
            ,NULL
            ,NULL
            ,1
            ,NULL
            ,1
            ,4
            ,0
            ,0
            ,0
            ,NULL
            ,NULL
            ,0
            ,NULL
            ,0
            ,0
            ,0
            ,NULL
            ,NULL
            ,4
            ,NULL
            ,0x01
            ,NULL
            ,0
            ,NULL
            ,NULL
            ,NULL
            ,NULL
            ,4012340000000000000
            ,4012340000009999999
            ,0
            ,NULL
            ,NULL
            ,NULL
            ,NULL
            ,NULL
            ,0
            ,0
            ,0
            ,0
            ,0
            ,0
            ,0
            ,NULL)

GO

INSERT INTO [dbo].[ProductType]
           ([ProductID]
		   ,[SchemeID]
           ,[Product]
           ,[AccountNo]
           ,[ProductCode]
           ,[ProductType]
           ,[CrdProduct]
           ,[ProgramID]
           ,[ServiceCode]
           ,[Active]
           ,[StartPAN]
           ,[ProductType_XML]
           ,[gps_validity]
           ,[cash_withdrawal_limit]
           ,[branchCode]
           ,[EmbossName]
           ,[Currency]
           ,[SubBinLow]
           ,[SubBinHigh]
           ,[Currency_Native]
           ,[TransactionDays]
           ,[BankID]
           ,[GroupID]
           ,[flBreakage_Fee]
           ,[AuthIdResponse_De038]
           ,[Limit]
           ,[FeeGroupID]
           ,[IsVisa]
           ,[ImageId]
           ,[EmbossLine4]
           ,[CardDesignID]
           ,[Group_Usage_DefaultID]
           ,[Group_MCC_DefaultID]
           ,[Group_AuthFee_DefaultID]
           ,[Group_RecurringFees_DefaultID]
           ,[Group_Limited_Net_ID]
           ,[Group_WSFee_DefaultID]
           ,[QRCode]
           ,[fx_paddingpercent]
           ,[ProductDesc]
           ,[UserName]
           ,[CountryofIssue]
           ,[cvv_yyMM]
           ,[Short_Name]
           ,[GroupCardLinkageID]
           ,[LimitCount]
           ,[RestockQuantity]
           ,[White_List_ID]
           ,[FXGroupID]
           ,[AuthCalendarGroupID]
           ,[TransArchiveDaysAfter]
           ,[Black_List_ID]
           ,[SeparateCardFile]
           ,[IsUnlimited_LimitGroup]
           ,[flg_Sanction]
           ,[BillingRef]
           ,[ATCLength]
           ,[ATCPosition]
           ,[CVVLength]
           ,[CVVPosition]
           ,[UNLength]
           ,[UNPosition]
           ,[InitialValuesfromCard]
           ,[Enable3DSecureWS]
           ,[Autocard_Gen]
           ,[AlternateSMSURL]
           ,[ARPCKey]
           ,[PinLength]
           ,[SessionKeyIndex]
           ,[GPSSanctionCheck]
           ,[W2SanctionCheck]
           ,[MatchItems]
           ,[CheckLevel]
           ,[GPSProtectDataFeed]
           ,[flCCAProcessing]
           ,[Does_Not_Expire]
           ,[ShortNameStatus]
           ,[TransactionDays_Preauth]
           ,[payment_token_usage_defaultId]
           ,[CVC2_max_tries]
           ,[PinLength_Max]
           ,[Supplier_3DS]
           ,[ReturnedBalConfig]
           ,[Supplier_3DS_Version]
           ,[cb_credittocard_flag]
           ,[PSD_Compliance]
           ,[TxnCountLimit]
           ,[AccumValueLimit]
           ,[SingleValLimit]
           ,[SubBINRangeLow]
           ,[SubBINRangeHigh]
           ,[flSecPreCreditsFirstCB]
           ,[DefaultAuthenticationType]
           ,[FallbackAuthenticationType]
           ,[AutoEnrol3DSBiometrics]
           ,[InitialBiometricCredential]
           ,[BiometricValidationTimeout]
           ,[PSD2DLRDSTxnIDDecision]
           ,[PSD2DLRDSTxnIDVariance20Decision]
           ,[PSD2DLRDSTxnIDVarianceDecision]
           ,[PSD2DLRVariance20Decision]
           ,[PSD2DLRVarianceDecision]
           ,[PSD2DLRDSTxnIDFailDecision]
           ,[PSD2DLRCurrMatchDecision]
           ,[MultiFXProduct])
     VALUES
            (9831
            ,1028
            ,'TestHSMAuto MCRD'
            ,01
            ,NULL
            ,0
            ,'MCRD'
            ,'GPS'
            ,221
            ,1
            ,NULL
            ,1
            ,9999
            ,NULL
            ,NULL
            ,'N/A'
            ,'GBP'
            ,50123400
            ,50123400
            ,'GBP'
            ,7
            ,2
            ,1053
            ,0
            ,4
            ,50
            ,NULL
            ,0
            ,-1
            ,NULL
            ,2
            ,17
            ,0
            ,0
            ,0
            ,0
            ,-1
            ,NULL
            ,0
            ,'TestHSMAuto MCRD'
            ,'AdrianC'
            ,826
            ,1
            ,'N/A'
            ,0
            ,1000
            ,2000
            ,0
            ,0
            ,0
            ,90
            ,0
            ,0
            ,0
            ,0
            ,0
            ,0
            ,0
            ,0
            ,0
            ,0
            ,0
            ,NULL
            ,NULL
            ,1
            ,NULL
            ,1
            ,4
            ,0
            ,0
            ,0
            ,NULL
            ,NULL
            ,0
            ,NULL
            ,0
            ,0
            ,0
            ,NULL
            ,NULL
            ,4
            ,NULL
            ,0x01
            ,NULL
            ,0
            ,NULL
            ,NULL
            ,NULL
            ,NULL
            ,5012340000000000000
            ,5012340000009999999
            ,0
            ,NULL
            ,NULL
            ,NULL
            ,NULL
            ,NULL
            ,0
            ,0
            ,0
            ,0
            ,0
            ,0
            ,0
            ,NULL)

GO

SET IDENTITY_INSERT [dbo].[ProductType] OFF
GO