OP 19 August, 2025 - 09:49 PM
Code:
Download https://gofile.io/d/kKPKiS
Claim Number,Customer First Name,Customer Last Name,Claim History Count,Scheme Name,Product Name,Insured Device Make,Insured Device Model,Insured Device IMEI,Updated Device Make,Updated Device Model,Updated Device IMEI,Policy Number,Policy Address Line 1,Policy Address Line 2,Policy Post Code,Customer Email Address,Alternate Email Address,Mobile Number,Incident Type,Cause Of Loss,Device Fault,Policy Effective Date,Incident Date,Claim Notification Date,Date Network Notified,Claim Raised By,Date Claim Form Sent,Date Claim Form Assessed,Order Number(Current Order),Order Date(Current Order),Order Status(Current Order),Order Situation(Current Order),Fulfilled Device IMEI(Current Order),Re-Orders,Claim Submitted Date,Fulfilled Device Make,Fulfilled Device Model,Delivery Address Line 1,Delivery Address Line 2,Delivery Address Post Code,Claim Status,Claim Status Detail,Last Status Change Date,Rejected_Reason,Claim Declined by,Declinature Date,Date of Claim Decision,Date Claim Closed,Fulfilment Completed Date,Claim Form Received Date,Deductible_Amount,PickDate,PICKTIME,PickUpAddress1,PickUpAddress2,PickUpCity,PREVIOUSSTATUS,Current Collect and Inspect Flag,Policy Age in Days,Contact Number,Orphan Claim,SKU Code,Device Priority,Original Collect and Inspect Flag,Awaiting Restock Indicator
TCL-0000409,FRANK,SMITH,1,O2,O2 Evolution Full Cover Flagship £15,APPLE,APPLE IPHONE 12 PRO MAX 256GB GRAPHITE,356731112546049,APPLE,APPLE IPHONE 12 PRO MAX 256GB GRAPHITE,356731112546049,TO2UK0006232657,26 NORWICH WAY,CRAMLINGTON,NE231RE,,jay.peake@likewize.com,07540933561,Accidental Damage,Car accident,Broken Buttons,14/11/2020,09/10/2022,10/10/2022,10/10/2022,charlie.summerfield@likewize.c,,,,10/10/2022,Pending resend Movired,,,0,10/10/2022,APPLE,IPHONE 12 PRO MAX 5G 256GB,26 NORWICH WAY,,NE231RE,Closed,No Claim,19/10/2022,,,,19/10/2022,19/10/2022,,,,,,26 NORWICH WAY,,CRAMLINGTON,Authorised,,935,07540933561,N,MGDC3B/A,,True,
TCL-0000422,JULIAN,BOXALL,5,O2,O2 Evolution AD Only Flagship £9.00,<Unknown Make ... >,,352630606242483,SAMSUNG,SAMSUNG GALAXY S21 PLUS 5G 128GB BLACK,352630606242483,TEST00003,HOLLYBANKS|ARROW LANE,HOOK,RG27 8LR,JULIAN.BOXALL@VIRGINMEDIAO2.CO.UK,JULIAN.BOXALL@VIRGINMEDIAO2.CO.UK,07796615060,Accidental Damage,Crushed By External Object,Camera Not Functioning,10/10/2021,10/10/2022,11/10/2022,11/10/2022,jay.peake@likewize.com,,,,11/10/2022,Pending resend Movired,,,0,11/10/2022,SAMSUNG,GALAXY S21 PLUS 128GB 5G,HOLLYBANKS,,RG27 8LR,Closed,No Claim,20/10/2022,,,,20/10/2022,20/10/2022,,,,,Next Day,HOLLYBANKS,,HOOK,Authorised,,603,07796615060,N,1SAUT228BN,,False,
TCL-0000430,TEST,CLIENT 03,1,O2,O2 Evolution Full Cover High £12.50,SAMSUNG,SAMSUNG GALAXY NOTE 9 128G BLUE,862960055234712,SAMSUNG,SAMSUNG GALAXY NOTE 9 128G BLUE,862960055234712,TEST00014,BRIGHTSTAR DEVICE SUPPORT SER|UNIT 2|CREWE LOGISTICS PARK|JACK MILLS WAY,CREWE,CW2 5XF,info@delonia.com,info@delonia.com,07548449064,Accidental Damage,Damaged in Pocket/Bag,Fire Damage,12/01/2022,11/10/2022,11/10/2022,11/10/2022,Pruebas,,,15249579,11/10/2022,Closed,,862960055234712,0,11/10/2022,SAMSUNG,GALAXY NOTE 9 128G,Flat 1605,Cascades Tower,E148JW,Closed,Settled,18/04/2023,,,,18/04/2023,18/04/2023,18/04/2023,,40,11/12/2022,,Flat 1605,Cascades Tower,London,Authorised,,509,07456749271,N,1SAGC28BLN,,True,
TCL-0000438,GONZALO,FERNANDEZ,5,O2,O2 Evolution Full Cover High £12.50,SAMSUNG,SAMSUNG GALAXY A50 128G BLACK,358690106058221,APPLE,APPLE IPHONE 13 PRO 512GB SILVER,352926110555885,TEST00006,7 GARFIELD PLACE,WINDSOR,SL4 3BT,GONZALO.FERNANDEZAYALANOVO@TELEFONICA.COM,GONZALO.FERNANDEZAYALANOVO@TELEFONICA.COM,07541593325,Loss,Unknown Location & Time,Unknown Location & Time,07/10/2021,11/10/2022,12/10/2022,12/10/2022,madison.tomson@likewize.com,14/10/2022,,5732144,12/10/2022,Closed,,,0,12/10/2022,APPLE,IPHONE 13 PRO 512GB,7 GARFIELD PLACE,,SL4 3BT,Closed,Settled,21/02/2023,,,,23/11/2022,21/02/2023,24/10/2022,,70,13/10/2022,Next Day,7 GARFIELD PLACE,,WINDSOR,No Claim,,606,07541593325,N,MLVN3B/A,,False, 
