BeyondERP.Newsletter
Menu

Setup step on the Scheduler subjobs page · Retail and Commerce

Set up Scheduler subjobs

Use this page to check which fields of a table are synchronized to channels, to verify that extension columns appear in the mapping, and to exclude a table from offline databases.

Used by
Retail operations manager, Retail service, Information technology manager
Business process
Manage sales channels
Menu item
RetailConnSchedulerSubJobTable
Main table
RetailConnSchedulerSubjobTable
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page listing the Commerce Data Exchange subjobs; each subjob maps one headquarters table to its channel database table, shows the channel field mapping, and belongs to one or more scheduler jobs.
What you do hereUse this page to check which fields of a table are synchronized to channels, to verify that extension columns appear in the mapping, and to exclude a table from offline databases.
ExampleFor example, after enabling product ratings you check here that the RetailProductRating subjob exists before scheduling the ratings sync.
Scheduler subjobs page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Set up Scheduler subjobs

Use this page to check which fields of a table are synchronized to channels, to verify that extension columns appear in the mapping, and to exclude a table from offline databases.

Steps from Microsoft

  1. Go to Retail and Commerce > Headquarters setup > Commerce scheduler > Scheduler subjobs.
  2. In the subjob list, search for the subjob ID (the headquarters table name).
  3. In the details area, open the Channel field mapping section and check the fields that are synchronized.
  4. If needed, set Exclude from offline databases to Yes to keep the table out of offline databases.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Subjob IDIdentifier of the subjob, normally the headquarters table name.Microsoft Learn
Channel field mappingList of headquarters fields mapped to channel table fields for this subjob.Microsoft Learn
Exclude from offline databasesWhen Yes, the table is not synchronized to offline databases by any job that contains the subjob.Microsoft Learn AllowSkipDataSync

Test checklist

  1. Open the subjob for a table you extended and check that the extension columns appear in Channel field mapping.
  2. In a sandbox, exclude a non-critical subjob and run a job that contains it.
  3. Check on Download sessions that the table isn't in the offline package.
  4. Confirm DIRPARTYTABLE is not excluded and that staff can sign in to Store Commerce offline.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Scheduler subjobsLeave DIRPARTYTABLE included; exclude a subjob only when its table isn't needed in any job offlineExcluding a subjob stops its table from syncing to offline databases for every job that contains it. Microsoft says not to exclude DIRPARTYTABLE because it holds staff data needed offline.Excluding DIRPARTYTABLE to drop customer data. It is shared by customers and employees and is synced by three jobs, so staff data is lost offline. Use Filter shared customer data tables on the channel schema instead.
Solution architect

5Design impact

Can it be undoneHard to reverse: Excluded tables stop syncing to offline databases for all jobs that contain the subjob. Data already removed from offline databases must be resynchronized after the exclusion is lifted.
If you change it laterExcluding a subjob removes its table from offline synchronization for every job that contains it; Microsoft warns not to exclude DIRPARTYTABLE because offline sign-in depends on the staff data it holds. Microsoft Learn
Technical architect

6Technical

Menu itemRetailConnSchedulerSubJobTable Checked in Dynamics 365
FormRetailConnSchedulerSubJobTable Checked in Dynamics 365
TableRetailConnSchedulerSubjobTableShown as “SCHEDULER SUB JOBS” in Record infoChecked in Dynamics 365
Who can open itPrivilegesMaintain Retail scheduler RetailSchedulerMaintainDutiesManage Commerce Data Exchange: Synch Service RetailSchedulerManage
3 security rolesRetail operations manager RetailOperationsManagerRetail service RetailServiceInformation technology manager SysServerITManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRetail service RetailServiceRetail operations manager RetailOperationsManagerInformation technology manager SysServerITManagerGive people one of these roles. On this system, 3 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Copy scheduler subjobChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=RetailConnSchedulerSubJobTable
Everyone

8Sources

To cite this step: RC-CDX-020, Set up Scheduler subjobs. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/RC-CDX-020