Posts: 119
Threads: 23
Joined: Mar 2026
Live Nation / TicketMaster
Data includes
100 million customers full details (name, address, email, phone)
Ticket sales, event information, order details.
CC detail - customer, last 4 of card, expiration date.
customer fraud details
much more
Quote:Telegram @Ratxs
Quote:Qtox: 48C1944F498B0751F8A6E7812A1CCC4E8A523CEE73D6F90830A1A48996FCF20A69F3197BD715
Quote:Session: 05b58ef0e61b6ccbdaf610df244eec2ea088c7ac0abb0a6cac9e7b4693a39b5557
Data Sample:
==> PATRON_LKUP_0_1_0.csv <==
"OFFSET_TS","PATRON_LKUP_ID","PATRON_LKUP_TYPE_CD","MEMBERDB_CUST_ID","EMAIL_ADDR","CRM_EMAIL_ID","ECDB_CUSTOMER_ID","PATRON_ID","LAST_BATCH_ID","INIT_RUN_ID","LAST_RUN_ID","SRC_LAST_MOD_TS","TD_INSERT_TS","TD_UPDATE_TS","SPLITID","UPDATED_TS"
"1900-01-01 00:00:00.000",137480236,"DACSCAN",707027268,"[email protected]",\\N,\\N,92823101,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",161,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",153713869,"DACSCAN",593497444,"[email protected]",\\N,\\N,83538625,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",169,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",26194293,"MEMBERDB_CUST_ID",123136663,"[email protected]",\\N,\\N,26194293,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",150,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",17524762,"MEMBERDB_CUST_ID",47735084,"[email protected]",\\N,\\N,17524762,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",152,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",77755238,"MEMBERDB_CUST_ID",549790508,"[email protected]",\\N,\\N,77755238,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",86772060,"MEMBERDB_CUST_ID",623959386,"[email protected]",\\N,\\N,86772060,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",173,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",175848192,"ECDB_CUSTOMER_ID",\\N,"[email protected]",\\N,4298333,175848192,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",167,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",80864190,"MEMBERDB_CUST_ID",571603886,"[email protected]",\\N,\\N,80864190,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",112102474,"MEMBERDB_CUST_ID",1024028567,"[email protected]",\\N,\\N,112102474,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",154,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",76645510,"MEMBERDB_CUST_ID",542699026,"[email protected]",\\N,\\N,76645510,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",164,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",29944083,"MEMBERDB_CUST_ID",156448483,"[email protected]",\\N,\\N,29944083,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",152,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",4407671,"MEMBERDB_CUST_ID",4483602,"[email protected]",\\N,\\N,4407671,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",159,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",197009983,"ECDB_CUSTOMER_ID",\\N,"[email protected]",\\N,30049587,197009983,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",153,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",167133679,"DACSCAN",451221308,"[email protected]",\\N,\\N,61798519,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",156,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",149941973,"DACSCAN",41372501,"[email protected]",\\N,\\N,16469298,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",170,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",215507814,"ECDB_CUSTOMER_ID",477885508,"[email protected]",\\N,49519801,215507814,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",157,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",119635763,"DACSCAN",600511268,"[email protected]",\\N,\\N,84373759,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",164,"2018-07-23 13:30:03.914 -0700"
"2015-05-10 13:59:45.000",1293198613,"DACSCAN",488463088,"[email protected]",-1,\\N,67994185,3095454,\\N,3095454,"2015-05-08 00:00:00.000","2015-05-10 11:18:09.000","2015-05-10 11:48:21.000",158,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",87118684,"MEMBERDB_CUST_ID",627679428,"[email protected]",\\N,\\N,87118684,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",164,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",155727857,"DACSCAN",662137987,"[email protected]",\\N,\\N,89779260,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",161,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",143038426,"DACSCAN",-1,"[email protected]",\\N,\\N,86109008,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",151,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",89465552,"MEMBERDB_CUST_ID",657553587,"[email protected]",\\N,\\N,89465552,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",151,"2018-07-23 13:30:03.914 -0700"
"2015-07-25 19:42:55.000",1302713489,"CRM",1735104726,"[email protected]",200305046,\\N,1302539195,3202390,\\N,3202390,"2015-07-25 00:21:40.000","2015-07-25 19:20:30.000","2015-07-25 19:37:25.000",154,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",212029968,"ECDB_CUSTOMER_ID",\\N,"[email protected]",\\N,46039104,212029968,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",157,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",208122384,"ECDB_CUSTOMER_ID",489856743,"[email protected]",\\N,41727234,208122384,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",153,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",35788047,"MEMBERDB_CUST_ID",208311980,"[email protected]",\\N,\\N,35788047,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",198373446,"ECDB_CUSTOMER_ID",394296380,"[email protected]",\\N,31977860,198373446,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",169,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",114661439,"DACSCAN",-1,"[email protected]",\\N,\\N,110788818,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",151,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",130835728,"DACSCAN",-1,"[email protected]",\\N,\\N,97348035,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",165,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",4231403,"MEMBERDB_CUST_ID",4307294,"[email protected]",\\N,\\N,4231403,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",173,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",121633586,"DACSCAN",932261947,"[email protected]",\\N,\\N,107751757,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",164,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",208805531,"ECDB_CUSTOMER_ID",362210881,"[email protected]",\\N,42812223,208805531,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",162,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",199668824,"ECDB_CUSTOMER_ID",\\N,"[email protected]",\\N,33273326,199668824,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",171,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",49205794,"MEMBERDB_CUST_ID",330284663,"[email protected]",\\N,\\N,49205794,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",154,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",124101271,"DACSCAN",-1,"[email protected]",\\N,\\N,98945088,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",152,"2018-07-23 13:30:03.914 -0700"
"2018-04-03 19:04:09.000",1944746670,"TNOW",-1,"[email protected]",-1,\\N,1944746670,\\N,\\N,\\N,"2016-11-14 20:44:25.000","2018-04-03 18:30:38.000","2018-04-03 19:04:09.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",54392055,"MEMBERDB_CUST_ID",383363480,"[email protected]",\\N,\\N,54392055,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",155,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",17851953,"MEMBERDB_CUST_ID",50304283,"[email protected]",\\N,\\N,17851953,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",155,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",115281475,"DACSCAN",-1,"[email protected]",\\N,\\N,48746902,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",164,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",67631254,"MEMBERDB_CUST_ID",486147704,"[email protected]",\\N,\\N,67631254,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",170,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",132723555,"DACSCAN",45397704,"[email protected]",\\N,\\N,17167803,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",169,"2018-07-23 13:30:03.914 -0700"
"2018-04-03 19:04:09.000",1952639778,"TNOW",-1,"[email protected]",-1,\\N,1730837529,\\N,\\N,\\N,"2017-06-19 07:48:15.000","2018-04-03 18:30:38.000","2018-04-03 19:04:09.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",89954813,"MEMBERDB_CUST_ID",664698168,"[email protected]",\\N,\\N,89954813,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",22055688,"MEMBERDB_CUST_ID",86230164,"[email protected]",\\N,\\N,22055688,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",173,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",110831671,"MEMBERDB_CUST_ID",976949286,"[email protected]",\\N,\\N,110831671,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",171,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",728027,"MEMBERDB_CUST_ID",802493,"[email protected]",\\N,\\N,728027,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",150,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",83971171,"MEMBERDB_CUST_ID",597115584,"[email protected]",\\N,\\N,83971171,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",155,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",78319852,"MEMBERDB_CUST_ID",553274668,"[email protected]",\\N,\\N,78319852,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",152,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",8729661,"MEMBERDB_CUST_ID",8806437,"[email protected]",\\N,\\N,8729661,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",163,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",76379865,"MEMBERDB_CUST_ID",541067941,"[email protected]",\\N,\\N,76379865,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",153,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",140892298,"DACSCAN",843576686,"[email protected]",\\N,\\N,101755100,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",158,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",69261058,"MEMBERDB_CUST_ID",496467380,"[email protected]",\\N,\\N,69261058,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",166,"2018-07-23 13:30:03.914 -0700"
"1900-01-01
==> SALES_ORD_EVENT_PMT_0_0_0.csv <==
"SALES_ORD_ID","HOST_SYS_CD","HOST_VAX_ACCT_NUM","HOST_ACCT_CREATE_DT","EVENT_ID","EVENT_ID_SRC_SYS_CD","SALES_ORD_PMT_NUM","PMT_METHOD_ID","SRC_PMT_METHOD_CD","PMT_METHOD_TYPE_CD","PMT_AMT","STREET_ADDR_VERIFICATION_CD","FRAUD_CD","PMT_DT","PMT_OPR_ID","PMT_OPR_CD","OVRRD_PMT_OPR_TYPE_CD","LAST_BATCH_ID","INIT_RUN_ID","LAST_RUN_ID","INIT_RUN_TS","LAST_RUN_TS","PMT_METHOD_TYPE_ID","PMT_USED_OPR_CD","MIMIC_FLG","REJECT_FLG","AUTH_FLG","REJECT_NUM","KAFKA_PARTITION","KAFKA_OFFSET","KAFKA_TOPIC","KAFKA_TIMESTAMP","UPDATED_TS"
44785347,"NY5","49-48206","2010-04-11","2089744460485843998","EVENTDB","1",24351318,"qbET94glnVohnf0SFPXnwsTsYB797EQZnke03MKbSZV8OrMrPHQBwiC7XF7+Nf2lmmO2Fj/a2LPA9FfZGqDLOA==","VISA",2.5000,"S","0","2010-04-11",\\N,"ZIQ134","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","T","F",23,0,293638156,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:56:52.596","2020-09-19 15:17:50.705"
10149526478,"DET","22-27078","2015-02-20","576545853164447579","EVENTDB","3",221282194,"zMQs7xxV+d2YHZjA6rbsSdG97WtEuGt9hvXH1jpYTGLATKR3FxoAIP1B4Xh0hpcFSBjN2trcZd4AX7Us9waCAA==","VISA",80.0000,"Z","9","2015-02-20",\\N,"ZIK148","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,293077109,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:47:58.407","2020-09-19 15:17:50.705"
10037737995,"NEV","24-45569","2012-06-01","1657403233966447115","EVENTDB","1",167433024,"Cx2vqtpJ2ORo+dLGGmGZKpAxazxDOQTzZoXEZxdWFyl1D2Db2BAR8eXFf2d1FFlXFax2tENCjz8/23D7vWeVpQ==","VISA",2.5000,"Y","9","2012-06-01",\\N,"ZIR320","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,293075072,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:47:56.407","2020-09-19 15:17:50.705"
37275811,"MTN","60-24889","2010-06-07","2161803166363443917","EVENTDB","1",28275427,"0B3qsmXsZ3Hqq2hdL8E5GdAF4fN/rNceFlljngX5ieOR1iX16+brBfjPDaVWSQQ6N2txgupVCyMK3BzzkC8ndg==","MC",35.0000,"Y","0","2010-06-07",\\N,"ZIR152","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",11,"\N","\N","F","T",\\N,0,293423047,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:53:34.254","2020-09-19 15:17:50.705"
39409625,"NCA","63-54038","2010-02-26","2017687661647986903","EVENTDB","1",25826926,"gUXJ/JyPfO2QOdZvl+1gDwR7RKBWmd9moWd3+lvBqUIdRFuuV4H/j82k2G8WznKtu4sfpTaL17kmS0Py//2h6w==","AMX",74.9500,"Y","0","2010-02-26",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",10,"\N","\N","F","T",\\N,0,293620061,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:56:37.011","2020-09-19 15:17:50.705"
10130308716,"MXC","19-25702","2012-05-17","1441230616142452458","EVENTDB","5",214562879,"LYyt1JDXLDcpmNt6FxlACo2k9xbsUeqlD+yaFhM1dXbm1vofIVYRfBo6pPie7BB6Uj/1XynPo3lCFw/SCQwnhQ==","VISA",135.0000,"S","10","2012-05-17",\\N,"ZMC012","P",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",25,"\N","\N","F","T",\\N,0,293562332,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:55:44.879","2020-09-19 15:17:50.705"
188501217,"CH2","10-30302","2006-07-13","360354634159743312","EVENTDB","1",133369002,"UznYL8bkWBk0mJ/Dc30YTXMe7/LUkznxeeAJZ4EohwjkM2wh5wYTqPDdBn+LevYgDux7ZfgQaP3vC/ilYw4gkQ==","AMX",176.5000,"Y","0","2006-07-13",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",10,"\N","\N","F","T",\\N,0,293669290,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:57:23.789","2020-09-19 15:17:50.705"
241450545,"NY4","24-14875","2006-08-07","216238240938221991","EVENTDB","2",118380726,"HWj4Idx44DgFVUtn1tTt6A6BIZdP57OA2u1Bm3KvhaU024EsgwUi2Hjwyipn4sTaUaDAhfFX9PegTcQoLHPRjg==","MC",-1.7500,"","2","2006-08-07",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",11,"\N","\N","F","T",\\N,0,293464402,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:54:11.950","2020-09-19 15:17:50.705"
125293309,"NY5","67-39943","2008-06-30","2089741521932006947","EVENTDB","1",63214349,"oLJe7GqasBrjsUJ7egkl+iJV1S4djb7PiCc2/m1a1v8Xx+IhdFZ0cv0f9/347G6m4O4EU0sv99Q1kSyqwvzbWw==","AMX",160.3000,"Y","0","2008-06-30",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",10,"\N","\N","F","T",\\N,0,292934386,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:45:44.538","2020-09-19 15:17:50.705"
10120869364,"WES","27-23776","2014-08-20","720660373808436848","EVENTDB","1",6787263,"9SDKZbqSxdxEjmZ+6RnarbGaepSk1W6o9dsj8dkONh31Ty1XBQtDvseNWHM/ePCdOny451AbN2RYWRiIGRW9jA==","MC",450.0000,"Y","9","2014-08-20",\\N,"ZIH466","A",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",11,"\N","\N","F","T",\\N,0,292863596,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:44:40.805","2020-09-19 15:17:50.705"
204318566,"DAL","45-46221","2006-07-31","864758154409246949","EVENTDB","1",38356155,"SVSj12AOMAIgv4sRKbf5aHqNIGTgFRyGo7c/2RQQjpdSpH6VCGp+5/RDRZWzVAZxB+tBcHqw4TQEGPGzd91PVA==","VISA",175.9000,"Y","0","2006-07-31",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",10,"\N","\N","F","T",\\N,0,293503294,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:54:47.708","2020-09-19 15:17:50.705"
164417359,"NY5","27-35146","2007-04-14","2089738925525228258","EVENTDB","1",4243438,"UbGYctnmPplijP4lFq1QbpqoZ9sS7FWT8jLynH5fkMp/HlrmDUQep+8+FAyQ51hBG+1pM5TsKjp+CQ6HCv7UNA==","VISA",45.8000,"Y","1","2007-04-14",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,293220893,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:50:23.600","2020-09-19 15:17:50.705"
250236853,"PHI","3-25288","2004-01-24","144176278299595206","EVENTDB","1",115037095,"tQTFVYEznmC/XBxdJL+2Dggyji06HIqmKZyGem//W98nbyyD+B1e+OMSmJPqltriDa6fMdsKQ+n8RbxScw4IRQ==","VISA",2.5000,"1","0","2004-01-24",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","T","F",\\N,0,292911873,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:45:24.833","2020-09-19 15:17:50.705"
10117822915,"SCS","18-35252","2014-07-23","1945638069105127426","EVENTDB","1",203163391,"+6WI4woF3H0d3k+QvJnyvD2yP3VNgl62etN+OpQvdsLLTiJ1P6eEbvFKUCKNXSTDgGRG5zu24LwPnkQH4Rz2LQ==","VISA",234.2800,"Y","9","2014-07-23",\\N,"ZIK260","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,293258305,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:50:59.461","2020-09-19 15:17:50.705"
10152157463,"CH6","22-18400","2015-03-07","1585351963736955482","EVENTDB","1",222274642,"DwHz+EcE2LyNbZuqHb7N4ol7DBPSADQ67PEFUZ33juJp9qo67jC4fzkeaungC+U0EGxsz99jt3sAQh52tXZrLg==","MC",69.6900,"Y","9","2015-03-07",\\N,"ZIZ211","A",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",11,"\N","\N","F","T",\\N,0,292804322,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:43:43.483","2020-09-19 15:17:50.705"
219258939,"LA2","15-46591","2003-10-29","792692473466273174","EVENTDB","2",108747266,"Z9VJMttJhQ3aRtx7RL4fHaUItS+RzgHNk7P6U8vzb1pXQYwKSTtgJZqRo6MLfSj02ow/B2Bo0SIAcjPujEqFbA==","VISA",-14.5000,"Y","0","2003-10-29",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","T","F",\\N,0,293295713,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:51:35.110","2020-09-19 15:17:50.705"
25906119,"CH5","12-45219","2010-01-29","504476969614148687","EVENTDB","1",23951452,"8xK1dz2KPECmpHrqWmvSiQr6BezhxCJFyk3ehHTLnL16vwi0DDG9tgp1jtIgF/1D+XYR97ShBtrjWvEyJfhB0g==","VISA",258.6500,"Y","0","2010-01-29",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,292852430,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:44:28.631","2020-09-19 15:17:50.705"
10026696478,"T44","50-38851","2012-02-16","3170612759667229139","EVENTDB","1",160878629,"XzeGGwMlmDbezvpz27sEB5RTMbJr6t0a0W31SgsYy6fOb4rrOSNl7cn5qUspzMKQyybBRRt+gRSJmdKDE/W9KA==","VISA",222.2000,"Y","9","2012-02-16",\\N,"ZIZ192","A",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,293252029,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:50:52.850","2020-09-19 15:17:50.705"
267197811,"VAN","8-43807","2003-05-28","1225038631072257870","EVENTDB","1",102808090,"Z5GXs0/ANGTBHPG8H2A+jhE5tCEWqYGNK48Yf+J9hg67t6Y1F+d3F2ydOZWhPFFCBjLEJ4g9eboACRLQoPk4Bg==","MC",44.1000,"","0","2003-05-28",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",11,"\N","\N","F","T",\\N,0,293628627,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:56:44.845","2020-09-19 15:17:50.705"
10072962777,"TOR","16-56951","2013-05-29","1153003598773197636","EVENTDB","1",176891619,"5TQ0neRjjQL6Pvq4CeLaL01H32MoZjHRL8HLJN7x3tVloDZOj5wfIzQOMCPYHa9Fkgtf1oirwId5bBzaDSUwww==","VISA",93.8500,"Y","9","2013-05-29",\\N,"ZIL553","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",12,"\N","\N","T","F",0,0,292980261,"prd1831_preprod0_avro_pfocusvw-sales_o
Reply
Reply
Reply
Reply
Reply
Posts: 10
Threads: 0
Joined: Apr 2026
22-05-26, 02:21 AM
(This post was last modified: 22-05-26, 02:21 AM by ByteHunter.)
(16-04-26, 03:53 AM)OnarDev Wrote: Live Nation / TicketMaster
Data includes
100 million customers full details (name, address, email, phone)
Ticket sales, event information, order details.
CC detail - customer, last 4 of card, expiration date.
customer fraud details
much more
Quote:Telegram @Ratxs
Quote:Qtox: 48C1944F498B0751F8A6E7812A1CCC4E8A523CEE73D6F90830A1A48996FCF20A69F3197BD715
Quote:Session: 05b58ef0e61b6ccbdaf610df244eec2ea088c7ac0abb0a6cac9e7b4693a39b5557
Data Sample:
==> PATRON_LKUP_0_1_0.csv <==
"OFFSET_TS","PATRON_LKUP_ID","PATRON_LKUP_TYPE_CD","MEMBERDB_CUST_ID","EMAIL_ADDR","CRM_EMAIL_ID","ECDB_CUSTOMER_ID","PATRON_ID","LAST_BATCH_ID","INIT_RUN_ID","LAST_RUN_ID","SRC_LAST_MOD_TS","TD_INSERT_TS","TD_UPDATE_TS","SPLITID","UPDATED_TS"
"1900-01-01 00:00:00.000",137480236,"DACSCAN",707027268,"[email protected]",\\N,\\N,92823101,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",161,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",153713869,"DACSCAN",593497444,"[email protected]",\\N,\\N,83538625,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",169,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",26194293,"MEMBERDB_CUST_ID",123136663,"[email protected]",\\N,\\N,26194293,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",150,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",17524762,"MEMBERDB_CUST_ID",47735084,"[email protected]",\\N,\\N,17524762,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",152,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",77755238,"MEMBERDB_CUST_ID",549790508,"[email protected]",\\N,\\N,77755238,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",86772060,"MEMBERDB_CUST_ID",623959386,"[email protected]",\\N,\\N,86772060,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",173,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",175848192,"ECDB_CUSTOMER_ID",\\N,"[email protected]",\\N,4298333,175848192,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",167,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",80864190,"MEMBERDB_CUST_ID",571603886,"[email protected]",\\N,\\N,80864190,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",112102474,"MEMBERDB_CUST_ID",1024028567,"[email protected]",\\N,\\N,112102474,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",154,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",76645510,"MEMBERDB_CUST_ID",542699026,"[email protected]",\\N,\\N,76645510,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",164,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",29944083,"MEMBERDB_CUST_ID",156448483,"[email protected]",\\N,\\N,29944083,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",152,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",4407671,"MEMBERDB_CUST_ID",4483602,"[email protected]",\\N,\\N,4407671,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",159,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",197009983,"ECDB_CUSTOMER_ID",\\N,"[email protected]",\\N,30049587,197009983,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",153,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",167133679,"DACSCAN",451221308,"[email protected]",\\N,\\N,61798519,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",156,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",149941973,"DACSCAN",41372501,"[email protected]",\\N,\\N,16469298,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",170,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",215507814,"ECDB_CUSTOMER_ID",477885508,"[email protected]",\\N,49519801,215507814,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",157,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",119635763,"DACSCAN",600511268,"[email protected]",\\N,\\N,84373759,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",164,"2018-07-23 13:30:03.914 -0700"
"2015-05-10 13:59:45.000",1293198613,"DACSCAN",488463088,"[email protected]",-1,\\N,67994185,3095454,\\N,3095454,"2015-05-08 00:00:00.000","2015-05-10 11:18:09.000","2015-05-10 11:48:21.000",158,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",87118684,"MEMBERDB_CUST_ID",627679428,"[email protected]",\\N,\\N,87118684,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",164,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",155727857,"DACSCAN",662137987,"[email protected]",\\N,\\N,89779260,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",161,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",143038426,"DACSCAN",-1,"[email protected]",\\N,\\N,86109008,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",151,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",89465552,"MEMBERDB_CUST_ID",657553587,"[email protected]",\\N,\\N,89465552,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",151,"2018-07-23 13:30:03.914 -0700"
"2015-07-25 19:42:55.000",1302713489,"CRM",1735104726,"[email protected]",200305046,\\N,1302539195,3202390,\\N,3202390,"2015-07-25 00:21:40.000","2015-07-25 19:20:30.000","2015-07-25 19:37:25.000",154,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",212029968,"ECDB_CUSTOMER_ID",\\N,"[email protected]",\\N,46039104,212029968,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",157,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",208122384,"ECDB_CUSTOMER_ID",489856743,"[email protected]",\\N,41727234,208122384,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",153,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",35788047,"MEMBERDB_CUST_ID",208311980,"[email protected]",\\N,\\N,35788047,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",198373446,"ECDB_CUSTOMER_ID",394296380,"[email protected]",\\N,31977860,198373446,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",169,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",114661439,"DACSCAN",-1,"[email protected]",\\N,\\N,110788818,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",151,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",130835728,"DACSCAN",-1,"[email protected]",\\N,\\N,97348035,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",165,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",4231403,"MEMBERDB_CUST_ID",4307294,"[email protected]",\\N,\\N,4231403,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",173,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",121633586,"DACSCAN",932261947,"[email protected]",\\N,\\N,107751757,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",164,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",208805531,"ECDB_CUSTOMER_ID",362210881,"[email protected]",\\N,42812223,208805531,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",162,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",199668824,"ECDB_CUSTOMER_ID",\\N,"[email protected]",\\N,33273326,199668824,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",171,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",49205794,"MEMBERDB_CUST_ID",330284663,"[email protected]",\\N,\\N,49205794,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",154,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",124101271,"DACSCAN",-1,"[email protected]",\\N,\\N,98945088,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",152,"2018-07-23 13:30:03.914 -0700"
"2018-04-03 19:04:09.000",1944746670,"TNOW",-1,"[email protected]",-1,\\N,1944746670,\\N,\\N,\\N,"2016-11-14 20:44:25.000","2018-04-03 18:30:38.000","2018-04-03 19:04:09.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",54392055,"MEMBERDB_CUST_ID",383363480,"[email protected]",\\N,\\N,54392055,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",155,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",17851953,"MEMBERDB_CUST_ID",50304283,"[email protected]",\\N,\\N,17851953,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",155,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",115281475,"DACSCAN",-1,"[email protected]",\\N,\\N,48746902,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",164,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",67631254,"MEMBERDB_CUST_ID",486147704,"[email protected]",\\N,\\N,67631254,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",170,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",132723555,"DACSCAN",45397704,"[email protected]",\\N,\\N,17167803,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",169,"2018-07-23 13:30:03.914 -0700"
"2018-04-03 19:04:09.000",1952639778,"TNOW",-1,"[email protected]",-1,\\N,1730837529,\\N,\\N,\\N,"2017-06-19 07:48:15.000","2018-04-03 18:30:38.000","2018-04-03 19:04:09.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",89954813,"MEMBERDB_CUST_ID",664698168,"[email protected]",\\N,\\N,89954813,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",22055688,"MEMBERDB_CUST_ID",86230164,"[email protected]",\\N,\\N,22055688,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",173,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",110831671,"MEMBERDB_CUST_ID",976949286,"[email protected]",\\N,\\N,110831671,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",171,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",728027,"MEMBERDB_CUST_ID",802493,"[email protected]",\\N,\\N,728027,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",150,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",83971171,"MEMBERDB_CUST_ID",597115584,"[email protected]",\\N,\\N,83971171,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",155,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",78319852,"MEMBERDB_CUST_ID",553274668,"[email protected]",\\N,\\N,78319852,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",152,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",8729661,"MEMBERDB_CUST_ID",8806437,"[email protected]",\\N,\\N,8729661,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",163,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",76379865,"MEMBERDB_CUST_ID",541067941,"[email protected]",\\N,\\N,76379865,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",153,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",140892298,"DACSCAN",843576686,"[email protected]",\\N,\\N,101755100,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",158,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",69261058,"MEMBERDB_CUST_ID",496467380,"[email protected]",\\N,\\N,69261058,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",166,"2018-07-23 13:30:03.914 -0700"
"1900-01-01
==> SALES_ORD_EVENT_PMT_0_0_0.csv <==
"SALES_ORD_ID","HOST_SYS_CD","HOST_VAX_ACCT_NUM","HOST_ACCT_CREATE_DT","EVENT_ID","EVENT_ID_SRC_SYS_CD","SALES_ORD_PMT_NUM","PMT_METHOD_ID","SRC_PMT_METHOD_CD","PMT_METHOD_TYPE_CD","PMT_AMT","STREET_ADDR_VERIFICATION_CD","FRAUD_CD","PMT_DT","PMT_OPR_ID","PMT_OPR_CD","OVRRD_PMT_OPR_TYPE_CD","LAST_BATCH_ID","INIT_RUN_ID","LAST_RUN_ID","INIT_RUN_TS","LAST_RUN_TS","PMT_METHOD_TYPE_ID","PMT_USED_OPR_CD","MIMIC_FLG","REJECT_FLG","AUTH_FLG","REJECT_NUM","KAFKA_PARTITION","KAFKA_OFFSET","KAFKA_TOPIC","KAFKA_TIMESTAMP","UPDATED_TS"
44785347,"NY5","49-48206","2010-04-11","2089744460485843998","EVENTDB","1",24351318,"qbET94glnVohnf0SFPXnwsTsYB797EQZnke03MKbSZV8OrMrPHQBwiC7XF7+Nf2lmmO2Fj/a2LPA9FfZGqDLOA==","VISA",2.5000,"S","0","2010-04-11",\\N,"ZIQ134","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","T","F",23,0,293638156,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:56:52.596","2020-09-19 15:17:50.705"
10149526478,"DET","22-27078","2015-02-20","576545853164447579","EVENTDB","3",221282194,"zMQs7xxV+d2YHZjA6rbsSdG97WtEuGt9hvXH1jpYTGLATKR3FxoAIP1B4Xh0hpcFSBjN2trcZd4AX7Us9waCAA==","VISA",80.0000,"Z","9","2015-02-20",\\N,"ZIK148","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,293077109,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:47:58.407","2020-09-19 15:17:50.705"
10037737995,"NEV","24-45569","2012-06-01","1657403233966447115","EVENTDB","1",167433024,"Cx2vqtpJ2ORo+dLGGmGZKpAxazxDOQTzZoXEZxdWFyl1D2Db2BAR8eXFf2d1FFlXFax2tENCjz8/23D7vWeVpQ==","VISA",2.5000,"Y","9","2012-06-01",\\N,"ZIR320","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,293075072,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:47:56.407","2020-09-19 15:17:50.705"
37275811,"MTN","60-24889","2010-06-07","2161803166363443917","EVENTDB","1",28275427,"0B3qsmXsZ3Hqq2hdL8E5GdAF4fN/rNceFlljngX5ieOR1iX16+brBfjPDaVWSQQ6N2txgupVCyMK3BzzkC8ndg==","MC",35.0000,"Y","0","2010-06-07",\\N,"ZIR152","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",11,"\N","\N","F","T",\\N,0,293423047,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:53:34.254","2020-09-19 15:17:50.705"
39409625,"NCA","63-54038","2010-02-26","2017687661647986903","EVENTDB","1",25826926,"gUXJ/JyPfO2QOdZvl+1gDwR7RKBWmd9moWd3+lvBqUIdRFuuV4H/j82k2G8WznKtu4sfpTaL17kmS0Py//2h6w==","AMX",74.9500,"Y","0","2010-02-26",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",10,"\N","\N","F","T",\\N,0,293620061,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:56:37.011","2020-09-19 15:17:50.705"
10130308716,"MXC","19-25702","2012-05-17","1441230616142452458","EVENTDB","5",214562879,"LYyt1JDXLDcpmNt6FxlACo2k9xbsUeqlD+yaFhM1dXbm1vofIVYRfBo6pPie7BB6Uj/1XynPo3lCFw/SCQwnhQ==","VISA",135.0000,"S","10","2012-05-17",\\N,"ZMC012","P",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",25,"\N","\N","F","T",\\N,0,293562332,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:55:44.879","2020-09-19 15:17:50.705"
188501217,"CH2","10-30302","2006-07-13","360354634159743312","EVENTDB","1",133369002,"UznYL8bkWBk0mJ/Dc30YTXMe7/LUkznxeeAJZ4EohwjkM2wh5wYTqPDdBn+LevYgDux7ZfgQaP3vC/ilYw4gkQ==","AMX",176.5000,"Y","0","2006-07-13",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",10,"\N","\N","F","T",\\N,0,293669290,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:57:23.789","2020-09-19 15:17:50.705"
241450545,"NY4","24-14875","2006-08-07","216238240938221991","EVENTDB","2",118380726,"HWj4Idx44DgFVUtn1tTt6A6BIZdP57OA2u1Bm3KvhaU024EsgwUi2Hjwyipn4sTaUaDAhfFX9PegTcQoLHPRjg==","MC",-1.7500,"","2","2006-08-07",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",11,"\N","\N","F","T",\\N,0,293464402,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:54:11.950","2020-09-19 15:17:50.705"
125293309,"NY5","67-39943","2008-06-30","2089741521932006947","EVENTDB","1",63214349,"oLJe7GqasBrjsUJ7egkl+iJV1S4djb7PiCc2/m1a1v8Xx+IhdFZ0cv0f9/347G6m4O4EU0sv99Q1kSyqwvzbWw==","AMX",160.3000,"Y","0","2008-06-30",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",10,"\N","\N","F","T",\\N,0,292934386,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:45:44.538","2020-09-19 15:17:50.705"
10120869364,"WES","27-23776","2014-08-20","720660373808436848","EVENTDB","1",6787263,"9SDKZbqSxdxEjmZ+6RnarbGaepSk1W6o9dsj8dkONh31Ty1XBQtDvseNWHM/ePCdOny451AbN2RYWRiIGRW9jA==","MC",450.0000,"Y","9","2014-08-20",\\N,"ZIH466","A",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",11,"\N","\N","F","T",\\N,0,292863596,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:44:40.805","2020-09-19 15:17:50.705"
204318566,"DAL","45-46221","2006-07-31","864758154409246949","EVENTDB","1",38356155,"SVSj12AOMAIgv4sRKbf5aHqNIGTgFRyGo7c/2RQQjpdSpH6VCGp+5/RDRZWzVAZxB+tBcHqw4TQEGPGzd91PVA==","VISA",175.9000,"Y","0","2006-07-31",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",10,"\N","\N","F","T",\\N,0,293503294,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:54:47.708","2020-09-19 15:17:50.705"
164417359,"NY5","27-35146","2007-04-14","2089738925525228258","EVENTDB","1",4243438,"UbGYctnmPplijP4lFq1QbpqoZ9sS7FWT8jLynH5fkMp/HlrmDUQep+8+FAyQ51hBG+1pM5TsKjp+CQ6HCv7UNA==","VISA",45.8000,"Y","1","2007-04-14",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,293220893,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:50:23.600","2020-09-19 15:17:50.705"
250236853,"PHI","3-25288","2004-01-24","144176278299595206","EVENTDB","1",115037095,"tQTFVYEznmC/XBxdJL+2Dggyji06HIqmKZyGem//W98nbyyD+B1e+OMSmJPqltriDa6fMdsKQ+n8RbxScw4IRQ==","VISA",2.5000,"1","0","2004-01-24",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","T","F",\\N,0,292911873,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:45:24.833","2020-09-19 15:17:50.705"
10117822915,"SCS","18-35252","2014-07-23","1945638069105127426","EVENTDB","1",203163391,"+6WI4woF3H0d3k+QvJnyvD2yP3VNgl62etN+OpQvdsLLTiJ1P6eEbvFKUCKNXSTDgGRG5zu24LwPnkQH4Rz2LQ==","VISA",234.2800,"Y","9","2014-07-23",\\N,"ZIK260","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,293258305,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:50:59.461","2020-09-19 15:17:50.705"
10152157463,"CH6","22-18400","2015-03-07","1585351963736955482","EVENTDB","1",222274642,"DwHz+EcE2LyNbZuqHb7N4ol7DBPSADQ67PEFUZ33juJp9qo67jC4fzkeaungC+U0EGxsz99jt3sAQh52tXZrLg==","MC",69.6900,"Y","9","2015-03-07",\\N,"ZIZ211","A",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",11,"\N","\N","F","T",\\N,0,292804322,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:43:43.483","2020-09-19 15:17:50.705"
219258939,"LA2","15-46591","2003-10-29","792692473466273174","EVENTDB","2",108747266,"Z9VJMttJhQ3aRtx7RL4fHaUItS+RzgHNk7P6U8vzb1pXQYwKSTtgJZqRo6MLfSj02ow/B2Bo0SIAcjPujEqFbA==","VISA",-14.5000,"Y","0","2003-10-29",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","T","F",\\N,0,293295713,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:51:35.110","2020-09-19 15:17:50.705"
25906119,"CH5","12-45219","2010-01-29","504476969614148687","EVENTDB","1",23951452,"8xK1dz2KPECmpHrqWmvSiQr6BezhxCJFyk3ehHTLnL16vwi0DDG9tgp1jtIgF/1D+XYR97ShBtrjWvEyJfhB0g==","VISA",258.6500,"Y","0","2010-01-29",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,292852430,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:44:28.631","2020-09-19 15:17:50.705"
10026696478,"T44","50-38851","2012-02-16","3170612759667229139","EVENTDB","1",160878629,"XzeGGwMlmDbezvpz27sEB5RTMbJr6t0a0W31SgsYy6fOb4rrOSNl7cn5qUspzMKQyybBRRt+gRSJmdKDE/W9KA==","VISA",222.2000,"Y","9","2012-02-16",\\N,"ZIZ192","A",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,293252029,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:50:52.850","2020-09-19 15:17:50.705"
267197811,"VAN","8-43807","2003-05-28","1225038631072257870","EVENTDB","1",102808090,"Z5GXs0/ANGTBHPG8H2A+jhE5tCEWqYGNK48Yf+J9hg67t6Y1F+d3F2ydOZWhPFFCBjLEJ4g9eboACRLQoPk4Bg==","MC",44.1000,"","0","2003-05-28",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",11,"\N","\N","F","T",\\N,0,293628627,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:56:44.845","2020-09-19 15:17:50.705"
10072962777,"TOR","16-56951","2013-05-29","1153003598773197636","EVENTDB","1",176891619,"5TQ0neRjjQL6Pvq4CeLaL01H32MoZjHRL8HLJN7x3tVloDZOj5wfIzQOMCPYHa9Fkgtf1oirwId5bBzaDSUwww==","VISA",93.8500,"Y","9","2013-05-29",\\N,"ZIL553","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",12,"\N","\N","T","F",0,0,292980261,"prd1831_preprod0_avro_pfocusvw-sales_o
it's very old information
Reply
Reply
Reply
Reply
Reply
Posts: 10
Threads: 0
Joined: Apr 2026
(22-05-26, 02:21 AM)ByteHunter Wrote: (16-04-26, 03:53 AM)OnarDev Wrote: Live Nation / TicketMaster
Data includes
100 million customers full details (name, address, email, phone)
Ticket sales, event information, order details.
CC detail - customer, last 4 of card, expiration date.
customer fraud details
much more
Quote:Telegram @Ratxs
Quote:Qtox: 48C1944F498B0751F8A6E7812A1CCC4E8A523CEE73D6F90830A1A48996FCF20A69F3197BD715
Quote:Session: 05b58ef0e61b6ccbdaf610df244eec2ea088c7ac0abb0a6cac9e7b4693a39b5557
Data Sample:
==> PATRON_LKUP_0_1_0.csv <==
"OFFSET_TS","PATRON_LKUP_ID","PATRON_LKUP_TYPE_CD","MEMBERDB_CUST_ID","EMAIL_ADDR","CRM_EMAIL_ID","ECDB_CUSTOMER_ID","PATRON_ID","LAST_BATCH_ID","INIT_RUN_ID","LAST_RUN_ID","SRC_LAST_MOD_TS","TD_INSERT_TS","TD_UPDATE_TS","SPLITID","UPDATED_TS"
"1900-01-01 00:00:00.000",137480236,"DACSCAN",707027268,"[email protected]",\\N,\\N,92823101,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",161,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",153713869,"DACSCAN",593497444,"[email protected]",\\N,\\N,83538625,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",169,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",26194293,"MEMBERDB_CUST_ID",123136663,"[email protected]",\\N,\\N,26194293,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",150,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",17524762,"MEMBERDB_CUST_ID",47735084,"[email protected]",\\N,\\N,17524762,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",152,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",77755238,"MEMBERDB_CUST_ID",549790508,"[email protected]",\\N,\\N,77755238,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",86772060,"MEMBERDB_CUST_ID",623959386,"[email protected]",\\N,\\N,86772060,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",173,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",175848192,"ECDB_CUSTOMER_ID",\\N,"[email protected]",\\N,4298333,175848192,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",167,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",80864190,"MEMBERDB_CUST_ID",571603886,"[email protected]",\\N,\\N,80864190,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",112102474,"MEMBERDB_CUST_ID",1024028567,"[email protected]",\\N,\\N,112102474,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",154,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",76645510,"MEMBERDB_CUST_ID",542699026,"[email protected]",\\N,\\N,76645510,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",164,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",29944083,"MEMBERDB_CUST_ID",156448483,"[email protected]",\\N,\\N,29944083,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",152,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",4407671,"MEMBERDB_CUST_ID",4483602,"[email protected]",\\N,\\N,4407671,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",159,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",197009983,"ECDB_CUSTOMER_ID",\\N,"[email protected]",\\N,30049587,197009983,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",153,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",167133679,"DACSCAN",451221308,"[email protected]",\\N,\\N,61798519,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",156,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",149941973,"DACSCAN",41372501,"[email protected]",\\N,\\N,16469298,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",170,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",215507814,"ECDB_CUSTOMER_ID",477885508,"[email protected]",\\N,49519801,215507814,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",157,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",119635763,"DACSCAN",600511268,"[email protected]",\\N,\\N,84373759,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",164,"2018-07-23 13:30:03.914 -0700"
"2015-05-10 13:59:45.000",1293198613,"DACSCAN",488463088,"[email protected]",-1,\\N,67994185,3095454,\\N,3095454,"2015-05-08 00:00:00.000","2015-05-10 11:18:09.000","2015-05-10 11:48:21.000",158,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",87118684,"MEMBERDB_CUST_ID",627679428,"[email protected]",\\N,\\N,87118684,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",164,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",155727857,"DACSCAN",662137987,"[email protected]",\\N,\\N,89779260,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",161,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",143038426,"DACSCAN",-1,"[email protected]",\\N,\\N,86109008,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",151,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",89465552,"MEMBERDB_CUST_ID",657553587,"[email protected]",\\N,\\N,89465552,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",151,"2018-07-23 13:30:03.914 -0700"
"2015-07-25 19:42:55.000",1302713489,"CRM",1735104726,"[email protected]",200305046,\\N,1302539195,3202390,\\N,3202390,"2015-07-25 00:21:40.000","2015-07-25 19:20:30.000","2015-07-25 19:37:25.000",154,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",212029968,"ECDB_CUSTOMER_ID",\\N,"[email protected]",\\N,46039104,212029968,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",157,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",208122384,"ECDB_CUSTOMER_ID",489856743,"[email protected]",\\N,41727234,208122384,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",153,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",35788047,"MEMBERDB_CUST_ID",208311980,"[email protected]",\\N,\\N,35788047,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",198373446,"ECDB_CUSTOMER_ID",394296380,"[email protected]",\\N,31977860,198373446,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",169,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",114661439,"DACSCAN",-1,"[email protected]",\\N,\\N,110788818,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",151,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",130835728,"DACSCAN",-1,"[email protected]",\\N,\\N,97348035,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",165,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",4231403,"MEMBERDB_CUST_ID",4307294,"[email protected]",\\N,\\N,4231403,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",173,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",121633586,"DACSCAN",932261947,"[email protected]",\\N,\\N,107751757,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",164,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",208805531,"ECDB_CUSTOMER_ID",362210881,"[email protected]",\\N,42812223,208805531,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",162,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",199668824,"ECDB_CUSTOMER_ID",\\N,"[email protected]",\\N,33273326,199668824,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",171,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",49205794,"MEMBERDB_CUST_ID",330284663,"[email protected]",\\N,\\N,49205794,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",154,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",124101271,"DACSCAN",-1,"[email protected]",\\N,\\N,98945088,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",152,"2018-07-23 13:30:03.914 -0700"
"2018-04-03 19:04:09.000",1944746670,"TNOW",-1,"[email protected]",-1,\\N,1944746670,\\N,\\N,\\N,"2016-11-14 20:44:25.000","2018-04-03 18:30:38.000","2018-04-03 19:04:09.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",54392055,"MEMBERDB_CUST_ID",383363480,"[email protected]",\\N,\\N,54392055,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",155,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",17851953,"MEMBERDB_CUST_ID",50304283,"[email protected]",\\N,\\N,17851953,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",155,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",115281475,"DACSCAN",-1,"[email protected]",\\N,\\N,48746902,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",164,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",67631254,"MEMBERDB_CUST_ID",486147704,"[email protected]",\\N,\\N,67631254,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",170,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",132723555,"DACSCAN",45397704,"[email protected]",\\N,\\N,17167803,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",169,"2018-07-23 13:30:03.914 -0700"
"2018-04-03 19:04:09.000",1952639778,"TNOW",-1,"[email protected]",-1,\\N,1730837529,\\N,\\N,\\N,"2017-06-19 07:48:15.000","2018-04-03 18:30:38.000","2018-04-03 19:04:09.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",89954813,"MEMBERDB_CUST_ID",664698168,"[email protected]",\\N,\\N,89954813,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",174,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",22055688,"MEMBERDB_CUST_ID",86230164,"[email protected]",\\N,\\N,22055688,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",173,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",110831671,"MEMBERDB_CUST_ID",976949286,"[email protected]",\\N,\\N,110831671,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",171,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",728027,"MEMBERDB_CUST_ID",802493,"[email protected]",\\N,\\N,728027,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",150,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",83971171,"MEMBERDB_CUST_ID",597115584,"[email protected]",\\N,\\N,83971171,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",155,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",78319852,"MEMBERDB_CUST_ID",553274668,"[email protected]",\\N,\\N,78319852,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",152,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",8729661,"MEMBERDB_CUST_ID",8806437,"[email protected]",\\N,\\N,8729661,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",163,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",76379865,"MEMBERDB_CUST_ID",541067941,"[email protected]",\\N,\\N,76379865,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",153,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",140892298,"DACSCAN",843576686,"[email protected]",\\N,\\N,101755100,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",158,"2018-07-23 13:30:03.914 -0700"
"1900-01-01 00:00:00.000",69261058,"MEMBERDB_CUST_ID",496467380,"[email protected]",\\N,\\N,69261058,0,0,0,"\N","1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",166,"2018-07-23 13:30:03.914 -0700"
"1900-01-01
==> SALES_ORD_EVENT_PMT_0_0_0.csv <==
"SALES_ORD_ID","HOST_SYS_CD","HOST_VAX_ACCT_NUM","HOST_ACCT_CREATE_DT","EVENT_ID","EVENT_ID_SRC_SYS_CD","SALES_ORD_PMT_NUM","PMT_METHOD_ID","SRC_PMT_METHOD_CD","PMT_METHOD_TYPE_CD","PMT_AMT","STREET_ADDR_VERIFICATION_CD","FRAUD_CD","PMT_DT","PMT_OPR_ID","PMT_OPR_CD","OVRRD_PMT_OPR_TYPE_CD","LAST_BATCH_ID","INIT_RUN_ID","LAST_RUN_ID","INIT_RUN_TS","LAST_RUN_TS","PMT_METHOD_TYPE_ID","PMT_USED_OPR_CD","MIMIC_FLG","REJECT_FLG","AUTH_FLG","REJECT_NUM","KAFKA_PARTITION","KAFKA_OFFSET","KAFKA_TOPIC","KAFKA_TIMESTAMP","UPDATED_TS"
44785347,"NY5","49-48206","2010-04-11","2089744460485843998","EVENTDB","1",24351318,"qbET94glnVohnf0SFPXnwsTsYB797EQZnke03MKbSZV8OrMrPHQBwiC7XF7+Nf2lmmO2Fj/a2LPA9FfZGqDLOA==","VISA",2.5000,"S","0","2010-04-11",\\N,"ZIQ134","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","T","F",23,0,293638156,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:56:52.596","2020-09-19 15:17:50.705"
10149526478,"DET","22-27078","2015-02-20","576545853164447579","EVENTDB","3",221282194,"zMQs7xxV+d2YHZjA6rbsSdG97WtEuGt9hvXH1jpYTGLATKR3FxoAIP1B4Xh0hpcFSBjN2trcZd4AX7Us9waCAA==","VISA",80.0000,"Z","9","2015-02-20",\\N,"ZIK148","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,293077109,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:47:58.407","2020-09-19 15:17:50.705"
10037737995,"NEV","24-45569","2012-06-01","1657403233966447115","EVENTDB","1",167433024,"Cx2vqtpJ2ORo+dLGGmGZKpAxazxDOQTzZoXEZxdWFyl1D2Db2BAR8eXFf2d1FFlXFax2tENCjz8/23D7vWeVpQ==","VISA",2.5000,"Y","9","2012-06-01",\\N,"ZIR320","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,293075072,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:47:56.407","2020-09-19 15:17:50.705"
37275811,"MTN","60-24889","2010-06-07","2161803166363443917","EVENTDB","1",28275427,"0B3qsmXsZ3Hqq2hdL8E5GdAF4fN/rNceFlljngX5ieOR1iX16+brBfjPDaVWSQQ6N2txgupVCyMK3BzzkC8ndg==","MC",35.0000,"Y","0","2010-06-07",\\N,"ZIR152","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",11,"\N","\N","F","T",\\N,0,293423047,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:53:34.254","2020-09-19 15:17:50.705"
39409625,"NCA","63-54038","2010-02-26","2017687661647986903","EVENTDB","1",25826926,"gUXJ/JyPfO2QOdZvl+1gDwR7RKBWmd9moWd3+lvBqUIdRFuuV4H/j82k2G8WznKtu4sfpTaL17kmS0Py//2h6w==","AMX",74.9500,"Y","0","2010-02-26",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",10,"\N","\N","F","T",\\N,0,293620061,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:56:37.011","2020-09-19 15:17:50.705"
10130308716,"MXC","19-25702","2012-05-17","1441230616142452458","EVENTDB","5",214562879,"LYyt1JDXLDcpmNt6FxlACo2k9xbsUeqlD+yaFhM1dXbm1vofIVYRfBo6pPie7BB6Uj/1XynPo3lCFw/SCQwnhQ==","VISA",135.0000,"S","10","2012-05-17",\\N,"ZMC012","P",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",25,"\N","\N","F","T",\\N,0,293562332,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:55:44.879","2020-09-19 15:17:50.705"
188501217,"CH2","10-30302","2006-07-13","360354634159743312","EVENTDB","1",133369002,"UznYL8bkWBk0mJ/Dc30YTXMe7/LUkznxeeAJZ4EohwjkM2wh5wYTqPDdBn+LevYgDux7ZfgQaP3vC/ilYw4gkQ==","AMX",176.5000,"Y","0","2006-07-13",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",10,"\N","\N","F","T",\\N,0,293669290,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:57:23.789","2020-09-19 15:17:50.705"
241450545,"NY4","24-14875","2006-08-07","216238240938221991","EVENTDB","2",118380726,"HWj4Idx44DgFVUtn1tTt6A6BIZdP57OA2u1Bm3KvhaU024EsgwUi2Hjwyipn4sTaUaDAhfFX9PegTcQoLHPRjg==","MC",-1.7500,"","2","2006-08-07",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",11,"\N","\N","F","T",\\N,0,293464402,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:54:11.950","2020-09-19 15:17:50.705"
125293309,"NY5","67-39943","2008-06-30","2089741521932006947","EVENTDB","1",63214349,"oLJe7GqasBrjsUJ7egkl+iJV1S4djb7PiCc2/m1a1v8Xx+IhdFZ0cv0f9/347G6m4O4EU0sv99Q1kSyqwvzbWw==","AMX",160.3000,"Y","0","2008-06-30",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",10,"\N","\N","F","T",\\N,0,292934386,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:45:44.538","2020-09-19 15:17:50.705"
10120869364,"WES","27-23776","2014-08-20","720660373808436848","EVENTDB","1",6787263,"9SDKZbqSxdxEjmZ+6RnarbGaepSk1W6o9dsj8dkONh31Ty1XBQtDvseNWHM/ePCdOny451AbN2RYWRiIGRW9jA==","MC",450.0000,"Y","9","2014-08-20",\\N,"ZIH466","A",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",11,"\N","\N","F","T",\\N,0,292863596,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:44:40.805","2020-09-19 15:17:50.705"
204318566,"DAL","45-46221","2006-07-31","864758154409246949","EVENTDB","1",38356155,"SVSj12AOMAIgv4sRKbf5aHqNIGTgFRyGo7c/2RQQjpdSpH6VCGp+5/RDRZWzVAZxB+tBcHqw4TQEGPGzd91PVA==","VISA",175.9000,"Y","0","2006-07-31",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",10,"\N","\N","F","T",\\N,0,293503294,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:54:47.708","2020-09-19 15:17:50.705"
164417359,"NY5","27-35146","2007-04-14","2089738925525228258","EVENTDB","1",4243438,"UbGYctnmPplijP4lFq1QbpqoZ9sS7FWT8jLynH5fkMp/HlrmDUQep+8+FAyQ51hBG+1pM5TsKjp+CQ6HCv7UNA==","VISA",45.8000,"Y","1","2007-04-14",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,293220893,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:50:23.600","2020-09-19 15:17:50.705"
250236853,"PHI","3-25288","2004-01-24","144176278299595206","EVENTDB","1",115037095,"tQTFVYEznmC/XBxdJL+2Dggyji06HIqmKZyGem//W98nbyyD+B1e+OMSmJPqltriDa6fMdsKQ+n8RbxScw4IRQ==","VISA",2.5000,"1","0","2004-01-24",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","T","F",\\N,0,292911873,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:45:24.833","2020-09-19 15:17:50.705"
10117822915,"SCS","18-35252","2014-07-23","1945638069105127426","EVENTDB","1",203163391,"+6WI4woF3H0d3k+QvJnyvD2yP3VNgl62etN+OpQvdsLLTiJ1P6eEbvFKUCKNXSTDgGRG5zu24LwPnkQH4Rz2LQ==","VISA",234.2800,"Y","9","2014-07-23",\\N,"ZIK260","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,293258305,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:50:59.461","2020-09-19 15:17:50.705"
10152157463,"CH6","22-18400","2015-03-07","1585351963736955482","EVENTDB","1",222274642,"DwHz+EcE2LyNbZuqHb7N4ol7DBPSADQ67PEFUZ33juJp9qo67jC4fzkeaungC+U0EGxsz99jt3sAQh52tXZrLg==","MC",69.6900,"Y","9","2015-03-07",\\N,"ZIZ211","A",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",11,"\N","\N","F","T",\\N,0,292804322,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:43:43.483","2020-09-19 15:17:50.705"
219258939,"LA2","15-46591","2003-10-29","792692473466273174","EVENTDB","2",108747266,"Z9VJMttJhQ3aRtx7RL4fHaUItS+RzgHNk7P6U8vzb1pXQYwKSTtgJZqRo6MLfSj02ow/B2Bo0SIAcjPujEqFbA==","VISA",-14.5000,"Y","0","2003-10-29",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","T","F",\\N,0,293295713,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:51:35.110","2020-09-19 15:17:50.705"
25906119,"CH5","12-45219","2010-01-29","504476969614148687","EVENTDB","1",23951452,"8xK1dz2KPECmpHrqWmvSiQr6BezhxCJFyk3ehHTLnL16vwi0DDG9tgp1jtIgF/1D+XYR97ShBtrjWvEyJfhB0g==","VISA",258.6500,"Y","0","2010-01-29",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,292852430,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:44:28.631","2020-09-19 15:17:50.705"
10026696478,"T44","50-38851","2012-02-16","3170612759667229139","EVENTDB","1",160878629,"XzeGGwMlmDbezvpz27sEB5RTMbJr6t0a0W31SgsYy6fOb4rrOSNl7cn5qUspzMKQyybBRRt+gRSJmdKDE/W9KA==","VISA",222.2000,"Y","9","2012-02-16",\\N,"ZIZ192","A",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,"\N","\N","F","T",\\N,0,293252029,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:50:52.850","2020-09-19 15:17:50.705"
267197811,"VAN","8-43807","2003-05-28","1225038631072257870","EVENTDB","1",102808090,"Z5GXs0/ANGTBHPG8H2A+jhE5tCEWqYGNK48Yf+J9hg67t6Y1F+d3F2ydOZWhPFFCBjLEJ4g9eboACRLQoPk4Bg==","MC",44.1000,"","0","2003-05-28",\\N,"UNKNOWN","B",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",11,"\N","\N","F","T",\\N,0,293628627,"prd1831_preprod0_avro_pfocusvw-sales_ord_event_pmt","2020-09-19 09:56:44.845","2020-09-19 15:17:50.705"
10072962777,"TOR","16-56951","2013-05-29","1153003598773197636","EVENTDB","1",176891619,"5TQ0neRjjQL6Pvq4CeLaL01H32MoZjHRL8HLJN7x3tVloDZOj5wfIzQOMCPYHa9Fkgtf1oirwId5bBzaDSUwww==","VISA",93.8500,"Y","9","2013-05-29",\\N,"ZIL553","I",0,\\N,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",12,"\N","\N","T","F",0,0,292980261,"prd1831_preprod0_avro_pfocusvw-sales_o
it's very old information bro)
Reply
Reply
Reply
Reply
Reply
|
