[
  {
    "so_order_address": "M-talo",
    "so_tariff_heading": "",
    "so_project_id": "",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "AK",
    "so_vat_total": 0,
    "so_your_reference": "",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "",
    "so_info": "",
    "so_offer_number": "T110023",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1.33627,
    "so_sales_order_id": "T110023",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 99.06,
    "so_sales_margin": 84.06,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "MTALO",
    "so_covenant": "",
    "so_term_of_delivery": "Vapaasti varastossamme",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "MÕõ-talõo  ",
    "so_material_margin": 0,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "2",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2015-02-13",
    "so_packing_state": 0,
    "so_cost_price": 15,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 0,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "14",
    "so_way_of_delivery": "",
    "so_notes": "",
    "so_currency_id": "USD",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TA",
    "so_mark": "",
    "so_sales_price_total": 99.06,
    "so_country_of_origin": "",
    "so_change_id": "20141217.111646.m3001.so_  zzy010ddb1b45aa80g",
    "so_collection_invoice": true,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "",
    "so_company_id": "MTALO",
    "so_number_of_pallets": 0,
    "so_invoicing_address": "M-talo",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20130919.150344.f5001.so_  zzy0001fc6c4f7a807",
    "so_order_discount": 0,
    "so_customer_project": "S1",
    "so_first_delivery_date": "2015-02-13",
    "so_invoicing_company_id": "MTALO",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": 85,
    "so_freight_charges_payer": "",
    "so_our_reference": "T110023/MG_AK",
    "sor": [
      {
        "sor_discount_amount": 0,
        "sor_waiting_for_delivery": 14,
        "sor_unit": "kpl",
        "sor_tariff_heading": "",
        "sor_additional_data": "",
        "sor_delivered_date": "2014-11-30",
        "sor_unit_2": "kpl",
        "sor_order_amount_2": 14,
        "sor_delivery_date": "0000-00-00",
        "sor_unit_price__volume": 0,
        "sor_in_enclosure": false,
        "sor_row_number": 1,
        "sor_marketing_support__unit": 0,
        "sor_marketing_support_percent": 0,
        "sor_est_manufacture_time": 0,
        "sor_number_of_packets": 1,
        "sor_critical_start_date": "0000-00-00",
        "sor_parcel_code": "",
        "sor_delivered_quantity": 0,
        "sor_material_est_arrival_date": "0000-00-00",
        "sor_pallet_number": "",
        "sor_vat_percentage": 0,
        "sor_production_state": "LT",
        "sor_in_dispatch_note": true,
        "sor_partial_delivery_number": 0,
        "sor_stock_event": "",
        "sor_price__unit_2": 105,
        "sor_cost_center": "520",
        "sor_marketing_support": 0,
        "sor_delivery_time": "",
        "sor_material_act_arrival_date": "0000-00-00",
        "sor_modifier_id": "",
        "sor_calc_sales_price_total": 1470,
        "sor_type_": "TI",
        "sor_pricing_state": 0,
        "sor_explanation":
          "Mikroauton putkirunko\rPitkä selitys raporttia varten tuotteelle: Mikroauton putkirunko",
        "sor_units__packet": 0,
        "sor_commission__unit": 0,
        "sor_transfer_id": "",
        "sor_sales_order_code_id": "U",
        "sor_discount_percentage": 0,
        "sor_position_": "",
        "sor_sales_probability": 0,
        "sor_est_manufacture_date": "0000-00-00",
        "sor_ordered_amount": 14,
        "sor_price_group": "",
        "sor_material_margin": 1470,
        "sor_cost_price_total": 686.67,
        "sor_material_cost": 0,
        "sor_sales_margin": 783.33,
        "sor_critical_start_time": 0,
        "sor_transfer_state": -100,
        "sor_creator_id": "",
        "sor_vat_price": 0,
        "sor_sales_price_total": 1470,
        "sor_change_id": "20141111.141230.3m001.sor_ zzy010ddb1b45aa80l",
        "sor_dispatch_note_id": "",
        "sor_volume": 0,
        "sor_est_finish_difference": 0,
        "sor_critical_start_difference": 0,
        "sor_waybill_id": "",
        "sor_project_id": "KV",
        "sor_customer_project": "",
        "sor_sales_margin_percentage": 53,
        "sor_postcalc_date": "2014-11-11",
        "sor_sales_order_id": "110300",
        "sor_purchase_order__row": "110146#01",
        "sor_firm_id": 0,
        "sor_price_with_vat__unit": 105,
        "sor_record_id": "20140918.110649.l0002.sor_ zzy058b035f010c203",
        "sor_collected_amount": "22",
        "sor_amount_to_collect": "",
        "sor_no_printing": false,
        "sor_product_id": "MA RUNKO",
        "sor_need_calculation_type": 0,
        "sor_work_phase_number": 0,
        "sor_info":
          "<CostAccount>\r<WorkCost>583,66</WorkCost>\r<SubcontractCost>98,00</SubcontractCost>\r<GenericCost>5,00</GenericCost>\r<CalculationTime>2014-11-11_14-12-30</CalculationTime>\r</CostAccount>\r\r",
        "sor_customer_row_number": "1",
        "sor_delivery_state": "",
        "sor_serial_number": "",
        "sor_invoice_id": "",
        "sor_make_invoice": true,
        "sor_price__unit": 105,
        "sor_commission": 0,
        "sor_confirmed_delivery_date": "0000-00-00",
        "sor_order_state": "AV",
        "sor_packet__length": 0,
        "sor_delivered_before": 0,
        "sor_commission_percent": 0,
        "sor_material_margin_percentage": 100,
        "sor_units__x_packet": 0,
        "sor_remove_from_stock": true,
        "sor_units__y_packet": 0,
        "sor_first_conf_delivery_date": "0000-00-00",
        "sor_production_lot": "02062/52"
      },
      {
        "sor_discount_amount": 0,
        "sor_waiting_for_delivery": 12,
        "sor_unit": "kpl",
        "sor_tariff_heading": "",
        "sor_additional_data": "",
        "sor_delivered_date": "2015-04-29",
        "sor_unit_2": "kpl",
        "sor_order_amount_2": 12,
        "sor_delivery_date": "0000-00-00",
        "sor_unit_price__volume": 0,
        "sor_in_enclosure": false,
        "sor_row_number": 2,
        "sor_marketing_support__unit": 0,
        "sor_marketing_support_percent": 0,
        "sor_est_manufacture_time": 0,
        "sor_number_of_packets": 1,
        "sor_critical_start_date": "0000-00-00",
        "sor_parcel_code": "01-03",
        "sor_delivered_quantity": 0,
        "sor_material_est_arrival_date": "0000-00-00",
        "sor_pallet_number": "",
        "sor_vat_percentage": 23,
        "sor_production_state": "",
        "sor_in_dispatch_note": true,
        "sor_partial_delivery_number": 0,
        "sor_stock_event": "",
        "sor_price__unit_2": 205,
        "sor_cost_center": "520",
        "sor_marketing_support": 0,
        "sor_delivery_time": "",
        "sor_material_act_arrival_date": "0000-00-00",
        "sor_modifier_id": "",
        "sor_calc_sales_price_total": 2460,
        "sor_type_": "TI",
        "sor_pricing_state": 0,
        "sor_explanation":
          "Mikroauton putkir. v3\rPitkä selitys raporttia varten tuotteelle: Mikroauton putkirunko",
        "sor_units__packet": 0,
        "sor_commission__unit": 0,
        "sor_transfer_id": "",
        "sor_sales_order_code_id": "MY",
        "sor_discount_percentage": 0,
        "sor_position_": "00",
        "sor_sales_probability": 0,
        "sor_est_manufacture_date": "0000-00-00",
        "sor_ordered_amount": 12,
        "sor_price_group": "",
        "sor_material_margin": 2460,
        "sor_cost_price_total": 686.67,
        "sor_material_cost": 0,
        "sor_sales_margin": 1773.33,
        "sor_critical_start_time": 0,
        "sor_transfer_state": -100,
        "sor_creator_id": "",
        "sor_vat_price": 565.8,
        "sor_sales_price_total": 2460,
        "sor_change_id": "20141111.141231.8j003.sor_ zzy010ddb1b45aa80l",
        "sor_dispatch_note_id": "",
        "sor_volume": 0,
        "sor_est_finish_difference": 0,
        "sor_critical_start_difference": 0,
        "sor_waybill_id": "",
        "sor_project_id": "",
        "sor_customer_project": "",
        "sor_sales_margin_percentage": 72,
        "sor_postcalc_date": "2014-11-11",
        "sor_sales_order_id": "110150",
        "sor_purchase_order__row": "",
        "sor_firm_id": 0,
        "sor_price_with_vat__unit": 252.15,
        "sor_record_id": "20130124.111239.k7001.sor_ zzy0001fc6c4f7a80a",
        "sor_collected_amount": "",
        "sor_amount_to_collect": "",
        "sor_no_printing": false,
        "sor_product_id": "MA RUNKO V3",
        "sor_need_calculation_type": 0,
        "sor_work_phase_number": 0,
        "sor_info":
          "<CostAccount>\r<WorkCost>583,66</WorkCost>\r<SubcontractCost>98,00</SubcontractCost>\r<GenericCost>5,00</GenericCost>\r<CalculationTime>2014-11-11_14-12-31</CalculationTime>\r</CostAccount>\r\r\r\r",
        "sor_customer_row_number": "2",
        "sor_delivery_state": "",
        "sor_serial_number": "",
        "sor_invoice_id": "",
        "sor_make_invoice": true,
        "sor_price__unit": 205,
        "sor_commission": 0,
        "sor_confirmed_delivery_date": "2015-07-30",
        "sor_order_state": "AV",
        "sor_packet__length": 0,
        "sor_delivered_before": 0,
        "sor_commission_percent": 0,
        "sor_material_margin_percentage": 100,
        "sor_units__x_packet": 0,
        "sor_remove_from_stock": true,
        "sor_units__y_packet": 0,
        "sor_first_conf_delivery_date": "2015-05-18",
        "sor_production_lot": ""
      },
      {
        "sor_discount_amount": 0,
        "sor_waiting_for_delivery": 13,
        "sor_unit": "kpl",
        "sor_tariff_heading": "",
        "sor_additional_data": "",
        "sor_delivered_date": "2015-05-07",
        "sor_unit_2": "kpl",
        "sor_order_amount_2": 13,
        "sor_delivery_date": "0000-00-00",
        "sor_unit_price__volume": 0,
        "sor_in_enclosure": false,
        "sor_row_number": 3,
        "sor_marketing_support__unit": 0,
        "sor_marketing_support_percent": 0,
        "sor_est_manufacture_time": 0,
        "sor_number_of_packets": 1,
        "sor_critical_start_date": "0000-00-00",
        "sor_parcel_code": "01-03",
        "sor_delivered_quantity": 0,
        "sor_material_est_arrival_date": "0000-00-00",
        "sor_pallet_number": "A",
        "sor_vat_percentage": 23,
        "sor_production_state": "",
        "sor_in_dispatch_note": true,
        "sor_partial_delivery_number": 0,
        "sor_stock_event": "",
        "sor_price__unit_2": 205,
        "sor_cost_center": "520",
        "sor_marketing_support": 0,
        "sor_delivery_time": "",
        "sor_material_act_arrival_date": "0000-00-00",
        "sor_modifier_id": "",
        "sor_calc_sales_price_total": 2665,
        "sor_type_": "TI",
        "sor_pricing_state": 0,
        "sor_explanation":
          "Mikroauton putkir. v3\rPitkä selitys raporttia varten tuotteelle: Mikroauton putkirunko",
        "sor_units__packet": 0,
        "sor_commission__unit": 0,
        "sor_transfer_id": "",
        "sor_sales_order_code_id": "MY",
        "sor_discount_percentage": 0,
        "sor_position_": "00",
        "sor_sales_probability": 0,
        "sor_est_manufacture_date": "0000-00-00",
        "sor_ordered_amount": 13,
        "sor_price_group": "",
        "sor_material_margin": 2665,
        "sor_cost_price_total": 686.67,
        "sor_material_cost": 0,
        "sor_sales_margin": 1978.33,
        "sor_critical_start_time": 0,
        "sor_transfer_state": -100,
        "sor_creator_id": "",
        "sor_vat_price": 612.95,
        "sor_sales_price_total": 2665,
        "sor_change_id": "20141111.141232.iz005.sor_ zzy010ddb1b45aa80l",
        "sor_dispatch_note_id": "",
        "sor_volume": 0,
        "sor_est_finish_difference": 0,
        "sor_critical_start_difference": 0,
        "sor_waybill_id": "",
        "sor_project_id": "",
        "sor_customer_project": "",
        "sor_sales_margin_percentage": 74,
        "sor_postcalc_date": "2014-11-11",
        "sor_sales_order_id": "110150",
        "sor_purchase_order__row": "",
        "sor_firm_id": 0,
        "sor_price_with_vat__unit": 252.15,
        "sor_record_id": "20130124.111243.bx002.sor_ zzy0001fc6c4f7a80a",
        "sor_collected_amount": "4",
        "sor_amount_to_collect": "",
        "sor_no_printing": false,
        "sor_product_id": "MA RUNKO V3",
        "sor_need_calculation_type": 0,
        "sor_work_phase_number": 0,
        "sor_info":
          "<CostAccount>\r<WorkCost>583,66</WorkCost>\r<SubcontractCost>98,00</SubcontractCost>\r<GenericCost>5,00</GenericCost>\r<CalculationTime>2014-11-11_14-12-32</CalculationTime>\r</CostAccount>\r\r\r\r",
        "sor_customer_row_number": "3",
        "sor_delivery_state": "",
        "sor_serial_number": "",
        "sor_invoice_id": "",
        "sor_make_invoice": true,
        "sor_price__unit": 205,
        "sor_commission": 0,
        "sor_confirmed_delivery_date": "2015-04-29",
        "sor_order_state": "AV",
        "sor_packet__length": 0,
        "sor_delivered_before": 0,
        "sor_commission_percent": 0,
        "sor_material_margin_percentage": 100,
        "sor_units__x_packet": 0,
        "sor_remove_from_stock": true,
        "sor_units__y_packet": 0,
        "sor_first_conf_delivery_date": "2015-02-15",
        "sor_production_lot": ""
      }
    ]
  },
  {
    "so_order_address": "Koneen Valo Oy\rHonkatie 11\r08500 Lohja As.",
    "so_tariff_heading": "",
    "so_project_id": "KV",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "AK",
    "so_vat_total": 0,
    "so_your_reference": "",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "R001",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110022",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 14896,
    "so_sales_margin": 5304.03,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "KONEEN VALO",
    "so_covenant": "",
    "so_term_of_delivery": "Vapaasti varastossamme",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address":
      "Koneen Valo Oy\rHonkatie 13 (toimitus)\r08500\tLohja As.",
    "so_material_margin": 14508.6,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2014-12-26",
    "so_packing_state": 0,
    "so_cost_price": 9591.97,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 97,
    "so_material_cost": 387.4,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "30",
    "so_way_of_delivery": "Tuodaan",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 14896,
    "so_country_of_origin": "",
    "so_change_id": "20141111.141351.ka03v.so_  zzy010ddb1b45aa80l",
    "so_collection_invoice": true,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "",
    "so_company_id": "KONEEN VALO",
    "so_number_of_pallets": 0,
    "so_invoicing_address":
      "Koneen Valo Oy\rPL 100 (laskutus)\r08501\tLohja As.",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20110913.094622.47001.so_  zzy01c4bd6ee2e1b03",
    "so_order_discount": 0,
    "so_customer_project": "Runko*2",
    "so_first_delivery_date": "2014-12-26",
    "so_invoicing_company_id": "KONEEN VALO",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": 36,
    "so_freight_charges_payer": "",
    "so_our_reference": "110022/AK"
  },
  {
    "so_order_address": "KeuKing Oy\rKeuruuntie 12 B 8\r42700 Keuruu",
    "so_tariff_heading": "",
    "so_project_id": "",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "PM",
    "so_vat_total": 1035,
    "so_your_reference": "Alpo Kurkinen",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110295",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 4500,
    "so_sales_margin": -459.58,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "KEUKING",
    "so_covenant": "123/1243",
    "so_term_of_delivery": "",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "KeuKing Oy\rMaantie 3",
    "so_material_margin": 4500,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "Alpo Kurkinen",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2014-11-11",
    "so_packing_state": 0,
    "so_cost_price": 4959.58,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 100,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "7",
    "so_way_of_delivery": "",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 4500,
    "so_country_of_origin": "",
    "so_change_id": "20141111.141351.l403x.so_  zzy010ddb1b45aa80l",
    "so_collection_invoice": true,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "Alpo Kurkinen",
    "so_company_id": "KEUKING",
    "so_number_of_pallets": 0,
    "so_invoicing_address": "KeuKing Oy\rKeuruuntie 12 B 8\r42700 Keuruu",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20140916.152149.1d001.so_  zzy058b035f010c203",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "2014-11-11",
    "so_invoicing_company_id": "KEUKING",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": -10,
    "so_freight_charges_payer": "Asiakas",
    "so_our_reference": "110295/PM"
  },
  {
    "so_order_address": "Kiito Oy\rKirkkokatu 1\r41200 Saarijärvi",
    "so_tariff_heading": "",
    "so_project_id": "",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "PM",
    "so_vat_total": 508.95,
    "so_your_reference": "",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110294",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 2212.82,
    "so_sales_margin": 81.19,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "KIITO",
    "so_covenant": "113/25",
    "so_term_of_delivery": "Asiakkaalla",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "Kiito Oy\rKirkkokatu 1\r41200 Saarijärvi",
    "so_material_margin": 2212.82,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2014-11-11",
    "so_packing_state": 0,
    "so_cost_price": 2131.63,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 100,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "7",
    "so_way_of_delivery": "VR",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 2212.82,
    "so_country_of_origin": "",
    "so_change_id": "20141111.141351.lw03z.so_  zzy010ddb1b45aa80l",
    "so_collection_invoice": false,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "",
    "so_company_id": "KIITO",
    "so_number_of_pallets": 0,
    "so_invoicing_address": "Kiito Oy\rKirkkokatu 1\r41200 Saarijärvi",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20140916.145059.mb001.so_  zzy058b035f010c203",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "2014-11-11",
    "so_invoicing_company_id": "KIITO",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": 4,
    "so_freight_charges_payer": "Toimittaja",
    "so_our_reference": "110294/PM"
  },
  {
    "so_order_address":
      "Graafinen Painatus\rYliopiston 11 A 4\r40100 Jyväskylä",
    "so_tariff_heading": "",
    "so_project_id": "",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "AK",
    "so_vat_total": 45.89,
    "so_your_reference": "Jaana Läntinen",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110278",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 210,
    "so_sales_margin": -1333.83,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "GRAFHEAD",
    "so_covenant": "",
    "so_term_of_delivery": "",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address":
      "Graafinen Painatus\rYliopiston 11 A 4\r40100 Jyväskylä",
    "so_material_margin": 199.5,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "Jaana Läntinen",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2015-04-04",
    "so_packing_state": 0,
    "so_cost_price": 1533.33,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 100,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "7",
    "so_way_of_delivery": "Viedään",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 199.5,
    "so_country_of_origin": "",
    "so_change_id": "20141111.141351.m2041.so_  zzy010ddb1b45aa80l",
    "so_collection_invoice": false,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 10.5,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "Jaana Läntinen",
    "so_company_id": "GRAFHEAD",
    "so_number_of_pallets": 0,
    "so_invoicing_address":
      "Graafinen Painatus\rYliopiston 11 A 4\r40100 Jyväskylä",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20130926.115236.ka001.so_  zzy01c4bd6ee2e1b03",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "2015-04-04",
    "so_invoicing_company_id": "GRAFHEAD",
    "so_row_discount_percentage": 5,
    "so_sales_margin_percentage": -669,
    "so_freight_charges_payer": "",
    "so_our_reference": "110278/AK"
  },
  {
    "so_order_address": "Perfecta Industrier Ab\rBox 903\r67129 Arvika\rSWEDEN",
    "so_tariff_heading": "",
    "so_project_id": "",
    "so_state": "VA",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "AK",
    "so_vat_total": 5844.83,
    "so_your_reference": "",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110153",
    "so_eur_number": "",
    "so_destination": "Arvika",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 25412.31,
    "so_sales_margin": 21841.38,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "PERFECTA",
    "so_covenant": "",
    "so_term_of_delivery": "Vapaasti varastossamme",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address":
      "Perfecta Industrier Ab\rBox 903\r67129 Arvika\rSWEDEN",
    "so_material_margin": 25412.31,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2015-03-15",
    "so_packing_state": 0,
    "so_cost_price": 3570.93,
    "so_confirmation_date": "2015-01-24",
    "so_material_margin_percentage": 100,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "30",
    "so_way_of_delivery": "",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 25412.31,
    "so_country_of_origin": "",
    "so_change_id": "20141111.141351.m9043.so_  zzy010ddb1b45aa80l",
    "so_collection_invoice": true,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "SWEDEN",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "",
    "so_company_id": "PERFECTA",
    "so_number_of_pallets": 0,
    "so_invoicing_address":
      "Perfecta Industrier Ab\rBox 903\r67129 Arvika\rSWEDEN",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20130205.205533.lt001.so_  zzy01c4bd6ee2e1b0e",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "2015-03-15",
    "so_invoicing_company_id": "PERFECTA",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": 86,
    "so_freight_charges_payer": "",
    "so_our_reference": "110153/MG_AK"
  },
  {
    "so_order_address":
      "ABC Moottori Oyj\rIsomoottoritehdas\rPL 6\r65101 Vaasa",
    "so_tariff_heading": "",
    "so_project_id": "P2010-01",
    "so_state": "AL",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "AK",
    "so_vat_total": 1201,
    "so_your_reference": "",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "E123",
    "so_info": "XML Vahvistus<BR/>Vahvistettu XML:llä ",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "520",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110154",
    "so_eur_number": "",
    "so_destination": "Pori",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 5677.56,
    "so_sales_margin": -797,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "ELSOINTU",
    "so_covenant": "",
    "so_term_of_delivery": "",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "Elävä Sointu Oy\rPL 5\r28601 Pori\rSuomi",
    "so_material_margin": 1480.31,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2015-01-20",
    "so_packing_state": 0,
    "so_cost_price": 6474.56,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 26,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "14/30",
    "so_way_of_delivery": "Posti",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 5677.56,
    "so_country_of_origin": "",
    "so_change_id": "20141111.141351.nc045.so_  zzy010ddb1b45aa80l",
    "so_collection_invoice": true,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "Suomi",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "Hannu Pommila",
    "so_company_id": "ABC VAASA",
    "so_number_of_pallets": 0,
    "so_invoicing_address": "ABC Koneet Oyj\rPL 10\r00381 Helsinki",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20130206.102952.81001.so_  zzy01c4bd6ee2e1b08",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "2015-01-20",
    "so_invoicing_company_id": "ABC KONEET",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": -14,
    "so_freight_charges_payer": "",
    "so_our_reference": "110154/MG_Admin"
  },
  {
    "so_order_address": "KeuKing Oy\rKeuruuntie 12 B 8\r42700 Keuruu",
    "so_tariff_heading": "",
    "so_project_id": "",
    "so_state": "LO",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "AK",
    "so_vat_total": 1584.39,
    "so_your_reference": "Alpo Kurkinen",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "A001.120",
    "so_info": " ",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110147",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 6667.51,
    "so_sales_margin": 2787.62,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "KEUKING",
    "so_covenant": "123/1243",
    "so_term_of_delivery": "Vapaasti varastossamme",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "KeuKing Oy\rKeuruuntie 12 B 8\r42700 Keuruu",
    "so_material_margin": 1504.34,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2015-02-04",
    "so_packing_state": 0,
    "so_cost_price": 3879.89,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 23,
    "so_material_cost": 76.25,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "7",
    "so_way_of_delivery": "Matkahuolto",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "1000-01",
    "so_sales_price_total": 6667.51,
    "so_country_of_origin": "",
    "so_change_id": "20141111.141351.om047.so_  zzy010ddb1b45aa80l",
    "so_collection_invoice": true,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "Jarno Ahma",
    "so_company_id": "KEUKING",
    "so_number_of_pallets": 0,
    "so_invoicing_address": "KeuKing Oy\rKeuruuntie 12 B 8\r42700 Keuruu",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20121114.112519.l0001.so_  zzy0001fc6c4f7a803",
    "so_order_discount": 0,
    "so_customer_project": "Karting varaosat",
    "so_first_delivery_date": "2015-02-04",
    "so_invoicing_company_id": "KEUKING",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": 42,
    "so_freight_charges_payer": "",
    "so_our_reference": "110147/AK"
  },
  {
    "so_order_address": "KeuKing Oy\rKeuruuntie 12 B 8\r42700 Keuruu",
    "so_tariff_heading": "",
    "so_project_id": "",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "AK",
    "so_vat_total": 1697.4,
    "so_your_reference": "Alpo Kurkinen",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "X1501",
    "so_info": "EDI-Vahvistus\r\nEDI-Laskutus\r\n",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110150",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 7380,
    "so_sales_margin": 5287.01,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "KEUKING",
    "so_covenant": "123/1243",
    "so_term_of_delivery": "",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "KeuKing Oy\rKeuruuntie 12 B 8\r42700 Keuruu",
    "so_material_margin": 7380,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2015-01-28",
    "so_packing_state": 0,
    "so_cost_price": 2092.99,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 100,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "7",
    "so_way_of_delivery": "",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 7380,
    "so_country_of_origin": "",
    "so_change_id": "20141111.141351.p9049.so_  zzy010ddb1b45aa80l",
    "so_collection_invoice": true,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "Alpo Kurkinen",
    "so_company_id": "KEUKING",
    "so_number_of_pallets": 0,
    "so_invoicing_address": "KeuKing Oy\rKeuruuntie 12 B 8\r42700 Keuruu",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20121221.192008.hx001.so_  zzy0001fc6c4f7a808",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "0000-00-00",
    "so_invoicing_company_id": "KEUKING",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": 72,
    "so_freight_charges_payer": "Asiakas",
    "so_our_reference": ""
  },
  {
    "so_order_address": "Koneen Valo Oy\rHonkatie 11\r08500 Lohja As.",
    "so_tariff_heading": "",
    "so_project_id": "KV",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "AK",
    "so_vat_total": -0,
    "so_your_reference": "",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110272",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 6700.75,
    "so_sales_margin": 4690.39,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "SÄHKÖTUOTE",
    "so_covenant": "",
    "so_term_of_delivery": "",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "Sähkötuote Oy\rSilmukkatie 1\r65320 Vaasa",
    "so_material_margin": 6700.75,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2015-02-28",
    "so_packing_state": 0,
    "so_cost_price": 2010.36,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 100,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "30",
    "so_way_of_delivery": "Matkahuolto",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 6700.75,
    "so_country_of_origin": "",
    "so_change_id": "20141111.174553.a3001.so_  zzy010ddb1b45aa80k",
    "so_collection_invoice": true,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "Tarjous SOP1",
    "so_company_id": "KONEEN VALO",
    "so_number_of_pallets": 0,
    "so_invoicing_address":
      "Koneen Valo Oy\rPL 100 (laskutus)\r08501\tLohja As.",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20130822.182121.h1003.so_  zzy0001fc6c4f7a80c",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "2015-02-28",
    "so_invoicing_company_id": "KONEEN VALO",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": 70,
    "so_freight_charges_payer": "",
    "so_our_reference": "110272/MG_AK"
  },
  {
    "so_order_address": "Kiito Oy\rKirkkokatu 1\r41200 Saarijärvi",
    "so_tariff_heading": "",
    "so_project_id": "",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "MG_AK",
    "so_vat_total": 363.87,
    "so_your_reference": "",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110308",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 1582.05,
    "so_sales_margin": 634.94,
    "so_dealer_address": "",
    "so_postcalc_date": "0000-00-00",
    "so_delivery_company_id": "KIITO",
    "so_covenant": "113/25",
    "so_term_of_delivery": "Asiakkaalla",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "Kiito Oy\rKirkkokatu 1\r41200 Saarijärvi",
    "so_material_margin": 0,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2014-11-14",
    "so_packing_state": 0,
    "so_cost_price": 947.11,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 0,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "7",
    "so_way_of_delivery": "VR",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 1582.05,
    "so_country_of_origin": "",
    "so_change_id": "20141211.115206.9a009.so_  zzy010ddb1b45aa80e",
    "so_collection_invoice": false,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "",
    "so_company_id": "KIITO",
    "so_number_of_pallets": 0,
    "so_invoicing_address": "Kiito Oy\rKirkkokatu 1\r41200 Saarijärvi",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20141114.174708.f0001.so_  zzy0001fc6c4f7a805",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "2014-11-14",
    "so_invoicing_company_id": "KIITO",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": 40,
    "so_freight_charges_payer": "Toimittaja",
    "so_our_reference": "110308/MG_AK"
  },
  {
    "so_order_address": "Puupää Oy\rLastutie 3\r40320 Jyväskylä",
    "so_tariff_heading": "",
    "so_project_id": "",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "MG_AK",
    "so_vat_total": 0,
    "so_your_reference": "",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "ÄLÄ TUHOA",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110307",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 0,
    "so_sales_margin": 0,
    "so_dealer_address": "",
    "so_postcalc_date": "0000-00-00",
    "so_delivery_company_id": "MANAGE",
    "so_covenant": "",
    "so_term_of_delivery": "Vapaasti varastossamme",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "Manage Applications\rLaukaantie 4\r40320 Jyväskylä",
    "so_material_margin": 0,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2014-11-11",
    "so_packing_state": 0,
    "so_cost_price": 0,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 100,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "7",
    "so_way_of_delivery": "Posti",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 0,
    "so_country_of_origin": "",
    "so_change_id": "20141111.174404.h700e.so_  zzy010ddb1b45aa80d",
    "so_collection_invoice": true,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "",
    "so_company_id": "PUUPÄÄ",
    "so_number_of_pallets": 0,
    "so_invoicing_address":
      "Sky Is Limit Oy\rTaivas Rajana Oy\rHuopalahdenkatu 58 B\r00350 Helsinki",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20141111.164620.f6014.so_  zzy0001fc6c4f7a80b",
    "so_order_discount": 0,
    "so_customer_project": "Laser vastaanottotesti",
    "so_first_delivery_date": "2014-11-11",
    "so_invoicing_company_id": "SKYISLIMIT",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": 100,
    "so_freight_charges_payer": "",
    "so_our_reference": "110307/MG_AK"
  },
  {
    "so_order_address": "Kiito Oy\rKirkkokatu 1\r41200 Saarijärvi",
    "so_tariff_heading": "",
    "so_project_id": "",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "MG_AK",
    "so_vat_total": 1725,
    "so_your_reference": "",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110302",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 7500,
    "so_sales_margin": 7015.26,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "KIITO",
    "so_covenant": "113/25",
    "so_term_of_delivery": "Asiakkaalla",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "Kiito Oy\rKirkkokatu 1\r41200 Saarijärvi",
    "so_material_margin": 7500,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2014-12-16",
    "so_packing_state": 0,
    "so_cost_price": 484.74,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 100,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "7",
    "so_way_of_delivery": "VR",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 7500,
    "so_country_of_origin": "",
    "so_change_id": "20141111.141351.r804d.so_  zzy010ddb1b45aa80l",
    "so_collection_invoice": false,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "",
    "so_company_id": "KIITO",
    "so_number_of_pallets": 0,
    "so_invoicing_address": "Kiito Oy\rKirkkokatu 1\r41200 Saarijärvi",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20141021.135838.c0001.so_  zzy000059a3c7a0008",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "2014-12-16",
    "so_invoicing_company_id": "KIITO",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": 94,
    "so_freight_charges_payer": "Toimittaja",
    "so_our_reference": "110302/MG_AK"
  },
  {
    "so_order_address": "Rahtarit Oy\rSorastajankatu 45\r40100 Jyväskylä",
    "so_tariff_heading": "",
    "so_project_id": "",
    "so_state": "AL",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "MG_AK",
    "so_vat_total": 74.9,
    "so_your_reference": "",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110301",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 325.58,
    "so_sales_margin": -45.52,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "RAHTARIT",
    "so_covenant": "",
    "so_term_of_delivery": "",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "Rahtarit Oy\rSorastajankatu 45\r40100 Jyväskylä",
    "so_material_margin": 194.96,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2014-12-12",
    "so_packing_state": 0,
    "so_cost_price": 371.1,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 60,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "14",
    "so_way_of_delivery": "",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 325.58,
    "so_country_of_origin": "",
    "so_change_id": "20141111.141351.rl04f.so_  zzy010ddb1b45aa80l",
    "so_collection_invoice": false,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "",
    "so_company_id": "RAHTARIT",
    "so_number_of_pallets": 0,
    "so_invoicing_address": "Rahtarit Oy\rSorastajankatu 45\r40100 Jyväskylä",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20141017.144728.ij001.so_  zzy0001fc6c4f7a809",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "2014-12-12",
    "so_invoicing_company_id": "RAHTARIT",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": -14,
    "so_freight_charges_payer": "",
    "so_our_reference": "110301/MG_AK"
  },
  {
    "so_order_address": "Elävä Sointu Oy\rPL 5\r28601 Pori\rSuomi",
    "so_tariff_heading": "",
    "so_project_id": "P2010-01",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "AK",
    "so_vat_total": 770.5,
    "so_your_reference": "Hannu Pommi",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "Pinta-9001",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110143",
    "so_eur_number": "",
    "so_destination": "Pori",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 3350,
    "so_sales_margin": 2197.49,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "ELSOINTU",
    "so_covenant": "",
    "so_term_of_delivery": "",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "Elävä Sointu Oy\rHumalamäki\r28600\tPori",
    "so_material_margin": 3350,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2015-01-30",
    "so_packing_state": 0,
    "so_cost_price": 1152.51,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 100,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "14",
    "so_way_of_delivery": "Posti",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 3350,
    "so_country_of_origin": "",
    "so_change_id": "20141111.141351.rr04h.so_  zzy010ddb1b45aa80l",
    "so_collection_invoice": true,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "Suomi",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "",
    "so_company_id": "ELSOINTU",
    "so_number_of_pallets": 0,
    "so_invoicing_address": "Elävä Sointu Oy\rPL 5\r28601 Pori\rSuomi",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20121010.172809.qx001.so_  zzy0001fc6c4f7a80a",
    "so_order_discount": 0,
    "so_customer_project": "Pintakäsittely",
    "so_first_delivery_date": "2015-01-30",
    "so_invoicing_company_id": "ELSOINTU",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": 66,
    "so_freight_charges_payer": "",
    "so_our_reference": "110143/MG_AK"
  },
  {
    "so_order_address": "Koneen Valo Oy\rHonkatie 11\r08500 Lohja As.",
    "so_tariff_heading": "",
    "so_project_id": "KV",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "MG_AK",
    "so_vat_total": 0,
    "so_your_reference": "",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110282",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 3090,
    "so_sales_margin": 1037.91,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "SÄHKÖTUOTE",
    "so_covenant": "",
    "so_term_of_delivery": "",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "Sähkötuote Oy\rSilmukkatie 1\r65320 Vaasa",
    "so_material_margin": 3090,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2015-04-11",
    "so_packing_state": 0,
    "so_cost_price": 2052.09,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 100,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "30",
    "so_way_of_delivery": "Matkahuolto",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 3090,
    "so_country_of_origin": "",
    "so_change_id": "20141111.141351.0904j.so_  zzy010ddb1b45aa80l",
    "so_collection_invoice": true,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "Tarjous SOP1",
    "so_company_id": "KONEEN VALO",
    "so_number_of_pallets": 0,
    "so_invoicing_address":
      "Koneen Valo Oy\rPL 100 (laskutus)\r08501\tLohja As.",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20131003.142542.5x003.so_  zzy0001fc6c4f7a804",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "2015-04-11",
    "so_invoicing_company_id": "KONEEN VALO",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": 34,
    "so_freight_charges_payer": "",
    "so_our_reference": "110282/MG_AK"
  },
  {
    "so_order_address":
      "Koko Kosmetiikka\rMankkaa 21\r02256 Espoo\r003701141622015",
    "so_tariff_heading": "",
    "so_project_id": "",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "PM",
    "so_vat_total": 883.2,
    "so_your_reference": "Henrik Lönnblad",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "510",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110296",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 3840,
    "so_sales_margin": 1708.37,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "KOSMETIIKKA",
    "so_covenant": "",
    "so_term_of_delivery": "Vapaasti varastossamme",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address":
      "Koko Kosmetiikka\rMankkaa 21\r02256 Espoo\r003701141622015",
    "so_material_margin": 3840,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "Henrik Lönnblad",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2014-11-12",
    "so_packing_state": 0,
    "so_cost_price": 2131.63,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 100,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "7",
    "so_way_of_delivery": "Viedään",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 3840,
    "so_country_of_origin": "",
    "so_change_id": "20141111.141352.1504l.so_  zzy010ddb1b45aa80l",
    "so_collection_invoice": true,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "003701141622015",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "Henrik Lönnblad",
    "so_company_id": "KOSMETIIKKA",
    "so_number_of_pallets": 0,
    "so_invoicing_address":
      "Koko Kosmetiikka\rMankkaa 21\r02256 Espoo\r003701141622015",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20140917.100735.k3001.so_  zzy058b035f010c203",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "2014-11-12",
    "so_invoicing_company_id": "KOSMETIIKKA",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": 44,
    "so_freight_charges_payer": "",
    "so_our_reference": "110296/PM"
  },
  {
    "so_order_address": "M-talo",
    "so_tariff_heading": "",
    "so_project_id": "",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "PM",
    "so_vat_total": 0,
    "so_your_reference": "",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1.33627,
    "so_sales_order_id": "110297",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 3840,
    "so_sales_margin": 3120.35,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "MTALO",
    "so_covenant": "",
    "so_term_of_delivery": "Vapaasti varastossamme",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "M-talo",
    "so_material_margin": 3840,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2014-11-12",
    "so_packing_state": 0,
    "so_cost_price": 719.65,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 100,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "14",
    "so_way_of_delivery": "",
    "so_notes": "",
    "so_currency_id": "USD",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 3840,
    "so_country_of_origin": "",
    "so_change_id": "20141111.141352.2c04n.so_  zzy010ddb1b45aa80l",
    "so_collection_invoice": true,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "",
    "so_company_id": "MTALO",
    "so_number_of_pallets": 0,
    "so_invoicing_address": "M-talo",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20140917.112131.hb001.so_  zzy058b035f010c203",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "2014-11-12",
    "so_invoicing_company_id": "MTALO",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": 81,
    "so_freight_charges_payer": "",
    "so_our_reference": "110297/PM"
  },
  {
    "so_order_address": "Kiito Oy\rKirkkokatu 1\r41200 Saarijärvi",
    "so_tariff_heading": "",
    "so_project_id": "",
    "so_state": "AL",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "PM",
    "so_vat_total": 926.9,
    "so_your_reference": "",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110298",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 4030,
    "so_sales_margin": 3547.5,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "KIITO",
    "so_covenant": "113/25",
    "so_term_of_delivery": "Asiakkaalla",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "Kiito Oy\rKirkkokatu 1\r41200 Saarijärvi",
    "so_material_margin": 4030,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2014-11-12",
    "so_packing_state": 0,
    "so_cost_price": 482.5,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 100,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "7",
    "so_way_of_delivery": "VR",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 4030,
    "so_country_of_origin": "",
    "so_change_id": "20141111.141352.3h04p.so_  zzy010ddb1b45aa80l",
    "so_collection_invoice": false,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "",
    "so_company_id": "KIITO",
    "so_number_of_pallets": 0,
    "so_invoicing_address": "Kiito Oy\rKirkkokatu 1\r41200 Saarijärvi",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20140917.122103.cw003.so_  zzy058b035f010c203",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "2014-11-12",
    "so_invoicing_company_id": "KIITO",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": 88,
    "so_freight_charges_payer": "Toimittaja",
    "so_our_reference": "110298/PM"
  },
  {
    "so_order_address":
      "ABC Moottori Oyj\rIsomoottoritehdas\rPL 6\r65101 Vaasa",
    "so_tariff_heading": "",
    "so_project_id": "",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "MG_AK",
    "so_vat_total": 152.18,
    "so_your_reference": "",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "520",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110283",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 661.69,
    "so_sales_margin": -497.91,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "KEUKING",
    "so_covenant": "",
    "so_term_of_delivery": "",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "KeuKing Oy\rKeuruuntie 12 B 8\r42700 Keuruu",
    "so_material_margin": 661.69,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2015-10-31",
    "so_packing_state": 2,
    "so_cost_price": 1159.6,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 100,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "14/30",
    "so_way_of_delivery": "",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 661.69,
    "so_country_of_origin": "",
    "so_change_id": "20141111.174625.a9003.so_  zzy010ddb1b45aa80k",
    "so_collection_invoice": true,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "Alpo Kurkinen",
    "so_company_id": "ABC VAASA",
    "so_number_of_pallets": 0,
    "so_invoicing_address": "ABC Koneet Oyj\rPL 10\r00381 Helsinki",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20131022.125830.14001.so_  zzy0001fc6c4f7a808",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "2014-11-26",
    "so_invoicing_company_id": "ABC KONEET",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": -75,
    "so_freight_charges_payer": "",
    "so_our_reference": "110283/MG_AK"
  },
  {
    "so_order_address":
      "Sky Is Limit Oy\rTaivas Rajana Oy\rHuopalahdenkatu 58 B\r00350 Helsinki",
    "so_tariff_heading": "",
    "so_project_id": "",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "MG_AK",
    "so_vat_total": 379.5,
    "so_your_reference": "Molari Olli",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110305",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 1650,
    "so_sales_margin": 497.92,
    "so_dealer_address": "",
    "so_postcalc_date": "0000-00-00",
    "so_delivery_company_id": "SKYISLIMIT",
    "so_covenant": "",
    "so_term_of_delivery": "Vapaasti varastossamme",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address":
      "Sky Is Limit Oy\rTaivas Rajana Oy\rHuopalahdenkatu 58 B\r00350 Helsinki",
    "so_material_margin": 0,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2014-11-11",
    "so_packing_state": 0,
    "so_cost_price": 1152.08,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 0,
    "so_material_cost": 0,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "14",
    "so_way_of_delivery": "Sähköposti + viedään",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "TELA1500",
    "so_sales_price_total": 1650,
    "so_country_of_origin": "",
    "so_change_id": "20141111.180519.3800d.so_  zzy010ddb1b45aa80m",
    "so_collection_invoice": true,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "",
    "so_company_id": "SKYISLIMIT",
    "so_number_of_pallets": 0,
    "so_invoicing_address":
      "Sky Is Limit Oy\rTaivas Rajana Oy\rHuopalahdenkatu 58 B\r00350 Helsinki",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20141111.155536.8j001.so_  zzy0001fc6c4f7a80b",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "2014-11-11",
    "so_invoicing_company_id": "SKYISLIMIT",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": 30,
    "so_freight_charges_payer": "",
    "so_our_reference": "110305/MG_AK"
  },
  {
    "so_order_address": "Muovi Ltd\rPyykkärintie 4\r01233 Vantaa\r0190045",
    "so_tariff_heading": "",
    "so_project_id": "",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "MG_AK",
    "so_vat_total": 920,
    "so_your_reference": "Kristiina Sund",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110284",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 4000,
    "so_sales_margin": 1266.65,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "MUOVI",
    "so_covenant": "",
    "so_term_of_delivery": "",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "Muovi Ltd\rPyykkärintie 4\r01233 Vantaa\r0190045",
    "so_material_margin": 2616.4,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "Kristiina Sund",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2015-05-22",
    "so_packing_state": 0,
    "so_cost_price": 2733.35,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 65,
    "so_material_cost": 1383.6,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "7",
    "so_way_of_delivery": "Posti",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 4000,
    "so_country_of_origin": "",
    "so_change_id": "20141111.141352.5h04t.so_  zzy010ddb1b45aa80l",
    "so_collection_invoice": true,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "0190045",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "Kristiina Sund",
    "so_company_id": "MUOVI",
    "so_number_of_pallets": 0,
    "so_invoicing_address": "Muovi Ltd\rPyykkärintie 4\r01233 Vantaa\r0190045",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20131113.175505.74001.so_  zzy0001fc6c4f7a80c",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "2015-05-22",
    "so_invoicing_company_id": "MUOVI",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": 32,
    "so_freight_charges_payer": "",
    "so_our_reference": "110284/MG_AK"
  },
  {
    "so_order_address": "Koneen Valo Oy\rHonkatie 11\r08500 Lohja As.",
    "so_tariff_heading": "",
    "so_project_id": "KV",
    "so_state": "AV",
    "so_place_of_departure": "Jyväskylä",
    "so_employee_id": "PM",
    "so_vat_total": 0,
    "so_your_reference": "",
    "so_creator_id": "",
    "so_sales_probability": 0,
    "so_customer_order_number": "",
    "so_info": "",
    "so_offer_number": "",
    "so_supplier_invoice_number": "",
    "so_cost_center": "",
    "so_precarriage": "",
    "so_exchange_rate": 1,
    "so_sales_order_id": "110300",
    "so_eur_number": "",
    "so_destination": "",
    "so_supplier_id": "",
    "so_sales_price_wo_discount": 2095,
    "so_sales_margin": -2679.82,
    "so_dealer_address": "",
    "so_postcalc_date": "2014-11-11",
    "so_delivery_company_id": "SÄHKÖTUOTE",
    "so_covenant": "",
    "so_term_of_delivery": "",
    "so_gross_weight": 0,
    "so_dealer_company_id": "",
    "so_net_weight": 0,
    "so_delivery_address": "Sähkötuote Oy\rSilmukkatie 1\r65320 Vaasa",
    "so_material_margin": 1518.4,
    "so_supplier_invoice_date": "0000-00-00",
    "so_your_reference_of_invoice": "",
    "so_transfer_state": -100,
    "so_packing_info": "",
    "so_order_date": "2014-11-13",
    "so_packing_state": 0,
    "so_cost_price": 4774.82,
    "so_confirmation_date": "0000-00-00",
    "so_material_margin_percentage": 72,
    "so_material_cost": 576.6,
    "so_euro_rate": 0,
    "so_transfer_id": "",
    "so_modifier_id": "",
    "so_terms_of_payment_id": "30",
    "so_way_of_delivery": "Matkahuolto",
    "so_notes": "",
    "so_currency_id": "EUR",
    "so_description_of_the_goods": "",
    "so_volume": 0,
    "so_type_": "TI",
    "so_mark": "",
    "so_sales_price_total": 2095,
    "so_country_of_origin": "",
    "so_change_id": "20141111.141352.6504v.so_  zzy010ddb1b45aa80l",
    "so_collection_invoice": true,
    "so_order_discount_percentage": 0,
    "so_country_of_destination": "",
    "so_row_discount": 0,
    "so_additional_data": "",
    "so_your_reference_of_delivery": "Tarjous SOP1",
    "so_company_id": "KONEEN VALO",
    "so_number_of_pallets": 0,
    "so_invoicing_address":
      "Koneen Valo Oy\rPL 100 (laskutus)\r08501\tLohja As.",
    "so_firm_id": 1,
    "so_discharge_place": "",
    "so_record_id": "20140918.110640.px001.so_  zzy058b035f010c203",
    "so_order_discount": 0,
    "so_customer_project": "",
    "so_first_delivery_date": "2014-11-13",
    "so_invoicing_company_id": "KONEEN VALO",
    "so_row_discount_percentage": 0,
    "so_sales_margin_percentage": -128,
    "so_freight_charges_payer": "",
    "so_our_reference": "110300/PM"
  }
]
