{
	"row_table": ["sor"],
	"null_allowed": [],
	"grid": {
		"columns": [
			{
				"field_type": "string",
				"width": 83,
				"field_type_sql": "string",
				"field": "sor_product_id",
				"name": "Tuote",
				"footerValue": "/B1,==BreakValue"
			},
			{
				"headerBackColor": -2,
				"width": 30,
				"lineBackColor": -2,
				"field": "so_company_id",
				"lineForeColor": -2,
				"footerValue": "/O2",
				"field_type_sql": "string",
				"headerForeColor": -2,
				"name": "Tilaaja",
				"field_type": "string"
			},
			{
				"headerBackColor": -2,
				"width": 30,
				"lineBackColor": -2,
				"field": "so_order_date",
				"lineForeColor": -2,
				"field_type_sql": "date",
				"headerForeColor": -2,
				"name": "Tilauspv",
				"field_type": "string"
			},
			{
				"field_type": "string",
				"width": 83,
				"field_type_sql": "text",
				"field": "sor_explanation",
				"name": "Selitys"
			},
			{
				"field_type": "string",
				"width": 26,
				"field_type_sql": "string",
				"field": "sor_sales_order_id",
				"name": "Tilaus",
				"footerValue": "/O3"
			},
			{
				"headerBackColor": -2,
				"width": 32,
				"lineBackColor": -2,
				"field": "so_your_reference",
				"lineForeColor": -2,
				"field_type_sql": "string",
				"headerForeColor": -2,
				"name": "As.viite",
				"field_type": "string"
			},
			{
				"field_type": "number",
				"width": 12,
				"field_type_sql": "integer",
				"field": "sor_row_number",
				"style": {
					"font_name": "sans-serif",
					"format": ["%'.2f"],
					"horizontal_align": "right",
					"font_size": 8,
					"row_height": 12,
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"name": "Rivi",
				"footerValue": "/O4"
			},
			{
				"field_type": "number",
				"width": 12,
				"field_type_sql": "integer",
				"field": "sor_partial_delivery_number",
				"format_orig": "#0;;",
				"footerValue": "/O5",
				"style": {
					"font_name": "sans-serif",
					"format": ["%'.2f"],
					"horizontal_align": "right",
					"font_size": 8,
					"row_height": 12,
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"name": "Erä",
				"format": ["%'.0f"]
			},
			{
				"field_type": "string",
				"width": 12,
				"field_type_sql": "string",
				"field": "sor_customer_row_number",
				"name": "As.erä"
			},
			{
				"field_type": "number",
				"width": 30,
				"field_type_sql": "real",
				"field": "sor_ordered_amount",
				"format_orig": "### ##0,##",
				"footerValue": "=[10]*(_rep_UniqueValue([5]+String([7])))===Sum",
				"style": {
					"font_name": "sans-serif",
					"format": ["%'.2f"],
					"horizontal_align": "right",
					"font_size": 8,
					"row_height": 12,
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"formula": [],
				"name": "Tilattu",
				"format": ["%'.2f"]
			},
			{
				"field_type": "number",
				"width": 30,
				"field_type_sql": "real",
				"field": "sor_delivered_quantity",
				"format_orig": "### ##0,##",
				"footerValue": "==Sum",
				"style": {
					"font_name": "sans-serif",
					"format": ["%'.2f"],
					"horizontal_align": "right",
					"font_size": 8,
					"row_height": 12,
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"formula": [],
				"name": "Toimitettu",
				"format": ["%'.2f"]
			},
			{
				"field_type": "number",
				"width": 30,
				"field_type_sql": "real",
				"field": "sor_waiting_for_delivery",
				"format_orig": "### ##0,##",
				"footerValue": "==Sum",
				"style": {
					"font_name": "sans-serif",
					"format": ["%'.2f"],
					"horizontal_align": "right",
					"font_size": 8,
					"row_height": 12,
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"formula": [],
				"name": "Jäljellä mrä",
				"format": ["%'.2f"]
			},
			{
				"field_type": "string",
				"width": 12,
				"field_type_sql": "string",
				"field": "sor_delivery_state",
				"name": "Tila"
			},
			{
				"field_type": "string",
				"width": 30,
				"field_type_sql": "date",
				"field": "sor_delivered_date",
				"name": "Toim.pv"
			},
			{
				"headerBackColor": -2,
				"width": 51,
				"lineBackColor": -2,
				"field": "pr_size",
				"lineForeColor": -2,
				"field_type_sql": "string",
				"headerForeColor": -2,
				"name": "Koko",
				"field_type": "string"
			},
			{
				"field_type": "number",
				"width": 30,
				"style": {
					"font_name": "sans-serif",
					"format": ["%'.2f"],
					"horizontal_align": "right",
					"font_size": 8,
					"row_height": 12,
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"field_type_sql": "real",
				"field": "sor_commission",
				"formula": [],
				"name": "Komissio",
				"footerValue": "=num([15])/100*[17]===Sum"
			},
			{
				"field_type": "number",
				"width": 44,
				"style": {
					"font_name": "sans-serif",
					"format": ["%'.2f"],
					"horizontal_align": "right",
					"font_size": 8,
					"row_height": 12,
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"field_type_sql": "real",
				"field": "sor_sales_price_total",
				"formula": [],
				"name": "Myyntihinta mrä",
				"footerValue": "==Sum"
			}
		],
		"calculate": [],
		"null_allowed": [],
		"subtotal": ["sor_product_id"]
	},
	"print": [],
	"document_type": "pdf",
	"style": {
		"total_line": {
			"stroke_color": "black",
			"stroke_color_test": {
				"r": 0.25,
				"b": 0.25,
				"a": 1,
				"g": 0.25
			},
			"stroke_width": 0.25
		},
		"report_total": {
			"font_name": "sans-serif",
			"horizontal_align": "right",
			"font_size": 11
		},
		"row_header_number": {
			"font_name": "sans-serif",
			"row_height": 12,
			"horizontal_align": "right",
			"font_size": 8,
			"margin": {
				"right": 2,
				"top": 2
			}
		},
		"default_line": {
			"stroke_color": "black",
			"stroke_width": 0.25
		},
		"report_subtotal_bold": {
			"font_name": "sans-serif",
			"font_size": 11,
			"horizontal_align": "right",
			"font_weight": "bold"
		},
		"subtotal_line": {
			"stroke_color": {
				"r": 0.5,
				"b": 0.5,
				"a": 0.5,
				"g": 0.5
			},
			"stroke_width": 0.25
		},
		"default_rect": {
			"stroke_color": "black",
			"stroke_width": 0.5
		},
		"info_header": {
			"font_name": "sans-serif",
			"font_size": 12,
			"font_weight": "bold"
		},
		"report_info_label": {
			"font_name": "sans-serif",
			"font_weight": "bold",
			"font_size": 12
		},
		"report_total_bold": {
			"font_name": "sans-serif",
			"font_size": 11,
			"horizontal_align": "right",
			"font_weight": "bold"
		},
		"report_header_middle": {
			"font_name": "sans-serif",
			"horizontal_align": "center",
			"font_size": 16,
			"margin": {
				"top": 0
			},
			"vertical_align": "middle"
		},
		"report_header_right": {
			"font_name": "sans-serif",
			"font_size": 8,
			"horizontal_align": "right",
			"margin": {
				"top": 0
			}
		},
		"default_pict": {
			"margin": {
				"right": 2,
				"left": 2,
				"bottom": 2,
				"top": 2
			},
			"scaling": "fit",
			"stroke_width": 3
		},
		"default_text": {
			"font_name": "sans-serif",
			"font_size": 8
		},
		"date_format": "%d.%m.%y",
		"row_data": {
			"font_name": "sans-serif",
			"row_height": 12,
			"font_size": 8,
			"margin": {
				"right": 2,
				"top": 2
			}
		},
		"bold_text": {
			"font_name": "sans-serif",
			"font_size": 8,
			"font_weight": "bold"
		},
		"report_footer": {
			"font_name": "sans-serif",
			"font_size": 8
		},
		"report_billing_address": {
			"font_name": "sans-serif",
			"horizontal_align": "right",
			"font_size": 11
		},
		"report_subtotal": {
			"font_name": "sans-serif",
			"horizontal_align": "right",
			"font_size": 11
		},
		"row_data_number": {
			"font_name": "sans-serif",
			"format": ["%'.2f"],
			"horizontal_align": "right",
			"font_size": 8,
			"row_height": 12,
			"margin": {
				"right": 2,
				"top": 2
			}
		},
		"row_header": {
			"font_name": "sans-serif",
			"row_height": 15,
			"margin": {
				"right": 2,
				"top": 2
			},
			"font_size": 8
		},
		"report_order_number": {
			"font_name": "sans-serif",
			"font_weight": "bold",
			"font_size": 12
		},
		"name": "preference/report/style/default_style.json",
		"report_address": {
			"font_name": "sans-serif",
			"font_weight": "bold",
			"font_size": 12
		}
	},
	"table": ["sor"],
	"file_name": "Toimitetut tuotteittain.pdf",
	"content": {
		"row_line": {
			"x2": 801,
			"x": 0,
			"id": "row_line",
			"type": "line",
			"y2": 55,
			"style": {
				"stroke_color": "black",
				"stroke_width": 0.25
			},
			"y": 55
		},
		"page_break": 545,
		"header": [
			[
				{
					"style": {
						"margin": {
							"right": 2,
							"left": 2,
							"bottom": 2,
							"top": 2
						},
						"scaling": "fit",
						"stroke_width": 3
					},
					"x": 0,
					"source": "preference/report/nomet_logo.png",
					"id": "logo",
					"type": "pict",
					"width": 121,
					"height": 30,
					"y": 0
				}
			],
			[
				{
					"style": {
						"font_name": "sans-serif",
						"horizontal_align": "center",
						"font_size": 16,
						"margin": {
							"top": 0
						},
						"vertical_align": "middle"
					},
					"width": 559,
					"y": 0,
					"id": "report_header_text",
					"type": "text",
					"x": 120.5,
					"height": 30,
					"text": "Toimitetut tuotteittain"
				}
			],
			[
				{
					"x": 680,
					"id": "pageNumber",
					"y": 0,
					"subtotal_operator": "",
					"style": {
						"font_name": "sans-serif",
						"font_size": 8,
						"horizontal_align": "right",
						"margin": {
							"top": 0
						}
					},
					"subtotal": "",
					"type": "text",
					"format": ["Sivu %d"],
					"height": 30,
					"width": 121
				},
				{
					"style": {
						"font_name": "sans-serif",
						"font_size": 8,
						"horizontal_align": "right",
						"margin": {
							"top": 0
						}
					},
					"x": 680,
					"formula": ["dt.currentFormat", "viikko %W - %d.%m.%Y"],
					"id": "report_header_right_date",
					"type": "text",
					"width": 121,
					"height": 30,
					"y": 12
				},
				{
					"style": {
						"font_name": "sans-serif",
						"font_size": 8,
						"horizontal_align": "right",
						"margin": {
							"top": 0
						}
					},
					"x": 680,
					"formula": ["dt.currentFormat", "%H:%M:%S"],
					"id": "report_header_right_time",
					"type": "text",
					"width": 121,
					"height": 30,
					"y": 24
				}
			],
			{
				"x2": 801,
				"x": 0,
				"id": "header_bottom_horizontal_line",
				"type": "line",
				"y2": 40,
				"style": {
					"stroke_color": "black",
					"stroke_width": 0.25
				},
				"y": 40
			}
		],
		"row_data": [
			{
				"y_offset": 55,
				"width": 115.22183708838822,
				"id": "sor_product_id",
				"y": 55,
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"font_size": 8,
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"text": "sor_product_id",
				"footerValue": "/B1,==BreakValue",
				"field_type_sql": "string",
				"type": "text",
				"field_type": "string",
				"height": 12,
				"x": 0
			},
			{
				"y_offset": 55,
				"width": 41.646447140381287,
				"field_type": "string",
				"id": "so_company_id",
				"y": 55,
				"lineForeColor": -2,
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"font_size": 8,
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"text": "so_company_id",
				"headerBackColor": -2,
				"field_type_sql": "string",
				"footerValue": "/O2",
				"lineBackColor": -2,
				"type": "text",
				"headerForeColor": -2,
				"height": 12,
				"x": 115.22183708838822
			},
			{
				"y_offset": 55,
				"width": 41.646447140381287,
				"id": "so_order_date",
				"y": 55,
				"lineForeColor": -2,
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"font_size": 8,
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"text": "so_order_date",
				"field_type": "string",
				"headerBackColor": -2,
				"field_type_sql": "date",
				"lineBackColor": -2,
				"type": "text",
				"headerForeColor": -2,
				"height": 12,
				"x": 156.8682842287695
			},
			{
				"y_offset": 55,
				"width": 115.22183708838822,
				"id": "sor_explanation",
				"y": 55,
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"font_size": 8,
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"text": "sor_explanation",
				"field_type_sql": "text",
				"type": "text",
				"field_type": "string",
				"height": 12,
				"x": 198.51473136915079
			},
			{
				"y_offset": 55,
				"width": 36.09358752166378,
				"id": "sor_sales_order_id",
				"y": 55,
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"font_size": 8,
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"text": "sor_sales_order_id",
				"footerValue": "/O3",
				"field_type_sql": "string",
				"type": "text",
				"field_type": "string",
				"height": 12,
				"x": 313.736568457539
			},
			{
				"y_offset": 55,
				"width": 44.422876949740039,
				"id": "so_your_reference",
				"y": 55,
				"lineForeColor": -2,
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"font_size": 8,
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"text": "so_your_reference",
				"field_type": "string",
				"headerBackColor": -2,
				"field_type_sql": "string",
				"lineBackColor": -2,
				"type": "text",
				"headerForeColor": -2,
				"height": 12,
				"x": 349.8301559792028
			},
			{
				"y_offset": 55,
				"width": 16.658578856152514,
				"id": "sor_row_number",
				"y": 55,
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"horizontal_align": "right",
					"font_size": 8,
					"format": ["%'.2f"],
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"text": "sor_row_number",
				"footerValue": "/O4",
				"field_type_sql": "integer",
				"type": "text",
				"field_type": "number",
				"height": 12,
				"x": 394.25303292894287
			},
			{
				"y_offset": 55,
				"width": 16.658578856152514,
				"id": "sor_partial_delivery_number",
				"y": 55,
				"format_orig": "#0;;",
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"horizontal_align": "right",
					"font_size": 8,
					"format": ["%'.2f"],
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"text": "sor_partial_delivery_number",
				"format": ["%'.0f"],
				"footerValue": "/O5",
				"field_type_sql": "integer",
				"type": "text",
				"field_type": "number",
				"height": 12,
				"x": 410.9116117850953
			},
			{
				"y_offset": 55,
				"width": 16.658578856152514,
				"id": "sor_customer_row_number",
				"y": 55,
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"font_size": 8,
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"text": "sor_customer_row_number",
				"field_type_sql": "string",
				"type": "text",
				"field_type": "string",
				"height": 12,
				"x": 427.57019064124787
			},
			{
				"y_offset": 55,
				"width": 41.646447140381287,
				"id": "sor_ordered_amount",
				"y": 55,
				"format_orig": "### ##0,##",
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"horizontal_align": "right",
					"font_size": 8,
					"format": ["%'.2f"],
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"text": "sor_ordered_amount",
				"format": ["%'.2f"],
				"formula": [],
				"footerValue": "=[10]*(_rep_UniqueValue([5]+String([7])))===Sum",
				"field_type_sql": "real",
				"type": "text",
				"field_type": "number",
				"height": 12,
				"x": 444.2287694974004
			},
			{
				"y_offset": 55,
				"width": 41.646447140381287,
				"id": "sor_delivered_quantity",
				"y": 55,
				"format_orig": "### ##0,##",
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"horizontal_align": "right",
					"font_size": 8,
					"format": ["%'.2f"],
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"text": "sor_delivered_quantity",
				"format": ["%'.2f"],
				"formula": [],
				"footerValue": "==Sum",
				"field_type_sql": "real",
				"type": "text",
				"field_type": "number",
				"height": 12,
				"x": 485.87521663778167
			},
			{
				"y_offset": 55,
				"width": 41.646447140381287,
				"id": "sor_waiting_for_delivery",
				"y": 55,
				"format_orig": "### ##0,##",
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"horizontal_align": "right",
					"font_size": 8,
					"format": ["%'.2f"],
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"text": "sor_waiting_for_delivery",
				"format": ["%'.2f"],
				"formula": [],
				"footerValue": "==Sum",
				"field_type_sql": "real",
				"type": "text",
				"field_type": "number",
				"height": 12,
				"x": 527.521663778163
			},
			{
				"y_offset": 55,
				"width": 16.658578856152514,
				"id": "sor_delivery_state",
				"y": 55,
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"font_size": 8,
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"text": "sor_delivery_state",
				"field_type_sql": "string",
				"type": "text",
				"field_type": "string",
				"height": 12,
				"x": 569.1681109185443
			},
			{
				"y_offset": 55,
				"width": 41.646447140381287,
				"id": "sor_delivered_date",
				"y": 55,
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"font_size": 8,
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"text": "sor_delivered_date",
				"field_type_sql": "date",
				"type": "text",
				"field_type": "string",
				"height": 12,
				"x": 585.8266897746968
			},
			{
				"y_offset": 55,
				"width": 70.79896013864819,
				"id": "pr_size",
				"y": 55,
				"lineForeColor": -2,
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"font_size": 8,
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"text": "pr_size",
				"field_type": "string",
				"headerBackColor": -2,
				"field_type_sql": "string",
				"lineBackColor": -2,
				"type": "text",
				"headerForeColor": -2,
				"height": 12,
				"x": 627.473136915078
			},
			{
				"y_offset": 55,
				"width": 41.646447140381287,
				"id": "sor_commission",
				"y": 55,
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"horizontal_align": "right",
					"font_size": 8,
					"format": ["%'.2f"],
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"text": "sor_commission",
				"footerValue": "=num([15])/100*[17]===Sum",
				"formula": [],
				"field_type_sql": "real",
				"type": "text",
				"field_type": "number",
				"height": 12,
				"x": 698.2720970537262
			},
			{
				"y_offset": 55,
				"width": 61.08145580589255,
				"id": "sor_sales_price_total",
				"y": 55,
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"horizontal_align": "right",
					"font_size": 8,
					"format": ["%'.2f"],
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"text": "sor_sales_price_total",
				"footerValue": "==Sum",
				"formula": [],
				"field_type_sql": "real",
				"type": "text",
				"field_type": "number",
				"height": 12,
				"x": 739.9185441941074
			}
		],
		"row_header": [
			{
				"style": {
					"font_name": "sans-serif",
					"row_height": 15,
					"margin": {
						"right": 2,
						"top": 2
					},
					"font_size": 8
				},
				"width": 115.22183708838822,
				"y": 40,
				"id": "sor_product_id_hdr",
				"type": "text",
				"x": 0,
				"height": 15,
				"text": "Tuote"
			},
			{
				"style": {
					"font_name": "sans-serif",
					"row_height": 15,
					"margin": {
						"right": 2,
						"top": 2
					},
					"font_size": 8
				},
				"width": 41.646447140381287,
				"y": 40,
				"id": "so_company_id_hdr",
				"type": "text",
				"x": 115.22183708838822,
				"height": 15,
				"text": "Tilaaja"
			},
			{
				"style": {
					"font_name": "sans-serif",
					"row_height": 15,
					"margin": {
						"right": 2,
						"top": 2
					},
					"font_size": 8
				},
				"width": 41.646447140381287,
				"y": 40,
				"id": "so_order_date_hdr",
				"type": "text",
				"x": 156.8682842287695,
				"height": 15,
				"text": "Tilauspv"
			},
			{
				"style": {
					"font_name": "sans-serif",
					"row_height": 15,
					"margin": {
						"right": 2,
						"top": 2
					},
					"font_size": 8
				},
				"width": 115.22183708838822,
				"y": 40,
				"id": "sor_explanation_hdr",
				"type": "text",
				"x": 198.51473136915079,
				"height": 15,
				"text": "Selitys"
			},
			{
				"style": {
					"font_name": "sans-serif",
					"row_height": 15,
					"margin": {
						"right": 2,
						"top": 2
					},
					"font_size": 8
				},
				"width": 36.09358752166378,
				"y": 40,
				"id": "sor_sales_order_id_hdr",
				"type": "text",
				"x": 313.736568457539,
				"height": 15,
				"text": "Tilaus"
			},
			{
				"style": {
					"font_name": "sans-serif",
					"row_height": 15,
					"margin": {
						"right": 2,
						"top": 2
					},
					"font_size": 8
				},
				"width": 44.422876949740039,
				"y": 40,
				"id": "so_your_reference_hdr",
				"type": "text",
				"x": 349.8301559792028,
				"height": 15,
				"text": "As.viite"
			},
			{
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"horizontal_align": "right",
					"font_size": 8,
					"format": ["%'.2f"],
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"width": 16.658578856152514,
				"y": 40,
				"id": "sor_row_number_hdr",
				"type": "text",
				"x": 394.25303292894287,
				"height": 15,
				"text": "Rivi"
			},
			{
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"horizontal_align": "right",
					"font_size": 8,
					"format": ["%'.2f"],
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"width": 16.658578856152514,
				"y": 40,
				"id": "sor_partial_delivery_number_hdr",
				"type": "text",
				"x": 410.9116117850953,
				"height": 15,
				"text": "Erä"
			},
			{
				"style": {
					"font_name": "sans-serif",
					"row_height": 15,
					"margin": {
						"right": 2,
						"top": 2
					},
					"font_size": 8
				},
				"width": 16.658578856152514,
				"y": 40,
				"id": "sor_customer_row_number_hdr",
				"type": "text",
				"x": 427.57019064124787,
				"height": 15,
				"text": "As.erä"
			},
			{
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"horizontal_align": "right",
					"font_size": 8,
					"format": ["%'.2f"],
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"width": 41.646447140381287,
				"y": 40,
				"id": "sor_ordered_amount_hdr",
				"type": "text",
				"x": 444.2287694974004,
				"height": 15,
				"text": "Tilattu"
			},
			{
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"horizontal_align": "right",
					"font_size": 8,
					"format": ["%'.2f"],
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"width": 41.646447140381287,
				"y": 40,
				"id": "sor_delivered_quantity_hdr",
				"type": "text",
				"x": 485.87521663778167,
				"height": 15,
				"text": "Toimitettu"
			},
			{
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"horizontal_align": "right",
					"font_size": 8,
					"format": ["%'.2f"],
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"width": 41.646447140381287,
				"y": 40,
				"id": "sor_waiting_for_delivery_hdr",
				"type": "text",
				"x": 527.521663778163,
				"height": 15,
				"text": "Jäljellä mrä"
			},
			{
				"style": {
					"font_name": "sans-serif",
					"row_height": 15,
					"margin": {
						"right": 2,
						"top": 2
					},
					"font_size": 8
				},
				"width": 16.658578856152514,
				"y": 40,
				"id": "sor_delivery_state_hdr",
				"type": "text",
				"x": 569.1681109185443,
				"height": 15,
				"text": "Tila"
			},
			{
				"style": {
					"font_name": "sans-serif",
					"row_height": 15,
					"margin": {
						"right": 2,
						"top": 2
					},
					"font_size": 8
				},
				"width": 41.646447140381287,
				"y": 40,
				"id": "sor_delivered_date_hdr",
				"type": "text",
				"x": 585.8266897746968,
				"height": 15,
				"text": "Toim.pv"
			},
			{
				"style": {
					"font_name": "sans-serif",
					"row_height": 15,
					"margin": {
						"right": 2,
						"top": 2
					},
					"font_size": 8
				},
				"width": 70.79896013864819,
				"y": 40,
				"id": "pr_size_hdr",
				"type": "text",
				"x": 627.473136915078,
				"height": 15,
				"text": "Koko"
			},
			{
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"horizontal_align": "right",
					"font_size": 8,
					"format": ["%'.2f"],
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"width": 41.646447140381287,
				"y": 40,
				"id": "sor_commission_hdr",
				"type": "text",
				"x": 698.2720970537262,
				"height": 15,
				"text": "Komissio"
			},
			{
				"style": {
					"font_name": "sans-serif",
					"row_height": 12,
					"horizontal_align": "right",
					"font_size": 8,
					"format": ["%'.2f"],
					"margin": {
						"right": 2,
						"top": 2
					}
				},
				"width": 61.08145580589255,
				"y": 40,
				"id": "sor_sales_price_total_hdr",
				"type": "text",
				"x": 739.9185441941074,
				"height": 15,
				"text": "Myyntihinta mrä"
			}
		],
		"object_order": ["header", "row_header", "row_line", "row_data"]
	},
	"data": {
		"report": [
			{
				"sor": [
					{
						"sor_waiting_for_delivery": 9,
						"pr_size": "",
						"sor_customer_row_number": "1",
						"sor_delivered_quantity": 1,
						"sor_delivery_state": "OT",
						"sor_delivered_date": "2018-06-12",
						"sor_ordered_amount": 10,
						"so_company_id": "SÄHKÖTUOTE",
						"so_your_reference": "Tarjous SOP1",
						"sor_commission": 0,
						"sor_row_number": 1,
						"sor_sales_price_total": 400,
						"so_order_date": "2018-05-22",
						"sor_sales_order_id": "110355",
						"sor_partial_delivery_number": 1,
						"sor_explanation": "Mikroauton etuakseli\n",
						"sor_product_id": "MA AKSELI ETU"
					},
					{
						"sor_waiting_for_delivery": 10,
						"pr_size": "",
						"sor_customer_row_number": "1",
						"sor_delivered_quantity": 10,
						"sor_delivery_state": "LT",
						"sor_delivered_date": "2018-02-06",
						"sor_ordered_amount": 10,
						"so_company_id": "SKYISLIMIT",
						"so_your_reference": "",
						"sor_commission": 0,
						"sor_row_number": 1,
						"sor_sales_price_total": 2762.44,
						"so_order_date": "2017-12-22",
						"sor_sales_order_id": "110147",
						"sor_partial_delivery_number": 0,
						"sor_explanation": "Mikroauton etuakseli\n",
						"sor_product_id": "MA AKSELI ETU"
					},
					{
						"sor_waiting_for_delivery": 8,
						"pr_size": "",
						"sor_customer_row_number": "1",
						"sor_delivered_quantity": 1,
						"sor_delivery_state": "OT",
						"sor_delivered_date": "2018-06-12",
						"sor_ordered_amount": 10,
						"so_company_id": "SÄHKÖTUOTE",
						"so_your_reference": "Tarjous SOP1",
						"sor_commission": 0,
						"sor_row_number": 1,
						"sor_sales_price_total": 400,
						"so_order_date": "2018-05-22",
						"sor_sales_order_id": "110355",
						"sor_partial_delivery_number": 2,
						"sor_explanation": "Mikroauton etuakseli\n",
						"sor_product_id": "MA AKSELI ETU"
					},
					{
						"sor_waiting_for_delivery": 7,
						"pr_size": "",
						"sor_customer_row_number": "1",
						"sor_delivered_quantity": 1,
						"sor_delivery_state": "OT",
						"sor_delivered_date": "2018-06-12",
						"sor_ordered_amount": 10,
						"so_company_id": "SÄHKÖTUOTE",
						"so_your_reference": "Tarjous SOP1",
						"sor_commission": 0,
						"sor_row_number": 1,
						"sor_sales_price_total": 400,
						"so_order_date": "2018-05-22",
						"sor_sales_order_id": "110355",
						"sor_partial_delivery_number": 3,
						"sor_explanation": "Mikroauton etuakseli\n",
						"sor_product_id": "MA AKSELI ETU"
					},
					{
						"sor_waiting_for_delivery": 5,
						"pr_size": "2",
						"sor_customer_row_number": "6",
						"sor_delivered_quantity": 5,
						"sor_delivery_state": "LT",
						"sor_delivered_date": "2018-02-06",
						"sor_ordered_amount": 5,
						"so_company_id": "SKYISLIMIT",
						"so_your_reference": "",
						"sor_commission": 0,
						"sor_row_number": 6,
						"sor_sales_price_total": 269.4,
						"so_order_date": "2017-12-22",
						"sor_sales_order_id": "110147",
						"sor_partial_delivery_number": 0,
						"sor_explanation": "Mikroauton istuin\n",
						"sor_product_id": "MA ISTUIN"
					},
					{
						"sor_waiting_for_delivery": 0,
						"pr_size": "2",
						"sor_customer_row_number": "1",
						"sor_delivered_quantity": 1,
						"sor_delivery_state": "LT",
						"sor_delivered_date": "2018-06-08",
						"sor_ordered_amount": 1,
						"so_company_id": "TANJAZZ",
						"so_your_reference": "",
						"sor_commission": 0,
						"sor_row_number": 1,
						"sor_sales_price_total": 53.88,
						"so_order_date": "2018-06-08",
						"sor_sales_order_id": "110335",
						"sor_partial_delivery_number": 0,
						"sor_explanation": "Mikroauton istuin\n",
						"sor_product_id": "MA ISTUIN"
					}
				]
			}
		]
	},
	"subtotal": {
		"subtotal": [
			{
				"field": "sor_product_id",
				"calculate": [
					["sor_product_id", ""],
					["sor_ordered_amount", "+"],
					["sor_delivered_quantity", "+"],
					["sor_waiting_for_delivery", "+"],
					["sor_commission", "+"],
					["sor_sales_price_total", "+"]
				],
				"page_break": false
			}
		],
		"total": {
			"calculate": [
				["sor_ordered_amount", "+"],
				["sor_delivered_quantity", "+"],
				["sor_waiting_for_delivery", "+"],
				["sor_commission", "+"],
				["sor_sales_price_total", "+"]
			]
		}
	},
	"report_name": "Toimitetut tuotteittain",
	"paper": {
		"right": 821.8599999999999,
		"bottom": 575.26,
		"dpi": 72,
		"top": 20,
		"docType": "pdf",
		"border_top": 20,
		"width": 801.8599999999999,
		"height": 555.26,
		"left": 20,
		"full_height": 595.26,
		"paperType": "A4 landscape",
		"border_right": 20,
		"border_left": 20,
		"border_bottom": 20,
		"full_width": 841.8599999999999
	},
	"language": [],
	"main_table": "report"
}
