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
           ([REDACTED]
           ,'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'
           ,[REDACTED]
           ,NULL
           ,1
           ,NULL
           ,0
           ,3
           ,NULL
           ,[REDACTED]
           ,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
           ([REDACTED]
           ,'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'
           ,[REDACTED]
           ,NULL
           ,1
           ,NULL
           ,0
           ,3
           ,NULL
           ,[REDACTED]
           ,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