{
	"name": "table/external/moloni/order/order_row-sales.json",
	"table_name": "order_row",
	"table_prefix": "ordr",
	"record_type": ["sales"],
	"local_table": "order_row",
	"local_record_type": "sales",
	"field": [
		{
			"field_name": "order",
			"field_type": "integer",
			"local_field": "order_id",
			"writeable": false
		},
		{
			"field_name": "product_id",
			"field_type": "integer",
			"local_field": "product_id"
		},
		{
			"field_name": "name",
			"field_type": "varchar",
			"local_field": "description"
		},
		{
			"field_name": "price",
			"field_type": "double",
			"local_field": "unit_price"
		},
		{
			"field_name": "reference",
			"field_type": "varchar",
			"local_field": "product_id"
		},
		{
			"field_name": "qty",
			"field_type": "double",
			"local_field": "order_amount"
		},
		{
			"field_name": "exemption_reason",
			"field_type": "varchar",
			"local_field": "json_data.exemption_reason"
		},
		{
			"field_name": "subtotal",
			"field_type": "double",
			"local_field": "json_data.subtotal"
		},
		{
			"field_name": "subtotal_tax",
			"field_type": "double",
			"local_field": "json_data.subtotal_tax"
		},
		{
			"field_name": "tax_class",
			"field_type": "varchar",
			"local_field": "json_data.tax_class"
		},
		{
			"field_name": "total",
			"field_type": "double",
			"local_field": "price_without_vat"
		},
		{
			"field_name": "total_tax",
			"field_type": "double",
			"local_field": "vat_price"
		},
		{
			"field_name": "variation_id",
			"field_type": "varchar",
			"local_field": "json_data.variation_id"
		}
	]
}
