{
  "name": "dialog/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"
      }
    ]
  }
}
