| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443 |
- 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
|
