> ## 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.

# 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)
- [UDList table](/en/database/tables/udlist.md)
- [s_list table](/en/database/tables/s-list.md)
- [ejscript table](/en/database/tables/ejscript.md)
- [Service emails](/en/email/admin/mailbox/index.md)
