API tools faq
paste
Advertisement
Guest User

Search-TC8

a guest
Aug 23rd, 2019
174
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 152.99 KB | None | 0 0
raw download clone embed print report
  1. INSERT INTO "3pl_detail"("id","header_id","request_id","reference_number","reference_type","detail_type","activity","raw_data","translated_data","note","created_by","created_on","modified_by","modified_on")
  2. VALUES
  3. (10,9,E'SCP-896 INB-002',E'RefNumber SCP-896 INB-001 001',E'DN',E'OUTBOUND_REQUEST',E'TRANSLATION_FAILED',E'{"request_id":"SCP-896 INB-001","reference_number":"RefNumber SCP-896 INB-001 001","reference_type":1,"outbound_type":1,"order":{"order_number":"OrderNumber SCP-896 INB-001001","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557376071,"nanos":720637000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"1e15c0fa-c310-48c9-8a42-61dbc375c1f3","timestamp":{"seconds":1557376071,"nanos":720930000}}}',E'',E'',E'3PL LOGIC',E'2019-05-09 04:27:51.889494+00',E'3PL TRANSLATOR',E'2019-05-09 04:27:52.520545+00'),
  4. (11,10,E'SCP-896 INB-001002',E'RefNumber SCP-896 INB-001 002',E'DN',E'OUTBOUND_REQUEST',E'SENT_TO_3PL',E'{"request_id":"SCP-896 INB-001002","reference_number":"RefNumber SCP-896 INB-001 002","reference_type":1,"outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 INB-001002","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557376221,"nanos":454107000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"22f37db5-0bb1-4da1-83c1-945b0ce41fd8","timestamp":{"seconds":1557376221,"nanos":454293000}}}',E'{"header":{"shdl":"SHDL","interface_record_id":"SCP-896 INB-001002","shipment_id":"OrderNumber SCP-896 INB-001002","warehouse":"WH01","accessorial_charge":"0","actual_delivery_date_time":"","actual_ship_date":"","allocate_complete":"","alternate_email_address":"","authorized_employee_name":"","authorized_employee_title":"","base_freight_charge":"0","bill_of_lading":"","carrier":"Custom","carrier_group":"","carrier_service":"","carrier_type":"","company":"RMA","consolidated":"","consolidation_allowed":"","consolidation_location_area":"","consolidation_location_position":"","containerized":"","containers_shipped":"","create_orders_from_shipments":"","creation_date_time_stamp":"20190509","creation_process_stamp":"","customer":"blo.jakartaselatan@ruma.co.id","customer_address_1":"Bukan di Bulungan","customer_address_2":"","customer_address_3":"","customer_attention_to":"","category_1":"","category_10":"","category_2":"","category_3":"","category_4":"","category_5":"","category_6":"","category_7":"","category_8":"","category_9":"","customer_city":"Jakarta Selatan","customer_country":"Indonesia","customer_email_address":"blo.jakartaselatan@ruma.co.id","customer_fax_number":"","customer_name":"blo.jakartaselatan@ruma.co.id ","customer_phone_number":"+62 21 5331638","customer_po":"","customer_postal_code":"12130","customer_residential_flag":"","customer_state":"","date_time_stamp":"20190509","eccn":"","erp_order":"","export_port":"","export_tax_id":"","freight_bill_to":"","freight_bill_to_address_1":"","freight_bill_to_address_2":"","freight_bill_to_address_3":"","freight_bill_to_attention_to":"","freight_bill_to_city":"","freight_bill_to_country":"","freight_bill_to_email_address":"","freight_bill_to_fax_number":"","freight_bill_to_name":"","freight_bill_to_phone_number":"","freight_bill_to_postal_code":"","freight_bill_to_state":"","freight_discount":"0","freight_terms":"","ftz":"","immed_needs_note":"","intermediate_address_1":"","intermediate_address_2":"","intermediate_address_3":"","intermediate_attention_to":"","intermediate_city":"","intermediate_consignee":"","intermediate_country":"","intermediate_email_address":"","intermediate_fax_number":"","intermediate_name":"","intermediate_phone_number":"","intermediate_postal_code":"","intermediate_state":"","liability_terms":"","license_expiration_date":"","loading_pier":"","order_date":"","order_type":"","parties":"","planned_delivery_date_time":"","planned_ship_date":"","priority":"0","pro_number":"","process_stamp":"","process_type":"TF002","quantity_um":"","rejection_note":"","requested_delivery_date":"","requested_delivery_type":"","route":"","routing_code":"","scheduled_ship_date":"20190415","ship_to":"blo.jakartaselatan@ruma.co.id","ship_to_address_1":"Bukan di Bulungan","ship_to_address_2":"","ship_to_address_3":"","ship_to_attention_to":"","ship_to_city":"Jakarta Selatan","ship_to_country":"Indonesia","ship_to_email_address":"blo.jakartaselatan@ruma.co.id","ship_to_fax_number":"","ship_to_name":"blo.jakartaselatan@ruma.co.id ","ship_to_phone_number":"+62 21 5331638","ship_to_postal_code":"12130","ship_to_state":"","shipper_code":"","ship_to_residential_flag":"","single_item_cartons":"","stop":"","stop_sequence":"","store_distribution":"","temp_internal_order_number":"","temp_internal_shipment_number":"","total_freight_charge":"0","transportation_mode":"","unloading_port":"","user_defined_field_1":"","user_defined_field_2":"","user_defined_field_3":"","user_defined_field_4":"","user_defined_field_5":"0","user_defined_field_6":"0","user_defined_field_7":"0","user_defined_field_8":"0","user_stamp":"","validated_license":"","value_shipped":"","volume_shipped":"","volume_um":"","weight_shipped":"","weight_um":""},"detail":[{"sddl":"SDDL","erp_order_line_number":"1","interface_link_id":"SCP-896 INB-001002","interface_record_id":"1","item":"AANX12358","total_qty":"1","allocate_full_location_quantity":"","allocation_rule":"","allow_percent_allocation":"","shipment_bom_action":"","catalog_id":"","catch_weight_required":"","company":"RMA","container_creation_full_quantity":"","container_creation_full_quantity_um":"","container_creation_inner_pack_quantity":"","country_of_origin":"","customer_item":"","customer_po":"","date_time_stamp":"20190509","erp_order":"","export_description":"","harmonized_code":"","harmonized_description":"","hazardous_code":"","eligible_for_immediate_needs":"","immediate_needs_locating_rule":"","immed_needs_note":"","initial_qty":"","initial_value":"","initial_volume":"","initial_weight":"","invoice":"","category_1":"Alat masak","category_10":"","category_2":"UNKNOWN","category_3":"NON_DROPSHIP","category_4":"","category_5":"","category_6":"","category_7":"","category_8":"","category_9":"","item_class":"SOLID","item_color":"","item_department":"","item_description":"Kompor Rinnai 2 Tungku","item_dimension_um":"","item_division":"","item_height":"15","item_length":"100","item_list_price":"0","item_net_price":"0","item_size":"","item_style":"","item_weight":"2000","item_width":"40","license_plate":"","lot":"","lot_controlled":"","manufacturer_id":"","mark_for":"","mark_for_address_1":"","mark_for_address_2":"","mark_for_address_3":"","mark_for_attention_to":"","mark_for_city":"","mark_for_country":"","mark_for_email_address":"","mark_for_fax_number":"","mark_for_name":"","mark_for_phone_number":"","mark_for_postal_code":"","mark_for_state":"","maximum_allocation_percentage":"100","merchandise_code":"","minimum_allocation_percentage":"100","net_cost":"","nmfc_code":"","open_qty":"0","order_date":"","order_priority":"","original_item_ordered":"","packing_category":"","packing_class":"","parent_license_plate":"","pick_list_id":"","pick_location":"","pick_zone":"","planned_ship_date":"20190415","preference_criteria":"","priority":"","process_stamp":"","producer":"N","quantity_needed_per_item":"0","quantity_um":"","requested_delivery_date":"","requested_delivery_type":"","requested_quantity":"1","secondary_pick_location":"","secondary_pick_zone":"","serial_number_required":"","shipment_id":"OrderNumber SCP-896 INB-001002","shipped_qty":"1","status_flow_name":"","store_distribution":"","temp_internal_order_detail_number":"","temp_internal_order_number":"","temp_internal_shipment_line_number":"","temp_internal_shipment_number":"","treat_as_loose":"","user_defined_field_1":"","user_defined_field_2":"","user_defined_field_3":"","user_defined_field_4":"","user_defined_field_5":"0","user_defined_field_6":"0","user_defined_field_7":"0","user_defined_field_8":"0","user_stamp":"ILSSRV","value":"0","value_add_label_code":"","volume_um":"","warehouse":"WH01","weight_um":""}]}',E'',E'3PL LOGIC',E'2019-05-09 04:30:31.739094+00',E'DHL ADAPTER',E'2019-05-09 04:30:36.683221+00'),
  5. (15,14,E'SCP-896 INB-002 attempt 002',E'RefNumber SCP-896 INB-002 attempt 002',E'DN',E'OUTBOUND_REQUEST',E'REJECTED',E'{"request_id":"SCP-896 INB-002 attempt 002","reference_number":"RefNumber SCP-896 INB-002 attempt 002","reference_type":1,"outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 INB-002 attempt 002","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557376495,"nanos":516249000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"3ccc06ac-95d9-4ce7-90e3-c242e0a1c5b5","timestamp":{"seconds":1557376495,"nanos":516499000}}}',E'',E'proto field Order.ShippedFromId is empty',E'3PL LOGIC',E'2019-05-09 04:34:55.559282+00',E'3PL LOGIC',E'2019-05-09 04:34:55.814576+00'),
  6. (31,28,E'SCP-896 OTB-007 attempt 001',E'RefNumber SCP-896 OTB-007 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'REJECTED',E'{"request_id":"SCP-896 OTB-007 attempt 001","reference_number":"RefNumber SCP-896 OTB-007 attempt 001","reference_type":1,"outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 OTB-007 attempt 001","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557378125,"nanos":821906000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"b6b28dfb-9dc0-41e0-92e9-4269936365cf","timestamp":{"seconds":1557378125,"nanos":822132000}}}',E'',E'proto field Order.ShippedToId is empty',E'3PL LOGIC',E'2019-05-09 05:02:05.866747+00',E'3PL LOGIC',E'2019-05-09 05:02:06.117197+00'),
  7. (13,12,E'SCP-896 INB-002 attempt 001',E'RefNumber SCP-896 INB-002 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'SENT_TO_3PL',E'{"request_id":"SCP-896 INB-002 attempt 001","reference_number":"RefNumber SCP-896 INB-002 attempt 001","reference_type":1,"outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 INB-002 attempt 001","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557376404,"nanos":792262000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"1f2c2305-1369-4c05-9f5b-18ffb092c7ea","timestamp":{"seconds":1557376404,"nanos":792500000}}}',E'{"header":{"shdl":"SHDL","interface_record_id":"SCP-896 INB-002 attempt 001","shipment_id":"OrderNumber SCP-896 INB-002 attempt 001","warehouse":"WH01","accessorial_charge":"0","actual_delivery_date_time":"","actual_ship_date":"","allocate_complete":"","alternate_email_address":"","authorized_employee_name":"","authorized_employee_title":"","base_freight_charge":"0","bill_of_lading":"","carrier":"Custom","carrier_group":"","carrier_service":"","carrier_type":"","company":"RMA","consolidated":"","consolidation_allowed":"","consolidation_location_area":"","consolidation_location_position":"","containerized":"","containers_shipped":"","create_orders_from_shipments":"","creation_date_time_stamp":"20190509","creation_process_stamp":"","customer":"blo.jakartaselatan@ruma.co.id","customer_address_1":"Bukan di Bulungan","customer_address_2":"","customer_address_3":"","customer_attention_to":"","category_1":"","category_10":"","category_2":"","category_3":"","category_4":"","category_5":"","category_6":"","category_7":"","category_8":"","category_9":"","customer_city":"Jakarta Selatan","customer_country":"Indonesia","customer_email_address":"blo.jakartaselatan@ruma.co.id","customer_fax_number":"","customer_name":"blo.jakartaselatan@ruma.co.id ","customer_phone_number":"+62 21 5331638","customer_po":"","customer_postal_code":"12130","customer_residential_flag":"","customer_state":"","date_time_stamp":"20190509","eccn":"","erp_order":"","export_port":"","export_tax_id":"","freight_bill_to":"","freight_bill_to_address_1":"","freight_bill_to_address_2":"","freight_bill_to_address_3":"","freight_bill_to_attention_to":"","freight_bill_to_city":"","freight_bill_to_country":"","freight_bill_to_email_address":"","freight_bill_to_fax_number":"","freight_bill_to_name":"","freight_bill_to_phone_number":"","freight_bill_to_postal_code":"","freight_bill_to_state":"","freight_discount":"0","freight_terms":"","ftz":"","immed_needs_note":"","intermediate_address_1":"","intermediate_address_2":"","intermediate_address_3":"","intermediate_attention_to":"","intermediate_city":"","intermediate_consignee":"","intermediate_country":"","intermediate_email_address":"","intermediate_fax_number":"","intermediate_name":"","intermediate_phone_number":"","intermediate_postal_code":"","intermediate_state":"","liability_terms":"","license_expiration_date":"","loading_pier":"","order_date":"","order_type":"","parties":"","planned_delivery_date_time":"","planned_ship_date":"","priority":"0","pro_number":"","process_stamp":"","process_type":"TF002","quantity_um":"","rejection_note":"","requested_delivery_date":"","requested_delivery_type":"","route":"","routing_code":"","scheduled_ship_date":"20190415","ship_to":"blo.jakartaselatan@ruma.co.id","ship_to_address_1":"Bukan di Bulungan","ship_to_address_2":"","ship_to_address_3":"","ship_to_attention_to":"","ship_to_city":"Jakarta Selatan","ship_to_country":"Indonesia","ship_to_email_address":"blo.jakartaselatan@ruma.co.id","ship_to_fax_number":"","ship_to_name":"blo.jakartaselatan@ruma.co.id ","ship_to_phone_number":"+62 21 5331638","ship_to_postal_code":"12130","ship_to_state":"","shipper_code":"","ship_to_residential_flag":"","single_item_cartons":"","stop":"","stop_sequence":"","store_distribution":"","temp_internal_order_number":"","temp_internal_shipment_number":"","total_freight_charge":"0","transportation_mode":"","unloading_port":"","user_defined_field_1":"","user_defined_field_2":"","user_defined_field_3":"","user_defined_field_4":"","user_defined_field_5":"0","user_defined_field_6":"0","user_defined_field_7":"0","user_defined_field_8":"0","user_stamp":"","validated_license":"","value_shipped":"","volume_shipped":"","volume_um":"","weight_shipped":"","weight_um":""},"detail":[{"sddl":"SDDL","erp_order_line_number":"1","interface_link_id":"SCP-896 INB-002 attempt 001","interface_record_id":"1","item":"AANX12358","total_qty":"1","allocate_full_location_quantity":"","allocation_rule":"","allow_percent_allocation":"","shipment_bom_action":"","catalog_id":"","catch_weight_required":"","company":"RMA","container_creation_full_quantity":"","container_creation_full_quantity_um":"","container_creation_inner_pack_quantity":"","country_of_origin":"","customer_item":"","customer_po":"","date_time_stamp":"20190509","erp_order":"","export_description":"","harmonized_code":"","harmonized_description":"","hazardous_code":"","eligible_for_immediate_needs":"","immediate_needs_locating_rule":"","immed_needs_note":"","initial_qty":"","initial_value":"","initial_volume":"","initial_weight":"","invoice":"","category_1":"Alat masak","category_10":"","category_2":"UNKNOWN","category_3":"NON_DROPSHIP","category_4":"","category_5":"","category_6":"","category_7":"","category_8":"","category_9":"","item_class":"SOLID","item_color":"","item_department":"","item_description":"Kompor Rinnai 2 Tungku","item_dimension_um":"","item_division":"","item_height":"15","item_length":"100","item_list_price":"0","item_net_price":"0","item_size":"","item_style":"","item_weight":"2000","item_width":"40","license_plate":"","lot":"","lot_controlled":"","manufacturer_id":"","mark_for":"","mark_for_address_1":"","mark_for_address_2":"","mark_for_address_3":"","mark_for_attention_to":"","mark_for_city":"","mark_for_country":"","mark_for_email_address":"","mark_for_fax_number":"","mark_for_name":"","mark_for_phone_number":"","mark_for_postal_code":"","mark_for_state":"","maximum_allocation_percentage":"100","merchandise_code":"","minimum_allocation_percentage":"100","net_cost":"","nmfc_code":"","open_qty":"0","order_date":"","order_priority":"","original_item_ordered":"","packing_category":"","packing_class":"","parent_license_plate":"","pick_list_id":"","pick_location":"","pick_zone":"","planned_ship_date":"20190415","preference_criteria":"","priority":"","process_stamp":"","producer":"N","quantity_needed_per_item":"0","quantity_um":"","requested_delivery_date":"","requested_delivery_type":"","requested_quantity":"1","secondary_pick_location":"","secondary_pick_zone":"","serial_number_required":"","shipment_id":"OrderNumber SCP-896 INB-002 attempt 001","shipped_qty":"1","status_flow_name":"","store_distribution":"","temp_internal_order_detail_number":"","temp_internal_order_number":"","temp_internal_shipment_line_number":"","temp_internal_shipment_number":"","treat_as_loose":"","user_defined_field_1":"","user_defined_field_2":"","user_defined_field_3":"","user_defined_field_4":"","user_defined_field_5":"0","user_defined_field_6":"0","user_defined_field_7":"0","user_defined_field_8":"0","user_stamp":"ILSSRV","value":"0","value_add_label_code":"","volume_um":"","warehouse":"WH01","weight_um":""}]}',E'',E'3PL LOGIC',E'2019-05-09 04:33:24.833568+00',E'DHL ADAPTER',E'2019-05-09 04:33:29.932326+00'),
  8. (17,16,E'SCP-896 INB-003 attempt 001',E'RefNumber SCP-896 INB-003 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'REJECTED',E'{"request_id":"SCP-896 INB-003 attempt 001","reference_number":"RefNumber SCP-896 INB-003 attempt 001","reference_type":1,"outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 INB-003 attempt 001","shipped_from_id":"0178349349","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557376690,"nanos":920046000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"d58ebc33-c92e-4a4f-947c-5c37d4d8865e","timestamp":{"seconds":1557376690,"nanos":920345000}}}',E'',E'request to http://management.dev.3pl.mapan.io:8081/tpl/code/0178349349 resulting response code 404',E'3PL LOGIC',E'2019-05-09 04:38:10.968593+00',E'3PL LOGIC',E'2019-05-09 04:38:11.229143+00'),
  9. (19,18,E'SCP-896 INB-004 attempt 001',E'RefNumber SCP-896 INB-004 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'REJECTED',E'{"request_id":"SCP-896 INB-004 attempt 001","reference_number":"RefNumber SCP-896 INB-004 attempt 001","reference_type":1,"outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 INB-004 attempt 001","shipped_from_id":"1234","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557376952,"nanos":186261000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"3c0a8a79-12e6-4d68-9733-5c189c252d4e","timestamp":{"seconds":1557376952,"nanos":186527000}}}',E'',E'',E'3PL LOGIC',E'2019-05-09 04:42:32.226818+00',E'3PL LOGIC',E'2019-05-09 04:42:32.484753+00'),
  10. (21,20,E'SCP-896 INB-005 attempt 001',E'RefNumber SCP-896 INB-005 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'REJECTED',E'{"request_id":"SCP-896 INB-005 attempt 001","reference_number":"RefNumber SCP-896 INB-005 attempt 001","reference_type":1,"outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 INB-005 attempt 001","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557377567,"nanos":464777000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"822a83a7-3292-4f5e-b673-62d865c13041","timestamp":{"seconds":1557377567,"nanos":464938000}}}',E'',E'',E'3PL LOGIC',E'2019-05-09 04:52:47.512065+00',E'3PL LOGIC',E'2019-05-09 04:52:47.775193+00'),
  11. (23,22,E'SCP-896 INB-006 attempt 001',E'RefNumber SCP-896 INB-006 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'REJECTED',E'{"request_id":"SCP-896 INB-006 attempt 001","reference_number":"RefNumber SCP-896 INB-006 attempt 001","reference_type":1,"outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 INB-006 attempt 001","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557377692,"nanos":72876000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"0b6a4240-6eb1-456e-9cd4-89c323611864","timestamp":{"seconds":1557377692,"nanos":73296000}}}',E'',E'proto field Order.ShippedFromId is empty',E'3PL LOGIC',E'2019-05-09 04:54:52.1316+00',E'3PL LOGIC',E'2019-05-09 04:54:52.383549+00'),
  12. (33,30,E'SCP-896 OTB-008 attempt 001',E'RefNumber SCP-896 OTB-008 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'REJECTED',E'{"request_id":"SCP-896 OTB-008 attempt 001","reference_number":"RefNumber SCP-896 OTB-008 attempt 001","reference_type":1,"outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 OTB-008 attempt 001","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557378188,"nanos":490255000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"4887685d-9276-4e7b-b5ff-290d0311ace9","timestamp":{"seconds":1557378188,"nanos":490477000}}}',E'',E'proto field Order.ShippedToId is empty',E'3PL LOGIC',E'2019-05-09 05:03:08.545825+00',E'3PL LOGIC',E'2019-05-09 05:03:08.799788+00'),
  13. (39,36,E'SCP-896 OTB-004 attempt 001',E'RefNumber SCP-896 OTB-004 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'REJECTED',E'{"request_id":"SCP-896 OTB-004 attempt 001","reference_number":"RefNumber SCP-896 OTB-004 attempt 001","reference_type":1,"outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 OTB-004 attempt 001","shipped_from_id":"1234","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557382503,"nanos":637970000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"df5e429b-9cff-45a0-bee7-176565f407ce","timestamp":{"seconds":1557382503,"nanos":638341000}}}',E'',E'type of 1234 is not storage',E'3PL LOGIC',E'2019-05-09 06:15:03.68425+00',E'3PL LOGIC',E'2019-05-09 06:15:03.94194+00'),
  14. (41,38,E'SCP-896 OTB-005 attempt 001',E'RefNumber SCP-896 OTB-005 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'REJECTED',E'{"request_id":"SCP-896 OTB-005 attempt 001","reference_number":"RefNumber SCP-896 OTB-005 attempt 001","reference_type":1,"outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 OTB-005 attempt 001","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557382602,"nanos":975016000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"a34dccf3-3ba4-4154-b1a9-c94a359c6dc1","timestamp":{"seconds":1557382602,"nanos":975407000}}}',E'',E'storage 0178 is not active',E'3PL LOGIC',E'2019-05-09 06:16:43.014492+00',E'3PL LOGIC',E'2019-05-09 06:16:43.275861+00'),
  15. (53,49,E'SCP-896 OTB-010 attempt 004',E'RefNumber SCP-896 OTB-010 attempt 004',E'DN',E'OUTBOUND_REQUEST',E'REJECTED',E'{"request_id":"SCP-896 OTB-010 attempt 004","reference_number":"RefNumber SCP-896 OTB-010 attempt 004","reference_type":1,"order":{"order_number":"OrderNumber SCP-896 OTB-010 attempt 004","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557391164,"nanos":129475000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"2dc9f71f-2609-4c1b-93c9-56b4e1c79943","timestamp":{"seconds":1557391164,"nanos":129766000}}}',E'',E'proto field OutboundType is invalid',E'3PL LOGIC',E'2019-05-09 08:39:24.18239+00',E'3PL LOGIC',E'2019-05-09 08:39:24.432726+00'),
  16. (55,51,E'SCP-896 OTB-010 attempt 005',E'RefNumber SCP-896 OTB-010 attempt 005',E'DN',E'OUTBOUND_REQUEST',E'REJECTED',E'{"request_id":"SCP-896 OTB-010 attempt 005","reference_number":"RefNumber SCP-896 OTB-010 attempt 005","reference_type":1,"outbound_type":400,"order":{"order_number":"OrderNumber SCP-896 OTB-010 attempt 005","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557391254,"nanos":999407000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"c2bf2532-e01a-4f61-ba12-d8ab810bb58e","timestamp":{"seconds":1557391254,"nanos":999586000}}}',E'',E'proto field OutboundType is invalid',E'3PL LOGIC',E'2019-05-09 08:40:55.043599+00',E'3PL LOGIC',E'2019-05-09 08:40:55.29516+00'),
  17. (44,40,E'SCP-896 OTB-009 attempt 001',E'RefNumber SCP-896 OTB-009 attempt 001',E'',E'OUTBOUND_REQUEST',E'SENT_TO_3PL',E'{"request_id":"SCP-896 OTB-009 attempt 001","reference_number":"RefNumber SCP-896 OTB-009 attempt 001","outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 OTB-009 attempt 001","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557382750,"nanos":633654000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"b1eeadf0-5665-4843-996c-49bd816168d4","timestamp":{"seconds":1557382750,"nanos":633902000}}}',E'{"header":{"shdl":"SHDL","interface_record_id":"SCP-896 OTB-009 attempt 001","shipment_id":"OrderNumber SCP-896 OTB-009 attempt 001","warehouse":"WH01","accessorial_charge":"0","actual_delivery_date_time":"","actual_ship_date":"","allocate_complete":"","alternate_email_address":"","authorized_employee_name":"","authorized_employee_title":"","base_freight_charge":"0","bill_of_lading":"","carrier":"Custom","carrier_group":"","carrier_service":"","carrier_type":"","company":"RMA","consolidated":"","consolidation_allowed":"","consolidation_location_area":"","consolidation_location_position":"","containerized":"","containers_shipped":"","create_orders_from_shipments":"","creation_date_time_stamp":"20190509","creation_process_stamp":"","customer":"blo.jakartaselatan@ruma.co.id","customer_address_1":"Bukan di Bulungan","customer_address_2":"","customer_address_3":"","customer_attention_to":"","category_1":"","category_10":"","category_2":"","category_3":"","category_4":"","category_5":"","category_6":"","category_7":"","category_8":"","category_9":"","customer_city":"Jakarta Selatan","customer_country":"Indonesia","customer_email_address":"blo.jakartaselatan@ruma.co.id","customer_fax_number":"","customer_name":"blo.jakartaselatan@ruma.co.id ","customer_phone_number":"+62 21 5331638","customer_po":"","customer_postal_code":"12130","customer_residential_flag":"","customer_state":"","date_time_stamp":"20190509","eccn":"","erp_order":"","export_port":"","export_tax_id":"","freight_bill_to":"","freight_bill_to_address_1":"","freight_bill_to_address_2":"","freight_bill_to_address_3":"","freight_bill_to_attention_to":"","freight_bill_to_city":"","freight_bill_to_country":"","freight_bill_to_email_address":"","freight_bill_to_fax_number":"","freight_bill_to_name":"","freight_bill_to_phone_number":"","freight_bill_to_postal_code":"","freight_bill_to_state":"","freight_discount":"0","freight_terms":"","ftz":"","immed_needs_note":"","intermediate_address_1":"","intermediate_address_2":"","intermediate_address_3":"","intermediate_attention_to":"","intermediate_city":"","intermediate_consignee":"","intermediate_country":"","intermediate_email_address":"","intermediate_fax_number":"","intermediate_name":"","intermediate_phone_number":"","intermediate_postal_code":"","intermediate_state":"","liability_terms":"","license_expiration_date":"","loading_pier":"","order_date":"","order_type":"","parties":"","planned_delivery_date_time":"","planned_ship_date":"","priority":"0","pro_number":"","process_stamp":"","process_type":"TF002","quantity_um":"","rejection_note":"","requested_delivery_date":"","requested_delivery_type":"","route":"","routing_code":"","scheduled_ship_date":"20190415","ship_to":"blo.jakartaselatan@ruma.co.id","ship_to_address_1":"Bukan di Bulungan","ship_to_address_2":"","ship_to_address_3":"","ship_to_attention_to":"","ship_to_city":"Jakarta Selatan","ship_to_country":"Indonesia","ship_to_email_address":"blo.jakartaselatan@ruma.co.id","ship_to_fax_number":"","ship_to_name":"blo.jakartaselatan@ruma.co.id ","ship_to_phone_number":"+62 21 5331638","ship_to_postal_code":"12130","ship_to_state":"","shipper_code":"","ship_to_residential_flag":"","single_item_cartons":"","stop":"","stop_sequence":"","store_distribution":"","temp_internal_order_number":"","temp_internal_shipment_number":"","total_freight_charge":"0","transportation_mode":"","unloading_port":"","user_defined_field_1":"","user_defined_field_2":"","user_defined_field_3":"","user_defined_field_4":"","user_defined_field_5":"0","user_defined_field_6":"0","user_defined_field_7":"0","user_defined_field_8":"0","user_stamp":"","validated_license":"","value_shipped":"","volume_shipped":"","volume_um":"","weight_shipped":"","weight_um":""},"detail":[{"sddl":"SDDL","erp_order_line_number":"1","interface_link_id":"SCP-896 OTB-009 attempt 001","interface_record_id":"1","item":"AANX12358","total_qty":"1","allocate_full_location_quantity":"","allocation_rule":"","allow_percent_allocation":"","shipment_bom_action":"","catalog_id":"","catch_weight_required":"","company":"RMA","container_creation_full_quantity":"","container_creation_full_quantity_um":"","container_creation_inner_pack_quantity":"","country_of_origin":"","customer_item":"","customer_po":"","date_time_stamp":"20190509","erp_order":"","export_description":"","harmonized_code":"","harmonized_description":"","hazardous_code":"","eligible_for_immediate_needs":"","immediate_needs_locating_rule":"","immed_needs_note":"","initial_qty":"","initial_value":"","initial_volume":"","initial_weight":"","invoice":"","category_1":"Alat masak","category_10":"","category_2":"UNKNOWN","category_3":"NON_DROPSHIP","category_4":"","category_5":"","category_6":"","category_7":"","category_8":"","category_9":"","item_class":"SOLID","item_color":"","item_department":"","item_description":"Kompor Rinnai 2 Tungku","item_dimension_um":"","item_division":"","item_height":"15","item_length":"100","item_list_price":"0","item_net_price":"0","item_size":"","item_style":"","item_weight":"2000","item_width":"40","license_plate":"","lot":"","lot_controlled":"","manufacturer_id":"","mark_for":"","mark_for_address_1":"","mark_for_address_2":"","mark_for_address_3":"","mark_for_attention_to":"","mark_for_city":"","mark_for_country":"","mark_for_email_address":"","mark_for_fax_number":"","mark_for_name":"","mark_for_phone_number":"","mark_for_postal_code":"","mark_for_state":"","maximum_allocation_percentage":"100","merchandise_code":"","minimum_allocation_percentage":"100","net_cost":"","nmfc_code":"","open_qty":"0","order_date":"","order_priority":"","original_item_ordered":"","packing_category":"","packing_class":"","parent_license_plate":"","pick_list_id":"","pick_location":"","pick_zone":"","planned_ship_date":"20190415","preference_criteria":"","priority":"","process_stamp":"","producer":"N","quantity_needed_per_item":"0","quantity_um":"","requested_delivery_date":"","requested_delivery_type":"","requested_quantity":"1","secondary_pick_location":"","secondary_pick_zone":"","serial_number_required":"","shipment_id":"OrderNumber SCP-896 OTB-009 attempt 001","shipped_qty":"1","status_flow_name":"","store_distribution":"","temp_internal_order_detail_number":"","temp_internal_order_number":"","temp_internal_shipment_line_number":"","temp_internal_shipment_number":"","treat_as_loose":"","user_defined_field_1":"","user_defined_field_2":"","user_defined_field_3":"","user_defined_field_4":"","user_defined_field_5":"0","user_defined_field_6":"0","user_defined_field_7":"0","user_defined_field_8":"0","user_stamp":"ILSSRV","value":"0","value_add_label_code":"","volume_um":"","warehouse":"WH01","weight_um":""}]}',E'',E'3PL LOGIC',E'2019-05-09 06:19:10.679237+00',E'DHL ADAPTER',E'2019-05-09 06:19:15.539678+00'),
  18. (45,41,E'SCP-896 OTB-010 attempt 001',E'RefNumber SCP-896 OTB-010 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'REJECTED',E'{"request_id":"SCP-896 OTB-010 attempt 001","reference_number":"RefNumber SCP-896 OTB-010 attempt 001","reference_type":1,"order":{"order_number":"OrderNumber SCP-896 OTB-010 attempt 001","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557382966,"nanos":266691000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"b9e1deba-c311-432a-b6a3-44373bf5f84e","timestamp":{"seconds":1557382966,"nanos":266975000}}}',E'',E'proto field OutboundType is invalid',E'3PL LOGIC',E'2019-05-09 06:22:46.312734+00',E'3PL LOGIC',E'2019-05-09 06:23:09.828543+00'),
  19. (56,32,E'SCP-896 OTB-011 attempt 001',E'RefNumber SCP-896 OTB-011 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'REJECTED',E'{"request_id":"SCP-896 OTB-011 attempt 001","reference_number":"RefNumber SCP-896 OTB-011 attempt 001","reference_type":1,"outbound_type":1,"order":{"shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557391343,"nanos":55383000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"e15d0418-9f14-44a9-82e7-f9972b4be3e4","timestamp":{"seconds":1557391343,"nanos":55694000}}}',E'',E'proto field Order.OrderNumber is empty',E'3PL LOGIC',E'2019-05-09 08:42:23.109711+00',E'3PL LOGIC',E'2019-05-09 08:42:23.347365+00'),
  20. (47,43,E'SCP-896 OTB-010 attempt 002',E'RefNumber SCP-896 OTB-010 attempt 002',E'DN',E'OUTBOUND_REQUEST',E'REJECTED',E'{"request_id":"SCP-896 OTB-010 attempt 002","reference_number":"RefNumber SCP-896 OTB-010 attempt 002","reference_type":1,"outbound_type":300,"order":{"order_number":"OrderNumber SCP-896 OTB-010 attempt 002","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557383022,"nanos":653773000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"f9cd04d5-c803-4db3-8c19-9f3d9665bdea","timestamp":{"seconds":1557383022,"nanos":654146000}}}',E'',E'proto field OutboundType is invalid',E'3PL LOGIC',E'2019-05-09 06:23:42.699362+00',E'3PL LOGIC',E'2019-05-09 06:23:42.951677+00'),
  21. (50,46,E'SCP-896 OTB-009 attempt 003',E'RefNumber SCP-896 OTB-009 attempt 003',E'',E'OUTBOUND_REQUEST',E'TRANSLATION_FAILED',E'{"request_id":"SCP-896 OTB-009 attempt 003","reference_number":"RefNumber SCP-896 OTB-009 attempt 003","outbound_type":1,"order":{"order_number":"OrderNumber SCP-896 OTB-009 attempt 003","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557390155,"nanos":271603000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"1511de31-5c30-4dd6-93db-538e23231b44","timestamp":{"seconds":1557390155,"nanos":271808000}}}',E'',E'',E'3PL LOGIC',E'2019-05-09 08:22:35.31915+00',E'3PL TRANSLATOR',E'2019-05-09 08:22:36.049892+00'),
  22. (61,32,E'SCP-896 OTB-012 attempt 001',E'RefNumber SCP-896 OTB-012 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'REJECTED',E'{"request_id":"SCP-896 OTB-012 attempt 001","reference_number":"RefNumber SCP-896 OTB-012 attempt 001","reference_type":1,"outbound_type":1,"order":{"shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557391704,"nanos":269091000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"a57cde22-5bc7-41d7-b3ff-cf64764bd92c","timestamp":{"seconds":1557391704,"nanos":269601000}}}',E'',E'proto field Order.OrderNumber is empty',E'3PL LOGIC',E'2019-05-09 08:48:24.314095+00',E'3PL LOGIC',E'2019-05-09 08:48:24.566747+00'),
  23. (70,64,E'SCP-896 OTB-021 attempt 001',E'RefNumber SCP-896 OTB-021 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'TRANSLATION_FAILED',E'{"request_id":"SCP-896 OTB-021 attempt 001","reference_number":"RefNumber SCP-896 OTB-021 attempt 001","reference_type":1,"outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 OTB-021 attempt 001","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557395500,"nanos":696967000}},"shipped_items":[{"name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"676ce94e-d036-46b0-9be7-9c7ef81713ea","timestamp":{"seconds":1557395500,"nanos":697304000}}}',E'',E'mandatory fields are required: map[OutboundRequest.ShippedItems-1:[Code]]',E'3PL LOGIC',E'2019-05-09 09:51:40.851287+00',E'3PL TRANSLATOR',E'2019-05-09 09:51:45.789113+00'),
  24. (62,56,E'SCP-896 OTB-017 attempt 001',E'RefNumber SCP-896 OTB-017 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'SENT_TO_3PL',E'{"request_id":"SCP-896 OTB-017 attempt 001","reference_number":"RefNumber SCP-896 OTB-017 attempt 001","reference_type":1,"outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 OTB-017 attempt 001","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557391847,"nanos":628632000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"dfd54eb2-9d73-419e-a5af-93a08cb6d6f9","timestamp":{"seconds":1557391847,"nanos":628866000}}}',E'{"header":{"shdl":"SHDL","interface_record_id":"SCP-896 OTB-017 attempt 001","shipment_id":"OrderNumber SCP-896 OTB-017 attempt 001","warehouse":"WH01","accessorial_charge":"0","actual_delivery_date_time":"","actual_ship_date":"","allocate_complete":"","alternate_email_address":"","authorized_employee_name":"","authorized_employee_title":"","base_freight_charge":"0","bill_of_lading":"","carrier":"Custom","carrier_group":"","carrier_service":"","carrier_type":"","company":"RMA","consolidated":"","consolidation_allowed":"","consolidation_location_area":"","consolidation_location_position":"","containerized":"","containers_shipped":"","create_orders_from_shipments":"","creation_date_time_stamp":"20190509","creation_process_stamp":"","customer":"blo.jakartaselatan@ruma.co.id","customer_address_1":"Bukan di Bulungan","customer_address_2":"","customer_address_3":"","customer_attention_to":"","category_1":"","category_10":"","category_2":"","category_3":"","category_4":"","category_5":"","category_6":"","category_7":"","category_8":"","category_9":"","customer_city":"Jakarta Selatan","customer_country":"Indonesia","customer_email_address":"blo.jakartaselatan@ruma.co.id","customer_fax_number":"","customer_name":"blo.jakartaselatan@ruma.co.id ","customer_phone_number":"+62 21 5331638","customer_po":"","customer_postal_code":"12130","customer_residential_flag":"","customer_state":"","date_time_stamp":"20190509","eccn":"","erp_order":"","export_port":"","export_tax_id":"","freight_bill_to":"","freight_bill_to_address_1":"","freight_bill_to_address_2":"","freight_bill_to_address_3":"","freight_bill_to_attention_to":"","freight_bill_to_city":"","freight_bill_to_country":"","freight_bill_to_email_address":"","freight_bill_to_fax_number":"","freight_bill_to_name":"","freight_bill_to_phone_number":"","freight_bill_to_postal_code":"","freight_bill_to_state":"","freight_discount":"0","freight_terms":"","ftz":"","immed_needs_note":"","intermediate_address_1":"","intermediate_address_2":"","intermediate_address_3":"","intermediate_attention_to":"","intermediate_city":"","intermediate_consignee":"","intermediate_country":"","intermediate_email_address":"","intermediate_fax_number":"","intermediate_name":"","intermediate_phone_number":"","intermediate_postal_code":"","intermediate_state":"","liability_terms":"","license_expiration_date":"","loading_pier":"","order_date":"","order_type":"","parties":"","planned_delivery_date_time":"","planned_ship_date":"","priority":"0","pro_number":"","process_stamp":"","process_type":"TF002","quantity_um":"","rejection_note":"","requested_delivery_date":"","requested_delivery_type":"","route":"","routing_code":"","scheduled_ship_date":"20190415","ship_to":"blo.jakartaselatan@ruma.co.id","ship_to_address_1":"Bukan di Bulungan","ship_to_address_2":"","ship_to_address_3":"","ship_to_attention_to":"","ship_to_city":"Jakarta Selatan","ship_to_country":"Indonesia","ship_to_email_address":"blo.jakartaselatan@ruma.co.id","ship_to_fax_number":"","ship_to_name":"blo.jakartaselatan@ruma.co.id ","ship_to_phone_number":"+62 21 5331638","ship_to_postal_code":"12130","ship_to_state":"","shipper_code":"","ship_to_residential_flag":"","single_item_cartons":"","stop":"","stop_sequence":"","store_distribution":"","temp_internal_order_number":"","temp_internal_shipment_number":"","total_freight_charge":"0","transportation_mode":"","unloading_port":"","user_defined_field_1":"","user_defined_field_2":"","user_defined_field_3":"","user_defined_field_4":"","user_defined_field_5":"0","user_defined_field_6":"0","user_defined_field_7":"0","user_defined_field_8":"0","user_stamp":"","validated_license":"","value_shipped":"","volume_shipped":"","volume_um":"","weight_shipped":"","weight_um":""},"detail":[{"sddl":"SDDL","erp_order_line_number":"1","interface_link_id":"SCP-896 OTB-017 attempt 001","interface_record_id":"1","item":"AANX12358","total_qty":"1","allocate_full_location_quantity":"","allocation_rule":"","allow_percent_allocation":"","shipment_bom_action":"","catalog_id":"","catch_weight_required":"","company":"RMA","container_creation_full_quantity":"","container_creation_full_quantity_um":"","container_creation_inner_pack_quantity":"","country_of_origin":"","customer_item":"","customer_po":"","date_time_stamp":"20190509","erp_order":"","export_description":"","harmonized_code":"","harmonized_description":"","hazardous_code":"","eligible_for_immediate_needs":"","immediate_needs_locating_rule":"","immed_needs_note":"","initial_qty":"","initial_value":"","initial_volume":"","initial_weight":"","invoice":"","category_1":"Alat masak","category_10":"","category_2":"UNKNOWN","category_3":"NON_DROPSHIP","category_4":"","category_5":"","category_6":"","category_7":"","category_8":"","category_9":"","item_class":"SOLID","item_color":"","item_department":"","item_description":"Kompor Rinnai 2 Tungku","item_dimension_um":"","item_division":"","item_height":"15","item_length":"100","item_list_price":"0","item_net_price":"0","item_size":"","item_style":"","item_weight":"2000","item_width":"40","license_plate":"","lot":"","lot_controlled":"","manufacturer_id":"","mark_for":"","mark_for_address_1":"","mark_for_address_2":"","mark_for_address_3":"","mark_for_attention_to":"","mark_for_city":"","mark_for_country":"","mark_for_email_address":"","mark_for_fax_number":"","mark_for_name":"","mark_for_phone_number":"","mark_for_postal_code":"","mark_for_state":"","maximum_allocation_percentage":"100","merchandise_code":"","minimum_allocation_percentage":"100","net_cost":"","nmfc_code":"","open_qty":"0","order_date":"","order_priority":"","original_item_ordered":"","packing_category":"","packing_class":"","parent_license_plate":"","pick_list_id":"","pick_location":"","pick_zone":"","planned_ship_date":"20190415","preference_criteria":"","priority":"","process_stamp":"","producer":"N","quantity_needed_per_item":"0","quantity_um":"","requested_delivery_date":"","requested_delivery_type":"","requested_quantity":"1","secondary_pick_location":"","secondary_pick_zone":"","serial_number_required":"","shipment_id":"OrderNumber SCP-896 OTB-017 attempt 001","shipped_qty":"1","status_flow_name":"","store_distribution":"","temp_internal_order_detail_number":"","temp_internal_order_number":"","temp_internal_shipment_line_number":"","temp_internal_shipment_number":"","treat_as_loose":"","user_defined_field_1":"","user_defined_field_2":"","user_defined_field_3":"","user_defined_field_4":"","user_defined_field_5":"0","user_defined_field_6":"0","user_defined_field_7":"0","user_defined_field_8":"0","user_stamp":"ILSSRV","value":"0","value_add_label_code":"","volume_um":"","warehouse":"WH01","weight_um":""}]}',E'',E'3PL LOGIC',E'2019-05-09 08:50:47.673626+00',E'DHL ADAPTER',E'2019-05-09 08:50:52.720135+00'),
  25. (65,59,E'SCP-896 OTB-018 attempt 001',E'RefNumber SCP-896 OTB-018 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'SENT_TO_3PL',E'{"request_id":"SCP-896 OTB-018 attempt 001","reference_number":"RefNumber SCP-896 OTB-018 attempt 001","reference_type":1,"outbound_type":6,"order":{"order_number":"OrderNumber SCP-896 OTB-018 attempt 001","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557393777,"nanos":5130000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"4cd3c46e-3b5c-4d68-a1b3-ef660aa3b503","timestamp":{"seconds":1557393777,"nanos":5360000}}}',E'{"header":{"shdl":"SHDL","interface_record_id":"SCP-896 OTB-018 attempt 001","shipment_id":"OrderNumber SCP-896 OTB-018 attempt 001","warehouse":"WH01","accessorial_charge":"0","actual_delivery_date_time":"","actual_ship_date":"","allocate_complete":"","alternate_email_address":"","authorized_employee_name":"","authorized_employee_title":"","base_freight_charge":"0","bill_of_lading":"","carrier":"Custom","carrier_group":"","carrier_service":"","carrier_type":"","company":"RMA","consolidated":"","consolidation_allowed":"","consolidation_location_area":"","consolidation_location_position":"","containerized":"","containers_shipped":"","create_orders_from_shipments":"","creation_date_time_stamp":"20190509","creation_process_stamp":"","customer":"blo.jakartaselatan@ruma.co.id","customer_address_1":"Bukan di Bulungan","customer_address_2":"","customer_address_3":"","customer_attention_to":"","category_1":"","category_10":"","category_2":"","category_3":"","category_4":"","category_5":"","category_6":"","category_7":"","category_8":"","category_9":"","customer_city":"Jakarta Selatan","customer_country":"Indonesia","customer_email_address":"blo.jakartaselatan@ruma.co.id","customer_fax_number":"","customer_name":"blo.jakartaselatan@ruma.co.id ","customer_phone_number":"+62 21 5331638","customer_po":"","customer_postal_code":"12130","customer_residential_flag":"","customer_state":"","date_time_stamp":"20190509","eccn":"","erp_order":"","export_port":"","export_tax_id":"","freight_bill_to":"","freight_bill_to_address_1":"","freight_bill_to_address_2":"","freight_bill_to_address_3":"","freight_bill_to_attention_to":"","freight_bill_to_city":"","freight_bill_to_country":"","freight_bill_to_email_address":"","freight_bill_to_fax_number":"","freight_bill_to_name":"","freight_bill_to_phone_number":"","freight_bill_to_postal_code":"","freight_bill_to_state":"","freight_discount":"0","freight_terms":"","ftz":"","immed_needs_note":"","intermediate_address_1":"","intermediate_address_2":"","intermediate_address_3":"","intermediate_attention_to":"","intermediate_city":"","intermediate_consignee":"","intermediate_country":"","intermediate_email_address":"","intermediate_fax_number":"","intermediate_name":"","intermediate_phone_number":"","intermediate_postal_code":"","intermediate_state":"","liability_terms":"","license_expiration_date":"","loading_pier":"","order_date":"","order_type":"","parties":"","planned_delivery_date_time":"","planned_ship_date":"","priority":"0","pro_number":"","process_stamp":"","process_type":"OB002","quantity_um":"","rejection_note":"","requested_delivery_date":"","requested_delivery_type":"","route":"","routing_code":"","scheduled_ship_date":"20190415","ship_to":"blo.jakartaselatan@ruma.co.id","ship_to_address_1":"Bukan di Bulungan","ship_to_address_2":"","ship_to_address_3":"","ship_to_attention_to":"","ship_to_city":"Jakarta Selatan","ship_to_country":"Indonesia","ship_to_email_address":"blo.jakartaselatan@ruma.co.id","ship_to_fax_number":"","ship_to_name":"blo.jakartaselatan@ruma.co.id ","ship_to_phone_number":"+62 21 5331638","ship_to_postal_code":"12130","ship_to_state":"","shipper_code":"","ship_to_residential_flag":"","single_item_cartons":"","stop":"","stop_sequence":"","store_distribution":"","temp_internal_order_number":"","temp_internal_shipment_number":"","total_freight_charge":"0","transportation_mode":"","unloading_port":"","user_defined_field_1":"","user_defined_field_2":"","user_defined_field_3":"","user_defined_field_4":"","user_defined_field_5":"0","user_defined_field_6":"0","user_defined_field_7":"0","user_defined_field_8":"0","user_stamp":"","validated_license":"","value_shipped":"","volume_shipped":"","volume_um":"","weight_shipped":"","weight_um":""},"detail":[{"sddl":"SDDL","erp_order_line_number":"1","interface_link_id":"SCP-896 OTB-018 attempt 001","interface_record_id":"1","item":"AANX12358","total_qty":"1","allocate_full_location_quantity":"","allocation_rule":"","allow_percent_allocation":"","shipment_bom_action":"","catalog_id":"","catch_weight_required":"","company":"RMA","container_creation_full_quantity":"","container_creation_full_quantity_um":"","container_creation_inner_pack_quantity":"","country_of_origin":"","customer_item":"","customer_po":"","date_time_stamp":"20190509","erp_order":"","export_description":"","harmonized_code":"","harmonized_description":"","hazardous_code":"","eligible_for_immediate_needs":"","immediate_needs_locating_rule":"","immed_needs_note":"","initial_qty":"","initial_value":"","initial_volume":"","initial_weight":"","invoice":"","category_1":"Alat masak","category_10":"","category_2":"","category_3":"NON_DROPSHIP","category_4":"","category_5":"","category_6":"","category_7":"","category_8":"","category_9":"","item_class":"SOLID","item_color":"","item_department":"","item_description":"Kompor Rinnai 2 Tungku","item_dimension_um":"","item_division":"","item_height":"15","item_length":"100","item_list_price":"0","item_net_price":"0","item_size":"","item_style":"","item_weight":"2000","item_width":"40","license_plate":"","lot":"","lot_controlled":"","manufacturer_id":"","mark_for":"","mark_for_address_1":"","mark_for_address_2":"","mark_for_address_3":"","mark_for_attention_to":"","mark_for_city":"","mark_for_country":"","mark_for_email_address":"","mark_for_fax_number":"","mark_for_name":"","mark_for_phone_number":"","mark_for_postal_code":"","mark_for_state":"","maximum_allocation_percentage":"100","merchandise_code":"","minimum_allocation_percentage":"100","net_cost":"","nmfc_code":"","open_qty":"0","order_date":"","order_priority":"","original_item_ordered":"","packing_category":"","packing_class":"","parent_license_plate":"","pick_list_id":"","pick_location":"","pick_zone":"","planned_ship_date":"20190415","preference_criteria":"","priority":"","process_stamp":"","producer":"N","quantity_needed_per_item":"0","quantity_um":"","requested_delivery_date":"","requested_delivery_type":"","requested_quantity":"1","secondary_pick_location":"","secondary_pick_zone":"","serial_number_required":"","shipment_id":"OrderNumber SCP-896 OTB-018 attempt 001","shipped_qty":"1","status_flow_name":"","store_distribution":"","temp_internal_order_detail_number":"","temp_internal_order_number":"","temp_internal_shipment_line_number":"","temp_internal_shipment_number":"","treat_as_loose":"","user_defined_field_1":"","user_defined_field_2":"","user_defined_field_3":"","user_defined_field_4":"","user_defined_field_5":"0","user_defined_field_6":"0","user_defined_field_7":"0","user_defined_field_8":"0","user_stamp":"ILSSRV","value":"0","value_add_label_code":"","volume_um":"","warehouse":"WH01","weight_um":""}]}',E'',E'3PL LOGIC',E'2019-05-09 09:22:57.054263+00',E'DHL ADAPTER',E'2019-05-09 09:23:02.320742+00'),
  26. (95,88,E'SCP-896 REQUEST ID_190509172059184878070_DHL20190503140443015.csv',E'1770-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"SCP-896 REQUEST ID","outbound_type":"TF002","order_number":"SCP-896 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896 REQUEST ID","outbound_type":"TF002","order_number":"SCP-896 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12353","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896 REQUEST ID","outbound_type":"TF002","order_number":"SCP-896 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896 REQUEST ID","outbound_type":"TF002","order_number":"SCP-896 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896 REQUEST ID","outbound_type":"TF002","order_number":"SCP-896 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12494","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896 REQUEST ID","outbound_type":"TF002","order_number":"SCP-896 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12495","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190503140443015.csv"}',E'{"request_id":"SCP-896 REQUEST ID_190509172059184878070_DHL20190503140443015.csv","reference_number":"1770-JAKARTA SELATAN","reference_type":1,"outbound_type":16,"order":{"order_number":"SCP-896 ORDER NUMBER","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557397259,"nanos":184878070}},"shipped_items":[{"code":"AAAX12352","quantity":1,"condition":1},{"code":"AAAX12353","quantity":1,"condition":1},{"code":"LAAX12345","quantity":1,"condition":1},{"code":"LAAX12345","quantity":1,"condition":1},{"code":"CABX12494","quantity":1,"condition":1},{"code":"CABX12495","quantity":1,"condition":1}],"actual_date":{"year":2019,"month":5,"day":3},"report_status":1}',E'',E'DHL ADAPTER',E'2019-05-09 10:20:59.195231+00',E'3PL TRANSLATOR',E'2019-05-09 10:20:59.918086+00'),
  27. (66,60,E'SCP-896 OTB-018 attempt 002',E'RefNumber SCP-896 OTB-018 attempt 002',E'DN',E'OUTBOUND_REQUEST',E'TRANSLATION_FAILED',E'{"request_id":"SCP-896 OTB-018 attempt 002","reference_number":"RefNumber SCP-896 OTB-018 attempt 002","reference_type":1,"outbound_type":6,"order":{"order_number":"OrderNumber SCP-896 OTB-018 attempt 002","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557394204,"nanos":172192000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"61d3651f-de0c-44da-8f88-aaf985db4b94","timestamp":{"seconds":1557394204,"nanos":172527000}}}',E'{"header":{"shdl":"SHDL","interface_record_id":"SCP-896 OTB-018 attempt 002","shipment_id":"OrderNumber SCP-896 OTB-018 attempt 002","warehouse":"WH01","accessorial_charge":"0","actual_delivery_date_time":"","actual_ship_date":"","allocate_complete":"","alternate_email_address":"","authorized_employee_name":"","authorized_employee_title":"","base_freight_charge":"0","bill_of_lading":"","carrier":"Custom","carrier_group":"","carrier_service":"","carrier_type":"","company":"RMA","consolidated":"","consolidation_allowed":"","consolidation_location_area":"","consolidation_location_position":"","containerized":"","containers_shipped":"","create_orders_from_shipments":"","creation_date_time_stamp":"20190509","creation_process_stamp":"","customer":"blo.jakartaselatan@ruma.co.id","customer_address_1":"Bukan di Bulungan","customer_address_2":"","customer_address_3":"","customer_attention_to":"","category_1":"","category_10":"","category_2":"","category_3":"","category_4":"","category_5":"","category_6":"","category_7":"","category_8":"","category_9":"","customer_city":"Jakarta Selatan","customer_country":"Indonesia","customer_email_address":"blo.jakartaselatan@ruma.co.id","customer_fax_number":"","customer_name":"blo.jakartaselatan@ruma.co.id ","customer_phone_number":"+62 21 5331638","customer_po":"","customer_postal_code":"12130","customer_residential_flag":"","customer_state":"","date_time_stamp":"20190509","eccn":"","erp_order":"","export_port":"","export_tax_id":"","freight_bill_to":"","freight_bill_to_address_1":"","freight_bill_to_address_2":"","freight_bill_to_address_3":"","freight_bill_to_attention_to":"","freight_bill_to_city":"","freight_bill_to_country":"","freight_bill_to_email_address":"","freight_bill_to_fax_number":"","freight_bill_to_name":"","freight_bill_to_phone_number":"","freight_bill_to_postal_code":"","freight_bill_to_state":"","freight_discount":"0","freight_terms":"","ftz":"","immed_needs_note":"","intermediate_address_1":"","intermediate_address_2":"","intermediate_address_3":"","intermediate_attention_to":"","intermediate_city":"","intermediate_consignee":"","intermediate_country":"","intermediate_email_address":"","intermediate_fax_number":"","intermediate_name":"","intermediate_phone_number":"","intermediate_postal_code":"","intermediate_state":"","liability_terms":"","license_expiration_date":"","loading_pier":"","order_date":"","order_type":"","parties":"","planned_delivery_date_time":"","planned_ship_date":"","priority":"0","pro_number":"","process_stamp":"","process_type":"OB002","quantity_um":"","rejection_note":"","requested_delivery_date":"","requested_delivery_type":"","route":"","routing_code":"","scheduled_ship_date":"20190415","ship_to":"blo.jakartaselatan@ruma.co.id","ship_to_address_1":"Bukan di Bulungan","ship_to_address_2":"","ship_to_address_3":"","ship_to_attention_to":"","ship_to_city":"Jakarta Selatan","ship_to_country":"Indonesia","ship_to_email_address":"blo.jakartaselatan@ruma.co.id","ship_to_fax_number":"","ship_to_name":"blo.jakartaselatan@ruma.co.id ","ship_to_phone_number":"+62 21 5331638","ship_to_postal_code":"12130","ship_to_state":"","shipper_code":"","ship_to_residential_flag":"","single_item_cartons":"","stop":"","stop_sequence":"","store_distribution":"","temp_internal_order_number":"","temp_internal_shipment_number":"","total_freight_charge":"0","transportation_mode":"","unloading_port":"","user_defined_field_1":"","user_defined_field_2":"","user_defined_field_3":"","user_defined_field_4":"","user_defined_field_5":"0","user_defined_field_6":"0","user_defined_field_7":"0","user_defined_field_8":"0","user_stamp":"","validated_license":"","value_shipped":"","volume_shipped":"","volume_um":"","weight_shipped":"","weight_um":""},"detail":[{"sddl":"SDDL","erp_order_line_number":"1","interface_link_id":"SCP-896 OTB-018 attempt 002","interface_record_id":"1","item":"AANX12358","total_qty":"1","allocate_full_location_quantity":"","allocation_rule":"","allow_percent_allocation":"","shipment_bom_action":"","catalog_id":"","catch_weight_required":"","company":"RMA","container_creation_full_quantity":"","container_creation_full_quantity_um":"","container_creation_inner_pack_quantity":"","country_of_origin":"","customer_item":"","customer_po":"","date_time_stamp":"20190509","erp_order":"","export_description":"","harmonized_code":"","harmonized_description":"","hazardous_code":"","eligible_for_immediate_needs":"","immediate_needs_locating_rule":"","immed_needs_note":"","initial_qty":"","initial_value":"","initial_volume":"","initial_weight":"","invoice":"","category_1":"Alat masak","category_10":"","category_2":"","category_3":"NON_DROPSHIP","category_4":"","category_5":"","category_6":"","category_7":"","category_8":"","category_9":"","item_class":"SOLID","item_color":"","item_department":"","item_description":"Kompor Rinnai 2 Tungku","item_dimension_um":"","item_division":"","item_height":"15","item_length":"100","item_list_price":"0","item_net_price":"0","item_size":"","item_style":"","item_weight":"2000","item_width":"40","license_plate":"","lot":"","lot_controlled":"","manufacturer_id":"","mark_for":"","mark_for_address_1":"","mark_for_address_2":"","mark_for_address_3":"","mark_for_attention_to":"","mark_for_city":"","mark_for_country":"","mark_for_email_address":"","mark_for_fax_number":"","mark_for_name":"","mark_for_phone_number":"","mark_for_postal_code":"","mark_for_state":"","maximum_allocation_percentage":"100","merchandise_code":"","minimum_allocation_percentage":"100","net_cost":"","nmfc_code":"","open_qty":"0","order_date":"","order_priority":"","original_item_ordered":"","packing_category":"","packing_class":"","parent_license_plate":"","pick_list_id":"","pick_location":"","pick_zone":"","planned_ship_date":"20190415","preference_criteria":"","priority":"","process_stamp":"","producer":"N","quantity_needed_per_item":"0","quantity_um":"","requested_delivery_date":"","requested_delivery_type":"","requested_quantity":"1","secondary_pick_location":"","secondary_pick_zone":"","serial_number_required":"","shipment_id":"OrderNumber SCP-896 OTB-018 attempt 002","shipped_qty":"1","status_flow_name":"","store_distribution":"","temp_internal_order_detail_number":"","temp_internal_order_number":"","temp_internal_shipment_line_number":"","temp_internal_shipment_number":"","treat_as_loose":"","user_defined_field_1":"","user_defined_field_2":"","user_defined_field_3":"","user_defined_field_4":"","user_defined_field_5":"0","user_defined_field_6":"0","user_defined_field_7":"0","user_defined_field_8":"0","user_stamp":"ILSSRV","value":"0","value_add_label_code":"","volume_um":"","warehouse":"WH01","weight_um":""}]}',E'invalid value for: map[OutboundRequest.OutboundType:[TF004]]',E'3PL LOGIC',E'2019-05-09 09:30:04.216849+00',E'3PL TRANSLATOR',E'2019-05-09 09:31:10.168548+00'),
  28. (101,94,E'SCP-896_OTB-042_190509173456384605020_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-042","outbound_type":"TF002","order_number":"SCP-896_OTB-042 ORDER NUMBER 6","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12495","quantity":"1","condition":"RUSAK PRODUK RETUR","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: Item condition "RUSAK PRODUK RETUR" is invalid',E'DHL ADAPTER',E'2019-05-09 10:34:56.506865+00',E'3PL TRANSLATOR',E'2019-05-09 10:34:57.917573+00'),
  29. (103,96,E'SCP-896_OTB-042_190509173456606708566_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-042","outbound_type":"TF002","order_number":"SCP-896_OTB-042 ORDER NUMBER 1","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"RUSAK","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: Item condition "RUSAK" is invalid',E'DHL ADAPTER',E'2019-05-09 10:34:56.629271+00',E'3PL TRANSLATOR',E'2019-05-09 10:35:00.184854+00'),
  30. (108,101,E'SCP-896_OTB-042_190509173626391018828_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-042","outbound_type":"TF002","order_number":"SCP-896_OTB-042 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"RUSAK","note":""},{"request_id":"SCP-896_OTB-042","outbound_type":"TF002","order_number":"SCP-896_OTB-042 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12353","quantity":"1","condition":"RUSAK PRODUK WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-042","outbound_type":"TF002","order_number":"SCP-896_OTB-042 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"RUSAK KEMASAN WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-042","outbound_type":"TF002","order_number":"SCP-896_OTB-042 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"RUSAK PRODUK SUPPLIER","note":""},{"request_id":"SCP-896_OTB-042","outbound_type":"TF002","order_number":"SCP-896_OTB-042 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12494","quantity":"1","condition":"RUSAK KEMASAN SUPPLIER","note":""},{"request_id":"SCP-896_OTB-042","outbound_type":"TF002","order_number":"SCP-896_OTB-042 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12495","quantity":"1","condition":"RUSAK PRODUK RETUR","note":""},{"request_id":"SCP-896_OTB-042","outbound_type":"TF002","order_number":"SCP-896_OTB-042 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12493","quantity":"1","condition":"RUSAK KEMASAN RETUR","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: Item condition "RUSAK" is invalid',E'DHL ADAPTER',E'2019-05-09 10:36:26.400959+00',E'3PL TRANSLATOR',E'2019-05-09 10:36:27.16758+00'),
  31. (104,97,E'SCP-896_OTB-042_190509173456609875079_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-042","outbound_type":"TF002","order_number":"SCP-896_OTB-042 ORDER NUMBER 2","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12353","quantity":"1","condition":"RUSAK PRODUK WAREHOUSE","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: Item condition "RUSAK PRODUK WAREHOUSE" is invalid',E'DHL ADAPTER',E'2019-05-09 10:34:56.907008+00',E'3PL TRANSLATOR',E'2019-05-09 10:35:01.19275+00'),
  32. (106,99,E'SCP-896_OTB-042_190509173456616511250_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-042","outbound_type":"TF002","order_number":"SCP-896_OTB-042 ORDER NUMBER 4","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"RUSAK PRODUK SUPPLIER","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: Item condition "RUSAK PRODUK SUPPLIER" is invalid',E'DHL ADAPTER',E'2019-05-09 10:34:58.172081+00',E'3PL TRANSLATOR',E'2019-05-09 10:35:02.201039+00'),
  33. (105,98,E'SCP-896_OTB-042_190509173456612942680_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-042","outbound_type":"TF002","order_number":"SCP-896_OTB-042 ORDER NUMBER 3","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"RUSAK KEMASAN WAREHOUSE","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: Item condition "RUSAK KEMASAN WAREHOUSE" is invalid',E'DHL ADAPTER',E'2019-05-09 10:34:57.667482+00',E'3PL TRANSLATOR',E'2019-05-09 10:35:01.69621+00'),
  34. (107,100,E'SCP-896_OTB-042_190509173456619024691_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-042","outbound_type":"TF002","order_number":"SCP-896_OTB-042 ORDER NUMBER 5","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12494","quantity":"1","condition":"RUSAK KEMASAN SUPPLIER","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: Item condition "RUSAK KEMASAN SUPPLIER" is invalid',E'DHL ADAPTER',E'2019-05-09 10:34:58.424102+00',E'3PL TRANSLATOR',E'2019-05-09 10:35:02.704939+00'),
  35. (67,61,E'SCP-896 OTB-020 attempt 001',E'RefNumber SCP-896 OTB-020 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'TRANSLATION_FAILED',E'{"request_id":"SCP-896 OTB-020 attempt 001","reference_number":"RefNumber SCP-896 OTB-020 attempt 001","reference_type":1,"outbound_type":18,"order":{"order_number":"OrderNumber SCP-896 OTB-020 attempt 001","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557394298,"nanos":508660000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"efa24408-6da0-482b-a4f3-219d5dcd86c7","timestamp":{"seconds":1557394298,"nanos":508928000}}}',E'',E'invalid value for: map[OutboundRequest.OutboundType:[TF004]]',E'3PL LOGIC',E'2019-05-09 09:31:38.551637+00',E'3PL TRANSLATOR',E'2019-05-09 09:31:39.324346+00'),
  36. (109,102,E'SCP-896_OTB-043_190509201806055147065_DHL20190503140443015.csv',E'1770-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"SCP-896_OTB-043","outbound_type":"TF002","order_number":"SCP-896_OTB-043 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896_OTB-043","outbound_type":"TF002","order_number":"SCP-896_OTB-043 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12353","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896_OTB-043","outbound_type":"TF002","order_number":"SCP-896_OTB-043 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896_OTB-043","outbound_type":"TF002","order_number":"SCP-896_OTB-043 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896_OTB-043","outbound_type":"TF002","order_number":"SCP-896_OTB-043 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12494","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896_OTB-043","outbound_type":"TF002","order_number":"SCP-896_OTB-043 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12495","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896_OTB-043","outbound_type":"TF002","order_number":"SCP-896_OTB-043 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12493","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190503140443015.csv"}',E'{"request_id":"SCP-896_OTB-043_190509201806055147065_DHL20190503140443015.csv","reference_number":"1770-JAKARTA SELATAN","reference_type":1,"outbound_type":16,"order":{"order_number":"SCP-896_OTB-043 ORDER NUMBER","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557407886,"nanos":55147065}},"shipped_items":[{"code":"AAAX12352","quantity":1,"condition":1},{"code":"AAAX12353","quantity":1,"condition":1},{"code":"LAAX12345","quantity":1,"condition":1},{"code":"LAAX12345","quantity":1,"condition":1},{"code":"CABX12494","quantity":1,"condition":1},{"code":"CABX12495","quantity":1,"condition":1},{"code":"CABX12493","quantity":1,"condition":1}],"actual_date":{"year":2019,"month":5,"day":3},"report_status":1}',E'',E'DHL ADAPTER',E'2019-05-09 13:18:06.181074+00',E'3PL TRANSLATOR',E'2019-05-09 13:18:06.979094+00'),
  37. (111,104,E'SCP-896_OTB-043B_190509202226680209750_DHL20190503140443015.csv',E'1770-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"SCP-896_OTB-043B","outbound_type":"OB002","order_number":"SCP-896_OTB-043B ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896_OTB-043B","outbound_type":"OB002","order_number":"SCP-896_OTB-043B ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"RUSAK","note":""},{"request_id":"SCP-896_OTB-043B","outbound_type":"OB002","order_number":"SCP-896_OTB-043B ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12353","quantity":"1","condition":"RUSAK PRODUK WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-043B","outbound_type":"OB002","order_number":"SCP-896_OTB-043B ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"RUSAK KEMASAN WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-043B","outbound_type":"OB002","order_number":"SCP-896_OTB-043B ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"RUSAK PRODUK SUPPLIER","note":""},{"request_id":"SCP-896_OTB-043B","outbound_type":"OB002","order_number":"SCP-896_OTB-043B ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12494","quantity":"1","condition":"RUSAK KEMASAN SUPPLIER","note":""},{"request_id":"SCP-896_OTB-043B","outbound_type":"OB002","order_number":"SCP-896_OTB-043B ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12495","quantity":"1","condition":"RUSAK PRODUK RETUR","note":""},{"request_id":"SCP-896_OTB-043B","outbound_type":"OB002","order_number":"SCP-896_OTB-043B ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12493","quantity":"1","condition":"RUSAK KEMASAN RETUR","note":""}],"filename":"DHL20190503140443015.csv"}',E'{"request_id":"SCP-896_OTB-043B_190509202226680209750_DHL20190503140443015.csv","reference_number":"1770-JAKARTA SELATAN","reference_type":1,"outbound_type":6,"order":{"order_number":"SCP-896_OTB-043B ORDER NUMBER","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557408146,"nanos":680209750}},"shipped_items":[{"code":"AAAX12352","quantity":1,"condition":1},{"code":"AAAX12352","quantity":1,"condition":2},{"code":"AAAX12353","quantity":1,"condition":8},{"code":"LAAX12345","quantity":1,"condition":5},{"code":"LAAX12345","quantity":1,"condition":6},{"code":"CABX12494","quantity":1,"condition":3},{"code":"CABX12495","quantity":1,"condition":7},{"code":"CABX12493","quantity":1,"condition":4}],"actual_date":{"year":2019,"month":5,"day":3},"report_status":1}',E'',E'DHL ADAPTER',E'2019-05-09 13:22:26.690878+00',E'3PL TRANSLATOR',E'2019-05-09 13:22:27.463018+00'),
  38. (110,103,E'SCP-896_OTB-043A_190509202056985223538_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-043A","outbound_type":"TF002","order_number":"SCP-896_OTB-043A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"RUSAK","note":""},{"request_id":"SCP-896_OTB-043A","outbound_type":"TF002","order_number":"SCP-896_OTB-043A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12353","quantity":"1","condition":"RUSAK PRODUK WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-043A","outbound_type":"TF002","order_number":"SCP-896_OTB-043A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"RUSAK KEMASAN WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-043A","outbound_type":"TF002","order_number":"SCP-896_OTB-043A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"RUSAK PRODUK SUPPLIER","note":""},{"request_id":"SCP-896_OTB-043A","outbound_type":"TF002","order_number":"SCP-896_OTB-043A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12494","quantity":"1","condition":"RUSAK KEMASAN SUPPLIER","note":""},{"request_id":"SCP-896_OTB-043A","outbound_type":"TF002","order_number":"SCP-896_OTB-043A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12495","quantity":"1","condition":"RUSAK PRODUK RETUR","note":""},{"request_id":"SCP-896_OTB-043A","outbound_type":"TF002","order_number":"SCP-896_OTB-043A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12493","quantity":"1","condition":"RUSAK KEMASAN RETUR","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: Item condition "RUSAK" is invalid',E'DHL ADAPTER',E'2019-05-09 13:20:56.993984+00',E'3PL TRANSLATOR',E'2019-05-09 13:20:57.512585+00'),
  39. (129,107,E'SCP-896_OTB-047A_190509205022756829044_DHL20190503140443017.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190503140443017.csv"}',E'',E'invalid report on line number 1: OutboundType is empty',E'DHL ADAPTER',E'2019-05-09 13:50:23.878728+00',E'3PL TRANSLATOR',E'2019-05-09 13:50:24.633325+00'),
  40. (126,107,E'SCP-896_OTB-047A_190509205022465049088_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: OutboundType is empty',E'DHL ADAPTER',E'2019-05-09 13:50:22.473685+00',E'3PL TRANSLATOR',E'2019-05-09 13:50:22.691523+00'),
  41. (128,107,E'SCP-896_OTB-047A_190509205022684818030_DHL20190503140443019.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190503140443019.csv"}',E'',E'invalid report on line number 1: OutboundType is empty',E'DHL ADAPTER',E'2019-05-09 13:50:22.868795+00',E'3PL TRANSLATOR',E'2019-05-09 13:50:23.626575+00'),
  42. (127,107,E'SCP-896_OTB-047A_190509205022483227104_DHL20190503140443018.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190503140443018.csv"}',E'',E'invalid report on line number 1: OutboundType is empty',E'DHL ADAPTER',E'2019-05-09 13:50:22.703035+00',E'3PL TRANSLATOR',E'2019-05-09 13:50:22.851041+00'),
  43. (130,107,E'SCP-896_OTB-047A_190509205022844793646_DHL20190503140443016.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190503140443016.csv"}',E'',E'invalid report on line number 1: OutboundType is empty',E'DHL ADAPTER',E'2019-05-09 13:50:24.886355+00',E'3PL TRANSLATOR',E'2019-05-09 13:50:25.640241+00'),
  44. (80,73,E'SCP-896 OTB-020 attempt 002',E'RefNumber SCP-896 OTB-020 attempt 002',E'DN',E'OUTBOUND_REQUEST',E'TRANSLATION_FAILED',E'{"request_id":"SCP-896 OTB-020 attempt 002","reference_number":"RefNumber SCP-896 OTB-020 attempt 002","reference_type":1,"outbound_type":18,"order":{"order_number":"OrderNumber SCP-896 OTB-020 attempt 002","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557395541,"nanos":985785000}},"shipped_items":[{"name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"27e08361-4bff-44bc-b799-7795fcfab69e","timestamp":{"seconds":1557395541,"nanos":986335000}}}',E'',E'mandatory fields are required: map[OutboundRequest.ShippedItems-1:[Code]]\ninvalid value for: map[OutboundRequest.OutboundType:[TF004]]',E'3PL LOGIC',E'2019-05-09 09:52:22.026179+00',E'3PL TRANSLATOR',E'2019-05-09 09:52:22.797814+00'),
  45. (81,74,E'SCP-896 OTB-020 attempt 003',E'RefNumber SCP-896 OTB-020 attempt 003',E'DN',E'OUTBOUND_REQUEST',E'TRANSLATION_FAILED',E'{"request_id":"SCP-896 OTB-020 attempt 003","reference_number":"RefNumber SCP-896 OTB-020 attempt 003","reference_type":1,"outbound_type":18,"order":{"order_number":"OrderNumber SCP-896 OTB-020 attempt 003","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557395571,"nanos":683209000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"57745fa4-b09e-48cf-a717-1ad2e84c0c05","timestamp":{"seconds":1557395571,"nanos":683503000}}}',E'',E'invalid value for: map[OutboundRequest.OutboundType:[TF004]]',E'3PL LOGIC',E'2019-05-09 09:52:51.724903+00',E'3PL TRANSLATOR',E'2019-05-09 09:52:52.496116+00'),
  46. (82,75,E'SCP-896 OTB-022 attempt 001',E'RefNumber SCP-896 OTB-022 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'TRANSLATION_FAILED',E'{"request_id":"SCP-896 OTB-022 attempt 001","reference_number":"RefNumber SCP-896 OTB-022 attempt 001","reference_type":1,"outbound_type":18,"order":{"order_number":"OrderNumber SCP-896 OTB-022 attempt 001","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557395658,"nanos":322747000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":-1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"68a3abd3-c981-47ef-97b3-66a8ceab184d","timestamp":{"seconds":1557395658,"nanos":323075000}}}',E'',E'invalid value for: map[OutboundRequest.OutboundType:[TF004] OutboundRequest.ShippedItems-1:[Quantity]]',E'3PL LOGIC',E'2019-05-09 09:54:18.368448+00',E'3PL TRANSLATOR',E'2019-05-09 09:54:19.145399+00'),
  47. (83,76,E'SCP-896 OTB-022 attempt 002',E'RefNumber SCP-896 OTB-022 attempt 002',E'DN',E'OUTBOUND_REQUEST',E'TRANSLATION_FAILED',E'{"request_id":"SCP-896 OTB-022 attempt 002","reference_number":"RefNumber SCP-896 OTB-022 attempt 002","reference_type":1,"outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 OTB-022 attempt 002","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557395694,"nanos":334419000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":-1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"6f0e52e7-5f0b-4b30-92c5-57573b750230","timestamp":{"seconds":1557395694,"nanos":334759000}}}',E'',E'invalid value for: map[OutboundRequest.ShippedItems-1:[Quantity]]',E'3PL LOGIC',E'2019-05-09 09:54:54.377552+00',E'3PL TRANSLATOR',E'2019-05-09 09:54:55.150205+00'),
  48. (131,107,E'SCP-896_OTB-047A_190509205157653214591_DHL20190503140443019.csv',E'1770-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"TF002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190503140443019.csv"}',E'{"request_id":"SCP-896_OTB-047A_190509205157653214591_DHL20190503140443019.csv","reference_number":"1770-JAKARTA SELATAN","reference_type":1,"outbound_type":16,"order":{"order_number":"SCP-896_OTB-047A ORDER NUMBER","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557409917,"nanos":653214591}},"shipped_items":[{"code":"AAAX12352","quantity":1,"condition":1}],"actual_date":{"year":2019,"month":5,"day":3},"report_status":1}',E'',E'DHL ADAPTER',E'2019-05-09 13:51:57.660653+00',E'3PL TRANSLATOR',E'2019-05-09 13:51:57.869125+00'),
  49. (132,107,E'SCP-896_OTB-047A_190509205157849312362_DHL20190503140443015.csv',E'1770-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"TF002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190503140443015.csv"}',E'{"request_id":"SCP-896_OTB-047A_190509205157849312362_DHL20190503140443015.csv","reference_number":"1770-JAKARTA SELATAN","reference_type":1,"outbound_type":16,"order":{"order_number":"SCP-896_OTB-047A ORDER NUMBER","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557409917,"nanos":849312362}},"shipped_items":[{"code":"AAAX12352","quantity":1,"condition":1}],"actual_date":{"year":2019,"month":5,"day":3},"report_status":1}',E'',E'DHL ADAPTER',E'2019-05-09 13:51:58.121834+00',E'3PL TRANSLATOR',E'2019-05-09 13:51:58.880198+00'),
  50. (133,107,E'SCP-896_OTB-047A_190509205242326927810_DHL20190503140443017.csv',E'1770-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"TF002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190503140443017.csv"}',E'{"request_id":"SCP-896_OTB-047A_190509205242326927810_DHL20190503140443017.csv","reference_number":"1770-JAKARTA SELATAN","reference_type":1,"outbound_type":16,"order":{"order_number":"SCP-896_OTB-047A ORDER NUMBER","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557409962,"nanos":326927810}},"shipped_items":[{"code":"AAAX12352","quantity":1,"condition":1}],"actual_date":{"year":2019,"month":5,"day":3},"report_status":1}',E'',E'DHL ADAPTER',E'2019-05-09 13:52:42.334726+00',E'3PL TRANSLATOR',E'2019-05-09 13:52:42.524473+00'),
  51. (84,77,E'SCP-896 OTB-023 attempt 001',E'RefNumber SCP-896 OTB-023 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'TRANSLATION_FAILED',E'{"request_id":"SCP-896 OTB-023 attempt 001","reference_number":"RefNumber SCP-896 OTB-023 attempt 001","reference_type":1,"outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 OTB-023 attempt 001","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557395728,"nanos":257520000}},"shipped_items":[{"name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"8af316bb-313b-4de1-a54e-610798b23470","timestamp":{"seconds":1557395728,"nanos":257842000}}}',E'',E'mandatory fields are required: map[OutboundRequest.ShippedItems-1:[Code]]',E'3PL LOGIC',E'2019-05-09 09:55:28.299643+00',E'3PL TRANSLATOR',E'2019-05-09 09:55:29.07294+00'),
  52. (134,107,E'SCP-896_OTB-047A_190509205242502785194_DHL20190503140443018.csv',E'1770-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"TF002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190503140443018.csv"}',E'{"request_id":"SCP-896_OTB-047A_190509205242502785194_DHL20190503140443018.csv","reference_number":"1770-JAKARTA SELATAN","reference_type":1,"outbound_type":16,"order":{"order_number":"SCP-896_OTB-047A ORDER NUMBER","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557409962,"nanos":502785194}},"shipped_items":[{"code":"AAAX12352","quantity":1,"condition":1}],"actual_date":{"year":2019,"month":5,"day":3},"report_status":1}',E'',E'DHL ADAPTER',E'2019-05-09 13:52:42.676512+00',E'3PL TRANSLATOR',E'2019-05-09 13:52:43.19633+00'),
  53. (135,107,E'SCP-896_OTB-047A_190509205242669340288_DHL20190503140443016.csv',E'1770-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"TF002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190503140443016.csv"}',E'{"request_id":"SCP-896_OTB-047A_190509205242669340288_DHL20190503140443016.csv","reference_number":"1770-JAKARTA SELATAN","reference_type":1,"outbound_type":16,"order":{"order_number":"SCP-896_OTB-047A ORDER NUMBER","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557409962,"nanos":669340288}},"shipped_items":[{"code":"AAAX12352","quantity":1,"condition":1}],"actual_date":{"year":2019,"month":5,"day":3},"report_status":1}',E'',E'DHL ADAPTER',E'2019-05-09 13:52:43.446095+00',E'3PL TRANSLATOR',E'2019-05-09 13:52:44.202136+00'),
  54. (85,78,E'SCP-896 OTB-024 attempt 001',E'RefNumber SCP-896 OTB-024 attempt 001',E'DN',E'OUTBOUND_REQUEST',E'TRANSLATION_FAILED',E'{"request_id":"SCP-896 OTB-024 attempt 001","reference_number":"RefNumber SCP-896 OTB-024 attempt 001","reference_type":1,"outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 OTB-024 attempt 001","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557395798,"nanos":731895000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"3265a65f-134b-481d-ad40-bd07bdaf48dc","timestamp":{"seconds":1557395798,"nanos":732193000}}}',E'',E'mandatory fields are required: map[OutboundRequest.ShippedItems-1:[Quantity]]',E'3PL LOGIC',E'2019-05-09 09:56:38.773545+00',E'3PL TRANSLATOR',E'2019-05-09 09:56:39.551686+00'),
  55. (96,89,E'SCP-896 OTB-009 attempt 004',E'RefNumber SCP-896 OTB-009 attempt 004',E'',E'OUTBOUND_REQUEST',E'SENT_TO_3PL',E'{"request_id":"SCP-896 OTB-009 attempt 004","reference_number":"RefNumber SCP-896 OTB-009 attempt 004","outbound_type":16,"order":{"order_number":"OrderNumber SCP-896 OTB-009 attempt 004","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557397436,"nanos":497430000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"05f2f226-91a2-4213-a48d-1784c65bf48c","timestamp":{"seconds":1557397436,"nanos":497721000}}}',E'{"header":{"shdl":"SHDL","interface_record_id":"SCP-896 OTB-009 attempt 004","shipment_id":"OrderNumber SCP-896 OTB-009 attempt 004","warehouse":"WH01","accessorial_charge":"0","actual_delivery_date_time":"","actual_ship_date":"","allocate_complete":"","alternate_email_address":"","authorized_employee_name":"","authorized_employee_title":"","base_freight_charge":"0","bill_of_lading":"","carrier":"Custom","carrier_group":"","carrier_service":"","carrier_type":"","company":"RMA","consolidated":"","consolidation_allowed":"","consolidation_location_area":"","consolidation_location_position":"","containerized":"","containers_shipped":"","create_orders_from_shipments":"","creation_date_time_stamp":"20190509","creation_process_stamp":"","customer":"blo.jakartaselatan@ruma.co.id","customer_address_1":"Bukan di Bulungan","customer_address_2":"","customer_address_3":"","customer_attention_to":"","category_1":"","category_10":"","category_2":"","category_3":"","category_4":"","category_5":"","category_6":"","category_7":"","category_8":"","category_9":"","customer_city":"Jakarta Selatan","customer_country":"Indonesia","customer_email_address":"blo.jakartaselatan@ruma.co.id","customer_fax_number":"","customer_name":"blo.jakartaselatan@ruma.co.id ","customer_phone_number":"+62 21 5331638","customer_po":"","customer_postal_code":"12130","customer_residential_flag":"","customer_state":"","date_time_stamp":"20190509","eccn":"","erp_order":"","export_port":"","export_tax_id":"","freight_bill_to":"","freight_bill_to_address_1":"","freight_bill_to_address_2":"","freight_bill_to_address_3":"","freight_bill_to_attention_to":"","freight_bill_to_city":"","freight_bill_to_country":"","freight_bill_to_email_address":"","freight_bill_to_fax_number":"","freight_bill_to_name":"","freight_bill_to_phone_number":"","freight_bill_to_postal_code":"","freight_bill_to_state":"","freight_discount":"0","freight_terms":"","ftz":"","immed_needs_note":"","intermediate_address_1":"","intermediate_address_2":"","intermediate_address_3":"","intermediate_attention_to":"","intermediate_city":"","intermediate_consignee":"","intermediate_country":"","intermediate_email_address":"","intermediate_fax_number":"","intermediate_name":"","intermediate_phone_number":"","intermediate_postal_code":"","intermediate_state":"","liability_terms":"","license_expiration_date":"","loading_pier":"","order_date":"","order_type":"","parties":"","planned_delivery_date_time":"","planned_ship_date":"","priority":"0","pro_number":"","process_stamp":"","process_type":"TF002","quantity_um":"","rejection_note":"","requested_delivery_date":"","requested_delivery_type":"","route":"","routing_code":"","scheduled_ship_date":"20190415","ship_to":"blo.jakartaselatan@ruma.co.id","ship_to_address_1":"Bukan di Bulungan","ship_to_address_2":"","ship_to_address_3":"","ship_to_attention_to":"","ship_to_city":"Jakarta Selatan","ship_to_country":"Indonesia","ship_to_email_address":"blo.jakartaselatan@ruma.co.id","ship_to_fax_number":"","ship_to_name":"blo.jakartaselatan@ruma.co.id ","ship_to_phone_number":"+62 21 5331638","ship_to_postal_code":"12130","ship_to_state":"","shipper_code":"","ship_to_residential_flag":"","single_item_cartons":"","stop":"","stop_sequence":"","store_distribution":"","temp_internal_order_number":"","temp_internal_shipment_number":"","total_freight_charge":"0","transportation_mode":"","unloading_port":"","user_defined_field_1":"","user_defined_field_2":"","user_defined_field_3":"","user_defined_field_4":"","user_defined_field_5":"0","user_defined_field_6":"0","user_defined_field_7":"0","user_defined_field_8":"0","user_stamp":"","validated_license":"","value_shipped":"","volume_shipped":"","volume_um":"","weight_shipped":"","weight_um":""},"detail":[{"sddl":"SDDL","erp_order_line_number":"1","interface_link_id":"SCP-896 OTB-009 attempt 004","interface_record_id":"1","item":"AANX12358","total_qty":"1","allocate_full_location_quantity":"","allocation_rule":"","allow_percent_allocation":"","shipment_bom_action":"","catalog_id":"","catch_weight_required":"","company":"RMA","container_creation_full_quantity":"","container_creation_full_quantity_um":"","container_creation_inner_pack_quantity":"","country_of_origin":"","customer_item":"","customer_po":"","date_time_stamp":"20190509","erp_order":"","export_description":"","harmonized_code":"","harmonized_description":"","hazardous_code":"","eligible_for_immediate_needs":"","immediate_needs_locating_rule":"","immed_needs_note":"","initial_qty":"","initial_value":"","initial_volume":"","initial_weight":"","invoice":"","category_1":"Alat masak","category_10":"","category_2":"","category_3":"NON_DROPSHIP","category_4":"","category_5":"","category_6":"","category_7":"","category_8":"","category_9":"","item_class":"SOLID","item_color":"","item_department":"","item_description":"Kompor Rinnai 2 Tungku","item_dimension_um":"","item_division":"","item_height":"15","item_length":"100","item_list_price":"0","item_net_price":"0","item_size":"","item_style":"","item_weight":"2000","item_width":"40","license_plate":"","lot":"","lot_controlled":"","manufacturer_id":"","mark_for":"","mark_for_address_1":"","mark_for_address_2":"","mark_for_address_3":"","mark_for_attention_to":"","mark_for_city":"","mark_for_country":"","mark_for_email_address":"","mark_for_fax_number":"","mark_for_name":"","mark_for_phone_number":"","mark_for_postal_code":"","mark_for_state":"","maximum_allocation_percentage":"100","merchandise_code":"","minimum_allocation_percentage":"100","net_cost":"","nmfc_code":"","open_qty":"0","order_date":"","order_priority":"","original_item_ordered":"","packing_category":"","packing_class":"","parent_license_plate":"","pick_list_id":"","pick_location":"","pick_zone":"","planned_ship_date":"20190415","preference_criteria":"","priority":"","process_stamp":"","producer":"N","quantity_needed_per_item":"0","quantity_um":"","requested_delivery_date":"","requested_delivery_type":"","requested_quantity":"1","secondary_pick_location":"","secondary_pick_zone":"","serial_number_required":"","shipment_id":"OrderNumber SCP-896 OTB-009 attempt 004","shipped_qty":"1","status_flow_name":"","store_distribution":"","temp_internal_order_detail_number":"","temp_internal_order_number":"","temp_internal_shipment_line_number":"","temp_internal_shipment_number":"","treat_as_loose":"","user_defined_field_1":"","user_defined_field_2":"","user_defined_field_3":"","user_defined_field_4":"","user_defined_field_5":"0","user_defined_field_6":"0","user_defined_field_7":"0","user_defined_field_8":"0","user_stamp":"ILSSRV","value":"0","value_add_label_code":"","volume_um":"","warehouse":"WH01","weight_um":""}]}',E'',E'3PL LOGIC',E'2019-05-09 10:23:56.538932+00',E'DHL ADAPTER',E'2019-05-09 10:24:01.779199+00'),
  56. (102,95,E'SCP-896_OTB-042_190509173456603442269_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-042","outbound_type":"TF002","order_number":"SCP-896_OTB-042 ORDER NUMBER 7","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12493","quantity":"1","condition":"RUSAK KEMASAN RETUR","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: Item condition "RUSAK KEMASAN RETUR" is invalid',E'DHL ADAPTER',E'2019-05-09 10:34:56.612375+00',E'3PL TRANSLATOR',E'2019-05-09 10:34:59.428155+00'),
  57. (112,105,E'SCP-896_OTB-046_190509202557104342516_DHL20190503140443015.csv',E'1770-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"SCP-896_OTB-046","outbound_type":"OB002","order_number":"SCP-896_OTB-046 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896_OTB-046","outbound_type":"OB002","order_number":"SCP-896_OTB-046 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"RUSAK","note":""},{"request_id":"SCP-896_OTB-046","outbound_type":"OB002","order_number":"SCP-896_OTB-046 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12353","quantity":"1","condition":"RUSAK PRODUK WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-046","outbound_type":"OB002","order_number":"SCP-896_OTB-046 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"RUSAK KEMASAN WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-046","outbound_type":"OB002","order_number":"SCP-896_OTB-046 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"RUSAK PRODUK SUPPLIER","note":""},{"request_id":"SCP-896_OTB-046","outbound_type":"OB002","order_number":"SCP-896_OTB-046 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12494","quantity":"1","condition":"RUSAK KEMASAN SUPPLIER","note":""},{"request_id":"SCP-896_OTB-046","outbound_type":"OB002","order_number":"SCP-896_OTB-046 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12495","quantity":"1","condition":"RUSAK PRODUK RETUR","note":""},{"request_id":"SCP-896_OTB-046","outbound_type":"OB002","order_number":"SCP-896_OTB-046 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12493","quantity":"1","condition":"RUSAK KEMASAN RETUR","note":""}],"filename":"DHL20190503140443015.csv"}',E'{"request_id":"SCP-896_OTB-046_190509202557104342516_DHL20190503140443015.csv","reference_number":"1770-JAKARTA SELATAN","reference_type":1,"outbound_type":6,"order":{"order_number":"SCP-896_OTB-046 ORDER NUMBER","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557408357,"nanos":104342516}},"shipped_items":[{"code":"AAAX12352","quantity":1,"condition":1},{"code":"AAAX12352","quantity":1,"condition":2},{"code":"AAAX12353","quantity":1,"condition":8},{"code":"LAAX12345","quantity":1,"condition":5},{"code":"LAAX12345","quantity":1,"condition":6},{"code":"CABX12494","quantity":1,"condition":3},{"code":"CABX12495","quantity":1,"condition":7},{"code":"CABX12493","quantity":1,"condition":4}],"actual_date":{"year":2019,"month":5,"day":3},"report_status":1}',E'',E'DHL ADAPTER',E'2019-05-09 13:25:57.114078+00',E'3PL TRANSLATOR',E'2019-05-09 13:25:57.882462+00'),
  58. (116,107,E'SCP-896_OTB-047A_190509203318085125342_DHL20190503140443015.csv',E'1770-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Allocated","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Allocated","sku":"AAAX12352","quantity":"1","condition":"RUSAK","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Allocated","sku":"AAAX12353","quantity":"1","condition":"RUSAK PRODUK WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Allocated","sku":"LAAX12345","quantity":"1","condition":"RUSAK KEMASAN WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Allocated","sku":"LAAX12345","quantity":"1","condition":"RUSAK PRODUK SUPPLIER","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Allocated","sku":"CABX12494","quantity":"1","condition":"RUSAK KEMASAN SUPPLIER","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Allocated","sku":"CABX12495","quantity":"1","condition":"RUSAK PRODUK RETUR","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Allocated","sku":"CABX12493","quantity":"1","condition":"RUSAK KEMASAN RETUR","note":""}],"filename":"DHL20190503140443015.csv"}',E'{"request_id":"SCP-896_OTB-047A_190509203318085125342_DHL20190503140443015.csv","reference_number":"1770-JAKARTA SELATAN","reference_type":1,"outbound_type":6,"order":{"order_number":"SCP-896_OTB-047A ORDER NUMBER","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557408798,"nanos":85125342}},"shipped_items":[{"code":"AAAX12352","quantity":1,"condition":1},{"code":"AAAX12352","quantity":1,"condition":2},{"code":"AAAX12353","quantity":1,"condition":8},{"code":"LAAX12345","quantity":1,"condition":5},{"code":"LAAX12345","quantity":1,"condition":6},{"code":"CABX12494","quantity":1,"condition":3},{"code":"CABX12495","quantity":1,"condition":7},{"code":"CABX12493","quantity":1,"condition":4}],"actual_date":{"year":2019,"month":5,"day":3},"report_status":2}',E'',E'DHL ADAPTER',E'2019-05-09 13:33:18.092741+00',E'3PL TRANSLATOR',E'2019-05-09 13:33:18.612782+00'),
  59. (113,106,E'SCP-896_OTB-046A_190509202732365251322_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-046A","outbound_type":"TF003","order_number":"SCP-896_OTB-046A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896_OTB-046A","outbound_type":"TF003","order_number":"SCP-896_OTB-046A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"RUSAK","note":""},{"request_id":"SCP-896_OTB-046A","outbound_type":"TF003","order_number":"SCP-896_OTB-046A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12353","quantity":"1","condition":"RUSAK PRODUK WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-046A","outbound_type":"TF003","order_number":"SCP-896_OTB-046A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"RUSAK KEMASAN WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-046A","outbound_type":"TF003","order_number":"SCP-896_OTB-046A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"RUSAK PRODUK SUPPLIER","note":""},{"request_id":"SCP-896_OTB-046A","outbound_type":"TF003","order_number":"SCP-896_OTB-046A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12494","quantity":"1","condition":"RUSAK KEMASAN SUPPLIER","note":""},{"request_id":"SCP-896_OTB-046A","outbound_type":"TF003","order_number":"SCP-896_OTB-046A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12495","quantity":"1","condition":"RUSAK PRODUK RETUR","note":""},{"request_id":"SCP-896_OTB-046A","outbound_type":"TF003","order_number":"SCP-896_OTB-046A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12493","quantity":"1","condition":"RUSAK KEMASAN RETUR","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: OutboundType TF003 is invalid',E'DHL ADAPTER',E'2019-05-09 13:27:32.375144+00',E'3PL TRANSLATOR',E'2019-05-09 13:27:32.89279+00'),
  60. (115,107,E'SCP-896_OTB-047A_190509203113041180628_DHL20190503140443015.csv',E'1770-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"AAAX12352","quantity":"1","condition":"RUSAK","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"AAAX12353","quantity":"1","condition":"RUSAK PRODUK WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"LAAX12345","quantity":"1","condition":"RUSAK KEMASAN WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"LAAX12345","quantity":"1","condition":"RUSAK PRODUK SUPPLIER","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"CABX12494","quantity":"1","condition":"RUSAK KEMASAN SUPPLIER","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"CABX12495","quantity":"1","condition":"RUSAK PRODUK RETUR","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"CABX12493","quantity":"1","condition":"RUSAK KEMASAN RETUR","note":""}],"filename":"DHL20190503140443015.csv"}',E'{"request_id":"SCP-896_OTB-047A_190509203113041180628_DHL20190503140443015.csv","reference_number":"1770-JAKARTA SELATAN","reference_type":1,"outbound_type":6,"order":{"order_number":"SCP-896_OTB-047A ORDER NUMBER","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557408673,"nanos":41180628}},"shipped_items":[{"code":"AAAX12352","quantity":1,"condition":1},{"code":"AAAX12352","quantity":1,"condition":2},{"code":"AAAX12353","quantity":1,"condition":8},{"code":"LAAX12345","quantity":1,"condition":5},{"code":"LAAX12345","quantity":1,"condition":6},{"code":"CABX12494","quantity":1,"condition":3},{"code":"CABX12495","quantity":1,"condition":7},{"code":"CABX12493","quantity":1,"condition":4}],"actual_date":{"year":2019,"month":5,"day":3},"report_status":5}',E'',E'DHL ADAPTER',E'2019-05-09 13:31:13.049508+00',E'3PL TRANSLATOR',E'2019-05-09 13:31:13.818485+00'),
  61. (114,107,E'SCP-896_OTB-047A_190509203018228328482_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"TF002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"TF002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"AAAX12352","quantity":"1","condition":"RUSAK","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"TF002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"AAAX12353","quantity":"1","condition":"RUSAK PRODUK WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"TF002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"LAAX12345","quantity":"1","condition":"RUSAK KEMASAN WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"TF002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"LAAX12345","quantity":"1","condition":"RUSAK PRODUK SUPPLIER","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"TF002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"CABX12494","quantity":"1","condition":"RUSAK KEMASAN SUPPLIER","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"TF002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"CABX12495","quantity":"1","condition":"RUSAK PRODUK RETUR","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"TF002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"CABX12493","quantity":"1","condition":"RUSAK KEMASAN RETUR","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 2: Item condition "RUSAK" is invalid',E'DHL ADAPTER',E'2019-05-09 13:30:18.238645+00',E'3PL TRANSLATOR',E'2019-05-09 13:30:18.758364+00'),
  62. (117,107,E'SCP-896_OTB-047A_190509203529261161034_DHL20190503140443015.csv',E'1770-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Allocation","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Allocation","sku":"AAAX12352","quantity":"1","condition":"RUSAK","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Allocation","sku":"AAAX12353","quantity":"1","condition":"RUSAK PRODUK WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Allocation","sku":"LAAX12345","quantity":"1","condition":"RUSAK KEMASAN WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Allocation","sku":"LAAX12345","quantity":"1","condition":"RUSAK PRODUK SUPPLIER","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Allocation","sku":"CABX12494","quantity":"1","condition":"RUSAK KEMASAN SUPPLIER","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Allocation","sku":"CABX12495","quantity":"1","condition":"RUSAK PRODUK RETUR","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Allocation","sku":"CABX12493","quantity":"1","condition":"RUSAK KEMASAN RETUR","note":""}],"filename":"DHL20190503140443015.csv"}',E'{"request_id":"SCP-896_OTB-047A_190509203529261161034_DHL20190503140443015.csv","reference_number":"1770-JAKARTA SELATAN","reference_type":1,"outbound_type":6,"order":{"order_number":"SCP-896_OTB-047A ORDER NUMBER","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557408929,"nanos":261161034}},"shipped_items":[{"code":"AAAX12352","quantity":1,"condition":1},{"code":"AAAX12352","quantity":1,"condition":2},{"code":"AAAX12353","quantity":1,"condition":8},{"code":"LAAX12345","quantity":1,"condition":5},{"code":"LAAX12345","quantity":1,"condition":6},{"code":"CABX12494","quantity":1,"condition":3},{"code":"CABX12495","quantity":1,"condition":7},{"code":"CABX12493","quantity":1,"condition":4}],"actual_date":{"year":2019,"month":5,"day":3},"report_status":3}',E'',E'DHL ADAPTER',E'2019-05-09 13:35:29.269903+00',E'3PL TRANSLATOR',E'2019-05-09 13:35:29.793975+00'),
  63. (121,107,E'SCP-896_OTB-047A_190509204329871466317_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Picking","sku":"AAAX12352","quantity":"-1","condition":"CERITANYA RUSAK","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: Quantity -1 is negative',E'DHL ADAPTER',E'2019-05-09 13:43:29.881083+00',E'3PL TRANSLATOR',E'2019-05-09 13:43:30.645994+00'),
  64. (118,107,E'SCP-896_OTB-047A_190509203659689174160_DHL20190503140443015.csv',E'1770-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Picking","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Picking","sku":"AAAX12352","quantity":"1","condition":"RUSAK","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Picking","sku":"AAAX12353","quantity":"1","condition":"RUSAK PRODUK WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Picking","sku":"LAAX12345","quantity":"1","condition":"RUSAK KEMASAN WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Picking","sku":"LAAX12345","quantity":"1","condition":"RUSAK PRODUK SUPPLIER","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Picking","sku":"CABX12494","quantity":"1","condition":"RUSAK KEMASAN SUPPLIER","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Picking","sku":"CABX12495","quantity":"1","condition":"RUSAK PRODUK RETUR","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Picking","sku":"CABX12493","quantity":"1","condition":"RUSAK KEMASAN RETUR","note":""}],"filename":"DHL20190503140443015.csv"}',E'{"request_id":"SCP-896_OTB-047A_190509203659689174160_DHL20190503140443015.csv","reference_number":"1770-JAKARTA SELATAN","reference_type":1,"outbound_type":6,"order":{"order_number":"SCP-896_OTB-047A ORDER NUMBER","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557409019,"nanos":689174160}},"shipped_items":[{"code":"AAAX12352","quantity":1,"condition":1},{"code":"AAAX12352","quantity":1,"condition":2},{"code":"AAAX12353","quantity":1,"condition":8},{"code":"LAAX12345","quantity":1,"condition":5},{"code":"LAAX12345","quantity":1,"condition":6},{"code":"CABX12494","quantity":1,"condition":3},{"code":"CABX12495","quantity":1,"condition":7},{"code":"CABX12493","quantity":1,"condition":4}],"actual_date":{"year":2019,"month":5,"day":3},"report_status":4}',E'',E'DHL ADAPTER',E'2019-05-09 13:36:59.697782+00',E'3PL TRANSLATOR',E'2019-05-09 13:37:00.219826+00'),
  65. (120,107,E'SCP-896_OTB-047A_190509204120044972145_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Picking","sku":"AAAX12352","quantity":"-1","condition":"BAIK","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: Quantity -1 is negative',E'DHL ADAPTER',E'2019-05-09 13:41:20.052046+00',E'3PL TRANSLATOR',E'2019-05-09 13:41:20.569341+00'),
  66. (119,107,E'SCP-896_OTB-047A_190509203829780679606_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Picking","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Picking","sku":"AAAX12352","quantity":"1","condition":"RUSAK","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Picking","sku":"AAAX12353","quantity":"1","condition":"RUSAK PRODUK WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Picking","sku":"LAAX12345","quantity":"1","condition":"RUSAK KEMASAN WAREHOUSE","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Picking","sku":"LAAX12345","quantity":"1","condition":"RUSAK PRODUK SUPPLIER","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Picking","sku":"CABX12494","quantity":"1","condition":"RUSAK KEMASAN SUPPLIER","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Picking","sku":"CABX12495","quantity":"1","condition":"RUSAK PRODUK RETUR","note":""},{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Picking","sku":"CABX12493","quantity":"1","condition":"RUSAK KEMASAN RETUR","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: Status "Picking" is invalid',E'DHL ADAPTER',E'2019-05-09 13:38:29.807982+00',E'3PL TRANSLATOR',E'2019-05-09 13:38:30.554835+00'),
  67. (122,107,E'SCP-896_OTB-047A_190509204419208733545_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Picking","sku":"AAAX12352","quantity":"1","condition":"CERITANYA RUSAK","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: Status "Picking" is invalid',E'DHL ADAPTER',E'2019-05-09 13:44:19.215319+00',E'3PL TRANSLATOR',E'2019-05-09 13:44:19.73073+00'),
  68. (124,107,E'SCP-896_OTB-047A_190509204731772863021_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"CERITANYA RUSAK","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: OutboundType is empty',E'DHL ADAPTER',E'2019-05-09 13:47:31.780454+00',E'3PL TRANSLATOR',E'2019-05-09 13:47:32.299043+00'),
  69. (123,107,E'SCP-896_OTB-047A_190509204509372616308_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"OB002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"CERITANYA RUSAK","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: Item condition "CERITANYA RUSAK" is invalid',E'DHL ADAPTER',E'2019-05-09 13:45:09.37944+00',E'3PL TRANSLATOR',E'2019-05-09 13:45:09.895792+00'),
  70. (136,9,E'SCP-896 INB-002 HAHAHIHI',E'RefNumber SCP-896 INB-001 001',E'DN',E'OUTBOUND_REQUEST',E'TRANSLATION_FAILED',E'{"request_id":"SCP-896 INB-001","reference_number":"RefNumber SCP-896 INB-001 001","reference_type":1,"outbound_type":1,"order":{"order_number":"OrderNumber SCP-896 INB-001001","shipped_from_id":"0178","shipped_from_address":{"address":"Jl. Kemang Raya No.33 A","postal_code":"12730","phone":"+62 813-8205-6749","city":"Jakarta Selatan","country":"Indonesia","email":"ceritanya@dhl.co.id","first_name":"DHL Indonesia"},"shipped_to_id":"blo.jakartaselatan@ruma.co.id","shipped_to_address":{"address":"Bukan di Bulungan","postal_code":"12130","phone":"+62 21 5331638","city":"Jakarta Selatan","country":"Indonesia","email":"blo.jakartaselatan@ruma.co.id","first_name":"blo.jakartaselatan@ruma.co.id"},"created_by":"SYUKRI","created_time":{"seconds":1557376071,"nanos":720637000}},"shipped_items":[{"code":"AANX12358","name":"Kompor Rinnai 2 Tungku","quantity":1,"condition":1,"size":{"inner":{"length":100,"width":40,"height":15,"weight":2000,"volume":60000}},"category":"Alat masak","states_of_matter":1,"shipping_type":2}],"scheduled_date":{"year":2019,"month":4,"day":15},"audit":{"request_id":"1e15c0fa-c310-48c9-8a42-61dbc375c1f3","timestamp":{"seconds":1557376071,"nanos":720930000}}}',E'',E'',E'3PL LOGIC',E'2019-05-09 04:27:51.889494+00',E'3PL TRANSLATORZZZZadasd',E'2019-05-09 04:27:52.520545+00'),
  71. (6701,107,E'SCP-896_OTB-047A_190730150035346752118_DHL20190503140443016.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"TF002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":" +0800","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190503140443016.csv"}',E'',E'invalid report on line number 1: TransactionTime is not in the right format (YYYY-MM-DD hh:mm:ss)',E'DHL ADAPTER',E'2019-07-30 08:00:35.473067+00',E'3PL TRANSLATOR',E'2019-08-04 22:04:16.255112+00'),
  72. (6703,107,E'SCP-896_OTB-047A_190731150151899041272_DHL20190503140443016.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-047A","outbound_type":"TF002","order_number":"SCP-896_OTB-047A ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190503140443016.csv"}',E'',E'invalid report on line number 1: TransactionTime is empty',E'DHL ADAPTER',E'2019-07-31 08:01:51.916466+00',E'3PL TRANSLATOR',E'2019-08-04 22:04:16.563499+00');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!