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 630239 NULL NULL 0705 2018-02-06 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 1302-3924 109 NULL NULL 354395082892494 354395080284157 NULL 5/1/17 12:00:00 a. m. 2018-02-06 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1302-3924 SONY NULL 10 NULL NULL 2017-12-01 12:00:00 -04:00 orange NULL F3111 NULL P NULL 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 01:50:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL NULL 890 NULL True 10 0 8 NULL NULL NULL 630239 NULL NULL 0705 2018-02-06 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 1302-3924 109 NULL NULL 354395082892494 354395080284157 NULL 5/1/17 12:00:00 a. m. 2018-02-06 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-12-01 12:00:00 -04:00 orange NULL F3111 NULL P NULL 890 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-02-08 01:50:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL NULL 890 NULL True 10 0 11 NULL NULL NULL 626016 NULL NULL 0004 2018-01-18 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 1295-0626 109 NULL NULL 355386050629611 356579078566356 NULL 1/8/15 12:00:00 a. m. 2018-01-18 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1295-0626 SONY NULL 10 NULL NULL 2017-08-17 12:00:00 -04:00 orange NULL C6506 NULL P NULL 550 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 09:01:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL NULL 550 NULL True 10 0 8 NULL NULL NULL 626016 NULL NULL 0004 2018-01-18 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 1295-0626 109 NULL NULL 355386050629611 356579078566356 NULL 1/8/15 12:00:00 a. m. 2018-01-18 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-08-17 12:00:00 -04:00 orange NULL C6506 NULL P NULL 550 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-02-08 09:01:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL NULL 550 NULL True 10 0 1 NULL NULL NULL 629546 NULL NULL 1501 2018-02-02 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 101 NULL NULL 356056072439633 NULL NULL 4/1/17 12:00:00 a. m. 2018-02-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1293-8715 SONY NULL 10 NULL NULL 2017-09-26 12:00:00 -04:00 orange NULL F3211 36.1.A.1.186 P 36.1.A.1.186 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 04:51:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL 36.1.A.1.186 890 NULL True 10 0 1 NULL NULL NULL 629546 NULL NULL 1501 2018-02-02 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 101 NULL NULL 356056072439633 NULL NULL 4/1/17 12:00:00 a. m. 2018-02-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/320-0000-00095 SONY NULL 10 NULL NULL 2017-09-26 12:00:00 -04:00 orange NULL F3211 36.1.A.1.186 P 36.1.A.1.186 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 04:51:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL 36.1.A.1.186 890 NULL True 10 0 43 NULL NULL NULL 629546 NULL NULL 1501 2018-02-02 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 104 NULL NULL 356056072439633 NULL NULL 4/1/17 12:00:00 a. m. 2018-02-02 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-09-26 12:00:00 -04:00 orange NULL F3211 36.1.A.1.186 P 36.1.A.1.186 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 04:51:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL 36.1.A.1.186 890 NULL True 10 0 1 NULL NULL NULL 629546 NULL NULL 1501 2018-02-02 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 101 NULL NULL 356056072439633 NULL NULL 4/1/17 12:00:00 a. m. 2018-02-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/8CS-59290-0001 SONY NULL 10 NULL NULL 2017-09-26 12:00:00 -04:00 orange NULL F3211 36.1.A.1.186 P 36.1.A.1.186 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 04:51:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL 36.1.A.1.186 890 NULL True 10 0 1 NULL NULL NULL 629546 NULL NULL 1501 2018-02-02 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 101 NULL NULL 356056072439633 NULL NULL 4/1/17 12:00:00 a. m. 2018-02-02 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-09-26 12:00:00 -04:00 orange NULL F3211 36.1.A.1.186 P 36.1.A.1.186 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 04:51:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL 36.1.A.1.186 890 NULL True 10 0 5 NULL NULL NULL 629546 NULL NULL 1501 2018-02-02 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 108 NULL NULL 356056072439633 NULL NULL 4/1/17 12:00:00 a. m. 2018-02-02 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-09-26 12:00:00 -04:00 orange NULL F3211 36.1.A.1.186 P 36.1.A.1.186 890 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-02-08 04:51:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL 36.1.A.1.186 890 NULL True 10 0 1 NULL NULL NULL 629267 NULL NULL 1501 2018-02-01 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 101 NULL NULL 356056072441852 NULL NULL 2/1/17 12:00:00 a. m. 2018-02-01 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1293-8715 SONY NULL 10 NULL NULL 2017-09-18 12:00:00 -04:00 orange NULL F3211 36.1.A.1.186 P 36.1.A.1.186 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 04:54:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL 36.1.A.1.186 890 NULL True 10 0 1 NULL NULL NULL 629267 NULL NULL 1501 2018-02-01 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 101 NULL NULL 356056072441852 NULL NULL 2/1/17 12:00:00 a. m. 2018-02-01 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/320-0000-00095 SONY NULL 10 NULL NULL 2017-09-18 12:00:00 -04:00 orange NULL F3211 36.1.A.1.186 P 36.1.A.1.186 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 04:54:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL 36.1.A.1.186 890 NULL True 10 0 43 NULL NULL NULL 629267 NULL NULL 1501 2018-02-01 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 104 NULL NULL 356056072441852 NULL NULL 2/1/17 12:00:00 a. m. 2018-02-01 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-09-18 12:00:00 -04:00 orange NULL F3211 36.1.A.1.186 P 36.1.A.1.186 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 04:54:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL 36.1.A.1.186 890 NULL True 10 0 1 NULL NULL NULL 629267 NULL NULL 1501 2018-02-01 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 101 NULL NULL 356056072441852 NULL NULL 2/1/17 12:00:00 a. m. 2018-02-01 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/8CS-59290-0001 SONY NULL 10 NULL NULL 2017-09-18 12:00:00 -04:00 orange NULL F3211 36.1.A.1.186 P 36.1.A.1.186 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 04:54:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL 36.1.A.1.186 890 NULL True 10 0 1 NULL NULL NULL 629267 NULL NULL 1501 2018-02-01 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 101 NULL NULL 356056072441852 NULL NULL 2/1/17 12:00:00 a. m. 2018-02-01 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL A/8CS-59290-0003 SONY NULL 10 NULL NULL 2017-09-18 12:00:00 -04:00 orange NULL F3211 36.1.A.1.186 P 36.1.A.1.186 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 04:54:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL 36.1.A.1.186 890 NULL True 10 0 5 NULL NULL NULL 629267 NULL NULL 1501 2018-02-01 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 108 NULL NULL 356056072441852 NULL NULL 2/1/17 12:00:00 a. m. 2018-02-01 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-09-18 12:00:00 -04:00 orange NULL F3211 36.1.A.1.186 P 36.1.A.1.186 890 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-02-08 04:54:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL 36.1.A.1.186 890 NULL True 10 0 11 NULL NULL NULL 630691 NULL NULL 1003 2018-02-07 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 1308-2451 109 NULL NULL 358009082276196 358009080672032 NULL 1/1/00 12:00:00 a. m. 2018-02-07 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 1308-2451 SONY NULL 10 NULL NULL 2017-11-24 12:00:00 -04:00 orange NULL G3221 NULL P NULL 890 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 01:48:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL NULL 890 NULL True 10 0 8 NULL NULL NULL 630691 NULL NULL 1003 2018-02-07 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 1308-2451 109 NULL NULL 358009082276196 358009080672032 NULL 1/1/00 12:00:00 a. m. 2018-02-07 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-11-24 12:00:00 -04:00 orange NULL G3221 NULL P NULL 890 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-02-08 01:48:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL NULL 890 NULL True 10 0 1 NULL NULL NULL 630617 NULL NULL 1501 2018-02-07 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 101 NULL NULL 358119080855980 NULL NULL 24/7/17 12:00:00 a. m. 2018-02-07 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 78PB3400090 SONY NULL 10 NULL NULL 2017-10-16 12:00:00 -04:00 CLARO NULL G3223 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 04:37:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 630617 NULL NULL 1501 2018-02-07 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 101 NULL NULL 358119080855980 NULL NULL 24/7/17 12:00:00 a. m. 2018-02-07 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 78PB3500010 SONY NULL 10 NULL NULL 2017-10-16 12:00:00 -04:00 CLARO NULL G3223 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 04:37:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 630617 NULL NULL 1501 2018-02-07 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 101 NULL NULL 358119080855980 NULL NULL 24/7/17 12:00:00 a. m. 2018-02-07 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 78PB3600010 SONY NULL 10 NULL NULL 2017-10-16 12:00:00 -04:00 CLARO NULL G3223 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 04:37:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 5 NULL NULL NULL 630617 NULL NULL 1501 2018-02-07 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 108 NULL NULL 358119080855980 NULL NULL 24/7/17 12:00:00 a. m. 2018-02-07 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-10-16 12:00:00 -04:00 CLARO NULL G3223 NULL P NULL 2196 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-02-08 04:37:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 630285 NULL NULL 0501 2018-02-06 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 101 NULL NULL 358119082522547 NULL NULL 1/1/00 12:00:00 a. m. 2018-02-06 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 78PB3500010 SONY NULL 10 NULL NULL 2017-12-01 12:00:00 -04:00 CLARO NULL G3223 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 05:36:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 1 NULL NULL NULL 630285 NULL NULL 0501 2018-02-06 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 101 NULL NULL 358119082522547 NULL NULL 1/1/00 12:00:00 a. m. 2018-02-06 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL 78PB3600010 SONY NULL 10 NULL NULL 2017-12-01 12:00:00 -04:00 CLARO NULL G3223 NULL P NULL 2196 SONY NULL NULL 1 NULL NULL NULL NULL 6496 13 2018-02-08 05:36:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0 5 NULL NULL NULL 630285 NULL NULL 0501 2018-02-06 12:00:00 -04:00 2018-02-08 12:00:00 -04:00 NULL 0 108 NULL NULL 358119082522547 NULL NULL 1/1/00 12:00:00 a. m. 2018-02-06 12:00:00 -04:00 NULL 0001-01-01 12:00:00 -04:00 NULL NULL SONY NULL 10 NULL NULL 2017-12-01 12:00:00 -04:00 CLARO NULL G3223 NULL P NULL 2196 SONY NULL NULL NULL NULL NULL NULL NULL 6496 13 2018-02-08 05:36:00 -04:00 2018-02-09 09:52:05 -04:00 2018-02-08 12:00:00 -04:00 NULL NULL NULL NULL NULL 2196 NULL True 10 0