Full Live Nation / Ticketmaster 560M Users (Exclusive)

[whlx]

The recent data leak involving Live Nation / TicketMaster has exposed highly sensitive and detailed information of approximately 560 million customers. The leaked data includes personal details, such as names, addresses, email addresses, and phone numbers, along with information related to ticket sales, events, and order specifics.

The price is $500,000 USD for a one-time sale. (Time wasters and sample seekers, don't bother messaging me. )

• Personal Information:
  • Customer details including names, addresses, email addresses, and phone numbers.
  • Member database customer IDs and email addresses.
• Event and Ticket Sales Information:
  • Details of ticket purchases, including sales order transactions, event IDs, and associated promoter IDs.
  • Information on ticket types, quantities purchased, and amounts paid.
• Payment Information:
  • Transaction amounts, verification codes, and fraud indicators.
• Additional Data:
  • Patron lookup information including customer IDs and email addresses.
  • Sales order payment details and related financial transaction information.

TmPartyLkup.csv

OFFSET_TS,PARTY_LKUP_ID,PARTY_LKUP_TYPE_CD,MEMBERDB_CUST_ID,EMAIL_ADDR,PHN_NUM_1,PHN_NUM_2,STREET_ADDR_LINE_1_TEXT,STREET_ADDR_LINE_2_TEXT,CITY_NAME,TERR_NAME,CTRY_NAME,POSTAL_CD,GIVEN_NAME,MIDDLE_NAME,FMLY_NAME,CC_HASH_NUM,EVENTDB_ATTRACTION_ID,EVENTDB_PROMOTER_ID,EVENTDB_PARTNER_ID,ECDB_ATTRACTION_ID,EVENTDB_VEN_OWNER_CD,EVENTDB_VEN_CLIENT_CD,PARTY_ID,CONVERGENCE_TYPE,SRC_LAST_MOD_TS
2024-04-23 08:11:38.000,2772503360,EVENTDB_ATTRACTION_ID,,,,,,,,,,,,,,,3144437,,,,,,2772503360,,\N
2024-04-23 08:11:38.000,2795303029,EVENTDB_ATTRACTION_ID,,,,,,,,,,,,,,,3144418,,,,,,2795303029,,\N

TmPatronEmailAddr.csv

START_TS,TD_UPDATE_TS,PATRON_ID,PATRON_LKUP_ID,EMAIL_ADDR_TEXT,CUR_IND,HOLD_STATUS_CODE,TOMBSTONE_IND
2012-06-25 20:44:48.000,2012-06-26 00:34:15.000,1046813227,1046813227,SBAWRESTLER2012@YAHOO.COM,Y,N,
2011-10-20 09:50:45.000,2011-10-21 01:48:16.000,1029202149,1029202149,CORRINE.CLEWLOW@ANZ.COM,Y,N,

PatronLkup.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,"STEVE.FRANCO@YAHOO.COM",,,92823101,0,0,0,,"1900-01-01 00:00:00.000","1900-01-01 00:00:00.000",161,"2018-07-23 13:30:03.914 -0700"

SalesOrdTrans.csv

"SALES_ORD_ID","HOST_SYS_CD","HOST_VAX_ACCT_NUM","HOST_ACCT_CREATE_DT","EVENT_ID","EVENT_ID_SRC_SYS_CD","SRC_EVENT_ID","SALES_ORD_TRAN_ID","SALES_ORD_TRAN_DT","SALES_ORD_TRANS_LCL_DTTM","TRAN_AMT","ACCT_MODE_CD","TICKETS_PURCHASED_QTY","PRINT_FLG","PRINT_DT","TRAN_VOID_FLG","TRAN_VOID_DT","PRINT_OPR_ID","PRINT_OPR_CD","OVRRD_PRINT_OPR_TYPE_CD","TRAN_OPR_ID","TRAN_OPR_CD","OVRRD_TRAN_OPR_TYPE_CD","VOID_OPR_ID","VOID_OPR_CD","OVRRD_VOID_OPR_TYPE_CD","TRANS_FACE_VAL_AMT","TRANS_SERVICE_CHARGE_AMT","TRANS_SERVICE_TAX_AMT","TRANS_SERVICE_TAX_2_AMT","TRANS_SET_TAX_AMT","TRANS_ZONE_CHARGE_AMT","TRANS_FAC_FEE_AMT","TRANS_EXCH_FEE_AMT","LAST_BATCH_ID","INIT_RUN_ID","LAST_RUN_ID","TD_INSERT_TS","TD_UPDATE_TS","TKT_TRANSFER_SENT_FLG","TKT_TRANSFER_RCVD_FLG","TKT_TRANSFER_SURRENDER_FLG","RESALE_STATUS_NM","UPSELL_FLG","DLVRY_FLG","VOID_USED_OPR_CD","MIMIC_FLG","PRICE_LEVEL_ID","PRICE_LEVEL_NM","EXPECTED_PMT_METHOD_TYPE_ID","EXPECTED_PMT_METHOD_TYPE_CD","TKT_TYPE_CNT","KAFKA_PARTITION","KAFKA_OFFSET","KAFKA_TOPIC","KAFKA_TIMESTAMP","UPDATED_TS"
10040841437,"SCS","55-28772","2012-07-03","1945635082459307061","EVENTDB",,1,"2012-07-03",,11.9700,"TMC",1,"T","2012-07-10","F",,,"ZWS727","P",,"ZIQ057","I",,"NOT APPLICABLE","NA",10.0000,1.9700,0.1700,0.0000,0.0000,0.0000,0.0000,0.0000,1967145,,1967145,"1900-01-01 00:00:00.000","1900-01-01 00:00:00.000","N","N","N",,"Y","N",,,1,"1",,,,0,1349813692,"prd1831_preprod0_avro_pfocusvw-sales_ord_tran","2020-09-29 02:58:27.334","2020-09-29 03:23:49.837"
10046053810,"CH1","47-50692","2012-09-02","288310278963355847","EVENTDB",,1,"2012-09-02",,62.5000,"TMC",2,"T","2012-09-02","F",,,"ZIP482","I",,"ZIR495","I",,"NOT APPLICABLE","NA",40.0000,14.0000,0.0000,0.0000,0.0000,0.0000,8.5000,0.0000,2008021,,2008021,"1900-01-01 00:00:00.000","1900-01-01 00:00:00.000","N","N","N",,,,,,18,"LAWN",,,,0,1349755757,"prd1831_preprod0_avro_pfocusvw-sales_ord_tran","2020-09-29 02:57:31.207","2020-09-29 03:23:49.837"

SalesOrd.csv

OFFSET_TS,SALES_ORD_CREATE_DTTM,SALES_ORD_CREATE_LCL_DTTM,SALES_ORD_ID,HOST_ACCT_CREATE_DT,HOST_SYS_CD,HOST_VAX_ACCT_NUM,MEMBERDB_SALES_ORD_ID,LANG_CD,DEL_FLG,VOID_DTTM,VOID_FLG,DELIVERY_TYPE_CD,PURCH_PARTY_LKUP_ID,PURCH_NAME,CLN_STREET_ADDR_ID,RAW_STREET_ADDR_ID,RAW_CUST_ADDR1,RAW_CUST_ADDR2,RAW_CUST_CITY,RAW_CUST_ST,RAW_CUST_CTRY,RAW_CUST_POSTAL_CD,DOMAIN_ID,SELLER_INTERNAL_ORG_ID,PURCH_PATRON_LKUP_ID,MEMBERDB_CUST_ID,PURCH_EMAIL_ADDR_TEXT,DELIVERY_FEE_AMT,BALANCED_FLG,ORD_CREATE_OPR_CD,OVRRD_ORD_CREATE_OPR_TYPE_CD,SALES_ORD_CMNT,SALES_ORD_COMMENT,SALES_ORD_EXTRA_INFO_1,SALES_ORD_EXTRA_INFO_2,SALES_PLATFORM_CD,FROM_ISC_FLG,INSURANCE_AMT,CAMEFROM_CD_VAL,BROWSER_ID_VAL,WEB_SESSION_COOKIE_VAL,DQ_ADDR_FLG,DQ_ENGINE_NAME,DQ_STATUS_CD,DQ_INFO_CD,DQ_QUALITY_CD,DQ_ACTUAL_ASSIGNMENT_LVL,PURCH_PATRON_ID,DOMAIN_ID_SRC_SYS_CD,THIRD_PARTY_REF_NM,THIRD_PARTY_SRC_NM,AVS_CD,FRAUD_CD,REFUND_REQUEST_FLG,REFUND_REQUEST_ID,REFUND_REQUEST_CREATE_DTTM
2016-12-11 18:00:20.000,,,10284999125,2016-12-10,CH3,2-13909,0,,T,,,BWC,-1,gaikowski \jason\\\,11251969,,,,,,,,,,1444948052,-1,JGAIKOWSKI@YAHOO.COM,0.0000,T,ZIV432,R,,,,,avd.tmplus.us,,,,,,N,-1,-1,-1,-2,-1,1075429746,,30000118980871200,TMPlus,,,,,\N
2016-10-04 11:44:48.000,2016-07-29 17:07:46.000,,10220816234,2016-07-29,NY2,54-41733,2830624706,,T,,,eTicket,1188947719,HANNEY \NICHOLAS\\\,935586998,,96 Linden Street,UNIT 3A,Allston,MA,US,02134,1,,134243957,316189621,NICK_HANNEY@YAHOO.COM,0.0000,T,ZIN073,I,NICK_HANNEY@YAHOO.COM,NICK_HANNEY@YAHOO.COM,,UNIT 3A\,www.ticketmaster.com,Y,,,pidV5uM0sCoOzIAAFMdo68AAAOl,V5uM0sCoOzIAAFMdo68AAAOl,Y,USA,S2010,,Q2,S,47747065,,,,,,,,\N

SalesOrd.csv

OFFSET_TS,SALES_ORD_CREATE_DTTM,SALES_ORD_CREATE_LCL_DTTM,SALES_ORD_ID,HOST_ACCT_CREATE_DT,HOST_SYS_CD,HOST_VAX_ACCT_NUM,MEMBERDB_SALES_ORD_ID,LANG_CD,DEL_FLG,VOID_DTTM,VOID_FLG,DELIVERY_TYPE_CD,PURCH_PARTY_LKUP_ID,PURCH_NAME,CLN_STREET_ADDR_ID,RAW_STREET_ADDR_ID,RAW_CUST_ADDR1,RAW_CUST_ADDR2,RAW_CUST_CITY,RAW_CUST_ST,RAW_CUST_CTRY,RAW_CUST_POSTAL_CD,DOMAIN_ID,SELLER_INTERNAL_ORG_ID,PURCH_PATRON_LKUP_ID,MEMBERDB_CUST_ID,PURCH_EMAIL_ADDR_TEXT,DELIVERY_FEE_AMT,BALANCED_FLG,ORD_CREATE_OPR_CD,OVRRD_ORD_CREATE_OPR_TYPE_CD,SALES_ORD_CMNT,SALES_ORD_COMMENT,SALES_ORD_EXTRA_INFO_1,SALES_ORD_EXTRA_INFO_2,SALES_PLATFORM_CD,FROM_ISC_FLG,INSURANCE_AMT,CAMEFROM_CD_VAL,BROWSER_ID_VAL,WEB_SESSION_COOKIE_VAL,DQ_ADDR_FLG,DQ_ENGINE_NAME,DQ_STATUS_CD,DQ_INFO_CD,DQ_QUALITY_CD,DQ_ACTUAL_ASSIGNMENT_LVL,PURCH_PATRON_ID,DOMAIN_ID_SRC_SYS_CD,THIRD_PARTY_REF_NM,THIRD_PARTY_SRC_NM,AVS_CD,FRAUD_CD,REFUND_REQUEST_FLG,REFUND_REQUEST_ID,REFUND_REQUEST_CREATE_DTTM
2016-12-11 18:00:20.000,,,10284999125,2016-12-10,CH3,2-13909,0,,T,,,BWC,-1,gaikowski \jason\\\,11251969,,,,,,,,,,1444948052,-1,JGAIKOWSKI@YAHOO.COM,0.0000,T,ZIV432,R,,,,,avd.tmplus.us,,,,,,N,-1,-1,-1,-2,-1,1075429746,,30000118980871200,TMPlus,,,,,\N

SalesOrdDeluxeHDR.csv
"SALES_ORD_ID","HOST_SYS_CD","HOST_VAX_ACCT_NUM","HOST_ACCT_CREATE_DT","ADDR_TEXT","CITY_STATE_NM","POSTAL_CD","PHONE_1_NUM","PHONE_2_NUM","PURCH_AMT","TKT_PURCH_QTY","OPT_AMT","PMT_AMT","BALANCE_AMT","EVENT_CNT","HOB_FLG","HOST_ORD_NUM","DRIVER_LICENSE_ID","PASSPORT_NUM","MEMBERSHIP_NUM","TITLE_NM","LAST_NM_2","SUFFIX_NM","SALUTATION_NM","BIRTH_DT","GENDER_CD","OCCUPATION_NM","EMPLOYER_NM","SRC_CREATE_LCL_DTTM","SRC_CREATE_UTC_DTTM","CREATE_OPR_CD","ORIGIN_NM","BRAND_NM","IP_ADD_VAL","DISCRETE_ID","OFFER_1_DESC","OFFER_2_DESC","OFFER_3_DESC","OFFER_4_DESC","OFFER_5_DESC","ADDR_3_TEXT","UNIT_NUM","COMPANY_NM","COUNTY_NM","NEIGHBORHOOD_SUBURB_NM","DELEGATION_MUNICIPALITY_NM","SECONDARY_EMAIL_ADDR_TEXT","OTHER_EMAIL_ADDR_TEXT","DAY_PHONE_NUM","FAX_NUM","OTHER_PHONE_1_NUM","OTHER_PHONE_2_NUM","OTHER_PHONE_3_NUM","NO_SOLICIT_MAIL_FLG","NO_SOLICIT_EMAIL_FLG","NO_SOLICIT_PHONE_FLG","NO_SOLICIT_SMS_FLG","SHIP_TO_FIRST_NM","SHIP_TO_LAST_NM","SHIP_TO_COMPANY_NM","SHIP_TO_ADDR_1_TEXT","SHIP_TO_ADDR_2_TEXT","SHIP_TO_ADDR_3_TEXT","SHIP_TO_UNIT_NUM","SHIP_TO_CITY_NM","SHIP_TO_STATE_CD","SHIP_TO_POSTAL_CD","SHIP_TO_EMAIL_ADDR_TEXT","SHIP_TO_PHONE_NUM","SHIP_TO_ID","SHIP_TO_NOTE_TEXT","PICKUP_LOC_NM","SHIPPING_REF_VAL","THIRD_PARTY_SHIP_DT","THIRD_PARTY_SHIP_VENDOR_NM","THIRD_PARTY_SHIP_NOTE_TEXT","PID","GUEST_1_NM","GUEST_2_NM","GUEST_3_NM","GUEST_4_NM","GUEST_5_NM","GUEST_6_NM","GUEST_7_NM","GUEST_8_NM","GUEST_9_NM","GUEST_1_PHONE_NUM","GUEST_2_PHONE_NUM","GUEST_3_PHONE_NUM","GUEST_4_PHONE_NUM","LOCKED_LEVEL_DESC","LOCKED_REASON_DESC","NOTE_1_TXT","NOTE_2_TXT","NOTE_3_TXT","NOTE_4_TXT","NOTE_5_TXT","NOTE_6_TXT","NOTE_7_TXT","NOTE_8_TXT","NOTE_9_TXT","NOTE_10_TXT","PREF_LANG_CD","LAST_UPDATE_DTTM","LAST_UPDATE_OPR_CD","CUSTOM_1_DT","CUSTOM_1_FEE_AMT","CUSTOM_2_FEE_AMT","CUSTOM_1_FLG","CUSTOM_2_FLG","CUSTOM_1_TXT","CUSTOM_2_TXT","CUSTOM_3_TXT","CUSTOM_4_TXT","CUSTOM_5_TXT","REWARD_REF_DESC","REWARD_SRC_NM","MERCH_1_DESC","MERCH_2_DESC","MERCH_3_DESC","MERCH_4_DESC","MERCH_NOTE_TEXT","HOST_FILE_NM","LAST_BATCH_ID","TD_INSERT_TS","TD_UPDATE_TS","COMPLIANCE_SHARING_CD","COMPLIANCE_ACTION_CD","COMPLIANCE_ACTION_TS","KAFKA_PARTITION","KAFKA_OFFSET","KAFKA_TOPIC","KAFKA_TIMESTAMP","UPDATED_TS"
10268995446,"CH3","65-52918","2016-10-01","3001 SOUTH LORRAINE","HUTCHINSON,KS","67501","6206649150",,169.7000,3,3.2000,169.7000,0.0000,2,"0",,,,,,,,,,,,,"2016-10-01 11:38:23.000","2016-10-01 16:38:23.000","ZIK310",,,"184.53.68.152",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"en-us","1-OCT-2016 11:38:24:09","ZIK310",,,,,,,,,,,,,,,,,,"/STAGING/CH3AT01.J16",0,"2018-12-11 04:04:13.000","2018-12-11 04:04:13.000",,,,0,226990472,"prd1831_preprod0_avro_pfocusvw-sales_ord_deluxe_hdr","2020-09-16 08:24:01.670","2020-09-16 08:30:18.287"

TmPatron.csv

MEMBERDB_CUST_HMAC,MEMBERDB_CUST_MD5_HEX,ET_SUBSCR_MD5_HEX,MEMBERDB_CUST_DEL_FLG,MEMBERDB_CUST_ACTIVE_FLG,PATRON_CREATE_DTTM,MBR_START_DTTM,OFFSET_TS,SRC_UPDATE_TS,TD_UPDATE_TS,PATRON_ID,MEMBERDB_CUST_ID,PRMY_PARTY_ID,CRM_EMAIL_ID,ET_SUBSCR_ID,ECDB_CUSTOMER_ID,RSDNC_CTRY_ID,HOME_DOMAIN_ID,CREATE_FROM_DOMAIN_ID,CUST_CHOSEN_DMA_ID,CUST_CHOSEN_TKT_ALERT_DMA_ID,ECDB_DEPT_ID,MBR_FLG,FIRST_NAME,MIDDLE_NAME,LAST_NAME,NICK_NAME,GENDER_CD,PATRON_ALL_OPTIONS_OPT_IN_FLG,PREFERRED_LANG_TYPE_CD,PREFERRED_LANG_CTRY_CD,PGM_CD,DEL_FLG,MBR_PHN_NUM,MBR_PHN_TS,MBR_CCPA_DONT_SELL_FLG,MBR_CCPA_DONT_SELL_DTTM,MBR_LOCKED_FLG,MBR_LOCKED_BY,MBR_LOCKED_REASON
0d16cfc7196f006df5aaec1f058cb7c4f896ecb43db857390d65a903e1ec5cf6,2F44B9AE05203EE14552BF41ED0B6209,663793F74389476ABB39C0B853654C59,,Y,2012-05-18 20:39:11.000,2012-05-18 20:39:11.000,2021-01-18 17:18:39.000,2019-11-09 17:13:01.000,2021-01-18 16:54:25.000,1044059928,1126704946,1033029090,157043042,410486214,,1009526,1,1,396,-1,,Y,LAURA,,BELL,,,,en,us,TM,,+18138636449,2019-11-17 16:46:43.000,,,N,,\N
d5561395884e5fedc8c048213a1d7a6e5b317aabd78a0bcb2da0271e8aafc016,23B3C05E31D434A77F6CD518CC4025B4,B004A52E0C5F1A76A3A8E9AAE2A6BD6A,,Y,2019-11-11 01:44:01.000,2019-11-11 01:44:01.000,2021-01-18 17:18:39.000,2019-11-11 08:10:10.000,2021-01-18 16:54:25.000,2380330508,2678421339,2055544652,269496947,561882587,,1001738,2,2,522,-1,,Y,LANA,,DOWNS,,,Y,en,ca,TM,,+15102307772,2019-11-11 01:44:01.000,,,,,\N

TmParty.csv

PARTY_ID,ULT_PARTY_ID,START_DT,END_DT,CUR_IND,CUR_PARTY_CD,CUR_PARTY_NAME,PARTY_DESC,CUR_GIVEN_NAME,CUR_MIDDLE_NAME,CUR_FMLY_NAME,CUR_NAME_PREFIX,CUR_NAME_SUFFIX,PARTY_FIRST_PURCHASE_DT,PARTY_TYPE_CD,PREFERRED_LANG_TYPE_CD
2460782370,-1,0001-01-01,2022-01-04,N,,ANDREA ROHM,,ANDREA,UNKNOWN,ROHM,,,,PERSON,\N
2460782370,1532399971,2022-01-05,2022-12-01,N,,ANDREA ROHM,,ANDREA,UNKNOWN,ROHM,,,,PERSON,\N
2460782370,65170730,2022-12-02,9000-12-31,Y,,ANDREA ROHM,,ANDREA,UNKNOWN,ROHM,,,,PERSON,\N
1

SalesOrdPmt.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",,"ZIQ134","I",0,,0,"2015-06-06 23:44:19.000","2015-06-06 23:44:19.000",13,,,"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"

PmtMethod.csv

"OFFSET_TS","PMT_METHOD_ID","CC_HASHED_NUM","CC_TYPE_NAME","CC_TOKEN","PMT_METHOD_CD","LAST_BATCH_ID","INIT_RUN_ID","LAST_RUN_ID","CC_LAST_FOUR_NUM","CC_MASK_VAL","CC_EXPIRATION_DT","TD_INSERT_TS","SPLITID","UPDATED_TS"
"2023-04-13 07:21:10.000",1814290809,"OmfQ/PeJleWDHFfOOPyOhlitoUoJLwdED28fORE3Qd/xjVflsTgmRT/zJRWG/F4DzT4yyAK/Z38O4SjHfIIE1Q==","KLARNA",,,-2019820120,,129840089,"3807","3807","4/24","2023-04-13 07:21:10.000",52,"2023-04-13 09:48:46.000 Z"

CustDemographics.csv

OBJECT_ID,HASH_VALUE_SEED,PIN,ACCT_GUID,TRANSACTION_TYPE,UPD_DATETIME,PIN_SEED,SEQ_ID,ACCT_ID,CUST_NAME_ID,DSN,EMAIL_ADDR,FULL_NAME,PHONE_NUMBER,LOGIN_COUNT,RECORD_TYPE,CLIENT_OWNED_IND,CUR_IND,BOOTSTRAP
d9e89f22bb81ecab2fe67aea8480bb0c23be43b079b4a7ba222149466e54e61b,92b52abf1d6ac1f97f5a8867cf004bd88125746e9e16a172f61807a5dedd8cc1,d629f51ead7c41de4f6f55a4fe9d4bc6f7ebaa69ccf279fa092702480d4e8410,39df2631-ad76-4c9e-994f-1244179aba98,UPDATE,2019-04-05 01:13:56.121,874255,375369,32948703,1880186,COROCKIES,Kevin.Pechnick@rockies.com,Kevin Pechnick - EMP,3033122477,0,E,Y,true,false

TmCcMerge.csv

SALES_ORD_ID,HOST_SYS_CD,HOST_VAX_ACCT_NUM,HOST_ACCT_CREATE_DT,EVENT_ID,EVENT_ID_SRC_SYS_CD,PMT_METHOD_ID,SRC_PMT_METHOD_CD,PMT_METHOD_TYPE_CD,STREET_ADDR_VERIFICATION_CD,FRAUD_CD,PMT_DT,PMT_OPR_ID,PMT_OPR_CD,OVRRD_PMT_OPR_TYPE_CD,PMT_METHOD_TYPE_ID,PMT_USED_OPR_CD,MIMIC_FLG,REJECT_FLG,AUTH_FLG,REJECT_NUM,PMT_METHOD_ID,CC_HASHED_NUM,CC_TYPE_NAME,CC_TOKEN,PMT_METHOD_CD,CC_LAST_FOUR_NUM,CC_MASK_VAL,CC_EXPIRATION_DT
10161305191,ATL,58-55582,2015-05-15,1008892512271432951,EVENTDB,226209819,1UYujEAdLnSDNHK7KlvOWWTmcbPBXzib2IwjKZz+JgSzvzOTZ5R0C0t6tZvQSjp5ahvW4hTiMsXW5N3jYVoSSw==,MC,Y,9,2015-05-15,,ZIL162,I,11,,,F,T,,226209819,zG+T1wizQVZgX6mbYq3eImILdqo,MC,,,4094,,

 

[KillerNaziNa]

Let check