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 584313 NULL NULL 1206 2017-08-02 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 104 NULL NULL 352504071031608 NULL NULL 10/12/15 12:00:00 a. m. 2017-08-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1287-2024 SONY NULL 10 NULL NULL 2017-03-23 12:00:00 -04:00 orange NULL E6603 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 06:57:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 1 NULL NULL NULL 584313 NULL NULL 1206 2017-08-02 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 101 NULL NULL 352504071031608 NULL NULL 10/12/15 12:00:00 a. m. 2017-08-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1292-7099 SONY NULL 10 NULL NULL 2017-03-23 12:00:00 -04:00 orange NULL E6603 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 06:57:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 1 NULL NULL NULL 584313 NULL NULL 1206 2017-08-02 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 101 NULL NULL 352504071031608 NULL NULL 10/12/15 12:00:00 a. m. 2017-08-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1292-7127 SONY NULL 10 NULL NULL 2017-03-23 12:00:00 -04:00 orange NULL E6603 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 06:57:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 43 NULL NULL NULL 584313 NULL NULL 1206 2017-08-02 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 104 NULL NULL 352504071031608 NULL NULL 10/12/15 12:00:00 a. m. 2017-08-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1292-9864 SONY NULL 10 NULL NULL 2017-03-23 12:00:00 -04:00 orange NULL E6603 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 06:57:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 43 NULL NULL NULL 584313 NULL NULL 1206 2017-08-02 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 104 NULL NULL 352504071031608 NULL NULL 10/12/15 12:00:00 a. m. 2017-08-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1295-0480 SONY NULL 10 NULL NULL 2017-03-23 12:00:00 -04:00 orange NULL E6603 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 06:57:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 43 NULL NULL NULL 584313 NULL NULL 1206 2017-08-02 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 104 NULL NULL 352504071031608 NULL NULL 10/12/15 12:00:00 a. m. 2017-08-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1295-0525 SONY NULL 10 NULL NULL 2017-03-23 12:00:00 -04:00 orange NULL E6603 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 06:57:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 43 NULL NULL NULL 584313 NULL NULL 1206 2017-08-02 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 104 NULL NULL 352504071031608 NULL NULL 10/12/15 12:00:00 a. m. 2017-08-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1295-0526 SONY NULL 10 NULL NULL 2017-03-23 12:00:00 -04:00 orange NULL E6603 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 06:57:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 43 NULL NULL NULL 584313 NULL NULL 1206 2017-08-02 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 104 NULL NULL 352504071031608 NULL NULL 10/12/15 12:00:00 a. m. 2017-08-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1295-0534 SONY NULL 10 NULL NULL 2017-03-23 12:00:00 -04:00 orange NULL E6603 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 06:57:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 1 NULL NULL NULL 584313 NULL NULL 1206 2017-08-02 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 101 NULL NULL 352504071031608 NULL NULL 10/12/15 12:00:00 a. m. 2017-08-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1296-1894 SONY NULL 10 NULL NULL 2017-03-23 12:00:00 -04:00 orange NULL E6603 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 06:57:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 1 NULL NULL NULL 584313 NULL NULL 1206 2017-08-02 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 101 NULL NULL 352504071031608 NULL NULL 10/12/15 12:00:00 a. m. 2017-08-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1302-7193 SONY NULL 10 NULL NULL 2017-03-23 12:00:00 -04:00 orange NULL E6603 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 06:57:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 1 NULL NULL NULL 584313 NULL NULL 1206 2017-08-02 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 101 NULL NULL 352504071031608 NULL NULL 10/12/15 12:00:00 a. m. 2017-08-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1302-7194 SONY NULL 10 NULL NULL 2017-03-23 12:00:00 -04:00 orange NULL E6603 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 06:57:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 5 NULL NULL NULL 584313 NULL NULL 1206 2017-08-02 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 108 NULL NULL 352504071031608 NULL NULL 10/12/15 12:00:00 a. m. 2017-08-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-03-23 12:00:00 -04:00 orange NULL E6603 36.0.A.2.136 P 36.0.a.2.136 704 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2017-08-07 06:57:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 36.0.a.2.136 704 NULL True 10 0 1 NULL NULL NULL 584922 NULL NULL 0705 2017-08-04 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 101 NULL NULL 356057073763088 NULL NULL 3/1/17 12:00:00 a. m. 2017-08-04 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/415-59290-0005 SONY NULL 10 NULL NULL 2017-03-10 12:00:00 -04:00 CLARO NULL F3213 32.A.1.0.132 P 32.a.1.0.132 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 12:48:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 32.a.1.0.132 704 NULL True 10 0 1 NULL NULL NULL 584922 NULL NULL 0705 2017-08-04 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 101 NULL NULL 356057073763088 NULL NULL 3/1/17 12:00:00 a. m. 2017-08-04 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/415-59290-0006 SONY NULL 10 NULL NULL 2017-03-10 12:00:00 -04:00 CLARO NULL F3213 32.A.1.0.132 P 32.a.1.0.132 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 12:48:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 32.a.1.0.132 704 NULL True 10 0 43 NULL NULL NULL 584922 NULL NULL 0705 2017-08-04 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 104 NULL NULL 356057073763088 NULL NULL 3/1/17 12:00:00 a. m. 2017-08-04 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-03-10 12:00:00 -04:00 CLARO NULL F3213 32.A.1.0.132 P 32.a.1.0.132 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 12:48:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 32.a.1.0.132 704 NULL True 10 0 1 NULL NULL NULL 584922 NULL NULL 0705 2017-08-04 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 101 NULL NULL 356057073763088 NULL NULL 3/1/17 12:00:00 a. m. 2017-08-04 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-03-10 12:00:00 -04:00 CLARO NULL F3213 32.A.1.0.132 P 32.a.1.0.132 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 12:48:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 32.a.1.0.132 704 NULL True 10 0 1 NULL NULL NULL 584922 NULL NULL 0705 2017-08-04 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 101 NULL NULL 356057073763088 NULL NULL 3/1/17 12:00:00 a. m. 2017-08-04 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-03-10 12:00:00 -04:00 CLARO NULL F3213 32.A.1.0.132 P 32.a.1.0.132 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 12:48:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 32.a.1.0.132 704 NULL True 10 0 43 NULL NULL NULL 584922 NULL NULL 0705 2017-08-04 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 104 NULL NULL 356057073763088 NULL NULL 3/1/17 12:00:00 a. m. 2017-08-04 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/415-59290-0042 SONY NULL 10 NULL NULL 2017-03-10 12:00:00 -04:00 CLARO NULL F3213 32.A.1.0.132 P 32.a.1.0.132 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 12:48:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 32.a.1.0.132 704 NULL True 10 0 1 NULL NULL NULL 584922 NULL NULL 0705 2017-08-04 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 101 NULL NULL 356057073763088 NULL NULL 3/1/17 12:00:00 a. m. 2017-08-04 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-03-10 12:00:00 -04:00 CLARO NULL F3213 32.A.1.0.132 P 32.a.1.0.132 704 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2017-08-07 12:48:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 32.a.1.0.132 704 NULL True 10 0 5 NULL NULL NULL 584922 NULL NULL 0705 2017-08-04 12:00:00 -04:00 2017-08-07 12:00:00 -04:00 NULL 0 108 NULL NULL 356057073763088 NULL NULL 3/1/17 12:00:00 a. m. 2017-08-04 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-03-10 12:00:00 -04:00 CLARO NULL F3213 32.A.1.0.132 P 32.a.1.0.132 704 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2017-08-07 12:48:00 -04:00 2017-08-08 11:20:03 -04:00 2017-08-07 12:00:00 -04:00 NULL NULL NULL NULL 32.a.1.0.132 704 NULL True 10 0