SHARE
TWEET

Search-TC8

a guest Aug 23rd, 2019 120 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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');
RAW Paste Data
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
 
Top