{
	"name": "form/manager/fastems/fastems_columns.json",
	"new_orders": {
		"columns": [
			{
				"width": 60,
				"field": "production_lot",
				"format": "",
				"name": "Valmistuserä",
				"type": "s",
				"sort": 1
			},
			{
				"width": 90,
				"field": "product_id",
				"format": "",
				"name": "Tuotetunnus",
				"type": "s"
			},
			{
				"width": 90,
				"field": "fms_article_id",
				"format": "",
				"name": "Fastemsin article_id",
				"type": "s",
				"cellCssFormatter": ["managerArticleIdIsDifferent"]
			},
			{
				"width": 140,
				"field": "name",
				"format": "",
				"name": "Nimi",
				"type": "s"
			},
			{
				"width": 30,
				"field": "state",
				"format": "",
				"name": "Tila",
				"type": "s"
			},
			{
				"width": 90,
				"field": "due_date",
				"format": "",
				"name": "Eräpäivä",
				"type": "ts",
				"cellCssFormatter": ["managerDateChanged"]
			},
			{
				"width": 50,
				"field": "amount",
				"format": "%'.2f",
				"name": "Määrä",
				"type": "r",
				"cellCssFormatter": ["managerAmountChanged"]
			},
			{
				"width": 60,
				"field": "row_type",
				"format": "",
				"name": "Rivin tyyppi",
				"type": "s",
				"show_table": "rec.preference.row_type_info",
				"css_table": "rec.preference.row_type_css"
			},
			{
				"width": 200,
				"field": "info",
				"format": "",
				"name": "Piir. nro, lisätietoja",
				"type": "s",
				"cellCssFormatter": ["managerInfoChanged"]
			},
			{
				"width": 120,
				"field": "fms_info",
				"format": "",
				"name": "FMS valmistus",
				"type": "s"
			},
			{
				"width": 60,
				"field": "record_id",
				"format": "",
				"name": "Record id",
				"type": "s"
			}
		]
	},
	"orders_from_pps": {
		"columns": [
			{
				"width": 60,
				"field": "fmsofp.order_id",
				"format": "",
				"name": "Tilaus ID",
				"type": "s",
				"sort": 1
			},
			{
				"width": 90,
				"field": "product_id",
				"format": "",
				"name": "Tuotetunnus",
				"type": "s"
			},
			{
				"width": 90,
				"field": "fmsofp.article_id",
				"format": "",
				"name": "Fastemsin article_id",
				"type": "s",
				"cellCssFormatter": ["articleIdIsMissing", "articleIdIsDifferent", "productIdIsDifferent", "articleIdError"]
			},
			{
				"width": 140,
				"field": "name",
				"format": "",
				"name": "Nimi",
				"type": "s"
			},
			{
				"width": 90,
				"field": "fmsofp.due_date",
				"format": "",
				"name": "Eräpäivä",
				"type": "ts"
			},
			{
				"width": 50,
				"field": "fmsofp.amount",
				"format": "",
				"name": "Määrä",
				"type": "r"
			},
			{
				"width": 60,
				"field": "fmsofp.row_type",
				"format": "",
				"name": "Rivin tyyppi",
				"type": "s",
				"show_table": "rec.preference.row_type_info",
				"css_table": "rec.preference.row_type_css"
			},
			{
				"width": 90,
				"field": "fmsofp.time_stamp",
				"format": "",
				"name": "Aikaleima",
				"type": "ts"
			},
			{
				"width": 500,
				"field": "fmsofp.info",
				"format": "",
				"name": "Info",
				"type": "s"
			},
			{
				"width": 80,
				"field": "fmsofp.machine",
				"format": "",
				"name": "Kone",
				"type": "s"
			}
		]
	},
	"mms_manufactured_articles": {
		"columns": [
			{
				"width": 60,
				"field": "fmsmma.order_id",
				"format": "",
				"name": "Tilaus ID",
				"type": "s",
				"sort": 1
			},
			{
				"width": 90,
				"field": "product_id",
				"format": "",
				"name": "Tuotetunnus",
				"type": "s"
			},
			{
				"width": 90,
				"field": "fmsmma.article_id",
				"format": "",
				"name": "Fastemsin article_id",
				"type": "s",
				"cellCssFormatter": ["articleIdIsMissing", "articleIdIsDifferent", "productIdIsDifferent", "articleIdError"]
			},
			{
				"width": 140,
				"field": "name",
				"format": "",
				"name": "Nimi",
				"type": "s"
			},
			{
				"width": 30,
				"field": "work_order_state",
				"format": "",
				"name": "Tila",
				"type": "s"
			},
			{
				"width": 60,
				"field": "fmsmma.amount",
				"format": "",
				"name": "Määrä",
				"type": "r"
			},
			{
				"width": 90,
				"field": "fmsmma.time_stamp",
				"format": "",
				"name": "Valmistumispäivä",
				"type": "ts"
			},
			{
				"width": 60,
				"field": "fmsmma.row_type",
				"format": "",
				"name": "Rivin tyyppi",
				"type": "l"
			},
			{
				"width": 70,
				"field": "fmsmma.article_op",
				"name": "Nimikk. op. nro",
				"type": "l"
			},
			{
				"width": 70,
				"field": "fmsmma.operator_id",
				"name": "Käyttäjän nimi",
				"type": "s"
			},
			{
				"width": 70,
				"field": "fmsmma.scrap_reason",
				"name": "Hylkäyksen syy",
				"type": "s"
			}
		]
	},
	"mms_order_view": {
		"columns": [
			{
				"width": 60,
				"field": "fmsmov.order_id",
				"format": "",
				"name": "Tilaus ID",
				"type": "s",
				"sort": 1
			},
			{
				"width": 50,
				"field": "work_order_waiting",
				"format": "",
				"name": "Odottaa",
				"type": "s",
				"cellCssFormatter": ["waitForTypeDelete", "waitForTypeChange"]
			},
			{
				"width": 90,
				"field": "product_id",
				"format": "",
				"name": "Tuotetunnus",
				"type": "s"
			},
			{
				"width": 90,
				"field": "fmsmov.article_id",
				"format": "",
				"name": "Fastemsin article_id",
				"type": "s",
				"cellCssFormatter": ["articleIdIsMissing", "articleIdIsDifferent", "productIdIsDifferent", "articleIdError"]
			},
			{
				"width": 140,
				"field": "name",
				"format": "",
				"name": "Nimi",
				"type": "s"
			},
			{
				"width": 30,
				"field": "work_order_state",
				"format": "",
				"name": "Tila",
				"type": "s"
			},
			{
				"width": 54,
				"field": "work_order_real_critical_date",
				"format": "",
				"name": "Aito kr. pv",
				"type": "d"
			},
			{
				"width": 90,
				"field": "fmsmov.due_date",
				"format": "",
				"name": "Toimitus pv",
				"type": "ts"
			},
			{
				"width": 30,
				"field": "fmsmov.amount",
				"format": "",
				"name": "Määrä",
				"type": "r"
			},
			{
				"width": 50,
				"field": "fmsmov.username",
				"format": "",
				"name": "Käyttäjänimi",
				"type": "s"
			},
			{
				"width": 150,
				"field": "fmsmov.info",
				"format": "",
				"name": "Lisätietoja",
				"type": "s"
			},
			{
				"width": 50,
				"field": "fmsmov.priority",
				"format": "",
				"name": "Prioriteetti",
				"type": "l"
			},
			{
				"width": 60,
				"field": "fmsmov.machine",
				"format": "",
				"name": "Kone",
				"type": "s"
			},
			{
				"width": 60,
				"field": "record_id",
				"format": "",
				"name": "Record id",
				"type": "s"
			}
		]
	},
	"mms_storage_view": {
		"columns": [
			{
				"width": 60,
				"field": "fmsmsv.order_id",
				"format": "",
				"name": "Tilaus ID",
				"type": "s",
				"sort": 1
			},
			{
				"width": 90,
				"field": "product_id",
				"format": "",
				"name": "Tuotetunnus",
				"type": "s"
			},
			{
				"width": 90,
				"field": "fmsmsv.article_id",
				"format": "",
				"name": "Fastemsin article_id",
				"type": "s",
				"cellCssFormatter": ["articleIdIsMissing", "articleIdIsDifferent", "productIdIsDifferent", "articleIdError"]
			},
			{
				"width": 140,
				"field": "name",
				"format": "",
				"name": "Nimi",
				"type": "s"
			},
			{
				"width": 30,
				"field": "fmsmsv.phase",
				"format": "",
				"name": "Vaihe",
				"type": "s"
			},
			{
				"width": 60,
				"field": "fmsmsv.amount",
				"format": "",
				"name": "Määrä",
				"type": "r"
			}
		]
	},
	"syntax_error_orders": {
		"columns": [
			{
				"width": 60,
				"field": "fmsseo.order_id",
				"format": "",
				"name": "Tilaus ID",
				"type": "s",
				"sort": 1
			},
			{
				"width": 90,
				"field": "product_id",
				"format": "",
				"name": "Tuotetunnus",
				"type": "s"
			},
			{
				"width": 90,
				"field": "fmsseo.article_id",
				"format": "",
				"name": "Fastemsin article_id",
				"type": "s",
				"cellCssFormatter": ["articleIdIsMissing", "articleIdIsDifferent", "productIdIsDifferent", "articleIdError"]
			},
			{
				"width": 140,
				"field": "name",
				"format": "",
				"name": "Nimi",
				"type": "s"
			},
			{
				"width": 30,
				"field": "work_order_state",
				"format": "",
				"name": "Tila",
				"type": "s"
			},
			{
				"width": 30,
				"field": "fmsseo.reject_reason",
				"format": "",
				"name": "Syy",
				"type": "l"
			},
			{
				"width": 240,
				"field": "fmsseo.reject_info",
				"format": "",
				"name": "Hylkäys info",
				"type": "s"
			},
			{
				"width": 90,
				"field": "fmsseo.time_stamp",
				"format": "",
				"name": "Aika",
				"type": "ts"
			},
			{
				"width": 110,
				"field": "fmsseo.username",
				"format": "",
				"name": "Käyttäjänimi",
				"type": "s"
			}
		]
	},
	"columns_not_in_use": {
		"new_orders": [
			{
				"width": 14,
				"field": "check_mark",
				"name": "»",
				"format": "",
				"type": "s"
			},
			{
				"width": 60,
				"field": "row_type_info",
				"format": "",
				"name": "Tyyppi",
				"type": "s",
				"cellCssFormatter": ["newOrder", "syntaxErrorOrder", "deleteOrder", "modifyOrder"]
			}
		],
		"orders_from_pps": [
			{
				"width": 50,
				"field": "fmsofp.priority",
				"format": "",
				"name": "Tärkeys",
				"type": "l"
			}
		],
		"mms_manufactured_articles": [
			{
				"width": 54,
				"field": "work_order_real_critical_date",
				"format": "",
				"name": "Aito kr. pv",
				"type": "d"
			}
		]
	}
}
