{
	"name": "table/external/woocommerce/order/order_row.json",
	"table_name": "order_row",
	"table_prefix": "ordr",
	"record_type": ["sales"],
	"local_table": "order_row",
	"local_record_type": "sales",
	"field": [
		{
			"field_name": "json_data.fake_record_id",
			"field_type": "text",
			"local_field": "record_id",
			"info": "fake field to prevent local field 'ordr.record_id' can't be converted to external field -warnings",
			"writeable": false
		},
		{
			"field_name": "ord.order_id",
			"field_type": "varchar",
			"local_field": "order_id"
		},
		{
			"field_name": "id",
			"field_type": "varchar",
			"local_field": "project_id"
		},
		{
			"field_name": "name",
			"field_type": "varchar",
			"local_field": "description"
		},
		{
			"field_name": "price",
			"field_type": "double",
			"local_field": "unit_price"
		},
		{
			"field_name": "sku",
			"field_type": "varchar",
			"local_field": "product_id"
		},
		{
			"field_name": "quantity",
			"field_type": "varchar",
			"local_field": "order_amount"
		},
		{
			"field_name": "method_id",
			"field_type": "varchar",
			"local_field": "json_data.woocommerce.method_id"
		},
		{
			"field_name": "product_id",
			"field_type": "double",
			"local_field": "json_data.woocommerce.product_id"
		},
		{
			"field_name": "subtotal",
			"field_type": "double",
			"local_field": "json_data.woocommerce.subtotal"
		},
		{
			"field_name": "subtotal_tax",
			"field_type": "double",
			"local_field": "json_data.woocommerce.subtotal_tax"
		},
		{
			"field_name": "tax_class",
			"field_type": "varchar",
			"local_field": "json_data.woocommerce.tax_class"
		},
		{
			"field_name": "taxes.id",
			"field_type": "varchar",
			"local_field": "json_data.woocommerce.taxes.id"
		},
		{
			"field_name": "taxes.subtotal",
			"field_type": "varchar",
			"local_field": "json_data.woocommerce.subtotal.id"
		},
		{
			"field_name": "taxes.total",
			"field_type": "varchar",
			"local_field": "json_data.woocommerce.total.id"
		},
		{
			"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.woocommerce.variation_id"
		}
	],
	"default_field": "table/default_field.json"
}
