Home Esplora Aiuto
Accedi
paul
/
gps.docker
1
0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Albero (Tree): 171bbf76d0
Rami (Branch) Tag
gps.docker
/
daldb
/
SeedData
/
AlexisPTSTest
/
Cards.sql

Cards.sql 36 KB
Cronologia Originale

123456789101112131415161718192021222324252627282930313233343536373839404142434445 
  1. DELETE FROM Cards WHERE PAN in 
    2. 

  2. (3161298874256,3161318282514,3161371085730,3162189240263,3162264014022,3211927544494378,3211927622936488,
    3. 

  3. 3211927766605038,3162000111416,3162224992568,2494697286281,1751144528024763,2469036722636631,3173040045066091,
    4. 

  4. 3178042060841493,3186762710517944,3187007310413960,3187009719671308,3187157797424494,3187669174638864,
    5. 

  5. 3187674948643514,3188217694541622,3189555214291380,3421000591551411,3425138996040927,
    6. 

  6. 5179762040643138,6771083486022888,6771096490339182,6905342138769450,7591229857767875,7598406073257928,
    7. 

  7. 8068355351794216,8068355707321776);
    8. 

  8. 

  9. SET IDENTITY_INSERT [dbo].[Cards] ON 
    10. 

  10. 

  11. INSERT INTO dbo.Cards (ID,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 (29090786,3161298874256,'PPRO_1','14','','London','000','2100-01-01 00:00:00',500.00,19.00,null,null,441,0,'2100-01-01 00:00:00',null,'UNKNOWN/ PPRO_1',122,'2050-01-01 00:00:00','','',null,'CRU',null,null,0x0000000000,'GBP','000',3161298874256,null,1,null,0,3,null,null,null,0,null,null,null,null,'',3,null,'2017-01-07 18:02:00',null,null,null,null,0,0,null);
    12. 

  12. INSERT INTO dbo.Cards (ID,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 (29091397,3161318282514,'PPRO_1','14','','London','000','2100-01-01 00:00:00',500.00,19.00,null,null,890,0,'2100-01-01 00:00:00',null,'UNKNOWN/ PPRO_1',122,'2050-01-01 00:00:00','','',null,'CRU',null,null,0x0000000000,'GBP','000',3161318282514,null,1,null,0,3,null,null,null,0,null,null,null,null,'',3,null,'2017-01-07 18:06:00',null,null,null,null,0,0,null);
    13. 

  13. INSERT INTO dbo.Cards (ID,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 (29093120,3161371085730,'PPRO_1','14','','London','000','2100-01-01 00:00:00',500.00,19.00,null,null,441,0,'2100-01-01 00:00:00',null,'UNKNOWN/ PPRO_1',122,'2050-01-01 00:00:00','','',null,'CRU',null,null,0x0000000000,'GBP','000',3161371085730,null,1,null,0,3,null,null,null,0,null,null,null,null,'',3,null,'2017-01-07 18:21:00',null,null,null,null,0,0,null);
    14. 

  14. INSERT INTO dbo.Cards (ID,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 (34300709,3162189240263,'PPRO_1','14','','London','000','2100-01-01 00:00:00',500.00,19.00,null,null,441,0,'2100-01-01 00:00:00',null,'UNKNOWN/ PPRO_1',122,'2050-01-01 00:00:00','','',null,'CRU',null,null,0x0000000000,'GBP','000',3162189240263,null,1,null,0,3,null,3162189240263,null,0,null,null,null,null,'',3,null,'2017-06-20 13:42:00','2017-06-21 05:41:04.257',null,null,null,0,0,null);
    15. 

  15. INSERT INTO dbo.Cards (ID,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 (34302372,3162264014022,'PPRO_1','14','','London','000','2100-01-01 00:00:00',500.00,19.00,null,null,890,0,'2100-01-01 00:00:00',null,'UNKNOWN/ PPRO_1',122,'2050-01-01 00:00:00','','',null,'CRU',null,null,0x0000000000,'GBP','000',3162264014022,null,1,null,0,3,null,3162264014022,null,0,null,null,null,null,'',3,null,'2017-06-20 13:45:00','2017-06-21 05:41:04.257',null,null,null,0,0,null);
    16. 

  16. INSERT INTO dbo.Cards (ID,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 (39312665,3211927544494378,'ViaBuy_P','14','','Charuvila','000','2100-01-01 00:00:00',500.00,19.00,null,null,452,0,'2100-01-01 00:00:00',null,'UNKNOWN/ VIABUY_P',122,'2050-01-01 00:00:00','','',null,'CRU',null,null,0x0000000000,'EUR','000',3211927544494378,null,1,null,0,3,null,3211927544494378,null,0,null,null,null,null,'',3,null,'2017-07-31 09:05:00','2017-08-01 02:44:10.553',null,null,null,0,0,null);
    17. 

  17. INSERT INTO dbo.Cards (ID,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 (39312666,3211927622936488,'ViaBuy_P','14','','Charuvila','000','2100-01-01 00:00:00',500.00,19.00,null,null,452,0,'2100-01-01 00:00:00',null,'UNKNOWN/ VIABUY_P',122,'2050-01-01 00:00:00','','',null,'CRU',null,null,0x0000000000,'EUR','000',3211927622936488,null,1,null,0,3,null,3211927622936488,null,0,null,null,null,null,'',3,null,'2017-07-31 09:05:00','2017-08-01 02:44:11.553',null,null,null,0,0,null);
    18. 

  18. INSERT INTO dbo.Cards (ID,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 (39312671,3211927766605038,'ViaBuy_P','14','','Charuvila','000','2100-01-01 00:00:00',500.00,0.00,null,null,2,0,'2100-01-01 00:00:00',null,'UNKNOWN/ VIABUY_P',122,'2050-01-01 00:00:00','','',null,'CRU',null,null,0x0000000000,'EUR','000',3211927766605038,null,1,null,0,3,null,3211927766605038,null,0,null,null,null,null,'',3,null,'2017-07-31 09:05:00','2017-08-01 02:44:11.053',null,null,null,0,0,null);
    19. 

  19. INSERT INTO dbo.Cards (ID,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 (39314363,3162000111416,'PPRO_1','14','','London','000','2100-01-01 00:00:00',500.00,19.00,null,null,441,0,'2100-01-01 00:00:00',null,'UNKNOWN/ PPRO_1',122,'2050-01-01 00:00:00','','',null,'CRU',null,null,0x0000000000,'GBP','000',3162000111416,null,1,null,0,3,null,3162000111416,null,0,null,null,null,null,'',3,null,'2017-07-31 09:10:00','2017-08-01 02:37:41.867',null,null,null,0,0,null);
    20. 

  20. INSERT INTO dbo.Cards (ID,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 (39319302,3162224992568,'PPRO_1','14','','London','000','2100-01-01 00:00:00',500.00,19.00,null,null,441,0,'2100-01-01 00:00:00',null,'UNKNOWN/ PPRO_1',122,'2050-01-01 00:00:00','','',null,'CRU',null,null,0x0000000000,'GBP','000',3162224992568,null,1,null,0,3,null,3162224992568,null,0,null,null,null,null,'',3,null,'2017-07-31 09:25:00','2017-08-01 02:37:41.867',null,null,null,0,0,null);
    21. 

  21. INSERT INTO dbo.Cards (ID,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 (43347968,2494697286281,'BWFX (VFX_EURO) -111','14','','London','000','2100-01-01 00:00:00',500.00,19.00,null,null,193,0,'2100-01-01 00:00:00',null,'UNKNOWN/ BWFX (VFX_EURO) -111',122,'2050-01-01 00:00:00',null,'',null,'CRU',null,null,null,'EUR','000',2494697286281,null,1,null,0,3,null,2494697286281,null,0,null,null,null,null,'',3,null,'2018-03-15 05:48:00',null,null,null,null,0,0,null);
    22. 

  22. INSERT INTO dbo.Cards (ID,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 (62965615,1751144528024763,'54','00','012','NewYork','535','2015-10-27 11:41:13.140',-94.88,0.00,175,null,60,1,'2015-10-27 11:41:12.177','2020-09-30 00:00:00','IAN FLINDERS',201,'2020-09-30 00:00:00','D8AE46981A3452D7','F367F3E6B7C568F4','114511','CRU2',null,'2016-05-27 13:33:36.620',0x0001008906,'GBP','590',1751144528024763,'MVC Card',160,85,8,3,0,1751144528024763,0,204,'831',0,3,null,'831',3,null,'2015-09-29 14:58:00','2018-09-17 07:31:49.300',0,6,10,0,0,null);
    23. 

  23. INSERT INTO dbo.Cards (ID,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 (63014769,2469036722636631,'JISHNUTEST/','00','654789','','780','2017-04-20 00:00:00',820.00,-140.00,246,null,186,1,'2017-04-20 09:20:30.913','2020-12-31 00:00:00','JISHNUTEST',221,'2020-12-31 00:00:00','1C3F3D6CC4217E0E','0B27A9CF0DED5A1C','951124','',null,'2019-02-08 08:41:38.600',0x0000000000,'EUR','014',2469036722636631,null,1088,0,0,3,0,2469036722636631,0,98,'137',0,0,null,'137',3,null,'2019-02-08 08:37:00',null,0,0,0,25,0,0.0000);
    24. 

  24. INSERT INTO dbo.Cards (ID,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 (63040631,3173040045066091,'/N/A','00','','','519','2018-11-27 00:00:00',650.00,-400.00,317,null,592,1,'2018-07-06 08:24:51.957','2021-10-31 00:00:00','N/A',221,'2021-10-31 00:00:00',null,'8FC104E4F51E3F4A','339143','',null,'2018-11-27 13:14:53.457',0x0100000100,'EUR','346',3173040045066091,null,1053,0,0,3,0,3173040045066091,0,399,'306',0,0,null,'306',3,null,'2018-11-27 13:15:00',null,-1,0,0,17,0,null);
    25. 

  25. INSERT INTO dbo.Cards (ID,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 (63054789,3178042060841493,'JISHNUTEST/','00','654789','','812','2018-06-26 00:00:00',94.00,-60.60,317,null,592,1,'2018-06-26 09:40:21.490','2020-01-25 00:00:00','JISHNUTEST',221,'2021-05-31 00:00:00',null,'C66F828417F74129','814490','',null,'2018-06-26 09:43:04.623',0x0120000100,'EUR','686',3178042060841493,null,1092,0,0,3,0,3178042060841493,0,241,'565',0,0,null,'565',3,null,'2018-06-26 09:43:00','2019-05-16 10:54:53.360',0,0,0,1753,98,0.0000);
    26. 

  26. INSERT INTO dbo.Cards (ID,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 (63193623,3186762710517944,'REGALO/PLAZA RIO 2-TARJETA','00','2530001','0660110661','316','2018-08-14 00:00:00',1469.04,-1212.73,318,null,443,1,'2018-08-13 15:07:04.100','2019-08-31 07:57:43.873','PLAZA RIO 2-TARJETA REGALO',221,'2023-08-31 00:00:00',null,'065A6ABA2773116A','448682','',null,'2018-08-31 07:57:43.873',0x8281100101,'USD','979',3186762710517944,'JishTest',1131,0,0,3,0,3186762710517944,0,685,'994',0,0,null,'994',3,null,'2018-08-14 13:59:00',null,0,0,0,522,0,0.0000);
    27. 

  27. INSERT INTO dbo.Cards (ID,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 (63199198,3187007310413960,'JISHTEST10/','00','00110011','','781','2018-11-23 04:36:21.843',96.00,0.00,318,null,443,1,'2018-10-24 08:15:59.917','2019-11-23 04:36:21.040','JISHTEST10',221,'2023-11-30 00:00:00',null,'0D26C079CD3C597B','479078','',null,'2018-11-23 04:35:51.843',0x0000010000,'USD','899',3187007310413960,null,1131,0,159,3,436,3187007310413960,0,685,'742',0,66,null,'742',3,null,'2018-11-23 04:36:00',null,-1,0,8,0,0,null);
    28. 

  28. INSERT INTO dbo.Cards (ID,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 (63199251,3187009719671308,'JISHTEST10/','00','00110011','','482','2018-11-23 04:36:31.490',96.00,0.00,318,null,443,1,'2018-10-24 08:15:59.917','2019-11-23 04:36:31.350','JISHTEST10',221,'2023-11-30 00:00:00',null,'8A844899ECA967B3','332899','',null,'2018-11-23 04:36:01.490',0x0000010000,'USD','165',3187009719671308,null,1131,0,159,3,436,3187009719671308,0,685,'970',0,66,null,'970',3,null,'2018-11-23 04:37:00',null,-1,0,8,0,0,null);
    29. 

  29. INSERT INTO dbo.Cards (ID,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 (63202655,3187157797424494,'JISHTEST10/','00','00110011','','872','2018-11-28 13:30:38.250',333.00,0.00,318,null,443,1,'2018-10-24 08:15:59.917','2019-11-28 13:30:38.143','JISHTEST10',221,'2023-11-30 00:00:00',null,'F68D737B6ED37E21','839125','',null,'2018-11-28 13:30:08.250',0x0000110000,'USD','465',3187157797424494,null,677,0,159,3,436,3187157797424494,0,685,'994',0,66,null,'994',3,null,'2018-11-28 13:31:00',null,-1,0,8,0,0,null);
    30. 

  30. INSERT INTO dbo.Cards (ID,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 (63214745,3187669174638864,'JISHTEST10/','00','00110011','','260','2018-12-18 13:38:54.270',39.15,0.00,318,null,443,1,'2018-10-24 08:15:59.917','2019-12-18 13:36:56.657','JISHTEST10',221,'2023-12-31 00:00:00',null,'E5931FF480FE5959','286070','',null,'2018-12-18 13:36:56.810',0x0000110000,'USD','489',3187669174638864,null,677,0,159,3,436,3187669174638864,0,423,'780',0,66,null,'780',3,null,'2018-12-18 13:37:00',null,-1,0,8,0,0,null);
    31. 

  31. INSERT INTO dbo.Cards (ID,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 (63214905,3187674948643514,'JISHTEST10/','00','00110011','','895','2018-12-18 13:57:26.690',139.15,0.00,318,null,443,1,'2018-10-24 08:15:59.917','2019-12-18 13:55:11.167','JISHTEST10',221,'2023-12-31 00:00:00',null,'7CBE5F3AF150B5F1','447117','',null,'2018-12-18 13:55:11.263',0x0000110000,'USD','579',3187674948643514,null,677,0,159,3,436,3187674948643514,0,423,'591',0,66,null,'591',3,null,'2018-12-18 13:55:00',null,-1,0,8,0,0,null);
    32. 

  32. INSERT INTO dbo.Cards (ID,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 (63228615,3188217694541622,'BB/MR MM','00','','','314','2019-02-14 00:00:00',497.56,-16.20,318,null,443,1,'2018-10-24 08:15:59.917','2021-05-01 00:00:00','MR MM BB',221,'2024-02-29 00:00:00',null,'C54E538EAFC36941','745041','',null,'2019-02-14 05:24:16.997',0x0000110000,'USD','444',3188217694541622,null,1130,0,159,3,436,3188217694541622,0,0,'569',0,160,null,'569',0,null,'2019-02-14 05:24:00',null,0,53,0,5,0,0.0000);
    33. 

  33. INSERT INTO dbo.Cards (ID,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 (63302045,3189555214291380,'REGALO/PLAZA RIO 2-TARJETA','54','253000','Charuvila','474','2018-05-07 14:44:10.160',0.00,0.00,318,null,443,1,'2017-12-12 06:05:49.263','2019-05-07 14:47:15.683','PLAZA RIO 2-TARJETA REGALO',221,'2023-05-31 00:00:00',null,'0580DDA09BCF8A57','505877','',null,'2018-05-07 14:47:15.700',0x0000000000,'USD','075',3189555214291380,'JishTest',1053,0,0,3,0,3189555214291380,0,0,'977',0,55,null,'977',3,null,'2018-05-07 14:44:00',null,-1,0,49,0,0,null);
    34. 

  34. INSERT INTO dbo.Cards (ID,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 (63451137,3421000591551411,'JISHTEST10/','00','00110011','','273','2019-01-11 00:00:00',4986.96,-4813.66,342,null,588,1,'2018-09-24 14:12:06.497','2020-01-25 00:00:00','JISHTEST10',221,'2024-01-31 00:00:00',null,'5A9B5B51195925CB','419822','',null,'2019-01-11 12:02:29.347',0x0000000000,'GBP','193',3421000591551411,null,1131,0,0,3,0,3421000591551411,0,689,'304',0,0,null,'304',3,null,'2019-01-11 12:02:00','2019-04-10 13:33:37.937',0,0,0,415,99,0.0000);
    35. 

  35. INSERT INTO dbo.Cards (ID,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 (63510320,3425138996040927,'/PERSONALISED','00','','','177','2018-01-24 00:00:00',100.00,-40.00,342,null,588,1,'2018-01-22 06:48:28.153','2020-01-25 00:00:00','PERSONALISED',221,'2023-01-31 00:00:00',null,'4F2D8700DAD197D4','619845','',null,'2018-01-24 06:30:23.877',0x0000100041,'GBP','423',3425138996040927,null,1053,0,0,3,0,3425138996040927,0,0,'375',0,0,null,'375',0,null,'2018-01-24 06:30:00',null,0,0,0,10862,99,-20.0000);
    36. 

  36. INSERT INTO dbo.Cards (ID,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 (63778552,5179762040643138,'JISHNUTEST/','00','654789','','147','2017-12-01 00:00:00',1922.77,0.00,517,null,1545,0,'2017-12-01 13:37:57.547',null,'JISHNUTEST',221,'2020-12-31 00:00:00',null,'98AB4AE2023545E6','422115','',null,null,0x0000000000,'ILS','898',5179762040643138,null,475,0,0,3,0,5179762040643138,0,0,'622',0,66,null,'622',3,null,'2019-02-07 07:19:00',null,0,0,0,0,0,null);
    37. 

  37. INSERT INTO dbo.Cards (ID,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 (64222367,6771083486022888,'XYZ/TESTUSER','00','682030','','243','2018-11-27 05:48:59.923',105.00,0.00,677,null,1902,1,'2018-09-05 13:44:46.660','2021-10-31 00:00:00','TESTUSER XYZ',221,'2021-10-31 00:00:00',null,'45B946520EF7BC93','805335','',null,'2018-11-27 05:48:29.923',0x0000020000,'GBP','502',6771083486022888,null,544,108,134,3,198,6771083486022888,46,0,'213',0,0,null,'213',3,null,'2018-11-27 05:49:00',null,0,0,0,0,0,null);
    38. 

  38. INSERT INTO dbo.Cards (ID,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 (64222504,6771096490339182,'XYZ/TESTUSER','00','682030','','431','2019-01-04 08:49:14.183',120.00,0.00,677,null,1902,1,'2018-09-05 13:44:46.660','2021-12-31 00:00:00','TESTUSER XYZ',221,'2021-12-31 00:00:00',null,'956FAF4BC7FC8384','715931','',null,'2019-01-04 08:49:14.183',0x0000020000,'GBP','267',6771096490339182,null,544,108,134,3,198,6771096490339182,46,0,'996',0,0,null,'996',3,null,'2019-01-04 08:49:00',null,0,0,0,0,0,null);
    39. 

  39. INSERT INTO dbo.Cards (ID,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 (64284021,6905342138769450,'JISHTEST/','00','0','','882','2019-03-11 13:34:33.900',82.00,0.00,690,null,45671722,0,'2018-09-05 13:53:04.443',null,'JISHTEST',221,'2024-02-29 00:00:00',null,'F85ABB36BA947844','239189','',null,null,0x0100130084,'ALL','811',6905342138769450,null,525,0,0,3,16,6905342138769450,0,0,'534',0,-1,6905320346780922,'534',3,null,'2019-03-11 13:32:00',null,0,77,0,0,0,null);
    40. 

  40. INSERT INTO dbo.Cards (ID,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 (64351256,7591229857767875,'/N/A','00','0','','980','2018-11-23 08:12:47.400',0.00,0.00,759,null,9009,1,'2018-11-23 08:12:47.400','2021-10-31 00:00:00','N/A',221,'2021-10-31 00:00:00',null,'15A9E2CE4CAF5FCB','447867','',null,'2018-11-26 20:50:48.770',0x0000120004,'GBP','577',7591229857767875,'0',1053,0,0,3,0,7591229857767875,0,0,'819',0,-1,null,'819',3,null,'2018-11-26 20:51:00','2018-11-26 20:51:20.980',0,0,0,0,0,null);
    41. 

  41. INSERT INTO dbo.Cards (ID,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 (64909189,7598406073257928,'/N/A','00','0','','440','2019-04-27 03:20:17.607',84.00,0.00,759,null,9029,1,'2018-10-23 10:02:33.877','2022-03-31 00:00:00','N/A',221,'2022-03-31 00:00:00',null,'55DB15E6832F1729','587735','',null,'2019-04-27 03:20:17.607',0x0000120004,'GBP','763',7598406073257928,'0',1053,0,0,3,0,7598406073257928,0,681,'706',0,-1,null,'706',3,null,'2019-04-27 03:20:00',null,0,0,0,2,0,0.0000);
    42. 

  42. INSERT INTO dbo.Cards (ID,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 (65498035,8068355351794216,'/N/A','00','0','','101','2018-11-26 20:41:20.540',120.00,0.00,806,null,9093,1,'2018-09-19 23:01:11.597','2020-10-31 00:00:00','N/A',221,'2020-10-31 00:00:00',null,'351703E21B85BBC3','681122','',null,'2018-11-26 20:40:50.540',0x0000100004,'GBP','772',8068355351794216,'0',1053,0,0,3,426,8068355351794216,0,0,'980',0,-1,null,'980',3,null,'2018-11-26 20:41:00',null,0,0,0,0,0,null);
    43. 

  43. INSERT INTO dbo.Cards (ID,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 (65498044,8068355707321776,'/N/A','00','0','','669','2018-11-26 20:42:25.303',120.00,0.00,806,null,9093,1,'2018-09-19 23:01:10.877','2020-10-31 00:00:00','N/A',221,'2020-10-31 00:00:00',null,'EC1FC4E1BAE79BA3','649558','',null,'2018-11-26 20:41:55.303',0x0000100004,'GBP','044',8068355707321776,'0',1053,0,0,3,426,8068355707321776,0,0,'135',0,-1,null,'135',3,null,'2018-11-26 20:42:00',null,0,0,0,0,0,null);
    44. 

  44. 

  45. SET IDENTITY_INSERT [dbo].[Cards] OFF
    46.