{
	"name": "table/external/aj-mes/order/order_row.json",
	"table_name": "SalesOrdersTransfer",
	"table_prefix": "ord",
	"record_type": ["sales"],
	"local_table": "order",
	"local_record_type": "sales",
	"default_field-": "table/prf/default_field.json",
	"example_data": {
		"Id": 28,
		"Number": "170192",
		"RowNumber": 1,
		"Title": "Oulun Vesi Tervajärven RMK",
		"CustomerName": "MIPRO OY",
		"ProjectNumber": "170192",
		"Created": "2019-12-11 13:59:25.3766667 +00:00",
		"CreatedBy": "AJ DATA IMPORT FROM ERP",
		"ErpStatus": 0,
		"MesStatus": 0,
		"State": ""
	},
	"field": [
		{
			"field_name": "Id",
			"field_type": "bigint",
			"writeable": false,
			"local_field": "json_data.id"
		},
		{
			"field_name": "Number",
			"field_type": "varchar",
			"local_field": "order_id"
		},
		{
			"field_name": "RowNumber",
			"field_type": "integer",
			"local_field": "json_data.row_number"
		},
		{
			"field_name": "Title",
			"field_type": "varchar",
			"local_field": "json_data.mark"
		},
		{
			"field_name": "CustomerName",
			"field_type": "varchar",
			"local_field": "json_data.customer_name"
		},
		{
			"field_name": "ProjectNumber",
			"field_type": "varchar",
			"local_field": "json_data.customer_project"
		},
		{
			"field_name": "Created",
			"field_type": "timestamp",
			"local_field": "create_time"
		},
		{
			"field_name": "CreatedBy",
			"field_type": "varchar",
			"local_field": "json_data.create_user"
		},
		{
			"field_name": "ErpStatus",
			"field_type": "integer",
			"local_field": "json_data.erp_status"
		},
		{
			"field_name": "MesStatus",
			"field_type": "integer",
			"local_field": "json_data.mes_status"
		},
		{
			"field_name": "State",
			"field_type": "varchar",
			"local_field": "json_data.state"
		}
	]
}
