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 1 NULL NULL NULL 659684 NULL NULL 0706 2018-06-22 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 101 NULL NULL 355249090976774 NULL NULL 16/4/18 12:00:00 a. m. 2018-06-22 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-06-15 12:00:00 -04:00 orange NULL G3311 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-05 03:31:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 5 NULL NULL NULL 659684 NULL NULL 0706 2018-06-22 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 108 NULL NULL 355249090976774 NULL NULL 16/4/18 12:00:00 a. m. 2018-06-22 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2018-06-15 12:00:00 -04:00 orange NULL G3311 NULL P NULL 2196 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-07-05 03:31:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 11 NULL NULL NULL 660721 NULL NULL 0706 2018-06-27 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 1308-2451 113 NULL NULL 358009080233744 358009080779365 NULL 16/1/18 12:00:00 a. m. 2018-06-27 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1308-4462 SONY NULL 10 NULL NULL 2018-04-13 12:00:00 -04:00 orange NULL G3221 NULL P NULL 550 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-05 08:53:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 550 NULL True 10 0 8 NULL NULL NULL 660721 NULL NULL 0706 2018-06-27 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 1308-2451 109 NULL NULL 358009080233744 358009080779365 NULL 16/1/18 12:00:00 a. m. 2018-06-27 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2018-04-13 12:00:00 -04:00 orange NULL G3221 NULL P NULL 550 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-07-05 08:53:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 550 NULL True 10 0 36 NULL NULL NULL 661078 NULL NULL 1501 2018-06-28 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 106 NULL NULL 357444081517905 NULL NULL 19/10/17 12:00:00 a. m. 2018-06-28 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-12-20 12:00:00 -04:00 CLARO NULL G3123 48.1.a.2.21 P 48.1.A.2.21 890 SONY NULL NULL NULL NULL NULL NULL NULL 6496 50 2018-07-05 07:22:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL 48.1.A.2.21 890 NULL True 10 0 38 NULL NULL NULL 717869 NULL NULL 0705 2018-07-02 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 106 NULL NULL 357444080723504 NULL NULL 1/3/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-10-02 12:00:00 -04:00 CLARO NULL G3123 48.1.a.2.21 P 48.1.A.2.21 890 SONY NULL NULL NULL NULL NULL NULL NULL 6496 50 2018-07-05 07:39:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL 48.1.A.2.21 890 NULL True 10 0 38 NULL NULL NULL 717883 NULL NULL 0705 2018-07-02 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 106 NULL NULL 357444080719429 NULL NULL 6/8/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-09-13 12:00:00 -04:00 CLARO NULL G3123 NULL P NULL 2196 SONY NULL NULL NULL NULL NULL NULL NULL 6496 50 2018-07-05 07:15:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 718005 NULL NULL 0013 2018-07-03 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 101 NULL NULL 358009082674465 NULL NULL 3/11/17 12:00:00 a. m. 2018-07-03 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 21BY8600Y00 SONY NULL 10 NULL NULL 2017-12-16 12:00:00 -04:00 orange NULL G3221 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-05 10:47:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 718005 NULL NULL 0013 2018-07-03 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 101 NULL NULL 358009082674465 NULL NULL 3/11/17 12:00:00 a. m. 2018-07-03 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 2313000105W SONY NULL 10 NULL NULL 2017-12-16 12:00:00 -04:00 orange NULL G3221 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-05 10:47:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 718005 NULL NULL 0013 2018-07-03 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 101 NULL NULL 358009082674465 NULL NULL 3/11/17 12:00:00 a. m. 2018-07-03 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 2313000134W SONY NULL 10 NULL NULL 2017-12-16 12:00:00 -04:00 orange NULL G3221 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-05 10:47:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 718005 NULL NULL 0013 2018-07-03 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 101 NULL NULL 358009082674465 NULL NULL 3/11/17 12:00:00 a. m. 2018-07-03 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 2313000161W SONY NULL 10 NULL NULL 2017-12-16 12:00:00 -04:00 orange NULL G3221 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-05 10:47:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 718005 NULL NULL 0013 2018-07-03 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 101 NULL NULL 358009082674465 NULL NULL 3/11/17 12:00:00 a. m. 2018-07-03 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 303M1X60800 SONY NULL 10 NULL NULL 2017-12-16 12:00:00 -04:00 orange NULL G3221 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-05 10:47:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 718005 NULL NULL 0013 2018-07-03 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 101 NULL NULL 358009082674465 NULL NULL 3/11/17 12:00:00 a. m. 2018-07-03 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 306Q1YE0100 SONY NULL 10 NULL NULL 2017-12-16 12:00:00 -04:00 orange NULL G3221 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-05 10:47:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 718005 NULL NULL 0013 2018-07-03 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 101 NULL NULL 358009082674465 NULL NULL 3/11/17 12:00:00 a. m. 2018-07-03 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 306Q1YE0200 SONY NULL 10 NULL NULL 2017-12-16 12:00:00 -04:00 orange NULL G3221 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-05 10:47:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 718005 NULL NULL 0013 2018-07-03 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 101 NULL NULL 358009082674465 NULL NULL 3/11/17 12:00:00 a. m. 2018-07-03 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 306Q1YE0400 SONY NULL 10 NULL NULL 2017-12-16 12:00:00 -04:00 orange NULL G3221 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-05 10:47:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 718005 NULL NULL 0013 2018-07-03 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 101 NULL NULL 358009082674465 NULL NULL 3/11/17 12:00:00 a. m. 2018-07-03 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 82KB600001W SONY NULL 10 NULL NULL 2017-12-16 12:00:00 -04:00 orange NULL G3221 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-05 10:47:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 5 NULL NULL NULL 718005 NULL NULL 0013 2018-07-03 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 108 NULL NULL 358009082674465 NULL NULL 3/11/17 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-12-16 12:00:00 -04:00 orange NULL G3221 NULL P NULL 2196 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-07-05 10:47:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 718161 NULL NULL 0705 2018-07-04 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 101 NULL NULL 358009083090323 NULL NULL 22/1/18 12:00:00 a. m. 2018-07-04 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 306Q1YE0100 SONY NULL 10 NULL NULL 2018-03-01 12:00:00 -04:00 orange NULL G3221 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-05 02:05:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 718161 NULL NULL 0705 2018-07-04 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 101 NULL NULL 358009083090323 NULL NULL 22/1/18 12:00:00 a. m. 2018-07-04 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 306Q1YE0200 SONY NULL 10 NULL NULL 2018-03-01 12:00:00 -04:00 orange NULL G3221 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-05 02:05:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 718161 NULL NULL 0705 2018-07-04 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 101 NULL NULL 358009083090323 NULL NULL 22/1/18 12:00:00 a. m. 2018-07-04 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 306Q1YE0400 SONY NULL 10 NULL NULL 2018-03-01 12:00:00 -04:00 orange NULL G3221 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-05 02:05:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 718161 NULL NULL 0705 2018-07-04 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 101 NULL NULL 358009083090323 NULL NULL 22/1/18 12:00:00 a. m. 2018-07-04 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 78PB3400100 SONY NULL 10 NULL NULL 2018-03-01 12:00:00 -04:00 orange NULL G3221 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-07-05 02:05:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 5 NULL NULL NULL 718161 NULL NULL 0705 2018-07-04 12:00:00 -04:00 2018-07-05 12:00:00 -04:00 NULL 0 108 NULL NULL 358009083090323 NULL NULL 22/1/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-03-01 12:00:00 -04:00 orange NULL G3221 NULL P NULL 2196 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-07-05 02:05:00 -04:00 2018-07-06 08:59:12 -04:00 2018-07-05 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0