Action Code Action Reason Code AWB In AWB Out Claim ID Courier In Courier Out Customer Complaint Code - Primary Date In Date Out Delivery Date Delivery Number Fault Code IMEI 2 In IMEI 2 Out IMEI Number In IMEI Number Out Inbound Shipment Type Item code out Job Creation Date Mandatory Manufacture date Material Missing Material Number OEM Outbound Shipment Type Payer Pickup Arranged Date Pickup Date POP date POP supplier Problem Found Code Product Code In Product Code Out Product Type Product version in Product version out Project Provider/Carrier Quantity Missing Quantity Replaced Quotation End Date Quotation Start Date Reference designator number Remarks Repair Service Partner ID Repair Status Code Repair Timestamp Report date Return Date Second Status Serial Number In Serial Number Out Shop ID Software In Software Out Special project number Technician ID Transaction Code Warranty Flag 5 NULL NULL NULL 661258 NULL NULL 1003 2018-06-29 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 0 107 NULL NULL 352190070618767 NULL NULL 15/12/15 12:00:00 a. m. 2018-06-29 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2018-02-14 12:00:00 -04:00 orange NULL E5803 32.4.A.1.54 P 32.4.A.1.54 890 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-07-04 08:33:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL 32.4.A.1.54 890 NULL True 10 0 5 NULL NULL NULL 661426 NULL NULL 0005 2018-06-30 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 0 107 NULL NULL 358321082544386 NULL NULL 2/1/18 12:00:00 a. m. 2018-06-30 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2018-03-06 12:00:00 -04:00 orange NULL G8341 47.1.a.12.205 P 47.1.A.12.205 890 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-07-04 09:06:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL 47.1.A.12.205 890 NULL True 10 0 1 NULL NULL NULL 661448 NULL NULL 0706 2018-06-30 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 0 101 NULL NULL 358008089322458 NULL NULL 26/1/18 12:00:00 a. m. 2018-06-30 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/405-81000-0001 SONY NULL 10 NULL NULL 2018-03-22 12:00:00 -04:00 orange NULL G3311 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-04 05:20:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 661448 NULL NULL 0706 2018-06-30 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 0 101 NULL NULL 358008089322458 NULL NULL 26/1/18 12:00:00 a. m. 2018-06-30 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/8CS-81000-0005 SONY NULL 10 NULL NULL 2018-03-22 12:00:00 -04:00 orange NULL G3311 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-04 05:20:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 5 NULL NULL NULL 661448 NULL NULL 0706 2018-06-30 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 0 108 NULL NULL 358008089322458 NULL NULL 26/1/18 12:00:00 a. m. 2018-06-30 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2018-03-22 12:00:00 -04:00 orange NULL G3311 NULL P NULL 2196 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-07-04 05:20:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 5 NULL NULL NULL 661492 NULL NULL 0403 2018-06-30 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 0 107 NULL NULL 358009083039825 NULL NULL 6/1/18 12:00:00 a. m. 2018-06-30 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2018-01-29 12:00:00 -04:00 orange NULL G3221 NULL P NULL 2196 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-07-04 02:36:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 717602 NULL NULL 0503 2018-07-02 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 0 101 NULL NULL 358117085165306 NULL NULL 12/1/18 12:00:00 a. m. 2018-07-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1299-8167 SONY NULL 10 NULL NULL 2018-05-27 12:00:00 -04:00 CLARO NULL G3313 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-04 05:34:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 717602 NULL NULL 0503 2018-07-02 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 0 101 NULL NULL 358117085165306 NULL NULL 12/1/18 12:00:00 a. m. 2018-07-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/405-81000-0009 SONY NULL 10 NULL NULL 2018-05-27 12:00:00 -04:00 CLARO NULL G3313 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-04 05:34:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 5 NULL NULL NULL 717602 NULL NULL 0503 2018-07-02 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 0 108 NULL NULL 358117085165306 NULL NULL 12/1/18 12:00:00 a. m. 2018-07-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2018-05-27 12:00:00 -04:00 CLARO NULL G3313 NULL P NULL 2196 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-07-04 05:34:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 43 NULL NULL NULL 717653 NULL NULL 0601 2018-07-02 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 1302-3303 104 NULL NULL 356056072422175 356056072824776 NULL 4/1/17 12:00:00 a. m. 2018-07-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/415-59290-0025 SONY NULL 10 NULL NULL 2017-11-02 12:00:00 -04:00 orange NULL F3211 36.1.A.1.186 P 36.1.A.1.186 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-04 04:10:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL 36.1.A.1.186 890 NULL True 10 0 36 NULL NULL NULL 717653 NULL NULL 0601 2018-07-02 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 1302-3303 109 NULL NULL 356056072422175 356056072824776 NULL 4/1/17 12:00:00 a. m. 2018-07-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1305-7483 SONY NULL 10 NULL NULL 2017-11-02 12:00:00 -04:00 orange NULL F3211 36.1.A.1.186 P 36.1.A.1.186 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-04 04:10:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL 36.1.A.1.186 890 NULL True 10 0 8 NULL NULL NULL 717653 NULL NULL 0601 2018-07-02 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 1302-3303 109 NULL NULL 356056072422175 356056072824776 NULL 4/1/17 12:00:00 a. m. 2018-07-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-11-02 12:00:00 -04:00 orange NULL F3211 36.1.A.1.186 P 36.1.A.1.186 890 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-07-04 04:10:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL 36.1.A.1.186 890 NULL True 10 0 5 NULL NULL NULL 717829 NULL NULL 0601 2018-07-02 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 0 107 NULL NULL 358008086599108 NULL NULL 25/10/17 12:00:00 a. m. 2018-07-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-11-23 12:00:00 -04:00 orange NULL G3311 NULL P NULL 2196 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-07-04 10:23:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 5 NULL NULL NULL 717836 NULL NULL 0213 2018-07-02 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 0 107 NULL NULL 355249090965728 NULL NULL 16/4/18 12:00:00 a. m. 2018-07-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2018-06-24 12:00:00 -04:00 orange NULL G3311 43.0.a.7.55 P 43.0.A.7.55 890 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-07-04 09:09:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL 43.0.A.7.55 890 NULL True 10 0 1 NULL NULL NULL 718034 NULL NULL 0601 2018-07-03 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 0 101 NULL NULL 355249090965009 NULL NULL 16/4/18 12:00:00 a. m. 2018-07-03 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/405-81000-0009 SONY NULL 10 NULL NULL 2018-06-25 12:00:00 -04:00 orange NULL G3311 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-04 05:50:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 718034 NULL NULL 0601 2018-07-03 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 0 101 NULL NULL 355249090965009 NULL NULL 16/4/18 12:00:00 a. m. 2018-07-03 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/8CS-81000-0004 SONY NULL 10 NULL NULL 2018-06-25 12:00:00 -04:00 orange NULL G3311 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-04 05:50:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 5 NULL NULL NULL 718034 NULL NULL 0601 2018-07-03 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 0 108 NULL NULL 355249090965009 NULL NULL 16/4/18 12:00:00 a. m. 2018-07-03 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2018-06-25 12:00:00 -04:00 orange NULL G3311 NULL P NULL 2196 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-07-04 05:50:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 5 NULL NULL NULL 718108 NULL NULL 0602 2018-07-03 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 0 107 NULL NULL 358125076844136 NULL NULL 30/11/16 12:00:00 a. m. 2018-07-03 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-09-01 12:00:00 -04:00 orange NULL F3111 NULL P NULL 2196 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-07-04 03:36:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 5 NULL NULL NULL 718306 NULL NULL 0403 2018-07-04 12:00:00 -04:00 2018-07-04 12:00:00 -04:00 NULL 0 107 NULL NULL 357444086748067 NULL NULL 3/3/18 12:00:00 a. m. 2018-07-04 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2018-05-07 12:00:00 -04:00 CLARO NULL G3123 NULL P NULL 2196 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-07-04 04:08:00 -04:00 2018-07-05 09:24:47 -04:00 2018-07-04 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0