{
	"name": "table/external/4d/manager/product/product.json",
	"table_name": "product",
	"table_prefix": "pr",
	"table_number": 9,
	"table_name_local": "product",
	"record_type_local": "product",
	"field": [
	{
		"type": "varchar",
		"length": 40,
		"field_number": 33,
		"name": "abc_class"
	},
	{
		"type": "double",
		"field_number": 15,
		"name": "action_limit__unit"
	},
	{
		"type": "double",
		"field_number": 102,
		"name": "actual_average_need"
	},
	{
		"type": "double",
		"field_number": 24,
		"name": "average_balance"
	},
	{
		"type": "date",
		"field_number": 93,
		"name": "average_balance_start_date"
	},
	{
		"type": "double",
		"field_number": 32,
		"name": "average_price"
	},
	{
		"type": "double",
		"field_number": 60,
		"name": "calculated_sales_pr__unit"
	},
	{
		"type": "integer",
		"field_number": 70,
		"name": "calculation_type"
	},
	{
		"type": "varchar",
		"length": 80,
		"field_number": 78,
		"name": "category"
	},
	{
		"type": "date",
		"field_number": 68,
		"name": "change_date"
	},
	{
		"type": "varchar",
		"length": 90,
		"field_number": 3,
		"name": "change_id"
	},
	{
		"type": "double",
		"field_number": 53,
		"name": "coming_amount"
	},
	{
		"type": "double",
		"field_number": 11,
		"name": "conversion_multiplier"
	},
	{
		"type": "varchar",
		"length": 160,
		"field_number": 89,
		"name": "cost_center"
	},
	{
		"type": "double",
		"field_number": 17,
		"name": "cost_price__unit"
	},
	{
		"type": "varchar",
		"length": 40,
		"field_number": 113,
		"name": "creator_id"
	},
	{
		"type": "date",
		"field_number": 87,
		"name": "critical_date"
	},
	{
		"type": "date",
		"field_number": 94,
		"name": "critical_date_real"
	},
	{
		"type": "date",
		"field_number": 96,
		"name": "critical_start_date"
	},
	{
		"type": "date",
		"field_number": 97,
		"name": "critical_start_date_real"
	},
	{
		"field_number": 34,
		"nullable": true,
		"type": "varchar",
		"length": 12,
		"name": "currency_id",
		"foreign_key": {
			"field": "currency_id",
			"table": "currency"
		}
	},
	{
		"field_number": 122,
		"nullable": true,
		"type": "varchar",
		"length": 24,
		"name": "customer_id",
		"foreign_key": {
			"field": "company_id",
			"table": "company"
		}
	},
	{
		"type": "varchar",
		"length": 40,
		"field_number": 121,
		"name": "default_sales_person_id"
	},
	{
		"type": "double",
		"field_number": 42,
		"name": "design_conversion_multip"
	},
	{
		"type": "varchar",
		"length": 10,
		"field_number": 43,
		"name": "design_unit"
	},
	{
		"type": "varchar",
		"length": 10,
		"field_number": 44,
		"name": "design_unit_2"
	},
	{
		"type": "integer",
		"field_number": 124,
		"name": "document_count"
	},
	{
		"type": "varchar",
		"length": 160,
		"field_number": 86,
		"name": "drawing_number__material"
	},
	{
		"type": "integer",
		"field_number": 98,
		"name": "dynamic_act_limit_in_use"
	},
	{
		"type": "double",
		"field_number": 100,
		"name": "dynamic_act_limit_max_val"
	},
	{
		"type": "double",
		"field_number": 99,
		"name": "dynamic_act_limit_min_val"
	},
	{
		"type": "varchar",
		"length": 80,
		"field_number": 61,
		"name": "ean_code"
	},
	{
		"type": "varchar",
		"length": 80,
		"field_number": 62,
		"name": "ean_code2"
	},
	{
		"type": "integer",
		"field_number": 54,
		"name": "effect_of_amount"
	},
	{
		"type": "integer",
		"field_number": 55,
		"name": "effect_of_fixed_size"
	},
	{
		"type": "double",
		"field_number": 103,
		"name": "est_work_time"
	},
	{
		"type": "double",
		"field_number": 85,
		"name": "estimated_average_need"
	},
	{
		"type": "varchar",
		"length": 0,
		"field_number": 67,
		"name": "explanation"
	},
	{
		"type": "double",
		"field_number": 107,
		"name": "external_storage_balance"
	},
	{
		"type": "integer",
		"field_number": 72,
		"name": "firm_id"
	},
	{
		"type": "integer",
		"field_number": 115,
		"name": "forecast_days"
	},
	{
		"type": "double",
		"field_number": 35,
		"name": "foreign_purch_pr__unit"
	},
	{
		"field_number": 30,
		"nullable": true,
		"type": "varchar",
		"length": 12,
		"name": "foreign_sales_ord_code_id",
		"foreign_key": {
			"field": "sales_order_code_id",
			"table": "sales_order_code"
		}
	},
	{
		"type": "double",
		"field_number": 23,
		"name": "free_amount"
	},
	{
		"type": "double",
		"field_number": 22,
		"name": "going_amount"
	},
	{
		"type": "double",
		"field_number": 36,
		"name": "gross_weight"
	},
	{
		"type": "boolean",
		"field_number": 51,
		"name": "in_price_list"
	},
	{
		"type": "varchar",
		"length": 0,
		"field_number": 26,
		"name": "info"
	},
	{
		"type": "date",
		"field_number": 49,
		"name": "inventory_date"
	},
	{
		"type": "boolean",
		"field_number": 46,
		"name": "is_in_enclosure"
	},
	{
		"type": "date",
		"field_number": 25,
		"name": "last_stock_event_date"
	},
	{
		"type": "date",
		"field_number": 111,
		"name": "last_stock_removal_date"
	},
	{
		"type": "double",
		"field_number": 101,
		"name": "manufacturing_average_need"
	},
	{
		"type": "double",
		"field_number": 84,
		"name": "manufacturing_cycle_time"
	},
	{
		"type": "double",
		"field_number": 80,
		"name": "manufacturing_need"
	},
	{
		"type": "varchar",
		"length": 80,
		"field_number": 125,
		"name": "material_class"
	},
	{
		"type": "double",
		"field_number": 118,
		"name": "max_production_amount"
	},
	{
		"type": "double",
		"field_number": 110,
		"name": "max_wanted_stock_balance"
	},
	{
		"type": "double",
		"field_number": 116,
		"name": "maximum_stock"
	},
	{
		"type": "double",
		"field_number": 16,
		"name": "min_purchase_amount__unit"
	},
	{
		"type": "double",
		"field_number": 82,
		"name": "minimum_stock"
	},
	{
		"type": "varchar",
		"length": 40,
		"field_number": 114,
		"name": "modifier_id"
	},
	{
		"type": "varchar",
		"length": 100,
		"field_number": 2,
		"name": "name"
	},
	{
		"type": "boolean",
		"field_number": 19,
		"name": "need_calculation_in_use"
	},
	{
		"type": "double",
		"field_number": 37,
		"name": "net_weight"
	},
	{
		"type": "boolean",
		"field_number": 66,
		"name": "no_automatic_stock_remove"
	},
	{
		"type": "boolean",
		"field_number": 56,
		"name": "no_billing"
	},
	{
		"type": "boolean",
		"field_number": 10,
		"name": "no_discount"
	},
	{
		"type": "boolean",
		"field_number": 52,
		"name": "no_printing"
	},
	{
		"type": "double",
		"field_number": 83,
		"name": "normal_delivery_lot_size"
	},
	{
		"type": "boolean",
		"field_number": 41,
		"name": "not_in_dispatch_note"
	},
	{
		"type": "boolean",
		"field_number": 39,
		"name": "not_in_use"
	},
	{
		"type": "integer",
		"field_number": 88,
		"name": "order_forecast_days"
	},
	{
		"type": "varchar",
		"length": 160,
		"field_number": 126,
		"name": "origin"
	},
	{
		"type": "varchar",
		"length": 40,
		"field_number": 65,
		"name": "parcel_code"
	},
	{
		"type": "text",
		"field_number": 69,
		"name": "picture_path"
	},
	{
		"type": "date",
		"field_number": 21,
		"name": "price_change_date"
	},
	{
		"type": "varchar",
		"length": 88,
		"field_number": 40,
		"name": "price_group_id"
	},
	{
		"type": "varchar",
		"length": 88,
		"field_number": 7,
		"name": "product_code"
	},
	{
		"type": "varchar",
		"length": 30,
		"field_number": 4,
		"name": "product_group"
	},
	{
		"field_number": 1,
		"type": "varchar",
		"length": 88,
		"name": "product_id",
		"constraint": [
			"unique"
		]
	},
	{
		"type": "integer",
		"field_number": 76,
		"name": "production_control_type"
	},
	{
		"type": "double",
		"field_number": 18,
		"name": "profit_multiplier"
	},
	{
		"type": "varchar",
		"length": 80,
		"field_number": 112,
		"name": "project_id"
	},
	{
		"type": "double",
		"field_number": 91,
		"name": "purch_avg_price_amount"
	},
	{
		"type": "date",
		"field_number": 92,
		"name": "purch_avg_price_start_date"
	},
	{
		"type": "double",
		"field_number": 90,
		"name": "purchase_average_price"
	},
	{
		"type": "double",
		"field_number": 8,
		"name": "purchase_multiplier"
	},
	{
		"field_number": 31,
		"nullable": true,
		"type": "varchar",
		"length": 12,
		"name": "purchase_order_code_id",
		"foreign_key": {
			"field": "purchase_order_code_id",
			"table": "purchase_order_code"
		}
	},
	{
		"type": "double",
		"field_number": 28,
		"name": "purchase_price__unit"
	},
	{
		"type": "date",
		"field_number": 127,
		"name": "purchase_price_change_date"
	},
	{
		"type": "varchar",
		"length": 40,
		"field_number": 6,
		"name": "quality"
	},
	{
		"type": "double",
		"field_number": 73,
		"name": "raw_material_delivery_time"
	},
	{
		"type": "integer",
		"field_number": 123,
		"name": "reclamation_count"
	},
	{
		"field_number": 79,
		"type": "varchar",
		"length": 90,
		"name": "record_id",
		"constraint": [
			"unique"
		]
	},
	{
		"type": "double",
		"field_number": 75,
		"name": "safety_stock_duration"
	},
	{
		"field_number": 29,
		"nullable": true,
		"type": "varchar",
		"length": 12,
		"name": "sales_order_code_id",
		"foreign_key": {
			"field": "sales_order_code_id",
			"table": "sales_order_code"
		}
	},
	{
		"type": "double",
		"field_number": 14,
		"name": "sales_price__unit"
	},
	{
		"type": "double",
		"field_number": 108,
		"name": "shelf_stock_balance"
	},
	{
		"type": "varchar",
		"length": 160,
		"field_number": 63,
		"name": "size"
	},
	{
		"type": "double",
		"field_number": 81,
		"name": "spare_part_need"
	},
	{
		"type": "double",
		"field_number": 20,
		"name": "stock_balance__unit"
	},
	{
		"type": "double",
		"field_number": 95,
		"name": "stock_balance_wip"
	},
	{
		"type": "integer",
		"field_number": 74,
		"name": "stock_limit_calc_type"
	},
	{
		"type": "boolean",
		"field_number": 50,
		"name": "stock_parcel_in_use"
	},
	{
		"type": "varchar",
		"length": 40,
		"field_number": 64,
		"name": "stock_position"
	},
	{
		"type": "boolean",
		"field_number": 9,
		"name": "storable"
	},
	{
		"type": "varchar",
		"length": 30,
		"field_number": 5,
		"name": "subgroup"
	},
	{
		"field_number": 27,
		"nullable": true,
		"type": "varchar",
		"length": 24,
		"name": "supplier_id",
		"foreign_key": {
			"field": "supplier_id",
			"table": "supplier"
		}
	},
	{
		"type": "varchar",
		"length": 100,
		"field_number": 48,
		"name": "supplier_material_code"
	},
	{
		"type": "boolean",
		"field_number": 58,
		"name": "supplier_price_in_use"
	},
	{
		"type": "varchar",
		"length": 30,
		"field_number": 57,
		"name": "tariff_heading"
	},
	{
		"type": "integer",
		"field_number": 120,
		"name": "track_time_status"
	},
	{
		"type": "varchar",
		"length": 120,
		"field_number": 109,
		"name": "transfer_id"
	},
	{
		"type": "integer",
		"field_number": 117,
		"name": "transfer_state"
	},
	{
		"type": "double",
		"field_number": 104,
		"name": "true_coming_amount"
	},
	{
		"type": "double",
		"field_number": 106,
		"name": "true_free_amount"
	},
	{
		"type": "double",
		"field_number": 105,
		"name": "true_going_amount"
	},
	{
		"type": "integer",
		"field_number": 71,
		"name": "type_"
	},
	{
		"type": "double",
		"field_number": 77,
		"name": "unfinished_orders_in_weeks"
	},
	{
		"type": "varchar",
		"length": 10,
		"field_number": 12,
		"name": "unit"
	},
	{
		"type": "double",
		"field_number": 45,
		"name": "unit__design_unit_multip"
	},
	{
		"type": "varchar",
		"length": 10,
		"field_number": 13,
		"name": "unit_2"
	},
	{
		"type": "double",
		"field_number": 38,
		"name": "volume"
	},
	{
		"field_number": 47,
		"nullable": true,
		"type": "varchar",
		"length": 60,
		"name": "work__position_num_id",
		"foreign_key": {
			"field": "work__position_num_id",
			"table": "work"
		}
	},
	{
		"type": "varchar",
		"length": 24,
		"field_number": 59,
		"name": "work_load_group"
	},
	{
		"type": "integer",
		"field_number": 119,
		"name": "work_order_type"
	}
]
}
