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