Default Table & Sync configuration

Owned by Michiel van Beers
Last updated: 15-06-2023
1 min read

Versions 

R8.0, R9.0

Last updated

Jul 6, 2022 

Starting from R8.0, you can dynamically synchronize tables to the mobile applications, by adding them as a record in the Table Configuration. This also means that any table or field that is not part of the configuration will therefor not be synced. 

Overview default table configuration

Table

Full Sync Filter Configuration

Partial Sync Filter Configuration

Enable Form View

Enable Checklist

Enable Notes

Enable Task Suggestions

Enable Task Relations

Enable Attachments

Sync Form and List Layout

Table

Full Sync Filter Configuration

Partial Sync Filter Configuration

Enable Form View

Enable Checklist

Enable Notes

Enable Task Suggestions

Enable Task Relations

Enable Attachments

Sync Form and List Layout

cmn_location

x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

sys_user

location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^active=true^EQ

location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

sys_user_group

active=true^u_companyDYNAMIC65a3f1e2dbb223006be0ff09689619dd^EQ

u_companyDYNAMIC65a3f1e2dbb223006be0ff09689619dd^EQ

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

x_ap4_assess_assessment_instance

state=-2^work_areaDYNAMIC514187a9db3a17006be0ff0968961935^locationDYNAMICe587d012db09e3406be0ff09689619a1^EQ

work_areaDYNAMIC514187a9db3a17006be0ff0968961935^locationDYNAMICe587d012db09e3406be0ff09689619a1^EQ

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

x_ap4_scm_ci_idea

active=true^submitted_byDYNAMIC90d1921e5f510100a9ad2572f2b477fe^EQ

submitted_byDYNAMIC90d1921e5f510100a9ad2572f2b477fe^EQ

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

x_ap4_scm_ci_improvement_planned_task

active=true^location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

x_ap4_scm_core_equipment

install_status=4^location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

install_status=4^location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

x_ap4_scm_core_failure





FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

x_ap4_scm_core_failure_mode





TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

x_ap4_scm_core_process





TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

x_ap4_scm_core_smart_focus

active=true^EQ



TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

x_ap4_scm_core_smart_focus_action





TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

x_ap4_scm_core_task

active=true^active=false^EQ (to prevent tasks from double syncing)



TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

x_ap4_scm_core_task_category





TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

x_ap4_scm_core_task_definition

state=published^ad_hoc=true^document_scope=local

^locationDYNAMICe587d012db09e3406be0ff09689619a1^active=true^numberNOT LIKETAS^NQad_hoc=true^state=published^document_scope=global

state=published^ad_hoc=true^document_scope=local

^location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^numberNOT LIKETAS^NQad_hoc=true^state=published

^document_scope=global

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

x_ap4_scm_core_task_type





FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

x_ap4_scm_core_work_area

siteDYNAMICe587d012db09e3406be0ff09689619a1^statusINin_change,in_use^EQ

siteDYNAMICe587d012db09e3406be0ff09689619a1^statusINin_change,in_use^EQ

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

x_ap4_scm_dm_deviation

active=true^location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

TRUE

TRUE

TRUE

TRUE

TRUE

TRUE

TRUE

x_ap4_scm_ehs_hazard





FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

x_ap4_scm_ehs_issue

active=true^location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

TRUE

TRUE

TRUE

TRUE

TRUE

TRUE

TRUE

x_ap4_scm_ehs_risk_mitigation_definition





FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

x_ap4_scm_ehs_risk_mitigation_instance





FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

x_ap4_scm_km_job

active=true^locationDYNAMICe587d012db09e3406be0ff09689619a1
^work_areaDYNAMIC514187a9db3a17006be0ff0968961935^EQ

locationDYNAMICe587d012db09e3406be0ff09689619a1^work_areaDYNAMIC514187a9db3a17006be0ff0968961935^EQ

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

x_ap4_scm_maint_maintenance

active=true^location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

TRUE

TRUE

TRUE

TRUE

TRUE

TRUE

TRUE

x_ap4_scm_maint_maintenance_planned_task

active=true^location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

x_ap4_scm_rca_analysis

active=true^location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

TRUE

TRUE

TRUE

TRUE

TRUE

TRUE

TRUE

x_ap4_scm_rca_why

state=-5^location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^active=true^EQ

state=-5^location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

x_ap4_scm_resource_shift_templ





FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

x_ap4_scm_tmg_counter_measure

active=true^location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

TRUE

FALSE

TRUE

TRUE

TRUE

TRUE

TRUE

x_ap4_scm_tmg_group_task

active=true^location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

FALSE

FALSE

TRUE

FALSE

TRUE

FALSE

TRUE

x_ap4_scm_tmg_simple_task_definition

active=true^ad_hoc=true^EQ

active=true^ad_hoc=true^EQ

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

x_ap4_scm_tmg_task

active=true^locationDYNAMICe587d012db09e3406be0ff09689619a1^EQ

locationDYNAMICe587d012db09e3406be0ff09689619a1^EQ

TRUE

TRUE

FALSE

FALSE

FALSE

TRUE

TRUE

x_ap4_scm_wpm_permit

permit_request.active=true^permit_request.location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

permit_request.location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

x_ap4_scm_wpm_permit_request

active=true^location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

TRUE

FALSE

FALSE

FALSE

TRUE

FALSE

TRUE

x_ap4_scm_wpm_sign_off

permit.permit_request.location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^state!=approved^EQ

permit.permit_request.location.x_ap4_scm_core_top_parentDYNAMICe587d012db09e3406be0ff09689619a1^EQ

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

Overview default sync configuration

Table

Field

Table

Field

x_ap4_assess_assessment_definition

short_description,category,document_type,equipment_model,failure_mode,work_area,knowledge_article

x_ap4_assess_assessment_instance

shift_config

x_ap4_scm_tmg_counter_measure

due_date,short_description,description,location,equipment,process,parent,state,priority,work_start,work_end,opened_by,opened_at,lessons_learned,

assignment_group,assigned_to,active,number,work_area,source,sys_updated_on,x_ap4_scm_rca_root_cause.root_cause

x_ap4_scm_dm_deviation

short_description,number,description,category,impact,severity,location,process,correlation_id,state,priority,equipment,due_date,opened_at,

opened_by,lessons_learned,close_notes,assignment_group,assigned_to,active,sys_updated_on,failure_mode,source,anomaly,work_area,parent,shift_config

x_ap4_scm_core_failure_mode

equipment_model,name,code

x_ap4_scm_tmg_group_task

number,priority,sys_class_name,work_area,short_description,equipment,parent,assigned_to,assignment_group,close_notes,closed_at,closed_by,active,state,planned_end,planned_start,due_date

x_ap4_scm_ci_idea

active,parent,source,state,sys_updated_on,opened_by,submitted_by,category,short_description,number,description,work_area

x_ap4_scm_ci_improvement_planned_task

short_description,description,state,due_date,assignment_group,assigned_to,number,sys_updated_on,active,opened_at,equipment,work_area,parent

x_ap4_scm_km_job_definition

work_area,short_description,equipment_model,name,active,state,knowledge_article

x_ap4_scm_km_job

parent,source_definition,equipment,short_description,number,work_area,source

x_ap4_scm_maint_maintenance_plan

number,name,equipment_model,work_area,knowledge_article

x_ap4_scm_maint_maintenance

parent,source_definition,short_description,description,location,equipment,process,definition,state,priority,due_date,

ordered_parts,planned_resources,planned_start,planned_end,work_start,work_end,assignment_group,assigned_to,number,sys_updated_on,active,opened_at,source,work_area

x_ap4_scm_maint_maintenance_planned_task

parent,source_definition,short_description,description,location,equipment,process,due_date,state,assignment_group,assigned_to,number,sys_updated_on,active,opened_at,work_area,source

x_ap4_scm_rca_analysis

short_description,description,location,equipment,process,state,due_date,priority,opened_at,opened_by,what,when,where,who,why,

assigned_to,additional_assignee_list,number,active,sys_updated_on,source,work_area,parent,how

x_ap4_scm_rca_why

short_description,description,state,assignment_group,assigned_to,number,sys_updated_on,active,equipment,opened_at,source,work_area,parent,rca

x_ap4_scm_wpm_permit_request

short_description,description,type,location,equipment,work_area,process,state,start_date,due_date,assigned_to,number,sys_updated_on,active,opened_at,activity_due

x_ap4_scm_core_equipment

id,name,short_description,location,parent,primary_work_area,install_status,serial_number,assignment_group,support_group,install_date,longitude,latitude,beacon_minor_id,model,work_area

x_ap4_scm_ehs_issue

short_description,description,category,sub_category,severity,probability,location,equipment,work_area,correlation_id,

state,priority,affected_people,opened_at,opened_by,assigned_to,additional_assignee_list,number,sys_updated_on,active,parent,source,due_date

x_ap4_scm_tmg_simple_task_definition

author,average_duration,category,document_scope,document_type,equipment_model,knowledge_article,detailed_description,

loto_level,image,location,materials,required_line_status,short_description,work_area,tools,failure_mode,x_ap4_scm_ehs_safety_measures

x_ap4_scm_tmg_task

parent,source_definition,number,priority,sys_class_name,work_area,short_description,equipment,assigned_to,assignment_group,

close_notes,closed_at,closed_by,active,state,description,process,category,location,source,impact,correlation_id,opened_at,failure_mode,anomaly,due_date

x_ap4_scm_core_task_category

name,parent,icon

x_ap4_scm_core_task_definition

number,name,short_description,category,document_type,equipment_model,work_area,failure_mode,knowledge_article,loto_level,required_line_status,equipment_models