{
	"name": "table/external/4d/product/product.json",
	"table_name": "product",
	"table_prefix": "pr",
	"record_type": [""],
	"local_table": "product",
	"local_record_type": "",
	"table_number": 9,
	"run_script": [
		{
			"table": "product",
			"init_new_record": true,
			"script_field": ["pr.purchase_price"]
		}
	],
	"field": [
		{
			"field_name": "abc_class",
			"local_field": "json_data.abc_class",
			"field_type": "varchar",
			"field_length": 20,
			"field_number": 33,
			"constraint": ["index"]
		},
		{
			"field_name": "action_limit__unit",
			"local_field": "json_data.action_limit",
			"field_type": "double",
			"field_number": 15,
			"constraint": ["index"]
		},
		{
			"field_name": "actual_average_need",
			"local_field": "json_data.actual_average_need",
			"field_type": "double",
			"field_number": 102
		},
		{
			"field_name": "average_balance",
			"local_field": "json_data.average_balance",
			"field_type": "double",
			"field_number": 24
		},
		{
			"field_name": "average_balance_start_date",
			"local_field": "json_data.average_balance_start_date",
			"field_type": "date",
			"field_number": 93
		},
		{
			"field_name": "average_price",
			"local_field": "json_data.average_price",
			"field_type": "double",
			"field_number": 32
		},
		{
			"field_name": "calculated_sales_pr__unit",
			"local_field": "json_data.calculated_sales_pr__unit",
			"field_type": "double",
			"field_number": 60
		},
		{
			"field_name": "calculation_type",
			"local_field": "json_data.calculation_type",
			"field_type": "integer",
			"field_number": 70
		},
		{
			"field_name": "category",
			"local_field": "json_data.category",
			"field_type": "varchar",
			"field_length": 40,
			"field_number": 78
		},
		{
			"field_name": "change_date",
			"local_field": "modify_time",
			"field_type": "date",
			"field_number": 68,
			"constraint": ["index"]
		},
		{
			"field_name": "change_id",
			"local_field": "modify_id",
			"field_type": "varchar",
			"field_length": 45,
			"field_number": 3,
			"constraint": ["index"]
		},
		{
			"field_name": "coming_amount",
			"local_field": "json_data.coming_amount",
			"field_type": "double",
			"field_number": 53
		},
		{
			"field_name": "conversion_multiplier",
			"local_field": "unit_multiplier",
			"field_type": "double",
			"field_number": 11
		},
		{
			"field_name": "cost_center",
			"local_field": "json_data.cost_center",
			"field_type": "varchar",
			"field_length": 80,
			"field_number": 89
		},
		{
			"field_name": "cost_price__unit",
			"local_field": "cost_price",
			"field_type": "double",
			"field_number": 17
		},
		{
			"field_name": "creator_id",
			"local_field": "json_data.create_user",
			"field_type": "varchar",
			"field_length": 20,
			"field_number": 113
		},
		{
			"field_name": "critical_date",
			"local_field": "json_data.critical_end_date",
			"field_type": "date",
			"field_number": 87,
			"constraint": ["index"]
		},
		{
			"field_name": "critical_date_real",
			"local_field": "json_data.critical_end_date_real",
			"field_type": "date",
			"field_number": 94,
			"constraint": ["index"]
		},
		{
			"field_name": "critical_start_date",
			"local_field": "json_data.critical_date",
			"field_type": "date",
			"field_number": 96,
			"constraint": ["index"]
		},
		{
			"field_name": "critical_start_date_real",
			"local_field": "json_data.critical_date_real",
			"field_type": "date",
			"field_number": 97,
			"constraint": ["index"]
		},
		{
			"field_name": "currency_id",
			"local_field": "json_data.currency_id",
			"field_type": "varchar",
			"field_length": 6,
			"field_number": 34,
			"constraint": ["index"],
			"foreign_key": [
				{
					"link_type": "prevent delete",
					"linked_field": "currency_id",
					"linked_table": "currency"
				}
			],
			"nullable": true
		},
		{
			"field_name": "customer_id",
			"local_field": "json_data.default_customer_id",
			"field_type": "varchar",
			"field_length": 12,
			"field_number": 122,
			"constraint": ["index"],
			"foreign_key": [
				{
					"link_type": "prevent delete",
					"linked_field": "company_id",
					"linked_table": "company"
				}
			],
			"nullable": true
		},
		{
			"field_name": "default_sales_person_id",
			"local_field": "json_data.default_sales_person_id",
			"field_type": "varchar",
			"field_length": 20,
			"field_number": 121,
			"constraint": ["index"]
		},
		{
			"field_name": "design_conversion_multip",
			"local_field": "json_data.design_conversion_multiplier",
			"field_type": "double",
			"field_number": 42
		},
		{
			"field_name": "design_unit",
			"local_field": "design_unit",
			"field_type": "varchar",
			"field_length": 5,
			"field_number": 43
		},
		{
			"field_name": "design_unit_2",
			"local_field": "json_data.design_unit_2",
			"field_type": "varchar",
			"field_length": 5,
			"field_number": 44
		},
		{
			"field_name": "document_count",
			"local_field": "json_data.document_count",
			"field_type": "integer",
			"field_number": 124
		},
		{
			"field_name": "drawing_number__material",
			"local_field": "drawing_number",
			"field_type": "varchar",
			"field_length": 80,
			"field_number": 86
		},
		{
			"field_name": "dynamic_act_limit_in_use",
			"local_field": "json_data.dynamic_act_limit_in_use",
			"field_type": "integer",
			"field_number": 98
		},
		{
			"field_name": "dynamic_act_limit_max_val",
			"local_field": "json_data.dynamic_act_limit_max_val",
			"field_type": "double",
			"field_number": 100
		},
		{
			"field_name": "dynamic_act_limit_min_val",
			"local_field": "json_data.dynamic_act_limit_min_val",
			"field_type": "double",
			"field_number": 99
		},
		{
			"field_name": "ean_code",
			"local_field": "ean_code",
			"field_type": "varchar",
			"field_length": 40,
			"field_number": 61
		},
		{
			"field_name": "ean_code2",
			"local_field": "json_data.ean_code2",
			"field_type": "varchar",
			"field_length": 40,
			"field_number": 62
		},
		{
			"field_name": "effect_of_amount",
			"local_field": "json_data.effect_of_amount",
			"field_type": "integer",
			"field_number": 54
		},
		{
			"field_name": "effect_of_fixed_size",
			"local_field": "json_data.effect_of_fixed_size",
			"field_type": "integer",
			"field_number": 55
		},
		{
			"field_name": "est_work_time",
			"local_field": "json_data.work_time",
			"field_type": "double",
			"field_number": 103
		},
		{
			"field_name": "estimated_average_need",
			"local_field": "json_data.estimated_average_need",
			"field_type": "double",
			"field_number": 85
		},
		{
			"field_name": "explanation",
			"local_field": "json_data.explanation",
			"field_type": "text",
			"field_number": 67
		},
		{
			"field_name": "external_storage_balance",
			"local_field": "json_data.external_stock_balance",
			"field_type": "double",
			"field_number": 107
		},
		{
			"field_name": "firm_id",
			"local_field": "json_data.firm_id",
			"field_type": "integer",
			"field_number": 72,
			"constraint": ["index"]
		},
		{
			"field_name": "forecast_days",
			"local_field": "json_data.forecast_days",
			"field_type": "integer",
			"field_number": 115
		},
		{
			"field_name": "foreign_purch_pr__unit",
			"local_field": "json_data.foreign_purch_pr__unit",
			"field_type": "double",
			"field_number": 35
		},
		{
			"field_name": "foreign_sales_ord_code_id",
			"local_field": "json_data.foreign_sales_order_code_id",
			"field_type": "varchar",
			"field_length": 6,
			"field_number": 30,
			"constraint": ["index"],
			"foreign_key": [
				{
					"info": "aga, check",
					"link_type": "prevent delete",
					"linked_field": "sales_order_code_id",
					"linked_table": "sales_order_code"
				}
			],
			"nullable": true
		},
		{
			"field_name": "free_amount",
			"local_field": "json_data.free_amount",
			"field_type": "double",
			"field_number": 23
		},
		{
			"field_name": "going_amount",
			"local_field": "json_data.going_amount",
			"field_type": "double",
			"field_number": 22
		},
		{
			"field_name": "gross_weight",
			"local_field": "json_data.gross_weight",
			"field_type": "double",
			"field_number": 36
		},
		{
			"field_name": "in_price_list",
			"local_field": "json_data.in_price_list",
			"field_type": "boolean",
			"field_number": 51,
			"constraint": ["index"]
		},
		{
			"field_name": "info",
			"local_field": "info",
			"field_type": "text",
			"field_number": 26
		},
		{
			"field_name": "inventory_date",
			"local_field": "json_data.inventory_date",
			"field_type": "date",
			"field_number": 49,
			"constraint": ["index"]
		},
		{
			"field_name": "is_in_enclosure",
			"local_field": "json_data.is_in_enclosure",
			"field_type": "boolean",
			"field_number": 46
		},
		{
			"field_name": "last_stock_event_date",
			"local_field": "json_data.last_stock_event_date",
			"field_type": "date",
			"field_number": 25,
			"constraint": ["index"]
		},
		{
			"field_name": "last_stock_removal_date",
			"local_field": "json_data.last_stock_removal_date",
			"field_type": "date",
			"field_number": 111,
			"constraint": ["index"]
		},
		{
			"field_name": "manufacturing_average_need",
			"local_field": "json_data.manufacturing_average_need",
			"field_type": "double",
			"field_number": 101
		},
		{
			"field_name": "manufacturing_cycle_time",
			"local_field": "json_data.manufacturing_cycle_time",
			"field_type": "double",
			"field_number": 84
		},
		{
			"field_name": "manufacturing_need",
			"local_field": "json_data.manufacturing_need",
			"field_type": "double",
			"field_number": 80
		},
		{
			"field_name": "material_class",
			"local_field": "json_data.material_class",
			"field_type": "varchar",
			"field_length": 40,
			"field_number": 125,
			"constraint": ["index"]
		},
		{
			"field_name": "max_production_amount",
			"local_field": "json_data.max_production_amount",
			"field_type": "double",
			"field_number": 118
		},
		{
			"field_name": "max_wanted_stock_balance",
			"local_field": "json_data.max_wanted_stock_balance",
			"field_type": "double",
			"field_number": 110
		},
		{
			"field_name": "maximum_stock",
			"local_field": "json_data.maximum_stock",
			"field_type": "double",
			"field_number": 116
		},
		{
			"field_name": "min_purchase_amount__unit",
			"local_field": "minimum_order_amount",
			"field_type": "double",
			"field_number": 16
		},
		{
			"field_name": "minimum_stock",
			"local_field": "minimum_stock",
			"field_type": "double",
			"field_number": 82,
			"constraint": ["index"]
		},
		{
			"field_name": "modifier_id",
			"local_field": "modify_user",
			"field_type": "varchar",
			"field_length": 20,
			"field_number": 114
		},
		{
			"field_name": "name",
			"local_field": "name",
			"field_type": "varchar",
			"field_length": 50,
			"field_number": 2,
			"constraint": ["index"]
		},
		{
			"field_name": "need_calculation_in_use",
			"local_field": "json_data.need_calculation_in_use",
			"field_type": "boolean",
			"field_number": 19,
			"constraint": ["index"]
		},
		{
			"field_name": "net_weight",
			"local_field": "json_data.net_weight",
			"field_type": "double",
			"field_number": 37
		},
		{
			"field_name": "no_automatic_stock_remove",
			"local_field": "json_data.no_automatic_stock_remove",
			"field_type": "boolean",
			"field_number": 66
		},
		{
			"field_name": "no_billing",
			"local_field": "json_data.no_billing",
			"field_type": "boolean",
			"field_number": 56
		},
		{
			"field_name": "no_discount",
			"local_field": "json_data.no_discount",
			"field_type": "boolean",
			"field_number": 10,
			"constraint": ["index"]
		},
		{
			"field_name": "no_printing",
			"local_field": "json_data.no_printing",
			"field_type": "boolean",
			"field_number": 52
		},
		{
			"field_name": "normal_delivery_lot_size",
			"local_field": "json_data.normal_delivery_lot_size",
			"field_type": "double",
			"field_number": 83
		},
		{
			"field_name": "not_in_dispatch_note",
			"local_field": "json_data.not_in_dispatch_note",
			"field_type": "boolean",
			"field_number": 41
		},
		{
			"field_name": "not_in_use",
			"local_field": "json_data.not_in_use",
			"field_type": "boolean",
			"field_number": 39,
			"constraint": ["index"]
		},
		{
			"field_name": "order_forecast_days",
			"local_field": "json_data.order_forecast_days",
			"field_type": "integer",
			"field_number": 88
		},
		{
			"field_name": "origin",
			"local_field": "json_data.origin",
			"field_type": "varchar",
			"field_length": 80,
			"field_number": 126
		},
		{
			"field_name": "parcel_code",
			"local_field": "json_data.parcel_code",
			"field_type": "varchar",
			"field_length": 20,
			"field_number": 65,
			"constraint": ["index"]
		},
		{
			"field_name": "picture_path",
			"local_field": "json_data.picture_path",
			"field_type": "text",
			"field_number": 69
		},
		{
			"field_name": "price_change_date",
			"local_field": "json_data.price_change_date",
			"field_type": "date",
			"field_number": 21,
			"constraint": ["index"]
		},
		{
			"field_name": "price_group_id",
			"local_field": "json_data.price_group",
			"field_type": "varchar",
			"field_length": 44,
			"field_number": 40,
			"constraint": ["index"]
		},
		{
			"field_name": "product_code",
			"local_field": "json_data.product_code",
			"field_type": "varchar",
			"field_length": 44,
			"field_number": 7,
			"constraint": ["index"]
		},
		{
			"field_name": "product_group",
			"local_field": "product_group",
			"field_type": "varchar",
			"field_length": 15,
			"field_number": 4,
			"constraint": ["index"]
		},
		{
			"field_name": "product_id",
			"local_field": "product_id",
			"field_type": "varchar",
			"field_length": 44,
			"field_number": 1,
			"constraint": ["primary key"]
		},
		{
			"field_name": "production_control_type",
			"local_field": "production_type",
			"field_type": "integer",
			"field_number": 76,
			"constraint": ["index"]
		},
		{
			"field_name": "profit_multiplier",
			"local_field": "profit_multiplier",
			"field_type": "double",
			"field_number": 18
		},
		{
			"field_name": "project_id",
			"local_field": "json_data.project_id",
			"field_type": "varchar",
			"field_length": 40,
			"field_number": 112
		},
		{
			"field_name": "purch_avg_price_amount",
			"local_field": "json_data.purch_avg_price_amount",
			"field_type": "double",
			"field_number": 91
		},
		{
			"field_name": "purch_avg_price_start_date",
			"local_field": "json_data.purch_avg_price_start_date",
			"field_type": "date",
			"field_number": 92
		},
		{
			"field_name": "purchase_average_price",
			"local_field": "json_data.purchase_average_price",
			"field_type": "double",
			"field_number": 90
		},
		{
			"field_name": "purchase_multiplier",
			"local_field": "purchase_multiplier",
			"field_type": "double",
			"field_number": 8
		},
		{
			"field_name": "purchase_order_code_id",
			"local_field": "purchase_order_code_id",
			"field_type": "varchar",
			"field_length": 6,
			"field_number": 31,
			"constraint": ["index"],
			"foreign_key": [
				{
					"link_type": "prevent delete",
					"linked_field": "purchase_order_code_id",
					"linked_table": "purchase_order_code"
				}
			],
			"nullable": true
		},
		{
			"field_name": "purchase_price__unit",
			"local_field": "purchase_price",
			"field_type": "double",
			"field_number": 28
		},
		{
			"field_name": "purchase_price_change_date",
			"local_field": "json_data.purchase_price_change_date",
			"field_type": "date",
			"field_number": 127
		},
		{
			"field_name": "quality",
			"local_field": "quality",
			"field_type": "varchar",
			"field_length": 20,
			"field_number": 6,
			"constraint": ["index"]
		},
		{
			"field_name": "raw_material_delivery_time",
			"local_field": "json_data.raw_material_delivery_time",
			"field_type": "double",
			"field_number": 73
		},
		{
			"field_name": "reclamation_count",
			"local_field": "json_data.reclamation_count",
			"field_type": "integer",
			"field_number": 123
		},
		{
			"field_name": "record_id",
			"local_field": "record_id",
			"field_type": "varchar",
			"field_length": 45,
			"field_number": 79,
			"constraint": ["unique"]
		},
		{
			"field_name": "safety_stock_duration",
			"local_field": "json_data.safety_stock_duration",
			"field_type": "double",
			"field_number": 75
		},
		{
			"field_name": "sales_order_code_id",
			"local_field": "sales_order_code_id",
			"field_type": "varchar",
			"field_length": 6,
			"field_number": 29,
			"constraint": ["index"],
			"foreign_key": [
				{
					"info": "aga, check",
					"default_link": true,
					"link_type": "prevent delete",
					"linked_field": "sales_order_code_id",
					"linked_table": "sales_order_code"
				}
			],
			"nullable": true
		},
		{
			"field_name": "sales_price__unit",
			"local_field": "sales_price",
			"field_type": "double",
			"field_number": 14
		},
		{
			"field_name": "shelf_stock_balance",
			"local_field": "json_data.shelf_stock_balance",
			"field_type": "double",
			"field_number": 108,
			"constraint": ["index"]
		},
		{
			"field_name": "size",
			"local_field": "json_data.size",
			"field_type": "varchar",
			"field_length": 80,
			"field_number": 63
		},
		{
			"field_name": "spare_part_need",
			"local_field": "json_data.spare_part_need",
			"field_type": "double",
			"field_number": 81
		},
		{
			"field_name": "stock_balance__unit",
			"local_field": "json_data.stock_balance",
			"field_type": "double",
			"field_number": 20,
			"constraint": ["index"]
		},
		{
			"field_name": "stock_balance_wip",
			"local_field": "json_data.stock_balance_wip",
			"field_type": "double",
			"field_number": 95,
			"constraint": ["index"]
		},
		{
			"field_name": "stock_limit_calc_type",
			"local_field": "json_data.stock_limit_calc_type",
			"field_type": "integer",
			"field_number": 74
		},
		{
			"field_name": "stock_parcel_in_use",
			"local_field": "json_data.stock_parcel_in_use",
			"field_type": "boolean",
			"field_number": 50
		},
		{
			"field_name": "stock_position",
			"local_field": "json_data.stock_position",
			"field_type": "varchar",
			"field_length": 20,
			"field_number": 64,
			"constraint": ["index"]
		},
		{
			"field_name": "storable",
			"local_field": "stock_type",
			"field_type": "boolean",
			"field_number": 9,
			"constraint": ["index"]
		},
		{
			"field_name": "subgroup",
			"local_field": "subgroup",
			"field_type": "varchar",
			"field_length": 15,
			"field_number": 5,
			"constraint": ["index"]
		},
		{
			"field_name": "supplier_id",
			"local_field": "default_supplier_id",
			"field_type": "varchar",
			"field_length": 12,
			"field_number": 27,
			"foreign_key": [
				{
					"link_type": "prevent delete",
					"linked_field": "supplier_id",
					"linked_table": "supplier"
				}
			],
			"nullable": true
		},
		{
			"field_name": "supplier_material_code",
			"local_field": "json_data.supplier_product_code",
			"field_type": "varchar",
			"field_length": 50,
			"field_number": 48,
			"constraint": ["index"]
		},
		{
			"field_name": "supplier_price_in_use",
			"local_field": "json_data.supplier_price_in_use",
			"field_type": "boolean",
			"field_number": 58
		},
		{
			"field_name": "tariff_heading",
			"local_field": "json_data.tariff_heading",
			"field_type": "varchar",
			"field_length": 15,
			"field_number": 57
		},
		{
			"field_name": "track_time_status",
			"local_field": "json_data.track_time_status",
			"field_type": "integer",
			"field_number": 120
		},
		{
			"field_name": "transfer_id",
			"local_field": "json_data.transfer_id",
			"field_type": "varchar",
			"field_length": 60,
			"field_number": 109,
			"constraint": ["index"]
		},
		{
			"field_name": "transfer_state",
			"local_field": "json_data.transfer_state",
			"field_type": "integer",
			"field_number": 117
		},
		{
			"field_name": "true_coming_amount",
			"local_field": "json_data.true_coming_amount",
			"field_type": "double",
			"field_number": 104
		},
		{
			"field_name": "true_free_amount",
			"local_field": "json_data.true_free_amount",
			"field_type": "double",
			"field_number": 106
		},
		{
			"field_name": "true_going_amount",
			"local_field": "json_data.true_going_amount",
			"field_type": "double",
			"field_number": 105
		},
		{
			"field_name": "type_",
			"local_field": "product_type",
			"field_type": "integer",
			"field_number": 71,
			"constraint": ["index"]
		},
		{
			"field_name": "unfinished_orders_in_weeks",
			"local_field": "json_data.unfinished_orders_in_weeks",
			"field_type": "double",
			"field_number": 77
		},
		{
			"field_name": "unit",
			"local_field": "stock_unit",
			"field_type": "varchar",
			"field_length": 5,
			"field_number": 12
		},
		{
			"field_name": "unit_2",
			"local_field": "json_data.stock_unit_2",
			"field_type": "varchar",
			"field_length": 5,
			"field_number": 13
		},
		{
			"field_name": "unit__design_unit_multip",
			"local_field": "json_data.unit_design_unit_multiplier",
			"field_type": "double",
			"field_number": 45
		},
		{
			"field_name": "volume",
			"local_field": "json_data.volume",
			"field_type": "double",
			"field_number": 38
		},
		{
			"field_name": "work__position_num_id",
			"local_field": "work_number_id",
			"field_type": "varchar",
			"field_length": 30,
			"field_number": 47,
			"constraint": ["index"],
			"foreign_key": [
				{
					"join_type": "INNER JOIN",
					"link_type": "prevent delete",
					"linked_field": "work__position_num_id",
					"linked_table": "work"
				}
			],
			"nullable": true
		},
		{
			"field_name": "work_load_group",
			"local_field": "json_data.work_resource",
			"field_type": "varchar",
			"field_length": 12,
			"field_number": 59,
			"constraint": ["index"]
		},
		{
			"field_name": "work_order_type",
			"local_field": "json_data.work_order_type",
			"field_type": "integer",
			"field_number": 119
		},
		{
			"field_name": "normal_purchase_amount",
			"local_field": "json_data.normal_purchase_amount",
			"field_type": "double",
			"field_number": 128
		},
		{
			"field_name": "fixed",
			"local_field": "json_data.fixed",
			"field_type": "double",
			"field_number": 130,
			"constraint": ["index"]
		},
		{
			"field_name": "available",
			"local_field": "json_data.available",
			"field_type": "double",
			"field_number": 131,
			"constraint": ["index"]
		},
		{
			"field_name": "reserved",
			"local_field": "json_data.reserved",
			"field_type": "double",
			"field_number": 129,
			"constraint": ["index"]
		}
	],
	"default_value": {
		"copy_value": {
			"cost_price": "sales_price",
			"json_data.product_code": "product_id",
			"purchase_price": "sales_price",
			"sales_price__unit": "sales_price"
		},
		"static": {
			"unit_multiplier": 1,
			"json_data.design_conversion_multiplier": 1,
			"json_data.unit_design_unit_multiplier": 1,
			"design_unit": "kpl",
			"json_data.design_unit_2": "kpl",
			"currency_id": "EUR",
			"json_data.foreign_sales_order_code_id": "U",
			"minimum_order_amount": 1,
			"normal_delivery_lot_size": 1,
			"product_group": "WEB",
			"product_type": 3,
			"profit_multiplier": 1,
			"purchase_multiplier": 1,
			"purchase_order_code_id": "O24",
			"sales_order_code_id": "M24",
			"stock_unit": "kpl",
			"json_data.stock_unit_2": "kpl",
			"stock_type": true
		}
	}
}
