USE [AlexisPTSTokenTest]
GO

SET QUOTED_IDENTIFIER ON
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 401234525
           ,401344526
           ,4014012345250008
           ,NULL
           ,'933A0019D7A00FC0'
           ,4014013445260008
           ,'7DE42586806A1AC8'
           ,40123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 501556556
           ,501556557
           ,5015015565560005
           ,NULL
           ,'1418214235C87C8E'
           ,5015015565570005
           ,'67F90D389283DB03'
           ,50123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 401234633
           ,401234899
           ,4014012346330007
           ,NULL
           ,'E0B96BF058E3CA74'
           ,4014012348990007
           ,'0C8BC210BC6F83AF'
           ,40123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 501234633
           ,501234899
           ,5015012346330004
           ,NULL
           ,'DD6C9DA8C950E68D'
           ,5015012348990004
           ,'3D3EA69E98E05776'
           ,50123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 401633333
           ,401965436
           ,4014016333330006
           ,NULL
           ,'4C6D67CD9695FF6F'
           ,4014019654360006
           ,'263224EAEC2A453E'
           ,40123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 501633333
           ,501965436
           ,5014016333330003
           ,NULL
           ,'6E87DBB8FF84E855'
           ,5014019654360003
           ,'868F3256C0D07EEF'
           ,50123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 401656566
           ,401323457
           ,4014016565660005
           ,NULL
           ,'B256BE192F6CC0C1'
           ,4014013234570005
           ,'543BBB0F4FA53325'
           ,40123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 501695412
           ,501963145
           ,5015016954120002
           ,NULL
           ,'F2DD2D9ACDA6428E'
           ,5015019631450002
           ,'4E0E4D4BB8029E5E'
           ,50123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 401785623
           ,401412563
           ,4014017856230004
           ,NULL
           ,'258E6AE13EFF7AA7'
           ,4014014125630004
           ,'44019E94AE780D00'
           ,40123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 501859613
           ,501741235
           ,5015018596130001
           ,NULL
           ,'FCE4792BBF5928B4'
           ,5015017412350001
           ,'414DF2195ACE369D'
           ,40123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 401678954
           ,401654321
           ,4014016789540000
           ,NULL
           ,'2853CA832038BC7C'
           ,4014016543210000
           ,'95221F231953A493D4C54237F48F333E'
           ,40123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 501565656
           ,501323232
           ,5015015656560009
           ,NULL
           ,'5D13B76F0E8A93AA'
           ,5015013232320009
           ,'0726B56469A6EFC86F48CA4020A8BA4E'
           ,50123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 401456745
           ,401789543
           ,4014014567450007
           ,NULL
           ,'1CA7AB030530B8D9'
           ,[REDACTED]
           ,'8A675E8164FAC9C303250F26BA603439'
           ,40123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 501458976
           ,501658934
           ,5015014589760400
           ,NULL
           ,'3AB19C4F3C88C05A'
           ,5015016589340400
           ,'3D3EA69E98E0577629A153619057F7B2'
           ,50123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 401434546
           ,401675489
           ,4014014345460000
           ,NULL
           ,'143FA75380B94698'
           ,4014016754890000
           ,'54F96B67809F9698'
           ,40123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 501456745
           ,501789543
           ,5015014567450009
           ,NULL
           ,'96398333788BA7FF'
           ,5015017895430009
           ,'168B15DBBA29F6FA'
           ,50123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 405543289
           ,405789543
           ,4014055432890305
           ,NULL
           ,'FFFDD51D8927A229'
           ,4014057895430305
           ,'D073955309AD4EAC'
           ,40123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 505543289
           ,505789543
           ,5015055432890302
           ,NULL
           ,'26CE881BCA431DA2'
           ,5015057895430302
           ,'AE14A5F55EEB2075'
           ,50123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 407543289
           ,407789543
           ,[REDACTED]
           ,NULL
           ,'A0141A8453C6768F'
           ,4014077895434002
           ,'98426A7D156B2B72'
           ,40123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 509543289
           ,505989543
           ,5015095432894001
           ,NULL
           ,'24E4C3BDA85316BD'
           ,5015059895434001
           ,'304178B36563A316'
           ,50123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 401357951
           ,401159753
           ,[REDACTED]
           ,NULL
           ,'9EECA80FAF5EBC5B'
           ,[REDACTED]
           ,'8A675E8164FAC9C3B5B3552B56AB2DF2'
           ,40123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( 501741963
           ,501963147
           ,5015017419630007
           ,NULL
           ,'CDF8F04512C12EC1'
           ,5015019631470007
           ,'EA55256169E981C45575C628AA9E12EB'
           ,50123400
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( '058262649'
           ,'058999987'
           ,'5880582626498326'
           ,NULL
           ,'2FB1D68B0064A5D8'
           ,'5880589999878326'
           ,'4B1C3208C8D1A149'
           ,'05876500'
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( '058984549'
           ,'058887587'
           ,'5890589845494885'
           ,NULL
           ,'8513CEFDEB3A12B5'
           ,'5890588875874885'
           ,'52ABBBAA9A075A4F'
           ,'05876500'
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( '058978556'
           ,'058555459'
           ,'5870589785566874'
           ,NULL
           ,'FB8D625E0E436CCB'
           ,'5870585554596874'
           ,'89216DA7FE79D90A299F2843063DDD45'
           ,'05876500'
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( '048788954'
           ,'048335978'
           ,'4870487889549773'
           ,NULL
           ,'FCA4D27F2C1D78D1'
           ,'4870483359789773'
           ,'8046E2C7188F85BA'
           ,'04876500'
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( '048987777'
           ,'048112455'
           ,'4880489877772644'
           ,NULL
           ,'3E83D5EFA43F1659'
           ,'4880481124552644'
           ,'C6CE3574E014F034'
           ,'04876500'
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO

INSERT INTO [dbo].[PANTokenMapping]
           ([PRITOKEN]
           ,[PUBTOKEN]
           ,[PANT]
           ,[PIN_BLOCK]
           ,[mcPINBlock]
           ,[PanPubT]
           ,[ENCRYPAN]
           ,[BinRange]
           ,[SubBINRange]
           ,[CheckValue]
           ,[GDate]
           ,[FileName])
     VALUES
          ( '048114571'
           ,'048911547'
           ,'4890481145717981'
           ,NULL
           ,'222'
           ,'4890489115477981'
           ,'924DD35BB00BE0D0A5D39D0BEA15F9CC'
           ,'04876500'
           ,NULL
           ,'PB0D28MB71EE'
           ,getdate()
           ,NULL)
GO