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 11 NULL NULL NULL 578037 NULL NULL 0501 2017-07-06 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 1299-8143 113 NULL NULL 352190070228336 352190070422640 NULL 13/10/2015 12:00:00 a.m. 2017-07-06 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1299-7613 SONY NULL 10 NULL NULL 2017-02-11 12:00:00 -04:00 orange NULL E5803 NULL P NULL 923 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-07-17 05:36:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL NULL 923 NULL True 10 0 8 NULL NULL NULL 578037 NULL NULL 0501 2017-07-06 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 1299-8143 109 NULL NULL 352190070228336 352190070422640 NULL 13/10/2015 12:00:00 a.m. 2017-07-06 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-02-11 12:00:00 -04:00 orange NULL E5803 NULL P NULL 923 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2017-07-17 05:36:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL NULL 923 NULL True 10 0 43 NULL NULL NULL 580380 NULL NULL 1003 2017-07-17 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 104 NULL NULL 353748082982528 NULL NULL 01/12/2016 12:00:00 a.m. 2017-07-17 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 306Q1OI0500 SONY NULL 10 NULL NULL 2017-01-12 12:00:00 -04:00 orange NULL F3311 37.0.a.2.156 P 37.0.A.2.156 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-07-17 02:44:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL 37.0.A.2.156 890 NULL True 10 0 43 NULL NULL NULL 580380 NULL NULL 1003 2017-07-17 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 104 NULL NULL 353748082982528 NULL NULL 01/12/2016 12:00:00 a.m. 2017-07-17 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 306Q1OI0C00 SONY NULL 10 NULL NULL 2017-01-12 12:00:00 -04:00 orange NULL F3311 37.0.a.2.156 P 37.0.A.2.156 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-07-17 02:44:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL 37.0.A.2.156 890 NULL True 10 0 43 NULL NULL NULL 580380 NULL NULL 1003 2017-07-17 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 104 NULL NULL 353748082982528 NULL NULL 01/12/2016 12:00:00 a.m. 2017-07-17 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 306Q1OI0E00 SONY NULL 10 NULL NULL 2017-01-12 12:00:00 -04:00 orange NULL F3311 37.0.a.2.156 P 37.0.A.2.156 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-07-17 02:44:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL 37.0.A.2.156 890 NULL True 10 0 1 NULL NULL NULL 580380 NULL NULL 1003 2017-07-17 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 101 NULL NULL 353748082982528 NULL NULL 01/12/2016 12:00:00 a.m. 2017-07-17 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 78PA4100020 SONY NULL 10 NULL NULL 2017-01-12 12:00:00 -04:00 orange NULL F3311 37.0.a.2.156 P 37.0.A.2.156 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-07-17 02:44:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL 37.0.A.2.156 890 NULL True 10 0 5 NULL NULL NULL 580380 NULL NULL 1003 2017-07-17 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 108 NULL NULL 353748082982528 NULL NULL 01/12/2016 12:00:00 a.m. 2017-07-17 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-01-12 12:00:00 -04:00 orange NULL F3311 37.0.a.2.156 P 37.0.A.2.156 890 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2017-07-17 02:44:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL 37.0.A.2.156 890 NULL True 10 0 43 NULL NULL NULL 579778 NULL NULL 0599 2017-07-13 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 104 NULL NULL 354189071214632 NULL NULL 14/12/2015 12:00:00 a.m. 2017-07-13 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 56BHLY0010A SONY NULL 10 NULL NULL 2016-09-15 12:00:00 -04:00 CLARO NULL E5606 32.A.1.0.132 P 32.a.1.0.132 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-07-17 03:13:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL 32.a.1.0.132 704 NULL True 10 0 43 NULL NULL NULL 579778 NULL NULL 0599 2017-07-13 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 104 NULL NULL 354189071214632 NULL NULL 14/12/2015 12:00:00 a.m. 2017-07-13 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 56BHLY0080A SONY NULL 10 NULL NULL 2016-09-15 12:00:00 -04:00 CLARO NULL E5606 32.A.1.0.132 P 32.a.1.0.132 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-07-17 03:13:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL 32.a.1.0.132 704 NULL True 10 0 43 NULL NULL NULL 579778 NULL NULL 0599 2017-07-13 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 104 NULL NULL 354189071214632 NULL NULL 14/12/2015 12:00:00 a.m. 2017-07-13 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 56BHLY0130A SONY NULL 10 NULL NULL 2016-09-15 12:00:00 -04:00 CLARO NULL E5606 32.A.1.0.132 P 32.a.1.0.132 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-07-17 03:13:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL 32.a.1.0.132 704 NULL True 10 0 43 NULL NULL NULL 579778 NULL NULL 0599 2017-07-13 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 104 NULL NULL 354189071214632 NULL NULL 14/12/2015 12:00:00 a.m. 2017-07-13 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL F79660111000 SONY NULL 10 NULL NULL 2016-09-15 12:00:00 -04:00 CLARO NULL E5606 32.A.1.0.132 P 32.a.1.0.132 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-07-17 03:13:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL 32.a.1.0.132 704 NULL True 10 0 5 NULL NULL NULL 579778 NULL NULL 0599 2017-07-13 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 108 NULL NULL 354189071214632 NULL NULL 14/12/2015 12:00:00 a.m. 2017-07-13 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2016-09-15 12:00:00 -04:00 CLARO NULL E5606 32.A.1.0.132 P 32.a.1.0.132 704 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2017-07-17 03:13:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL 32.a.1.0.132 704 NULL True 10 0 44 NULL NULL NULL 579778 NULL NULL 0599 2017-07-13 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 114 NULL NULL 354189071214632 NULL NULL 14/12/2015 12:00:00 a.m. 2017-07-13 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2016-09-15 12:00:00 -04:00 CLARO NULL E5606 32.A.1.0.132 P 32.a.1.0.132 704 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2017-07-17 03:13:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL 32.a.1.0.132 704 NULL True 10 0 1 NULL NULL NULL 580421 NULL NULL 0213 2017-07-17 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 101 NULL NULL 356056072450671 NULL NULL 11/01/2017 12:00:00 a.m. 2017-07-17 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1293-8715 SONY NULL 10 NULL NULL 2017-07-03 12:00:00 -04:00 orange NULL F3211 36.0.a.2.146 P 36.0.A.2.146 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-07-17 05:45:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL 36.0.A.2.146 890 NULL True 10 0 43 NULL NULL NULL 580421 NULL NULL 0213 2017-07-17 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 104 NULL NULL 356056072450671 NULL NULL 11/01/2017 12:00:00 a.m. 2017-07-17 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-07-03 12:00:00 -04:00 orange NULL F3211 36.0.a.2.146 P 36.0.A.2.146 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-07-17 05:45:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL 36.0.A.2.146 890 NULL True 10 0 5 NULL NULL NULL 580421 NULL NULL 0213 2017-07-17 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 108 NULL NULL 356056072450671 NULL NULL 11/01/2017 12:00:00 a.m. 2017-07-17 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-07-03 12:00:00 -04:00 orange NULL F3211 36.0.a.2.146 P 36.0.A.2.146 890 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2017-07-17 05:45:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL 36.0.A.2.146 890 NULL True 10 0 43 NULL NULL NULL 579242 NULL NULL 0705 2017-07-11 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 104 NULL NULL 356056072591532 NULL NULL 25/01/2017 12:00:00 a.m. 2017-07-11 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-05-29 12:00:00 -04:00 orange NULL F3211 NULL P NULL 923 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-07-17 01:00:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL NULL 923 NULL True 10 0 1 NULL NULL NULL 579242 NULL NULL 0705 2017-07-11 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 101 NULL NULL 356056072591532 NULL NULL 25/01/2017 12:00:00 a.m. 2017-07-11 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/415-59290-0028 SONY NULL 10 NULL NULL 2017-05-29 12:00:00 -04:00 orange NULL F3211 NULL P NULL 923 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-07-17 01:00:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL NULL 923 NULL True 10 0 1 NULL NULL NULL 579242 NULL NULL 0705 2017-07-11 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 101 NULL NULL 356056072591532 NULL NULL 25/01/2017 12:00:00 a.m. 2017-07-11 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/415-59290-0029 SONY NULL 10 NULL NULL 2017-05-29 12:00:00 -04:00 orange NULL F3211 NULL P NULL 923 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-07-17 01:00:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL NULL 923 NULL True 10 0 1 NULL NULL NULL 579242 NULL NULL 0705 2017-07-11 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 101 NULL NULL 356056072591532 NULL NULL 25/01/2017 12:00:00 a.m. 2017-07-11 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/415-59290-0034 SONY NULL 10 NULL NULL 2017-05-29 12:00:00 -04:00 orange NULL F3211 NULL P NULL 923 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-07-17 01:00:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL NULL 923 NULL True 10 0 1 NULL NULL NULL 579242 NULL NULL 0705 2017-07-11 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 101 NULL NULL 356056072591532 NULL NULL 25/01/2017 12:00:00 a.m. 2017-07-11 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/415-59290-0035 SONY NULL 10 NULL NULL 2017-05-29 12:00:00 -04:00 orange NULL F3211 NULL P NULL 923 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-07-17 01:00:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL NULL 923 NULL True 10 0 1 NULL NULL NULL 579242 NULL NULL 0705 2017-07-11 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 101 NULL NULL 356056072591532 NULL NULL 25/01/2017 12:00:00 a.m. 2017-07-11 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/8CS-59290-0006 SONY NULL 10 NULL NULL 2017-05-29 12:00:00 -04:00 orange NULL F3211 NULL P NULL 923 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-07-17 01:00:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL NULL 923 NULL True 10 0 5 NULL NULL NULL 579242 NULL NULL 0705 2017-07-11 12:00:00 -04:00 2017-07-17 12:00:00 -04:00 NULL 0 108 NULL NULL 356056072591532 NULL NULL 25/01/2017 12:00:00 a.m. 2017-07-11 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-05-29 12:00:00 -04:00 orange NULL F3211 NULL P NULL 923 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2017-07-17 01:00:00 -04:00 2017-07-18 09:12:25 -04:00 2017-07-17 12:00:00 -04:00 NULL NULL NULL NULL NULL 923 NULL True 10 0