USE [AlexisPTSTest] GO SET QUOTED_IDENTIFIER ON GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (4014012345250008 ,'Automated_Test_card' ,'00' ,'123456' ,'London' ,'263' ,getdate() ,500.00 ,0.00 ,2 ,NULL ,9830 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'933A0019D7A00FC0' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'263' ,4014012345250008 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,4014012345250008 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (5015015565560005 ,'Automated_Test_card' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9831 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'1418214235C87C8E' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'209' ,5015015565560005 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,5015015565560005 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (4014012346330007 ,'Automated_Test_card' ,'00' ,'123456' ,'London' ,'263' ,getdate() ,500.00 ,0.00 ,2 ,NULL ,9830 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'E0B96BF058E3CA74' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'949' ,4014012346330007 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,4014012346330007 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (5015012346330004 ,'Automated_Test_card' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9831 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'DD6C9DA8C950E68D' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'246' ,5015012346330004 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,5015012346330004 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (4014016333330006 ,'Automated_Test_card' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9830 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'DD6C9DA8C950E68D' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'246' ,4014016333330006 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,4014016333330006 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (5014016333330003 ,'Automated_Test_card' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9831 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'6E87DBB8FF84E855' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'246' ,5014016333330003 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,5014016333330003 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (4014016565660005 ,'Automated_Test_card' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9830 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'B256BE192F6CC0C1' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'014' ,4014016565660005 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,4014016565660005 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (5015016954120002 ,'Automated_Test_card' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9831 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'F2DD2D9ACDA6428E' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'030' ,5015016954120002 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,5015016954120002 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (4014017856230004 ,'Automated_Test_card' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9830 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'258E6AE13EFF7AA7' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'167' ,4014017856230004 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,4014017856230004 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (5015018596130001 ,'Automated_Test_card' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9831 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'FCE4792BBF5928B4' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,5015018596130001 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,5015018596130001 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (4014016789540000 ,'Automated_Test_card_19len' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9830 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'2853CA832038BC7C' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'167' ,4014016789540000 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,4014016789540000 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (5015015656560009 ,'Automated_Test_card_19len' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9831 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'5D13B76F0E8A93AA' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,5015015656560009 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,5015015656560009 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (4014014567450007 ,'Automated_Test_card_18len' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9830 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'1CA7AB030530B8D9' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,4014014567450007 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,4014014567450007 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (5015014589760400 ,'Automated_Test_card_18len' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9831 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'3AB19C4F3C88C05A' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,5015014589760400 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,5015014589760400 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (4014014345460000 ,'Automated_Test_card_13len' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9830 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'143FA75380B94698' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,4014014345460000 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,4014014345460000 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (5015014567450009 ,'Automated_Test_card_13len' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9831 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'96398333788BA7FF' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,5015014567450009 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,5015014567450009 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (4014055432890305 ,'Automated_Test_card_14len' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9830 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'FFFDD51D8927A229' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,4014055432890305 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,4014055432890305 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (5015055432890302 ,'Automated_Test_card_14len' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9831 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'26CE881BCA431DA2' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,5015055432890302 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,5015055432890302 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (4014075432894002 ,'Automated_Test_card_15len' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9830 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'A0141A8453C6768F' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,4014075432894002 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,4014075432894002 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (5015095432894001 ,'Automated_Test_card_15len' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9831 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'24E4C3BDA85316BD' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,5015095432894001 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,5015095432894001 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (4014013579510008 ,'Automated_Test_card_17len' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9830 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'9EECA80FAF5EBC5B' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,4014013579510008 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,4014013579510008 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (5015017419630007 ,'Automated_Test_card_17len' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9831 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'CDF8F04512C12EC1' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,5015017419630007 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,5015017419630007 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (5880582626498326 ,'Automated_Test_card_13len_0pan' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9831 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'2FB1D68B0064A5D8' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,5880582626498326 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,5880582626498326 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (5890589845494885 ,'Automated_Test_card_16len_0pan' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9831 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'8513CEFDEB3A12B5' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,5890589845494885 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,5890589845494885 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (5870589785566874 ,'Automated_Test_card_19len_0pan' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9831 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'FB8D625E0E436CCB' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,5870589785566874 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,5870589785566874 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (4870487889549773 ,'Automated_Test_card_13len_0pan' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9830 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'FCA4D27F2C1D78D1' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,4870487889549773 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,4870487889549773 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (4880489877772644 ,'Automated_Test_card_16len_0pan' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9830 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'3E83D5EFA43F1659' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,4880489877772644 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,4880489877772644 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO INSERT INTO [dbo].[Cards] ([PAN] ,[CName] ,[status] ,[PostCode] ,[Address] ,[CVC1] ,[DateChargedUp] ,[Actual_Balance] ,[Blocked_Amount] ,[SchemeID] ,[IMKID] ,[ProductID] ,[IsLive] ,[IsLive_date] ,[gps_expiry] ,[Emboss_Name] ,[ServiceCode] ,[ExpiryDate] ,[Pin_Block] ,[mc_pin_block] ,[Passcode] ,[Carrier_type] ,[Note] ,[ActivationDate] ,[Advanced_Permissions] ,[BillingCcy] ,[EMBOSS_CVC] ,[Account_Id] ,[CustAccount] ,[GROUPID] ,[GROUPMCCID] ,[Groups_Fees_Scheduled_ID] ,[PIN_OnlineCounter] ,[Groups_Usage_ID] ,[Primary_id] ,[Groups_card_Linkage_id] ,[GRP_AUTH_FEE_ID] ,[CVC3] ,[Group_Limited_Net_ID] ,[GRP_WS_FEE_ID] ,[Multi_Fx_Account] ,[ICVV] ,[PIN_OffLineCounter] ,[ATC] ,[IssueDate] ,[last_positive_balance_date] ,[AuthCalendarGroupID] ,[Black_List_ID] ,[White_List_ID] ,[bal_seqno] ,[bal_seqno_exthost] ,[Blocked_Amount_Positive]) VALUES (4890481145717981 ,'Automated_Test_card_19len_0pan' ,'00' ,'123456' ,'London' ,'853' ,getdate() ,500.00 ,0.00 ,1 ,NULL ,9830 ,1 ,getdate() ,NULL ,'UNKNOWN/ UNKNOWN' ,221 ,'2050-01-01 00:00:00' ,NULL ,'707FBC6C8E773914' ,NULL ,'CRU' ,NULL ,NULL ,0x0000000000 ,'GBP' ,'718' ,4890481145717981 ,NULL ,1 ,NULL ,0 ,3 ,NULL ,4890481145717981 ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,3 ,NULL ,getdate() ,getdate() ,NULL ,NULL ,NULL ,0 ,0 ,NULL) GO