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. )
TmPatronEmailAddr.csv
PatronLkup.csv
SalesOrdTrans.csv
SalesOrd.csv
SalesOrd.csv
TmPatron.csv
TmParty.csv
SalesOrdPmt.csv
PmtMethod.csv
CustDemographics.csv
TmCcMerge.csv
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.
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,,