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 606639 NULL NULL 1206 2017-10-31 12:00:00 -04:00 2017-11-02 12:00:00 -04:00 NULL 0 104 NULL NULL 354395082889276 NULL NULL 5/1/17 12:00:00 a. m. 2017-10-31 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 306Q1N10F00 SONY NULL 10 NULL NULL 2017-09-30 12:00:00 -04:00 orange NULL F3111 33.3.a.0.131 P 33.3.A.0.131 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-11-02 02:12:00 -04:00 2017-11-03 09:04:07 -04:00 2017-11-02 12:00:00 -04:00 NULL NULL NULL NULL 33.3.A.0.131 890 NULL True 10 0 1 NULL NULL NULL 606639 NULL NULL 1206 2017-10-31 12:00:00 -04:00 2017-11-02 12:00:00 -04:00 NULL 0 101 NULL NULL 354395082889276 NULL NULL 5/1/17 12:00:00 a. m. 2017-10-31 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 78PA3100090 SONY NULL 10 NULL NULL 2017-09-30 12:00:00 -04:00 orange NULL F3111 33.3.a.0.131 P 33.3.A.0.131 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-11-02 02:12:00 -04:00 2017-11-03 09:04:07 -04:00 2017-11-02 12:00:00 -04:00 NULL NULL NULL NULL 33.3.A.0.131 890 NULL True 10 0 1 NULL NULL NULL 606639 NULL NULL 1206 2017-10-31 12:00:00 -04:00 2017-11-02 12:00:00 -04:00 NULL 0 101 NULL NULL 354395082889276 NULL NULL 5/1/17 12:00:00 a. m. 2017-10-31 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 78PA3500010 SONY NULL 10 NULL NULL 2017-09-30 12:00:00 -04:00 orange NULL F3111 33.3.a.0.131 P 33.3.A.0.131 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-11-02 02:12:00 -04:00 2017-11-03 09:04:07 -04:00 2017-11-02 12:00:00 -04:00 NULL NULL NULL NULL 33.3.A.0.131 890 NULL True 10 0 5 NULL NULL NULL 606639 NULL NULL 1206 2017-10-31 12:00:00 -04:00 2017-11-02 12:00:00 -04:00 NULL 0 108 NULL NULL 354395082889276 NULL NULL 5/1/17 12:00:00 a. m. 2017-10-31 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-09-30 12:00:00 -04:00 orange NULL F3111 33.3.a.0.131 P 33.3.A.0.131 890 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2017-11-02 02:12:00 -04:00 2017-11-03 09:04:07 -04:00 2017-11-02 12:00:00 -04:00 NULL NULL NULL NULL 33.3.A.0.131 890 NULL True 10 0 1 NULL NULL NULL 606655 NULL NULL 0402 2017-11-01 12:00:00 -04:00 2017-11-02 12:00:00 -04:00 NULL 0 101 NULL NULL 357444080720807 NULL NULL 31/7/17 12:00:00 a. m. 2017-11-01 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 73200000Y00 SONY NULL 10 NULL NULL 2017-09-28 12:00:00 -04:00 CLARO NULL G3123 40.0.a.3.7 P 40.0.A.3.7 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-11-02 10:43:00 -04:00 2017-11-03 09:04:07 -04:00 2017-11-02 12:00:00 -04:00 NULL NULL NULL NULL 40.0.A.3.7 890 NULL True 10 0 5 NULL NULL NULL 606655 NULL NULL 0402 2017-11-01 12:00:00 -04:00 2017-11-02 12:00:00 -04:00 NULL 0 108 NULL NULL 357444080720807 NULL NULL 31/7/17 12:00:00 a. m. 2017-11-01 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-09-28 12:00:00 -04:00 CLARO NULL G3123 40.0.a.3.7 P 40.0.A.3.7 890 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2017-11-02 10:43:00 -04:00 2017-11-03 09:04:07 -04:00 2017-11-02 12:00:00 -04:00 NULL NULL NULL NULL 40.0.A.3.7 890 NULL True 10 0 43 NULL NULL NULL 606708 NULL NULL 0705 2017-11-01 12:00:00 -04:00 2017-11-02 12:00:00 -04:00 NULL 0 104 NULL NULL 358125076981896 NULL NULL 20/9/16 12:00:00 a. m. 2017-11-01 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1298-9239 SONY NULL 10 NULL NULL 2016-11-04 12:00:00 -04:00 orange NULL F3111 33.3.a.0.131 P 33.3.A.0.131 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-11-02 02:10:00 -04:00 2017-11-03 09:04:07 -04:00 2017-11-02 12:00:00 -04:00 NULL NULL NULL NULL 33.3.A.0.131 890 NULL True 10 0 1 NULL NULL NULL 606708 NULL NULL 0705 2017-11-01 12:00:00 -04:00 2017-11-02 12:00:00 -04:00 NULL 0 101 NULL NULL 358125076981896 NULL NULL 20/9/16 12:00:00 a. m. 2017-11-01 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 2240000027W SONY NULL 10 NULL NULL 2016-11-04 12:00:00 -04:00 orange NULL F3111 33.3.a.0.131 P 33.3.A.0.131 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-11-02 02:10:00 -04:00 2017-11-03 09:04:07 -04:00 2017-11-02 12:00:00 -04:00 NULL NULL NULL NULL 33.3.A.0.131 890 NULL True 10 0 43 NULL NULL NULL 606708 NULL NULL 0705 2017-11-01 12:00:00 -04:00 2017-11-02 12:00:00 -04:00 NULL 0 104 NULL NULL 358125076981896 NULL NULL 20/9/16 12:00:00 a. m. 2017-11-01 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 306L1N10600 SONY NULL 10 NULL NULL 2016-11-04 12:00:00 -04:00 orange NULL F3111 33.3.a.0.131 P 33.3.A.0.131 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-11-02 02:10:00 -04:00 2017-11-03 09:04:07 -04:00 2017-11-02 12:00:00 -04:00 NULL NULL NULL NULL 33.3.A.0.131 890 NULL True 10 0 43 NULL NULL NULL 606708 NULL NULL 0705 2017-11-01 12:00:00 -04:00 2017-11-02 12:00:00 -04:00 NULL 0 104 NULL NULL 358125076981896 NULL NULL 20/9/16 12:00:00 a. m. 2017-11-01 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 306L1N10700 SONY NULL 10 NULL NULL 2016-11-04 12:00:00 -04:00 orange NULL F3111 33.3.a.0.131 P 33.3.A.0.131 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-11-02 02:10:00 -04:00 2017-11-03 09:04:07 -04:00 2017-11-02 12:00:00 -04:00 NULL NULL NULL NULL 33.3.A.0.131 890 NULL True 10 0 1 NULL NULL NULL 606708 NULL NULL 0705 2017-11-01 12:00:00 -04:00 2017-11-02 12:00:00 -04:00 NULL 0 101 NULL NULL 358125076981896 NULL NULL 20/9/16 12:00:00 a. m. 2017-11-01 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 78PA3000010 SONY NULL 10 NULL NULL 2016-11-04 12:00:00 -04:00 orange NULL F3111 33.3.a.0.131 P 33.3.A.0.131 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-11-02 02:10:00 -04:00 2017-11-03 09:04:07 -04:00 2017-11-02 12:00:00 -04:00 NULL NULL NULL NULL 33.3.A.0.131 890 NULL True 10 0 1 NULL NULL NULL 606708 NULL NULL 0705 2017-11-01 12:00:00 -04:00 2017-11-02 12:00:00 -04:00 NULL 0 101 NULL NULL 358125076981896 NULL NULL 20/9/16 12:00:00 a. m. 2017-11-01 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 78PA3100030 SONY NULL 10 NULL NULL 2016-11-04 12:00:00 -04:00 orange NULL F3111 33.3.a.0.131 P 33.3.A.0.131 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-11-02 02:10:00 -04:00 2017-11-03 09:04:07 -04:00 2017-11-02 12:00:00 -04:00 NULL NULL NULL NULL 33.3.A.0.131 890 NULL True 10 0 1 NULL NULL NULL 606708 NULL NULL 0705 2017-11-01 12:00:00 -04:00 2017-11-02 12:00:00 -04:00 NULL 0 101 NULL NULL 358125076981896 NULL NULL 20/9/16 12:00:00 a. m. 2017-11-01 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 78PA3300010 SONY NULL 10 NULL NULL 2016-11-04 12:00:00 -04:00 orange NULL F3111 33.3.a.0.131 P 33.3.A.0.131 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-11-02 02:10:00 -04:00 2017-11-03 09:04:07 -04:00 2017-11-02 12:00:00 -04:00 NULL NULL NULL NULL 33.3.A.0.131 890 NULL True 10 0 1 NULL NULL NULL 606708 NULL NULL 0705 2017-11-01 12:00:00 -04:00 2017-11-02 12:00:00 -04:00 NULL 0 101 NULL NULL 358125076981896 NULL NULL 20/9/16 12:00:00 a. m. 2017-11-01 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 78PA3600010 SONY NULL 10 NULL NULL 2016-11-04 12:00:00 -04:00 orange NULL F3111 33.3.a.0.131 P 33.3.A.0.131 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-11-02 02:10:00 -04:00 2017-11-03 09:04:07 -04:00 2017-11-02 12:00:00 -04:00 NULL NULL NULL NULL 33.3.A.0.131 890 NULL True 10 0 5 NULL NULL NULL 606708 NULL NULL 0705 2017-11-01 12:00:00 -04:00 2017-11-02 12:00:00 -04:00 NULL 0 108 NULL NULL 358125076981896 NULL NULL 20/9/16 12:00:00 a. m. 2017-11-01 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2016-11-04 12:00:00 -04:00 orange NULL F3111 33.3.a.0.131 P 33.3.A.0.131 890 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2017-11-02 02:10:00 -04:00 2017-11-03 09:04:07 -04:00 2017-11-02 12:00:00 -04:00 NULL NULL NULL NULL 33.3.A.0.131 890 NULL True 10 0 43 NULL NULL NULL 605118 NULL NULL 0602 2017-10-25 12:00:00 -04:00 2017-10-30 12:00:00 -04:00 NULL 0 104 NULL NULL 358126074551400 NULL NULL 9/1/17 12:00:00 a. m. 2017-10-25 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL XXKS100997W SONY NULL 10 NULL NULL 2017-07-25 12:00:00 -04:00 CLARO NULL F3113 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-10-30 10:00:00 -04:00 2017-11-03 09:04:07 -04:00 2017-10-30 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 43 NULL NULL NULL 605118 NULL NULL 0602 2017-10-25 12:00:00 -04:00 2017-10-30 12:00:00 -04:00 NULL 0 104 NULL NULL 358126074551400 NULL NULL 9/1/17 12:00:00 a. m. 2017-10-25 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL XXKS100994W SONY NULL 10 NULL NULL 2017-07-25 12:00:00 -04:00 CLARO NULL F3113 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-10-30 10:00:00 -04:00 2017-11-03 09:04:07 -04:00 2017-10-30 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 43 NULL NULL NULL 605118 NULL NULL 0602 2017-10-25 12:00:00 -04:00 2017-10-30 12:00:00 -04:00 NULL 0 104 NULL NULL 358126074551400 NULL NULL 9/1/17 12:00:00 a. m. 2017-10-25 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 251K1N10200 SONY NULL 10 NULL NULL 2017-07-25 12:00:00 -04:00 CLARO NULL F3113 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-10-30 10:00:00 -04:00 2017-11-03 09:04:07 -04:00 2017-10-30 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 43 NULL NULL NULL 605118 NULL NULL 0602 2017-10-25 12:00:00 -04:00 2017-10-30 12:00:00 -04:00 NULL 0 104 NULL NULL 358126074551400 NULL NULL 9/1/17 12:00:00 a. m. 2017-10-25 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 254FVY3606W SONY NULL 10 NULL NULL 2017-07-25 12:00:00 -04:00 CLARO NULL F3113 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-10-30 10:00:00 -04:00 2017-11-03 09:04:07 -04:00 2017-10-30 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 1 NULL NULL NULL 605118 NULL NULL 0602 2017-10-25 12:00:00 -04:00 2017-10-30 12:00:00 -04:00 NULL 0 101 NULL NULL 358126074551400 NULL NULL 9/1/17 12:00:00 a. m. 2017-10-25 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 78PA3100090 SONY NULL 10 NULL NULL 2017-07-25 12:00:00 -04:00 CLARO NULL F3113 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-10-30 10:00:00 -04:00 2017-11-03 09:04:07 -04:00 2017-10-30 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 1 NULL NULL NULL 605118 NULL NULL 0602 2017-10-25 12:00:00 -04:00 2017-10-30 12:00:00 -04:00 NULL 0 101 NULL NULL 358126074551400 NULL NULL 9/1/17 12:00:00 a. m. 2017-10-25 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 78PA3000030 SONY NULL 10 NULL NULL 2017-07-25 12:00:00 -04:00 CLARO NULL F3113 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-10-30 10:00:00 -04:00 2017-11-03 09:04:07 -04:00 2017-10-30 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 5 NULL NULL NULL 605118 NULL NULL 0602 2017-10-25 12:00:00 -04:00 2017-10-30 12:00:00 -04:00 NULL 0 108 NULL NULL 358126074551400 NULL NULL 9/1/17 12:00:00 a. m. 2017-10-25 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-07-25 12:00:00 -04:00 CLARO NULL F3113 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2017-10-30 10:00:00 -04:00 2017-11-03 09:04:07 -04:00 2017-10-30 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 5 NULL NULL NULL 605022 NULL NULL 0004 2017-10-25 12:00:00 -04:00 2017-10-30 12:00:00 -04:00 NULL 0 107 NULL NULL 359667074890719 NULL NULL 8/3/16 12:00:00 a. m. 2017-10-25 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-07-10 12:00:00 -04:00 CLARO NULL F3313 37.0.a.2.108 P 37.0.A.2.108 890 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2017-10-30 05:00:00 -04:00 2017-11-03 09:04:07 -04:00 2017-10-30 12:00:00 -04:00 NULL NULL NULL NULL 37.0.A.2.108 890 NULL True 10 0