| Docs Help
  AppSource  
Print this pageEntire manual (printable version)
Docs  /  App  /  NAVAX Replication  /  Setup

 Tables


2026/02/20 • 11 min. to read
The Replication Setup Tables defines which tables and fields are considered in the replication process and how they behave during replication. There are a variety of parameters that must be carefully configured. The setup screen is divided into Header Area (Tables) and Details (Fields and Dependent Tables).

Header Area (Tables)

You can minimize the header data to display more detail lines for the currently selected table. Below you will find the description of the fields in the header area.
ColumnDescription
TypeThe setup table contains different record types. Depending on the type, different parameters (columns) are relevant. In the header area, only the type "Table" is allowed.
  • Table This is the header record for each table to be replicated. Here you enter basic information about the table.
Table No.Specifies the number of the table.
Table NameDisplay name of the corresponding table.
Table FilterYou can define a filter here to replicate only specific records of the table. Only records that match the filter will be replicated. Table Filter Setup

Note

Note that non-replicated records can still be edited in all companies.
Table SequenceOnly relevant when Manual Replication is enabled and when using "Initialize Company". All dependent tables (linked via the type "Dependent Table") are replicated according to this value. Details can be found in the Manual Replication section and in the detail lines for the record type. When using the "Initialize Company" action, the tables are replicated according to this sequence.

Note

Note that non-replicated records can still be edited in all companies.
NewSet automatically by the system. If the checkbox is set, this is a new setup line. When closing the "Replication Setup Tables" page, a prompt appears if at least one line with "New = Yes" exists:
  • Activate setup and generate replication entries All required Replication Entries for the initial rollout will be created for the newly added tables and fields. The "New" checkboxes will be removed.
  • Close setup without replication entries The new setups will be saved and the "New" checkboxes will be removed. No Replication Entries will be created for already existing records of the tables to be replicated. If you want to designate the table for "Manual Replication", for example, you must choose this option when leaving the "Replication Setup Tables".
  • Reset Setup (delete new lines) The new setup lines will be deleted and therefore will not be applied.

Note

The "Replication Setup Tables" window may only be opened in one session at a time. It is locked for further access. If you leave the "Replication Setup Tables" not through the program but, for example, through a program abort or by directly closing the browser window, the setup may remain locked for the next few minutes.
Ignore CompanyIf set to "Yes", you can click on the three dots to define in which companies this table should not be replicated. This setup takes effect before all other setups as well - for example, if you replicate using company groups or have set filters.
Manual ReplicationThis parameter cannot be set here but is automatically activated when the table has been entered in the "Manual Replication Setup". "Manual Replication" offers flexible and transparent control of individual tables. When activated, newly created records of this table will only be replicated when the user triggers it via the "Repl. Companies" parameter in the Replication FactBox of the corresponding record. When the record is created, the "Repl. Companies" parameter is automatically set to "None". As soon as the user changes this parameter to a different value, the corresponding Replication Entries are created and the record is included in the replication processes.

Important

Since the required Replication FactBox is displayed in the card view, a card view is a prerequisite for this. If you activate this parameter and the Replication FactBox is still not displayed on the respective card, this table does not support the function. In this case, you either cannot use this function, or you must contact your system administrator to have the extension of this table implemented through customization. Enable Manual Replication for Additional Tables
Do not execute Insert triggerThis parameter causes insert triggers not to be executed when replicating this table.

Important

The functions executed by insert triggers usually exist for good reason. Therefore, this setting should only be made in coordination with your system administrator.
Do not execute Modify triggerThis parameter causes modify triggers not to be executed when replicating this table.

Important

The functions executed by modify triggers usually exist for good reason. Therefore, this setting should only be made in coordination with your system administrator.
Do not execute Delete triggerThis parameter causes delete triggers not to be executed when replicating this table.

Important

The functions executed by delete triggers usually exist for good reason. Therefore, this setting should only be made in coordination with your system administrator.
Ignore on "Initialize Company"If activated, this table will not be considered during the "Initialize Company" action.

Details Area

In the lower screen area, you will find the detail lines for the currently selected table. This area can also be minimized to display more header data lines simultaneously.
ColumnDescription
TypeEach line can have a specific record type that defines its function:
  • Field Defines which fields of the table should be replicated. Fields not listed will not be replicated. However, it is recommended to list all fields. A listed field can also be explicitly excluded from replication by marking it with the "Ignore Field" parameter.
  • Dependent Table If "Manual Replication" is activated for a table, you can define dependent tables in the details. A dependent table will only be replicated after the associated record of the main table (the one where it is listed as a dependent table) has been replicated. Note that the dependent table must also be set up as a table to be replicated. A "dependent table" must not be set up as manually replicated. Example: The bank accounts of a vendor should only be replicated after the vendor itself. However, if the vendor is manually replicated, it may happen that the created vendor bank account generates Replication Entries before the actual vendor - and this would lead to an error. Therefore, the table "Vendor Bank Account" must be stored as a "Dependent Table" under the table "Vendors". Replication Entries of the dependent table are created with the status "Waiting" and are only replicated after the main table has been replicated.
Field No.Number of the field in the table. For the line type "Dependent Table", the field number of the main table must be specified here, which establishes the unique link to the dependent table (e.g., field "No.").

Note

Dependent tables can only be linked to the main table via ONE unique key field. A link that requires more than one key field is currently not supported.
Field NameName of the field, automatically populated by the system.
Dependent Table No.Only relevant for the type "Dependent Table". Number of the dependent table.
Dependent Table NameName of the dependent table, automatically populated by the system.
Dependent Field No.Through this field number of the dependent table, the link to the main table is established.
Dependent Field NameName of the field, automatically populated by the system.
Dependency ConditionAn optional filter that allows you to further narrow down the records to be linked. You need this filter, for example, for table 352 (Default Dimension) to only set the default dimensions for this specific main table as dependent. Example: Table 167 "Job" is set to "Manual Replication". To prevent a replication error when entering a default dimension on the job card, you set up table 352 "Default Dimension" as a "Dependent Table". However, table 352 "Default Dimension" also contains records for other tables, so the filter "Table ID = 167" must be entered for the dependent table 352 line.
Field SequenceSpecifies the order in which fields are processed within the replication of a record. The smaller the value, the earlier the processing occurs. When using the "Initialize Company" action, the fields are replicated according to this sequence.

Important

When a newly created record is not set to "Manual Replication" or when an existing record is modified, the Replication Entries are in most cases created according to the order of your data entry. In this case, the "Sequence" parameter usually has no effect.
Skip Field ValidationIf activated, the field content is replicated but not validated.

Important

The functions executed by validations usually exist for good reason. Therefore, this setting should only be made in coordination with your system administrator.
Ignore FieldIf set, this field is excluded from replication. This has the same effect as if you did not create a setup line for this field. We recommend creating the line anyway, because on one hand it serves as documentation and on the other hand, future functions (e.g., a check for which fields have not been defined for this table) will take these lines into account.
Ignore CompanyCan have the following values:
  • None - This selection means that no companies should be ignored and therefore has no effect.
  • Yes - This selection means that companies should be ignored. Click on the three dots to open an overview where you can define to which companies this field should not be replicated.
NewThis parameter is set automatically and marks a new setup line. When closing the page, a prompt appears for saving or discarding all lines marked as "New". Only when you confirm upon closing that the setup lines should be retained will the required Replication Entries be automatically created. These can be entries for an entire table or just for a field of an already replicated table that was newly added.

Important

In some situations it may be useful to manually manipulate this parameter, which is possible in principle. For example, if you want to include a new field in replication but do not want an initial rollout for it. In that case, remove the "New" checkbox and click "OK" in the save prompt.
Write on InsertWhen a new record of a replicated table is created, a Replication Entry with the field Action = "Insert" is first created. This entry contains only the key fields of the table regarding the fields. Then any number of Replication Entries with the field Action = "Modify" follow. These entries contain the information regarding the fields that are not key fields. However, there are situations where you want certain data fields to be written already with the Replication Entry with the Action = "Insert". This can be the case, for example, when the insert trigger of this table performs functions based on these field values. If such fields exist, the "Write on Insert" checkbox must be set for them. Note that a popup window is displayed for entering these fields immediately when creating a new record.
Ignore on "Initialize Company"If activated, this field will not be considered during the "Initialize Company" action.

Actions

  • Add Tables

    Select the desired table (you can also select multiple). Setup lines are automatically generated for this table, which you can modify manually. New lines are automatically marked with the status "New". Only when leaving the setup screen do you have to decide whether these setup lines should actually be applied - and thereby Replication Entries should be created for an initial replication.

  • Activate "New"

    This action sets the "New" status in all detail lines of the current table.

  • Remove "New"

    This action removes the "New" status from all detail lines of the current table. This is useful, for example, if you have created new setups but want to prevent the Replication Entries for the initial rollout from being created.

  • Activate "Ignore Company Init"

    This action sets the "Ignore on Initialize Company" status in all detail lines of the current table.

  • Remove "Ignore Company Init"

    This action removes the "Ignore on Initialize Company" status from all detail lines of the current table.

  • Obsolete Fields

    Microsoft informs you when delivering a new version (somewhat hidden in the table definitions) which fields will no longer exist in the future, which fields have been changed or were changed (e.g., field lengths), or which fields were removed with this delivery. The replication makes this information visible here for all fields that are currently considered in the replication setup. When you select the action, only those fields that have been removed from the database are initially displayed. These fields must also be removed from the "Replication Table Setup". You can do this very easily by selecting the "Replication Setup Tables - Field" action and deleting the corresponding setup there. Additionally, you can remove the filter on "Obsolete state" to also see those fields that have already been flagged by Microsoft for deletion in later versions or have other changes.

    Important

    You should check the "Obsolete Fields" action immediately after each delivery of a new program version.

Related information



Submit feedback for
DE|EN Imprint
◀☰▶
△