{
	"name": "table/local/product/product_lot.json",
	"table_name": "product_lot",
	"table_prefix": "prl",
	"record_type": ["", "stock_parcel", "remnant", "nxdetail", "nxsheet", "nxsheetpath", "nxsheetpathdet"],
	"table_name_language": {
		"": "Product lot",
		"stock_parcel": "Stock parcel",
		"remnant": "Remnant",
		"nxdetail": "nx detail",
		"nxsheet": "nx sheet",
		"nxsheetpath": "nx sheet path",
		"nxsheetpathdet": "nx sheet path detail"
	},
	"default_order": [
		{
			"field": "product_lot_id",
			"order": ">"
		}
	],
	"default_field": "table/prf/default_field.json",
	"save_script": [],
	"calculated_field": [],
	"field": [
		{
			"field_name": "product_lot_id",
			"field_type": "varchar",
			"field_length": 80,
			"constraint": ["primary key"]
		},
		{
			"field_name": "order_id",
			"field_type": "varchar",
			"field_length": 80
		},
		{
			"field_name": "from_id",
			"field_type": "varchar",
			"field_length": 40
		},
		{
			"field_name": "to_id",
			"field_type": "varchar",
			"field_length": 40
		},
		{
			"field_name": "product_id",
			"field_type": "varchar",
			"field_length": 80,
			"foreign_key": [
				{
					"link_type": "prevent delete",
					"linked_field": "product_id",
					"linked_record_type": "",
					"linked_table": "product",
					"linking_record_type": ""
				}
			],
			"not_allowed_value": [""]
		},
		{
			"field_name": "amount",
			"field_type": "double"
		},
		{
			"field_name": "unit",
			"field_type": "varchar",
			"field_length": 20
		},
		{
			"field_name": "product_lot_state",
			"field_type": "varchar",
			"field_length": 20
		},
		{
			"field_name": "product_lot_type",
			"field_type": "varchar",
			"field_length": 20,
			"allowed_value": [
				{
					"show": "shelf",
					"value": "shelf"
				},
				{
					"show": "work in progress",
					"value": "wip"
				},
				{
					"show": "work",
					"value": "work"
				},
				{
					"show": "missing",
					"value": "missing"
				},
				{
					"show": "in transit",
					"value": "in transit"
				}
			]
		},
		{
			"field_name": "location",
			"field_type": "varchar",
			"field_length": 40
		},
		{
			"field_name": "serial_number",
			"field_type": "varchar",
			"field_length": 80
		},
		{
			"field_name": "info",
			"field_type": "text"
		}
	],
	"extra_field": [
		{
			"field_name": "json_data.transfer_id",
			"info": "Nestix",
			"field_type": "text"
		},
		{
			"field_name": "nxmatid_s",
			"info": "Lantek",
			"field_type": "text"
		},
		{
			"field_name": "nxsheetid_s",
			"info": "Lantek",
			"field_type": "text"
		},
		{
			"field_name": "nxsheetpathid_s",
			"info": "Lantek",
			"field_type": "text"
		},
		{
			"field_name": "nxorderposid_s",
			"info": "Lantek",
			"field_type": "text"
		},
		{
			"field_name": "json_data.width",
			"info": "Lantek sheet",
			"field_type": "double"
		},
		{
			"field_name": "json_data.height",
			"info": "Lantek sheet",
			"field_type": "double"
		},
		{
			"field_name": "json_data.area",
			"info": "Lantek sheet",
			"field_type": "double"
		}
	],
	"field_change": [
		{
			"name": "product_lot_id",
			"old_name": ["product_lot_id"]
		},
		{
			"name": "json_data.unit",
			"old_name": ["unit"]
		},
		{
			"name": "location_id",
			"old_name": ["location"]
		}
	]
}
