{
	"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": ["product"],
	"local_table": "product",
	"local_record_type": "product",
	"default_field": "table/default_field.json",
	"field": [
		{
			"field_name": "json_data.fake_record_id",
			"field_type": "text",
			"local_field": "record_id",
			"writeable": false
		},
		{
			"field_name": "product_id",
			"field_type": "text",
			"local_field": "json_data.project_id",
			"writeable": false
		},
		{
			"field_name": "category_id",
			"field_type": "integer",
			"local_field": "product_group"
		},
		{
			"field_name": "at_product_category",
			"field_type": "text",
			"local_field": "subgroup"
		},
		{
			"field_name": "type",
			"field_type": "integer",
			"local_field": "product_type"
		},
		{
			"field_name": "name",
			"field_type": "text",
			"local_field": "name"
		},
		{
			"field_name": "reference",
			"field_type": "text",
			"local_field": "product_id"
		},
		{
			"field_name": "ean",
			"field_type": "text",
			"local_field": "ean_code"
		},
		{
			"field_name": "price",
			"field_type": "double",
			"local_field": "sales_price"
		},
		{
			"field_name": "unit_id",
			"field_type": "integer",
			"local_field": "stock_unit"
		},
		{
			"field_name": "has_stock",
			"field_type": "integer",
			"local_field": "json_data.moloni.has_stock"
		},
		{
			"field_name": "stock",
			"field_type": "double",
			"local_field": "stock_balance"
		},
		{
			"field_name": "exemption_reason",
			"field_type": "varchar",
			"local_field": "json_data.moloni.exemption_reason"
		},
		{
			"field_name": "notes",
			"field_type": "text",
			"local_field": "info"
		}
	],
	"fields_not_in_use": [
		{
			"field_name": "tax_class",
			"field_type": "text",
			"local_field": "sales_order_code_id",
			"writeable": false
		},
		{
			"field_name": "weight",
			"field_type": "text",
			"local_field": "json_data.net_weight"
		},
		{
			"field_name": "short_description",
			"field_type": "text",
			"local_field": "json_data.explanation"
		},
		{
			"field_name": "stock",
			"field_type": "integer",
			"local_field": "stock_balance"
		},
		{
			"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"
		}
	],
	"example_data": {
		"ean": "",
		"stock": 0,
		"created": "2019-08-08T08:35:21+0100",
		"product_id": 29875257,
		"visibility_id": 1,
		"category_id": 1179243,
		"type": 1,
		"name": "QUICKSILVER 505 OPEN CONSOLE COVER 2240953",
		"summary": "",
		"notes": "2240953",
		"reference": "VK_QS505OPENPP1",
		"price": 115.1,
		"unit_id": 647438,
		"has_stock": 1,
		"minimum_stock": 0,
		"image": "",
		"exemption_reason": "",
		"pos_favorite": 0,
		"at_product_category": "A",
		"composition_type": 0,
		"category": {
			"category_id": 1179243,
			"parent_id": 1133338,
			"name": "Bimini",
			"description": "Bimini",
			"image": ""
		},
		"measurement_unit": {
			"unit_id": 647438,
			"name": "Unidade",
			"short_name": "Uni."
		},
		"suppliers": [],
		"taxes": [
			{
				"product_id": 29875257,
				"tax_id": 773258,
				"value": 26.473,
				"order": 0,
				"cumulative": 0,
				"tax": {
					"tax_id": 773258,
					"type": 1,
					"saft_type": 1,
					"vat_type": "NOR",
					"stamp_tax": "",
					"name": "IVA Normal",
					"value": 23,
					"fiscal_zone": "PT",
					"active_by_default": 1,
					"exemption_reason": ""
				}
			}
		],
		"properties": [],
		"price_classes": [],
		"warehouses": [
			{
				"stock": 0,
				"product_id": 29875257,
				"warehouse_id": 10910
			}
		],
		"child_products": []
	}
}
