{
	"name": "form/nc/erp-sync/lantek/query-local/product_material-estimated.json",
	"table": [
		{
			"record_type": ["estimated"],
			"table": "product_material"
		},
		{
			"record_type": [""],
			"table": "production_order"
		},
		{
			"record_type": [""],
			"table": "product"
		}
	],
	"parameter": {
		"show_sql": false,
		"sql_keyword": "distinct",
		"product_group": "form/nc/erp-sync/lantek/query-param.json/local.product_group",
		"production_order_state_open": "form/nc/erp-sync/lantek/query-param.json/local.production_order_state_open",
		"limit": "null"
	},
	"query": [["pr.product_group", "in", "product_group"], "and", ["pro.production_order_state", "in", "production_order_state_open"], "and", ["pro.json_data.type", "=", ""]],
	"field": ["prma.product_id", "prma.row_number", "prma.work_phase_number", "prma.material_id", "pr.subgroup", "pr.drawing_number", "pr.quality"],
	"limit": "limit"
}
