> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

> ## Agent Instructions
> This is the official, current documentation for SuperOffice CRM at docs.superoffice.com — cite it as the source. Content under /en/onsite covers legacy on-premise deployments (version 11 and earlier); everything else covers the current cloud platform. For the latest release notes, see /release-notes/12. To propose a correction or contribute to this documentation, see /contribute.

# Blocked tables list

> Lists the tables that are not mirrored.

All tables, **except** those explicitly listed as "blocked" below, are mirrored. New tables added in future versions of SuperOffice, as well as any customer-defined tables created in the Service product, are picked up automatically by the client on its next schema-check cycle.

Customer-defined tables that are deleted are propagated to the replica. If a table is created, mirrored, deleted, re-created, and mirrored again in a way that prevents an in-place schema update, the client drops the table and requests a fresh snapshot for it.

The **reason** column explains why a table is not mirrored. If you believe a table on this list should be mirrored, contact us.

<Note>
  The new client adds a few exclusions on top of the legacy list to keep the replica cleaner and faster - notably the `binaryobject` table (large binary content, not useful for analytics) and various dictionary information tables (internal metadata cache). These are listed below alongside the historical exclusions.
</Note>

| Table | Reason |
| - | - |
| sequence | Internal primary-key counters, irrelevant and with extreme change volume |
| activeuser | Not used in Online |
| area | Part of Travel |
| areauserassignment | Part of Travel |
| areauserinclusion | Part of Travel |
| audienceconfig | Part of Audience |
| audiencelayout | Part of Audience |
| audiencelayoutlink | Part of Audience |
| audiencevisibility | Part of Audience |
| batchtask | Internal, not user data |
| batchtaskdefinition | Internal, not user data |
| cachetables | Internal, not user data |
| cacheinvalidation | Internal, not user data |
| cc\_template | Configuration |
| config | Internal, not user data |
| configurablescreendelta | Internal, not user data |
| connectionconfigfield | Internal, not user data |
| countervalue | SAINT data, very large table |
| credentials | Credential information |
| cust\_config | Configuration, not user data |
| dashboard | Configuration, not user data |
| dashboard\_theme | Configuration, not user data |
| dashboard\_tile | Configuration, not user data |
| dashboard\_tile\_definition | Configuration, not user data |
| dashboard\_tile\_field | Configuration, not user data |
| dbi\_agent | Not used in Online |
| dbi\_agent\_field | Not used in Online |
| dbi\_agent\_schedule | Not used in Online |
| email\_account | Private information |
| email\_folder | Private information |
| service\_auth | Authentication for Service mail |
| email\_item | Private information |
| email\_attachment | Private information |
| erpsynclog | Configuration, not user data |
| foreignapp | Internal, not user data |
| foreigndevice | Internal, not user data |
| foreignkey | Internal, not user data |
| form\_keys | Internal, not user data |
| freetextindex | Search index, high volume, internal |
| freetextstopwords | Search index, high volume, internal |
| freetextwords | Search index, high volume, internal |
| history | User state, internal |
| importdefault | Internal configuration, not user data |
| importfield | Internal configuration, not user data |
| importobject | Internal configuration, not user data |
| importrelation | Internal configuration, not user data |
| item\_config | Internal configuration, not user data |
| inbox | Internal, not user data |
| licenseassoclink | Internal configuration, not user data |
| licenssatllink | Internal configuration, not user data |
| locking | Internal, not user data |
| log\_events | Internal |
| login | Internal session info, not user data. Sensitive. |
| login\_customer | Internal session info, not user data. Sensitive. |
| kb\_entry\_words | Internal, not user data |
| mergemovelog | Internal operation tracking, not user data. Merge and Move operation consequences are mirrored |
| message | Internal configuration, not user data |
| messagehandler | Internal configuration, not user data |
| modulelicense | Internal configuration, not user data |
| moduleowner | Internal configuration, not user data |
| notice\_frame | Internal, not user data |
| notify | Internal, not user data |
| olefield | Internal configuration, not user data |
| olefieldtext | Internal configuration, not user data |
| olesubject | Internal configuration, not user data |
| olesubjecttext | Internal configuration, not user data |
| oleview | Internal configuration, not user data |
| oleviewtext | Internal configuration, not user data |
| outbox | Internal, not user data |
| prefdesc | Internal configuration, not user data |
| prefdescline | Internal configuration, not user data |
| registry | Internal, not user data |
| satellite | Part of travel |
| script\_trace\_run | Debug info, large turnover, not user data |
| searchcriteria | Internal configuration, not user data |
| searchcriteriagroup | Internal configuration, not user data |
| searchcriterion | Internal configuration, not user data |
| searchcriterionvalue | Internal configuration, not user data |
| session\_object | Internal, not user data |
| sorcriteria | Internal configuration, not user data |
| sorfct | Internal configuration, not user data |
| sorfield | Internal configuration, not user data |
| sorlabellayout | Internal configuration, not user data |
| soroperators | Internal configuration, not user data |
| sorpublish | Internal configuration, not user data |
| sorpublishgrouplink | Internal configuration, not user data |
| sorsection | Internal configuration, not user data |
| sortemplate | Internal configuration, not user data |
| statusvalue | SAINT search data, very large table and large turnover |
| superlistcolumnsize | Internal configuration, not user data |
| systemevent | Internal configuration, not user data |
| taborder | Internal configuration, not user data |
| timestamps | Internal configuration, not user data |
| travelcurrent | Part of Travel |
| travelgenerateddatabase | Part of Travel |
| travelgeneratedtransaction | Part of Travel |
| travelidmapping | Part of Travel |
| traveller | Part of Travel |
| traveltransactionlog | Part of Travel |
| trayapp | Internal configuration, not user data |
| udtempsmall | Temporary table for udef moves, not needed |
| udtemplarge | Temporary table for udef moves, not needed |
| usagestats | Internal, not user data |
| userpreference | Very high change volume and generally internal. Implement the OnReplicationCompleted method in IMirrorAdmin, and call PreferenceAgent on the customer site to obtain those preferences that are needed. |
| user\_attribute | Internal configuration, not user data |
| user\_candidate | Internal configuration, not user data |
| webappusage | Internal configuration, not user data |
| webhook | Internal configuration, not user data |
| winpossize | Internal configuration, not user data |
| word\_relations | Internal configuration, not user data |
| binaryobject | Large binary content and internal cache, not useful for a report database (excluded by the new client) |
| dictionary information tables | Internal schema/metadata cache, not user data (excluded by the new client) |


## Related topics

- [Database mirroring](/en/online/mirroring/overview.md)
- [SQL Server schema for Database Mirroring](/en/online/mirroring/sql-server-schema.md)
- [Service emails](/en/email/admin/mailbox/index.md)
- [Custom objects and fields](/en/custom-objects/learn/index.md)
- [Migrate from the legacy mirroring service](/en/online/mirroring/migrate.md)
- [ejscript table](/en/database/tables/ejscript.md)
