| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789 |
- 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'
- ,4014017895430007
- ,'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
- ,4014075432894002
- ,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
- ,4014013579510008
- ,NULL
- ,'9EECA80FAF5EBC5B'
- ,4014011597530008
- ,'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
|
