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 43 NULL NULL NULL 571195 NULL NULL 0005 2017-06-08 12:00:00 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL 104 NULL NULL 356056071331732 NULL NULL NULL 2017-06-08 12:00:00 -04:00 NULL NULL NULL A/415-59290-0025 SONY NULL 10 NULL NULL 2016-12-07 12:00:00 -04:00 orange NULL F3211 NULL P NULL NULL SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-06-14 01:46:00 -04:00 2017-06-16 09:17:14 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL NULL NULL NULL NULL NULL NULL 10 1 1 NULL NULL NULL 571195 NULL NULL 0005 2017-06-08 12:00:00 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL 101 NULL NULL 356056071331732 NULL NULL NULL 2017-06-08 12:00:00 -04:00 NULL NULL NULL A/8CS-59290-0005 SONY NULL 10 NULL NULL 2016-12-07 12:00:00 -04:00 orange NULL F3211 NULL P NULL NULL SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-06-14 01:46:00 -04:00 2017-06-16 09:17:19 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL NULL NULL NULL NULL NULL NULL 10 1 5 NULL NULL NULL 571195 NULL NULL 0005 2017-06-08 12:00:00 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL 108 NULL NULL 356056071331732 NULL NULL NULL 2017-06-08 12:00:00 -04:00 NULL NULL NULL NULL SONY NULL 10 NULL NULL 2016-12-07 12:00:00 -04:00 orange NULL F3211 NULL P NULL NULL SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2017-06-14 01:46:00 -04:00 2017-06-16 09:17:23 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL NULL NULL NULL NULL NULL NULL 10 1 1 NULL NULL NULL 571623 NULL NULL 1402 2017-06-10 12:00:00 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL 101 NULL NULL 356056072166756 356056072390711 NULL NULL 2017-06-10 12:00:00 -04:00 NULL NULL NULL 1299-8621 SONY NULL 10 NULL NULL 2016-12-27 12:00:00 -04:00 orange NULL F3211 F3211 P NULL NULL SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-06-14 01:47:00 -04:00 2017-06-16 09:17:30 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL NULL NULL NULL NULL NULL NULL 10 1 43 NULL NULL NULL 571623 NULL NULL 1402 2017-06-10 12:00:00 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL 104 NULL NULL 356056072166756 356056072390711 NULL NULL 2017-06-10 12:00:00 -04:00 NULL NULL NULL A/415-59290-0025 SONY NULL 10 NULL NULL 2016-12-27 12:00:00 -04:00 orange NULL F3211 F3211 P NULL NULL SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-06-14 01:47:00 -04:00 2017-06-16 09:17:37 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL NULL NULL NULL NULL NULL NULL 10 1 36 NULL NULL NULL 571623 NULL NULL 1402 2017-06-10 12:00:00 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL 109 NULL NULL 356056072166756 356056072390711 NULL NULL 2017-06-10 12:00:00 -04:00 NULL NULL NULL 1302-3303 SONY NULL 10 NULL NULL 2016-12-27 12:00:00 -04:00 orange NULL F3211 F3211 P NULL NULL SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-06-14 01:47:00 -04:00 2017-06-16 09:17:43 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL NULL NULL NULL NULL NULL NULL 10 1 8 NULL NULL NULL 571623 NULL NULL 1402 2017-06-10 12:00:00 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL 109 NULL NULL 356056072166756 356056072390711 NULL NULL 2017-06-10 12:00:00 -04:00 NULL NULL NULL NULL SONY NULL 10 NULL NULL 2016-12-27 12:00:00 -04:00 orange NULL F3211 F3211 P NULL NULL SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2017-06-14 01:47:00 -04:00 2017-06-16 09:17:50 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL NULL NULL NULL NULL NULL NULL 10 1 11 NULL NULL NULL 572264 NULL NULL 0503 2017-06-13 12:00:00 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL 109 NULL NULL 356057071134589 356057072492754 NULL NULL 2017-06-13 12:00:00 -04:00 NULL NULL NULL 1305-2792 SONY NULL 10 NULL NULL 2016-11-07 12:00:00 -04:00 CLARO NULL F3213 F3213 P NULL NULL SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-06-14 02:37:00 -04:00 2017-06-16 09:17:56 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL NULL NULL NULL NULL NULL NULL 10 1 8 NULL NULL NULL 572264 NULL NULL 0503 2017-06-13 12:00:00 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL 109 NULL NULL 356057071134589 356057072492754 NULL NULL 2017-06-13 12:00:00 -04:00 NULL NULL NULL NULL SONY NULL 10 NULL NULL 2016-11-07 12:00:00 -04:00 CLARO NULL F3213 F3213 P NULL NULL SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2017-06-14 02:37:00 -04:00 2017-06-16 09:18:03 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL NULL NULL NULL NULL NULL NULL 10 1 11 NULL NULL NULL 571783 NULL NULL 0602 2017-06-12 12:00:00 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL 109 NULL NULL 359666079908641 353748082980902 NULL NULL 2017-06-12 12:00:00 -04:00 NULL NULL NULL 1306-1010 SONY NULL 10 NULL NULL 2016-11-06 12:00:00 -04:00 orange NULL F3311 F3311 P NULL NULL SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-06-14 10:55:00 -04:00 2017-06-16 09:18:09 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL NULL NULL NULL NULL NULL NULL 10 1 8 NULL NULL NULL 571783 NULL NULL 0602 2017-06-12 12:00:00 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL 109 NULL NULL 359666079908641 353748082980902 NULL NULL 2017-06-12 12:00:00 -04:00 NULL NULL NULL NULL SONY NULL 10 NULL NULL 2016-11-06 12:00:00 -04:00 orange NULL F3311 F3311 P NULL NULL SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2017-06-14 10:55:00 -04:00 2017-06-16 09:18:15 -04:00 2017-06-14 12:00:00 -04:00 NULL NULL NULL NULL NULL NULL NULL NULL 10 1