{
	"name": "table/external/4d/manager/product/work_phase_actual.json",
	"table_name": "work_phase_actual",
	"table_prefix": "wpa",
	"table_number": 48,
	"record_type": ["actual"],
	"main_table": "work_order",
	"default_field": "table/default_field.json",
	"local_record_type": "actual",
	"local_table": "product_work",
	"field": [
	{
		"field_name": "additional_data",
		"field_number": 71,
		"local_field": "json_data"
	},
	{
		"field_length": 90,
		"field_name": "change_id",
		"field_number": 59,
		"local_field": "modify_id"
	},
	{
		"field_name": "contract_multiplier",
		"field_number": 31,
		"local_field": "json_data.contract_multiplier"
	},
	{
		"field_name": "contract_price__unit",
		"field_number": 12,
		"local_field": "json_data.contract_price__unit"
	},
	{
		"field_name": "contract_salary",
		"field_number": 22,
		"local_field": "json_data.contract_salary"
	},
	{
		"field_length": 40,
		"field_name": "cost_center",
		"field_number": 33,
		"local_field": "json_data.cost_center"
	},
	{
		"field_length": 40,
		"field_name": "creator_id",
		"field_number": 60,
		"local_field": "create_user"
	},
	{
		"field_length": 80,
		"field_name": "customer_project",
		"field_number": 57,
		"local_field": "json_data.customer_project"
	},
	{
		"field_name": "date_",
		"field_number": 15,
		"field_type": "date",
		"local_field": "json_data.end_date"
	},
	{
		"field_length": 24,
		"field_name": "employee_id",
		"field_number": 3,
		"foreign_key": [
		{
			"link_type": "prevent delete",
			"linked_field": "employee_id",
			"linked_table": "employee"
		}],
		"local_field": "person_id",
		"nullable": true
	},
	{
		"field_name": "end_time",
		"field_number": 41,
		"local_field": "json_data.end_time"
	},
	{
		"field_name": "est_bonus_work_time__unit",
		"field_number": 48,
		"local_field": "json_data.est_bonus_work_time__unit"
	},
	{
		"field_name": "est_contract_price__unit",
		"field_number": 53,
		"local_field": "json_data.est_contract_price__unit"
	},
	{
		"field_name": "est_machine_setup_cost__hour",
		"field_number": 51,
		"local_field": "json_data.est_machine_setup_cost__hour"
	},
	{
		"field_name": "est_machine_work_cost__hour",
		"field_number": 52,
		"local_field": "json_data.est_machine_work_cost__hour"
	},
	{
		"field_name": "est_salary__hour",
		"field_number": 50,
		"local_field": "json_data.est_salary__hour"
	},
	{
		"field_name": "est_setup_salary__hour",
		"field_number": 49,
		"local_field": "json_data.est_setup_salary__hour"
	},
	{
		"field_name": "est_setup_time__lot",
		"field_number": 47,
		"local_field": "json_data.est_setup_hours"
	},
	{
		"field_name": "est_work_time__unit",
		"field_number": 46,
		"local_field": "json_data.est_work_time__unit"
	},
	{
		"field_name": "evening_work_hours",
		"field_number": 29,
		"local_field": "json_data.evening_work_hours"
	},
	{
		"field_name": "failed_amount",
		"field_number": 34,
		"local_field": "failed_amount"
	},
	{
		"field_name": "firm_id",
		"field_number": 40,
		"local_field": "json_data.firm_id"
	},
	{
		"field_name": "hourly_salary",
		"field_number": 14,
		"local_field": "json_data.hourly_salary"
	},
	{
		"field_name": "info",
		"field_number": 17,
		"local_field": "info"
	},
	{
		"field_name": "kind",
		"field_number": 20,
		"local_field": "json_data.kind"
	},
	{
		"field_name": "machine_hours",
		"field_number": 27,
		"local_field": "machine_hours"
	},
	{
		"field_name": "machine_setup_cost__hour",
		"field_number": 10,
		"local_field": "setup_hourly_self_cost"
	},
	{
		"field_name": "machine_work_cost__hour",
		"field_number": 11,
		"local_field": "work_hourly_self_cost"
	},
	{
		"field_name": "measured_track_time",
		"field_number": 73,
		"local_field": "json_data.measured_track_time"
	},
	{
		"field_length": 40,
		"field_name": "modifier_id",
		"field_number": 61,
		"local_field": "json_data.modifier_id"
	},
	{
		"field_name": "night_work_hours",
		"field_number": 30,
		"local_field": "json_data.night_work_hours"
	},
	{
		"field_length": 80,
		"field_name": "parcel_code",
		"field_number": 65,
		"local_field": "json_data.parcel_code"
	},
	{
		"field_name": "produced_amount",
		"field_number": 5,
		"local_field": "produced_amount"
	},
	{
		"field_length": 70,
		"field_name": "production_lot",
		"local_field": "production_lot",
		"nullable": true,
		"field_number": 19,
		"foreign_key": [
		{
			"link_type": "prevent delete",
			"linked_field": "production_lot",
			"linked_table": "work_order"
		},
		{
			"link_type": "",
			"linked_field": "production_lot",
			"linked_table": "work_order_schedule",
			"info": "4D production_lot to work_order_schedule",
			"extra_link_field": [{ "linking": "work_phase_est_id", "linked": "work_phase" }],
			"extra_join": ""
		}]
	},
	{
		"field_name": "profit_multiplier",
		"field_number": 23,
		"local_field": "profit_multiplier"
	},
	{
		"field_length": 80,
		"field_name": "program_id",
		"field_number": 54,
		"local_field": "json_data.program_id"
	},
	{
		"field_length": 80,
		"field_name": "project_id",
		"field_number": 58,
		"local_field": "json_data.project_id"
	},
	{
		"constraint": ["unique"],
		"field_length": 90,
		"field_name": "record_id",
		"field_number": 39,
		"local_field": "record_id"
	},
	{
		"field_name": "salary__hour",
		"field_number": 9,
		"local_field": "work_hourly_salary"
	},
	{
		"field_name": "salary_bonus",
		"field_number": 26,
		"local_field": "json_data.salary_bonus"
	},
	{
		"field_name": "setup_salary__hour",
		"field_number": 8,
		"local_field": "setup_hourly_salary"
	},
	{
		"field_name": "setup_time__amount",
		"field_number": 7,
		"local_field": "setup_hours"
	},
	{
		"field_name": "shift_number",
		"field_number": 45,
		"local_field": "json_data.work_shift"
	},
	{
		"field_length": 80,
		"field_name": "show_type",
		"field_number": 74
	},
	{
		"field_length": 80,
		"field_name": "smelting_num",
		"field_number": 35,
		"local_field": "json_data.smelting_num"
	},
	{
		"field_name": "social_cost_multiplier",
		"field_number": 32,
		"local_field": "json_data.social_cost_multiplier"
	},
	{
		"field_name": "start_date",
		"field_number": 42,
		"field_type": "date",
		"local_field": "json_data.start_date"
	},
	{
		"field_length": 24,
		"field_name": "start_employee_id",
		"field_number": 68,
		"local_field": "json_data.start_person_id"
	},
	{
		"field_name": "start_shift_number",
		"field_number": 69,
		"local_field": "json_data.start_work_shift"
	},
	{
		"field_length": 40,
		"field_name": "start_subtype",
		"field_number": 70,
		"local_field": "json_data.start_subtype"
	},
	{
		"field_name": "start_time",
		"field_number": 43,
		"local_field": "json_data.start_time"
	},
	{
		"field_name": "started_amount",
		"field_number": 55,
		"local_field": "started_amount"
	},
	{
		"field_length": 20,
		"field_name": "stock_event_id",
		"field_number": 28,
		"local_field": "json_data.stock_event_id"
	},
	{
		"field_name": "subcontract",
		"field_number": 37,
		"local_field": "subcontract"
	},
	{
		"field_length": 40,
		"field_name": "subtype",
		"field_number": 66,
		"local_field": "json_data.subtype"
	},
	{
		"field_length": 40,
		"field_name": "supplier_id",
		"field_number": 38,
		"foreign_key": [
		{
			"link_type": "prevent delete",
			"linked_field": "supplier_id",
			"linked_table": "supplier"
		}],
		"local_field": "json_data.supplier_id",
		"nullable": true
	},
	{
		"field_name": "target_machine_time",
		"field_number": 72,
		"local_field": "json_data.target_machine_time"
	},
	{
		"field_name": "target_time",
		"field_number": 67,
		"local_field": "json_data.target_time"
	},
	{
		"field_name": "track_time",
		"field_number": 63,
		"local_field": "json_data.track_time"
	},
	{
		"field_name": "track_time_status",
		"field_number": 64,
		"local_field": "json_data.track_time_status"
	},
	{
		"field_length": 120,
		"field_name": "transfer_id",
		"field_number": 56,
		"local_field": "json_data.transfer_id"
	},
	{
		"field_name": "transfer_state",
		"field_number": 62,
		"local_field": "json_data.transfer_state"
	},
	{
		"field_length": 70,
		"field_name": "type_",
		"field_number": 4,
		"local_field": "work_phase_type"
	},
	{
		"field_name": "unpaid_hours",
		"field_number": 44,
		"local_field": "json_data.unpaid_hours"
	},
	{
		"field_length": 24,
		"field_name": "user_id",
		"field_number": 21,
		"local_field": "json_data.user_id"
	},
	{
		"field_length": 60,
		"field_name": "work__position_num_id",
		"field_number": 1,
		"foreign_key": [
		{
			"link_type": "prevent delete",
			"linked_field": "work__position_num_id",
			"linked_table": "work"
		}],
		"local_field": "json_data.work_number",
		"nullable": true
	},
	{
		"field_name": "work_cost_price__amount",
		"field_number": 24,
		"local_field": "cost_price"
	},
	{
		"field_name": "work_description",
		"field_number": 16,
		"local_field": "description"
	},
	{
		"field_length": 24,
		"field_name": "work_load_group_id",
		"field_number": 2,
		"foreign_key": [
		{
			"link_type": "prevent delete",
			"linked_field": "work_load_group_id",
			"linked_table": "work_load_group"
		}],
		"local_field": "resource_id",
		"nullable": true
	},
	{
		"field_length": 80,
		"field_name": "work_location_id",
		"field_number": 75
	},
	{
		"field_name": "work_phase_actual_id",
		"field_number": 36,
		"local_field": "json_data.work_phase_actual_id"
	},
	{
		"field_name": "work_phase_est_id",
		"field_number": 18,
		"local_field": "work_phase_number"
	},
	{
		"field_name": "work_salary__amount",
		"field_number": 13,
		"field_type": "double",
		"local_field": "salary"
	},
	{
		"field_name": "work_sales_price__amount",
		"field_number": 25,
		"field_type": "double",
		"local_field": "sales_price"
	},
	{
		"field_name": "work_time__amount",
		"field_number": 6,
		"field_type": "double",
		"local_field": "work_hours"
	},
	{
		"field_name": "previous_track_time",
		"field_number": 76,
		"field_type": "double",
		"local_field": "json_data.previous_track_time"
	}]
}
