{
	"name": "table/external/moloni/product/product.json",
	"info": "https://www.moloni.pt/dev/index.php?action=getApiDocDetail&id=192",
	"table_name": "products",
	"table_prefix": "pr",
	"record_type": [""],
	"local_table": "product",
	"local_record_type": "",
	"field": [
		{
			"field_name": "json_data.fake_record_id",
			"local_field": "record_id",
			"field_type": "text",
			"writeable": false
		},
		{
			"field_name": "reference",
			"local_field": "product_id",
			"field_type": "text"
		},
		{
			"field_name": "product_id",
			"local_field": "json_data.transfer_id",
			"field_type": "integer"
		},
		{
			"field_name": "category_id",
			"local_field": "json_data.category_id",
			"field_type": "integer",
			"default_value": 4396386
		},
		{
			"field_name": "type",
			"local_field": "json_data.type",
			"field_type": "integer",
			"allowed_value": [
				{
					"show": "Product",
					"value": 1
				},
				{
					"value": 2,
					"label": "Service"
				},
				{
					"value": 3,
					"label": "Other"
				}
			],
			"default_value": 1
		},
		{
			"field_name": "name",
			"local_field": "name",
			"field_type": "text"
		},
		{
			"field_name": "summary",
			"local_field": "json_data.explanation",
			"field_type": "text"
		},
		{
			"field_name": "ean",
			"local_field": "ean_code",
			"field_type": "text"
		},
		{
			"field_name": "price",
			"local_field": "sales_price",
			"field_type": "double"
		},
		{
			"field_name": "unit_id",
			"local_field": "stock_unit",
			"field_type": "integer",
			"default_value": 1750191
		},
		{
			"field_name": "has_stock",
			"local_field": "stock_type",
			"field_type": "integer",
			"default_value": 0
		},
		{
			"field_name": "stock",
			"local_field": "json_data.stock_balance",
			"field_type": "double"
		},
		{
			"field_name": "minimum_stock",
			"local_field": "minimum_stock",
			"field_type": "double"
		},
		{
			"field_name": "exemption_reason",
			"local_field": "json_data.exemption_reason",
			"field_type": "varchar"
		},
		{
			"field_name": "notes",
			"local_field": "info",
			"field_type": "text"
		},
		{
			"info": "created from example data",
			"field_name": "at_product_category",
			"local_field": "product_type",
			"field_type": "string",
			"default_value": "A"
		},
		{
			"info": "created from example data",
			"field_name": "taxes[1].tax_id",
			"local_field": "json_data.tax_id",
			"field_type": "number",
			"default_value": "2329476"
		},
		{
			"info": "created from example data",
			"field_name": "taxes[1].value",
			"local_field": "json_data.tax_value",
			"field_type": "number",
			"default_value": "0"
		},
		{
			"info": "created from example data",
			"field_name": "taxes[1].order",
			"local_field": "json_data.tax_order",
			"field_type": "number",
			"default_value": "1"
		},
		{
			"info": "created from example data",
			"field_name": "taxes[1].cumulative",
			"local_field": "json_data.tax_cumulative",
			"field_type": "number",
			"default_value": "0"
		}
	],
	"fields_not_in_use": [
		{
			"field_name": "at_product_category",
			"local_field": "subgroup",
			"field_type": "text"
		},
		{
			"field_name": "tax_id",
			"local_field": "json_data.taxes.tax_id",
			"field_type": "integer"
		},
		{
			"field_name": "value",
			"local_field": "json_data.taxes.value",
			"field_type": "double"
		},
		{
			"field_name": "tax_class",
			"local_field": "sales_order_code_id",
			"field_type": "text",
			"writeable": false
		},
		{
			"field_name": "weight",
			"local_field": "json_data.net_weight",
			"field_type": "text"
		},
		{
			"field_name": "categories",
			"field_type": "text"
		},
		{
			"field_name": "dimensions",
			"field_type": "text"
		},
		{
			"field_name": "tags",
			"field_type": "text"
		},
		{
			"field_name": "tax_status",
			"field_type": "text",
			"default_value": "taxable"
		},
		{
			"field_name": "manage_stock",
			"field_type": "boolean",
			"default_value": true
		},
		{
			"field_name": "in_stock",
			"field_type": "boolean",
			"default_value": true
		},
		{
			"field_name": "on_sale",
			"field_type": "boolean",
			"default_value": false
		},
		{
			"field_name": "purchasable",
			"field_type": "boolean",
			"default_value": true
		},
		{
			"field_name": "reviews_allowed",
			"field_type": "boolean",
			"default_value": true
		},
		{
			"field_name": "shipping_required",
			"field_type": "boolean",
			"default_value": true
		},
		{
			"field_name": "shipping_taxable",
			"field_type": "boolean",
			"default_value": true
		},
		{
			"field_name": "sold_individually",
			"field_type": "boolean",
			"default_value": true
		},
		{
			"field_name": "backorders_allowed",
			"field_type": "boolean",
			"default_value": true
		},
		{
			"field_name": "status",
			"field_type": "text",
			"default_value": "publish"
		}
	]
}
