{
	"content": {
		"header": [
			[
				{
					"height": 30,
					"id": "logo",
					"source": "preference/report/logo_nomet.png",
					"style": {
						"Xvertical_align": "middle",
						"margin": {
							"bottom": 2,
							"left": 2,
							"right": 2,
							"top": 2
						},
						"scaling": "fit",
						"stroke_width": 3
					},
					"type": "pict",
					"width": 121,
					"x": 0,
					"y": 0
				}
			],
			[
				{
					"height": 30,
					"id": "report_header_text",
					"style": {
						"font_name": "sans-serif",
						"font_size": 16,
						"horizontal_align": "center",
						"margin": {
							"top": 0
						},
						"vertical_align": "middle"
					},
					"text": "Keskeneräisen tuotannon arvo",
					"type": "text",
					"width": 559,
					"x": 120.5,
					"y": 0
				}
			],
			[
				{
					"format": ["Sivu %d"],
					"height": 30,
					"id": "pageNumber",
					"style": {
						"font_name": "sans-serif",
						"font_size": 7,
						"horizontal_align": "right",
						"margin": {
							"top": 0
						}
					},
					"subtotal": "",
					"subtotal_operator": "",
					"type": "text",
					"width": 121,
					"x": 680,
					"y": 0
				},
				{
					"formula": ["dt.currentFormat", "viikko %W - %d.%m.%Y"],
					"height": 30,
					"id": "report_header_right_date",
					"style": {
						"font_name": "sans-serif",
						"font_size": 7,
						"horizontal_align": "right",
						"margin": {
							"top": 0
						}
					},
					"type": "text",
					"width": 121,
					"x": 680,
					"y": 12
				},
				{
					"formula": ["dt.currentFormat", "%H:%M:%S"],
					"height": 30,
					"id": "report_header_right_time",
					"style": {
						"font_name": "sans-serif",
						"font_size": 7,
						"horizontal_align": "right",
						"margin": {
							"top": 0
						}
					},
					"type": "text",
					"width": 121,
					"x": 680,
					"y": 24
				}
			],
			{
				"id": "header_bottom_horizontal_line",
				"style": {
					"stroke_color": "black",
					"stroke_width": 0.25
				},
				"type": "line",
				"x": 0,
				"x2": 801,
				"y": 40,
				"y2": 40
			}
		],
		"object_order": ["header", "row_header", "row_line", "row_data"],
		"page_break": 545,
		"row_data": [
			{
				"field": "self_cost_sum",
				"formula": [
					"+",
					"qry_work_self_cost_calculated",
					"qry_subcontract_self_cost_calculated",
					"calc_material_self_cost_wme",
					"qry_material_self_cost_por_calculated"
				],
				"id": "self_cost_sum",
				"type": "calculate"
			},
			{
				"field": "calc_material_self_cost_wme",
				"format": ["%'.0f"],
				"id": "calc_material_self_cost_wme",
				"name": "cost_wme",
				"type": "calculate",
				"width": 70
			},
			{
				"field": "qry_material_self_cost_wme__unit",
				"format": ["%'.0f"],
				"id": "qry_material_self_cost_wme__unit",
				"name": "Mat. OK/kpl (var. ohj)",
				"type": "calculate",
				"width": 70
			},
			{
				"fit_text": "width",
				"format": ["%'d"],
				"height": 20,
				"id": "rowNumber",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"subtotal": "",
				"subtotal_operator": "",
				"text": "rowNumber",
				"type": "text",
				"width": 17.325162220620044,
				"x": 0,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"height": 20,
				"id": "wo_company_id",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "wo_company_id",
				"type": "text",
				"width": 46.20043258832012,
				"x": 17.325162220620044,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"height": 20,
				"id": "pr_product_group",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "pr_product_group",
				"type": "text",
				"width": 51.97548666186013,
				"x": 63.52559480894016,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"height": 20,
				"id": "wo_drawing_number",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "wo_drawing_number",
				"type": "text",
				"width": 72.18817591925018,
				"x": 115.50108147080029,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"height": 20,
				"id": "pr_name",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "pr_name",
				"type": "text",
				"width": 127.05118961788033,
				"x": 187.68925739005047,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"height": 20,
				"id": "wo_production_lot",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "wo_production_lot",
				"type": "text",
				"width": 40.4253785147801,
				"x": 314.7404470079308,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"height": 20,
				"id": "wo_state",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "wo_state",
				"type": "text",
				"width": 14.437635183850036,
				"x": 355.1658255227109,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"format": ["d%d.%m.%Y"],
				"height": 20,
				"id": "wo_creation_date",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "wo_creation_date",
				"type": "text",
				"width": 36.960346070656094,
				"x": 369.60346070656095,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"format": ["d%d.%m.%Y"],
				"height": 20,
				"id": "wo_material_act_arrival_date",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "wo_material_act_arrival_date",
				"type": "text",
				"width": 36.960346070656094,
				"x": 406.56380677721705,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"formula": [
					"replace",
					{
						"0": "T",
						"1": "V"
					}
				],
				"height": 20,
				"id": "pr_production_control_type",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "center",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "pr_production_control_type",
				"type": "text",
				"width": 14.437635183850036,
				"x": 443.5241528478731,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"height": 20,
				"id": "wo_started_amount",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "center",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "wo_started_amount",
				"type": "text",
				"width": 23.10021629416006,
				"x": 457.9617880317232,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"height": 20,
				"id": "wo_produced_amount",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "center",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "wo_produced_amount",
				"type": "text",
				"width": 23.10021629416006,
				"x": 481.0620043258832,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"height": 20,
				"id": "wo_remaining_amount",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "center",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "wo_remaining_amount",
				"type": "text",
				"width": 23.10021629416006,
				"x": 504.1622206200433,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"height": 20,
				"id": "wo_failed_amount",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "center",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "wo_failed_amount",
				"type": "text",
				"width": 23.10021629416006,
				"x": 527.2624369142034,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"format": ["%'.0f"],
				"formula": [
					"+",
					"qry_material_self_cost_por_calculated",
					"calc_material_self_cost_wme"
				],
				"height": 20,
				"id": "calc_material_self_cost",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "right",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "calc_material_self_cost",
				"type": "text",
				"width": 40.4253785147801,
				"x": 550.3626532083634,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"format": ["%'.0f"],
				"formula": ["+", "qry_subcontract_self_cost_calculated"],
				"height": 20,
				"id": "calc_subcontract_self_cost",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "right",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "calc_subcontract_self_cost",
				"type": "text",
				"width": 40.4253785147801,
				"x": 590.7880317231435,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"format": ["%'.0f"],
				"formula": ["+", "qry_work_self_cost_calculated"],
				"height": 20,
				"id": "calc_work_self_cost",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "right",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "calc_work_self_cost",
				"type": "text",
				"width": 40.4253785147801,
				"x": 631.2134102379237,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"format": ["%'.0f"],
				"formula": ["*", "self_cost_sum", "reduced_self_cost_multiplier", "-1"],
				"height": 20,
				"id": "reduced_self_cost",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "right",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "reduced_self_cost",
				"type": "text",
				"width": 25.987743330930066,
				"x": 671.6387887527037,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"format": ["%'.0f"],
				"formula": ["*", "self_cost_sum", "self_cost_multiplier"],
				"height": 20,
				"id": "calc_self_cost",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "right",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "calc_self_cost",
				"type": "text",
				"width": 38.6928622927181,
				"x": 697.6265320836337,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"format": ["%'.0f"],
				"formula": ["*", "wo_remaining_amount", "wo_sales_price__unit"],
				"height": 20,
				"id": "calc_sales_price",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "right",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "calc_sales_price",
				"type": "text",
				"width": 38.6928622927181,
				"x": 736.3193943763519,
				"y": 56,
				"y_offset": 56
			},
			{
				"fit_text": "width",
				"format": ["%.f%%"],
				"formula": [["/", "calc_self_cost", "calc_sales_price"], ["*", "100"]],
				"height": 20,
				"id": "calc_profit_percent",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "right",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 20
				},
				"text": "calc_profit_percent",
				"type": "text",
				"width": 25.987743330930066,
				"x": 775.01225666907,
				"y": 56,
				"y_offset": 56
			}
		],
		"row_header": [
			{
				"height": 16,
				"id": "rowNumber_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "Rivi",
				"type": "text",
				"width": 17.325162220620044,
				"x": 0,
				"y": 40
			},
			{
				"height": 16,
				"id": "wo_company_id_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "Asiakas",
				"type": "text",
				"width": 46.20043258832012,
				"x": 17.325162220620044,
				"y": 40
			},
			{
				"height": 16,
				"id": "pr_product_group_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "Tuoteryhmä",
				"type": "text",
				"width": 51.97548666186013,
				"x": 63.52559480894016,
				"y": 40
			},
			{
				"height": 16,
				"id": "wo_drawing_number_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "Piirustusnumero",
				"type": "text",
				"width": 72.18817591925018,
				"x": 115.50108147080029,
				"y": 40
			},
			{
				"height": 16,
				"id": "pr_name_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "Nimi",
				"type": "text",
				"width": 127.05118961788033,
				"x": 187.68925739005047,
				"y": 40
			},
			{
				"height": 16,
				"id": "wo_production_lot_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "Valm. erä",
				"type": "text",
				"width": 40.4253785147801,
				"x": 314.7404470079308,
				"y": 40
			},
			{
				"height": 16,
				"id": "wo_state_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "Tila",
				"type": "text",
				"width": 14.437635183850036,
				"x": 355.1658255227109,
				"y": 40
			},
			{
				"height": 16,
				"id": "wo_creation_date_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "Luontipäivä",
				"type": "text",
				"width": 36.960346070656094,
				"x": 369.60346070656095,
				"y": 40
			},
			{
				"height": 16,
				"id": "wo_material_act_arrival_date_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "RA tot. tulo",
				"type": "text",
				"width": 36.960346070656094,
				"x": 406.56380677721705,
				"y": 40
			},
			{
				"height": 16,
				"id": "pr_production_control_type_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "center",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "T/V",
				"type": "text",
				"width": 14.437635183850036,
				"x": 443.5241528478731,
				"y": 40
			},
			{
				"height": 16,
				"id": "wo_started_amount_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "center",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "Al.",
				"type": "text",
				"width": 23.10021629416006,
				"x": 457.9617880317232,
				"y": 40
			},
			{
				"height": 16,
				"id": "wo_produced_amount_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "center",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "Val.",
				"type": "text",
				"width": 23.10021629416006,
				"x": 481.0620043258832,
				"y": 40
			},
			{
				"height": 16,
				"id": "wo_remaining_amount_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "center",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "Jäl.",
				"type": "text",
				"width": 23.10021629416006,
				"x": 504.1622206200433,
				"y": 40
			},
			{
				"height": 16,
				"id": "wo_failed_amount_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "center",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "Hyl.",
				"type": "text",
				"width": 23.10021629416006,
				"x": 527.2624369142034,
				"y": 40
			},
			{
				"height": 16,
				"id": "calc_material_self_cost_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "right",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "Mat. OK",
				"type": "text",
				"width": 40.4253785147801,
				"x": 550.3626532083634,
				"y": 40
			},
			{
				"height": 16,
				"id": "calc_subcontract_self_cost_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "right",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "Alih. OK",
				"type": "text",
				"width": 40.4253785147801,
				"x": 590.7880317231435,
				"y": 40
			},
			{
				"height": 16,
				"id": "calc_work_self_cost_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "right",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "Työ. OK",
				"type": "text",
				"width": 40.4253785147801,
				"x": 631.2134102379237,
				"y": 40
			},
			{
				"height": 16,
				"id": "reduced_self_cost_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "right",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "Väh.",
				"type": "text",
				"width": 25.987743330930066,
				"x": 671.6387887527037,
				"y": 40
			},
			{
				"height": 16,
				"id": "calc_self_cost_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "right",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "OK yht.",
				"type": "text",
				"width": 38.6928622927181,
				"x": 697.6265320836337,
				"y": 40
			},
			{
				"height": 16,
				"id": "calc_sales_price_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "right",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "MH",
				"type": "text",
				"width": 38.6928622927181,
				"x": 736.3193943763519,
				"y": 40
			},
			{
				"height": 16,
				"id": "calc_profit_percent_hdr",
				"style": {
					"fit_text": "width",
					"font_name": "sans-serif",
					"font_size": 7,
					"horizontal_align": "right",
					"margin": {
						"right": 2,
						"top": 2
					},
					"row_height": 16
				},
				"text": "%",
				"type": "text",
				"width": 25.987743330930066,
				"x": 775.01225666907,
				"y": 40
			}
		],
		"row_line": {
			"id": "row_line",
			"style": {
				"stroke_color": "black",
				"stroke_width": 0.25
			},
			"type": "line",
			"x": 0,
			"x2": 801,
			"y": 56,
			"y2": 56
		}
	},
	"data": {
		"report": [
			{
				"wo": [
					{
						"calc_material_self_cost_wme": 0,
						"pr_name": "FMS testi 101302F",
						"pr_product_group": "",
						"pr_product_id": "101302 F",
						"pr_production_control_type": 0,
						"pr_stock_balance__unit": 0,
						"qry_material_self_cost_por": 0,
						"qry_material_self_cost_por_calculated": 0,
						"qry_material_self_cost_wme__unit": 0,
						"qry_subcontract_self_cost": 0,
						"qry_subcontract_self_cost_calculated": 0,
						"qry_work_self_cost": 128.55,
						"qry_work_self_cost_calculated": 128.55,
						"reduced_self_cost": 0,
						"reduced_self_cost_multiplier": 0,
						"remaining_price_multiplier": 1,
						"self_cost_multiplier": 1,
						"self_cost_sum": 0,
						"wo_company_id": "MANAGE",
						"wo_creation_date": "2018-08-07",
						"wo_drawing_number": "FMS testi",
						"wo_failed_amount": 0,
						"wo_material_act_arrival_date": "0000-00-00",
						"wo_produced_amount": 0,
						"wo_production_lot": "03625/14",
						"wo_remaining_amount": 4,
						"wo_row_number": 1,
						"wo_sales_price__unit": 0,
						"wo_started_amount": 4,
						"wo_state": "AL",
						"wo_work__position_num_id": "03625"
					},
					{
						"calc_material_self_cost_wme": 0,
						"pr_name": "FMS testi 101302F",
						"pr_product_group": "",
						"pr_product_id": "101302 F",
						"pr_production_control_type": 0,
						"pr_stock_balance__unit": 0,
						"qry_material_self_cost_por": 0,
						"qry_material_self_cost_por_calculated": 0,
						"qry_material_self_cost_wme__unit": 0,
						"qry_subcontract_self_cost": 0,
						"qry_subcontract_self_cost_calculated": 0,
						"qry_work_self_cost": 24,
						"qry_work_self_cost_calculated": 24,
						"reduced_self_cost": 0,
						"reduced_self_cost_multiplier": 0,
						"remaining_price_multiplier": 1,
						"self_cost_multiplier": 1,
						"self_cost_sum": 0,
						"wo_company_id": "MANAGE",
						"wo_creation_date": "2018-08-07",
						"wo_drawing_number": "FMS testi",
						"wo_failed_amount": 0,
						"wo_material_act_arrival_date": "0000-00-00",
						"wo_produced_amount": 0,
						"wo_production_lot": "03625/15",
						"wo_remaining_amount": 5,
						"wo_row_number": 2,
						"wo_sales_price__unit": 0,
						"wo_started_amount": 5,
						"wo_state": "AL",
						"wo_work__position_num_id": "03625"
					},
					{
						"calc_material_self_cost_wme": 0,
						"pr_name": "Konenäytön testityö",
						"pr_product_group": "",
						"pr_product_id": "KONENÄYTTÖ",
						"pr_production_control_type": 0,
						"pr_stock_balance__unit": 0,
						"qry_material_self_cost_por": 0,
						"qry_material_self_cost_por_calculated": 0,
						"qry_material_self_cost_wme__unit": 0,
						"qry_subcontract_self_cost": 0,
						"qry_subcontract_self_cost_calculated": 0,
						"qry_work_self_cost": 663.9720000000001,
						"qry_work_self_cost_calculated": 663.9720000000001,
						"reduced_self_cost": 0,
						"reduced_self_cost_multiplier": 0,
						"remaining_price_multiplier": 1,
						"self_cost_multiplier": 1,
						"self_cost_sum": 0,
						"wo_company_id": "KONEEN-VALO",
						"wo_creation_date": "2017-12-14",
						"wo_drawing_number": "B23321",
						"wo_failed_amount": 0,
						"wo_material_act_arrival_date": "0000-00-00",
						"wo_produced_amount": 0,
						"wo_production_lot": "14937/01",
						"wo_remaining_amount": 5,
						"wo_row_number": 1,
						"wo_sales_price__unit": 235,
						"wo_started_amount": 5,
						"wo_state": "KU",
						"wo_work__position_num_id": "14937"
					},
					{
						"calc_material_self_cost_wme": 0,
						"pr_name": "Konenäytön testityö",
						"pr_product_group": "",
						"pr_product_id": "KONENÄYTTÖ",
						"pr_production_control_type": 0,
						"pr_stock_balance__unit": 0,
						"qry_material_self_cost_por": 0,
						"qry_material_self_cost_por_calculated": 0,
						"qry_material_self_cost_wme__unit": 0,
						"qry_subcontract_self_cost": 165,
						"qry_subcontract_self_cost_calculated": 165,
						"qry_work_self_cost": 0,
						"qry_work_self_cost_calculated": 0,
						"reduced_self_cost": 0,
						"reduced_self_cost_multiplier": 0,
						"remaining_price_multiplier": 1,
						"self_cost_multiplier": 1,
						"self_cost_sum": 0,
						"wo_company_id": "KONEEN-VALO",
						"wo_creation_date": "2017-12-22",
						"wo_drawing_number": "B23321",
						"wo_failed_amount": 0,
						"wo_material_act_arrival_date": "0000-00-00",
						"wo_produced_amount": 0,
						"wo_production_lot": "14937/02",
						"wo_remaining_amount": 15,
						"wo_row_number": 2,
						"wo_sales_price__unit": 235,
						"wo_started_amount": 15,
						"wo_state": "AL",
						"wo_work__position_num_id": "14937"
					},
					{
						"calc_material_self_cost_wme": 20,
						"pr_name": "Mikroauton pohja ",
						"pr_product_group": "MA",
						"pr_product_id": "MA POHJA",
						"pr_production_control_type": 1,
						"pr_stock_balance__unit": 11,
						"qry_material_self_cost_por": 2400,
						"qry_material_self_cost_por_calculated": 1714.2857142857142,
						"qry_material_self_cost_wme__unit": 4,
						"qry_subcontract_self_cost": 0,
						"qry_subcontract_self_cost_calculated": 0,
						"qry_work_self_cost": 190.59,
						"qry_work_self_cost_calculated": 136.1357142857143,
						"reduced_self_cost": 0,
						"reduced_self_cost_multiplier": 0,
						"remaining_price_multiplier": 0.7142857142857143,
						"self_cost_multiplier": 1,
						"self_cost_sum": 0,
						"wo_company_id": "MANAGE",
						"wo_creation_date": "2017-10-17",
						"wo_drawing_number": "123",
						"wo_failed_amount": 2,
						"wo_material_act_arrival_date": "2018-06-30",
						"wo_produced_amount": 0,
						"wo_production_lot": "02056/77",
						"wo_remaining_amount": 5,
						"wo_row_number": 77,
						"wo_sales_price__unit": 244.2449799,
						"wo_started_amount": 5,
						"wo_state": "AL",
						"wo_work__position_num_id": "02056"
					},
					{
						"calc_material_self_cost_wme": 208,
						"pr_name": "Mikroauton taka-akseli",
						"pr_product_group": "MA",
						"pr_product_id": "MA AKSELI TAKA",
						"pr_production_control_type": 0,
						"pr_stock_balance__unit": 5,
						"qry_material_self_cost_por": 0,
						"qry_material_self_cost_por_calculated": 0,
						"qry_material_self_cost_wme__unit": 13,
						"qry_subcontract_self_cost": 0,
						"qry_subcontract_self_cost_calculated": 0,
						"qry_work_self_cost": 0.850372,
						"qry_work_self_cost_calculated": 0.6802976000000001,
						"reduced_self_cost": 0,
						"reduced_self_cost_multiplier": 0,
						"remaining_price_multiplier": 0.8,
						"self_cost_multiplier": 1,
						"self_cost_sum": 0,
						"wo_company_id": "HKI RAUTA",
						"wo_creation_date": "2018-05-11",
						"wo_drawing_number": "P1232",
						"wo_failed_amount": 0,
						"wo_material_act_arrival_date": "0000-00-00",
						"wo_produced_amount": 4,
						"wo_production_lot": "02058/04",
						"wo_remaining_amount": 16,
						"wo_row_number": 4,
						"wo_sales_price__unit": 285.5739601,
						"wo_started_amount": 20,
						"wo_state": "AL",
						"wo_work__position_num_id": "02058"
					},
					{
						"calc_material_self_cost_wme": 0,
						"pr_name": "Mikroauton poljin",
						"pr_product_group": "MA",
						"pr_product_id": "MA POLJIN",
						"pr_production_control_type": 0,
						"pr_stock_balance__unit": 106,
						"qry_material_self_cost_por": 0,
						"qry_material_self_cost_por_calculated": 0,
						"qry_material_self_cost_wme__unit": 0,
						"qry_subcontract_self_cost": 0,
						"qry_subcontract_self_cost_calculated": 0,
						"qry_work_self_cost": 7.558659999999997,
						"qry_work_self_cost_calculated": 7.558659999999997,
						"reduced_self_cost": 0,
						"reduced_self_cost_multiplier": 0,
						"remaining_price_multiplier": 1,
						"self_cost_multiplier": 1,
						"self_cost_sum": 0,
						"wo_company_id": "PUUPÄÄ",
						"wo_creation_date": "2017-11-06",
						"wo_drawing_number": "",
						"wo_failed_amount": 0,
						"wo_material_act_arrival_date": "0000-00-00",
						"wo_produced_amount": 0,
						"wo_production_lot": "02061/07",
						"wo_remaining_amount": 620,
						"wo_row_number": 7,
						"wo_sales_price__unit": 48.743024000000005,
						"wo_started_amount": 8,
						"wo_state": "KU",
						"wo_work__position_num_id": "02061"
					},
					{
						"calc_material_self_cost_wme": 0,
						"pr_name": "Mikroauton poljin",
						"pr_product_group": "MA",
						"pr_product_id": "MA POLJIN",
						"pr_production_control_type": 0,
						"pr_stock_balance__unit": 106,
						"qry_material_self_cost_por": 0,
						"qry_material_self_cost_por_calculated": 0,
						"qry_material_self_cost_wme__unit": 0,
						"qry_subcontract_self_cost": 0,
						"qry_subcontract_self_cost_calculated": 0,
						"qry_work_self_cost": 18.431120000000004,
						"qry_work_self_cost_calculated": 18.431120000000004,
						"reduced_self_cost": 0,
						"reduced_self_cost_multiplier": 0,
						"remaining_price_multiplier": 1,
						"self_cost_multiplier": 1,
						"self_cost_sum": 0,
						"wo_company_id": "HKI RAUTA",
						"wo_creation_date": "2018-05-11",
						"wo_drawing_number": "",
						"wo_failed_amount": 0,
						"wo_material_act_arrival_date": "0000-00-00",
						"wo_produced_amount": 0,
						"wo_production_lot": "02061/08",
						"wo_remaining_amount": 60,
						"wo_row_number": 8,
						"wo_sales_price__unit": 48.743024000000005,
						"wo_started_amount": 60,
						"wo_state": "KU",
						"wo_work__position_num_id": "02061"
					},
					{
						"calc_material_self_cost_wme": 0,
						"pr_name": "Mikroauton putkirunko",
						"pr_product_group": "MA",
						"pr_product_id": "MA RUNKO",
						"pr_production_control_type": 0,
						"pr_stock_balance__unit": 16,
						"qry_material_self_cost_por": 0,
						"qry_material_self_cost_por_calculated": 0,
						"qry_material_self_cost_wme__unit": 0,
						"qry_subcontract_self_cost": 0,
						"qry_subcontract_self_cost_calculated": 0,
						"qry_work_self_cost": 25.5,
						"qry_work_self_cost_calculated": 25.5,
						"reduced_self_cost": 0,
						"reduced_self_cost_multiplier": 0,
						"remaining_price_multiplier": 1,
						"self_cost_multiplier": 1,
						"self_cost_sum": 0,
						"wo_company_id": "PERFECTA",
						"wo_creation_date": "2018-05-11",
						"wo_drawing_number": "B23321",
						"wo_failed_amount": 0,
						"wo_material_act_arrival_date": "0000-00-00",
						"wo_produced_amount": 0,
						"wo_production_lot": "02062/48",
						"wo_remaining_amount": 20,
						"wo_row_number": 48,
						"wo_sales_price__unit": 250,
						"wo_started_amount": 20,
						"wo_state": "KU",
						"wo_work__position_num_id": "02062"
					},
					{
						"calc_material_self_cost_wme": 5120,
						"pr_name": "Mikroauton putkirunko 2",
						"pr_product_group": "MA",
						"pr_product_id": "MA RUNKO-2",
						"pr_production_control_type": 0,
						"pr_stock_balance__unit": 0,
						"qry_material_self_cost_por": 23,
						"qry_material_self_cost_por_calculated": 23,
						"qry_material_self_cost_wme__unit": 32,
						"qry_subcontract_self_cost": 0,
						"qry_subcontract_self_cost_calculated": 0,
						"qry_work_self_cost": 1.8429999999999993,
						"qry_work_self_cost_calculated": 1.8429999999999993,
						"reduced_self_cost": 0,
						"reduced_self_cost_multiplier": 0,
						"remaining_price_multiplier": 1,
						"self_cost_multiplier": 1,
						"self_cost_sum": 0,
						"wo_company_id": "ELSOINTU",
						"wo_creation_date": "2018-05-20",
						"wo_drawing_number": "B23321",
						"wo_failed_amount": 0,
						"wo_material_act_arrival_date": "2018-06-21",
						"wo_produced_amount": 0,
						"wo_production_lot": "08071/13",
						"wo_remaining_amount": 160,
						"wo_row_number": 13,
						"wo_sales_price__unit": 508.9454719,
						"wo_started_amount": 10,
						"wo_state": "PY",
						"wo_work__position_num_id": "08071"
					},
					{
						"calc_material_self_cost_wme": 0,
						"pr_name": "Rear axle",
						"pr_product_group": "PRODR",
						"pr_product_id": "PRODR REAR AXLE",
						"pr_production_control_type": 0,
						"pr_stock_balance__unit": 0,
						"qry_material_self_cost_por": 0,
						"qry_material_self_cost_por_calculated": 0,
						"qry_material_self_cost_wme__unit": 0,
						"qry_subcontract_self_cost": 0,
						"qry_subcontract_self_cost_calculated": 0,
						"qry_work_self_cost": 839.25,
						"qry_work_self_cost_calculated": 839.25,
						"reduced_self_cost": 0,
						"reduced_self_cost_multiplier": 0,
						"remaining_price_multiplier": 1,
						"self_cost_multiplier": 1,
						"self_cost_sum": 0,
						"wo_company_id": "ELSOINTU",
						"wo_creation_date": "2018-06-11",
						"wo_drawing_number": "A20182",
						"wo_failed_amount": 0,
						"wo_material_act_arrival_date": "0000-00-00",
						"wo_produced_amount": 0,
						"wo_production_lot": "16276/01",
						"wo_remaining_amount": 10,
						"wo_row_number": 1,
						"wo_sales_price__unit": 408.5895344,
						"wo_started_amount": 10,
						"wo_state": "AL",
						"wo_work__position_num_id": "16276"
					},
					{
						"calc_material_self_cost_wme": 0,
						"pr_name": "Rear axle",
						"pr_product_group": "PRODR",
						"pr_product_id": "PRODR REAR AXLE",
						"pr_production_control_type": 0,
						"pr_stock_balance__unit": 0,
						"qry_material_self_cost_por": 0,
						"qry_material_self_cost_por_calculated": 0,
						"qry_material_self_cost_wme__unit": 0,
						"qry_subcontract_self_cost": 0,
						"qry_subcontract_self_cost_calculated": 0,
						"qry_work_self_cost": 575,
						"qry_work_self_cost_calculated": 372.05882352941177,
						"reduced_self_cost": 0,
						"reduced_self_cost_multiplier": 0,
						"remaining_price_multiplier": 0.6470588235294118,
						"self_cost_multiplier": 1,
						"self_cost_sum": 0,
						"wo_company_id": "KEUKING",
						"wo_creation_date": "2018-06-11",
						"wo_drawing_number": "A20182",
						"wo_failed_amount": 6,
						"wo_material_act_arrival_date": "0000-00-00",
						"wo_produced_amount": 0,
						"wo_production_lot": "16276/02",
						"wo_remaining_amount": 11,
						"wo_row_number": 2,
						"wo_sales_price__unit": 408.5895344,
						"wo_started_amount": 15,
						"wo_state": "AL",
						"wo_work__position_num_id": "16276"
					},
					{
						"calc_material_self_cost_wme": 0,
						"pr_name": "Control arm",
						"pr_product_group": "PRODR",
						"pr_product_id": "PRODR CONTROL ARM",
						"pr_production_control_type": 0,
						"pr_stock_balance__unit": 0,
						"qry_material_self_cost_por": 0,
						"qry_material_self_cost_por_calculated": 0,
						"qry_material_self_cost_wme__unit": 0,
						"qry_subcontract_self_cost": 0,
						"qry_subcontract_self_cost_calculated": 0,
						"qry_work_self_cost": 695,
						"qry_work_self_cost_calculated": 695,
						"reduced_self_cost": 0,
						"reduced_self_cost_multiplier": 0,
						"remaining_price_multiplier": 1,
						"self_cost_multiplier": 1,
						"self_cost_sum": 0,
						"wo_company_id": "ELSOINTU",
						"wo_creation_date": "2018-06-11",
						"wo_drawing_number": "B23321",
						"wo_failed_amount": 0,
						"wo_material_act_arrival_date": "0000-00-00",
						"wo_produced_amount": 0,
						"wo_production_lot": "16277/01",
						"wo_remaining_amount": 20,
						"wo_row_number": 1,
						"wo_sales_price__unit": 56.569611,
						"wo_started_amount": 20,
						"wo_state": "AL",
						"wo_work__position_num_id": "16277"
					}
				]
			}
		]
	},
	"document_type": "pdf",
	"file_name": "work_in_progress_cost.pdf",
	"language": [],
	"main_table": "report",
	"null_allowed": [
		"qry_work_self_cost",
		"qry_material_self_cost_por",
		"qry_material_self_cost_wme__unit",
		"qry_subcontract_self_cost"
	],
	"paper": {
		"border_bottom": 20,
		"border_left": 20,
		"border_right": 20,
		"border_top": 20,
		"bottom": 575.26,
		"docType": "pdf",
		"dpi": 72,
		"full_height": 595.26,
		"full_width": 841.8599999999999,
		"height": 555.26,
		"left": 20,
		"paperType": "A4 landscape",
		"right": 821.8599999999999,
		"top": 20,
		"width": 801.8599999999999
	},
	"print": [],
	"row": [
		{
			"ZZsort_field": [["pr_product_group", ">"], ["wo_production_lot", ">"]],
			"bottom": "por_unit_total_hdr",
			"height": 14,
			"top": "por_row_number"
		}
	],
	"row_table": ["wo"],
	"style": {
		"bold_text": {
			"font_name": "sans-serif",
			"font_size": 7,
			"font_weight": "bold"
		},
		"default_line": {
			"stroke_color": "black",
			"stroke_width": 0.25
		},
		"default_pict": {
			"Xvertical_align": "middle",
			"margin": {
				"bottom": 2,
				"left": 2,
				"right": 2,
				"top": 2
			},
			"scaling": "fit",
			"stroke_width": 3
		},
		"default_rect": {
			"stroke_color": "black",
			"stroke_width": 0.5
		},
		"default_text": {
			"font_name": "sans-serif",
			"font_size": 7
		},
		"info_header": {
			"font_name": "sans-serif",
			"font_size": 12,
			"font_weight": "bold"
		},
		"report_address": {
			"font_name": "sans-serif",
			"font_size": 12,
			"font_weight": "bold"
		},
		"report_billing_address": {
			"font_name": "sans-serif",
			"font_size": 11,
			"horizontal_align": "right"
		},
		"report_footer": {
			"font_name": "sans-serif",
			"font_size": 7
		},
		"report_header_middle": {
			"font_name": "sans-serif",
			"font_size": 16,
			"horizontal_align": "center",
			"margin": {
				"top": 0
			},
			"vertical_align": "middle"
		},
		"report_header_right": {
			"font_name": "sans-serif",
			"font_size": 7,
			"horizontal_align": "right",
			"margin": {
				"top": 0
			}
		},
		"report_info_label": {
			"font_name": "sans-serif",
			"font_size": 12,
			"font_weight": "bold"
		},
		"report_order_number": {
			"font_name": "sans-serif",
			"font_size": 12,
			"font_weight": "bold"
		},
		"report_subtotal": {
			"font_name": "sans-serif",
			"font_size": 11,
			"horizontal_align": "right"
		},
		"report_subtotal_bold": {
			"font_name": "sans-serif",
			"font_size": 11,
			"font_weight": "bold",
			"horizontal_align": "right"
		},
		"report_total": {
			"font_name": "sans-serif",
			"font_size": 11,
			"horizontal_align": "right"
		},
		"report_total_bold": {
			"font_name": "sans-serif",
			"font_size": 11,
			"font_weight": "bold",
			"horizontal_align": "right"
		},
		"row_data": {
			"font_name": "sans-serif",
			"font_size": 7,
			"margin": {
				"right": 2,
				"top": 2
			},
			"row_height": 20
		},
		"row_data_number": {
			"font_name": "sans-serif",
			"font_size": 7,
			"horizontal_align": "right",
			"margin": {
				"right": 2,
				"top": 2
			},
			"row_height": 20
		},
		"row_header": {
			"font_name": "sans-serif",
			"font_size": 7,
			"margin": {
				"right": 2,
				"top": 2
			},
			"row_height": 16
		},
		"row_header_number": {
			"font_name": "sans-serif",
			"font_size": 7,
			"horizontal_align": "right",
			"margin": {
				"right": 2,
				"top": 2
			},
			"row_height": 20
		}
	},
	"subtotal": {
		"subtotal": [
			{
				"calculate": [
					["pr_product_group", ""],
					["calc_work_self_cost", "+"],
					["calc_material_self_cost", "+"],
					["calc_subcontract_self_cost", "+"],
					["calc_self_cost", "+"],
					["reduced_self_cost", "+"],
					["calc_sales_price", "+"],
					["calc_profit_percent", "formula"]
				],
				"field": "pr_product_group",
				"page_break": false
			}
		],
		"total": {
			"calculate": [
				["calc_work_self_cost", "+"],
				["calc_material_self_cost", "+"],
				["calc_subcontract_self_cost", "+"],
				["reduced_self_cost", "+"],
				["calc_self_cost", "+"],
				["calc_sales_price", "+"],
				["calc_profit_percent", "formula"]
			]
		}
	}
}
