Skip to main content

Window: Replication Strategy

[Created: 19/06/2003 - Updated: 15/01/2024 ]
Description: Maintain Data Replication Strategy
Help: The Data Replication Strategy determines which tables and how they are replicated. Note that the migration does not synchronize Application Dictionary items.

Tab: Replication Strategy

[Created: 19/06/2003 - Updated: 15/01/2024 ]
Description: Data Replication Strategy
Help: The Data Replication Strategy determines which tables and how they are replicated. Note that the migration does not synchronize Application Dictionary items.
Tab Level: 0

Table 10: Replication Strategy - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.ad_replicationstrategy.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.ad_replicationstrategy.AD_Org_ID numeric(10)
Table Direct
Search KeySearch key for the record in the format required - must be uniqueA search key allows you a fast method of finding a particular record.If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_", where TableName is the actual name of the table (e.g. C_Order).ad_replicationstrategy.Value character varying(40)
String
NameAlphanumeric identifier of the entityThe name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.ad_replicationstrategy.Name character varying(60)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.ad_replicationstrategy.Description character varying(255)
String
Comment/HelpComment or HintThe Help field contains a hint, comment or help about the use of this item.ad_replicationstrategy.Help character varying(2000)
Text
ActiveThe record is active in the systemThere are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.ad_replicationstrategy.IsActive character(1)
Yes-No
Entity TypeDictionary Entity Type; Determines ownership and synchronizationThe Entity Types "Dictionary", "iDempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten. For customizations, copy the entity and select "User"!ad_replicationstrategy.EntityType character varying(40)
Table
Export Processorad_replicationstrategy.EXP_Processor_ID numeric(10)
Table Direct

Tab: Replication Table

[Created: 19/06/2003 - Updated: 05/03/2008 ]
Description: Data Replication Strategy Table Info
Help: Determines how the table is replicated. You have full access to Local tables, Reference tables are on Remote systems and are read-only. The data of Merge tables on Remote systems is copied to the central system.
Tab Level: 1

Table 20: Replication Table - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.ad_replicationtable.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.ad_replicationtable.AD_Org_ID numeric(10)
Table Direct
Replication StrategyData Replication StrategyThe Data Replication Strategy determines what and how tables are replicatedad_replicationtable.AD_ReplicationStrategy_ID numeric(10)
Table Direct
TableDatabase Table informationThe Database Table provides the information of the table definitionad_replicationtable.AD_Table_ID numeric(10)
Table Direct
ActiveThe record is active in the systemThere are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.ad_replicationtable.IsActive character(1)
Yes-No
DescriptionOptional short description of the recordA description is limited to 255 characters.ad_replicationtable.Description character varying(255)
String
Replication TypeType of Data ReplicationThe Type of data Replication determines the direction of the data replication. Reference means that the data in this system is read only -> Local means that the data in this system is not replicated to other systems - Merge means that the data in this system is synchronized with the other systemad_replicationtable.ReplicationType character(1)
List
Entity TypeDictionary Entity Type; Determines ownership and synchronizationThe Entity Types "Dictionary", "iDempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten. For customizations, copy the entity and select "User"!ad_replicationtable.EntityType character varying(40)
Table

Tab: Replication Document

[Created: 05/03/2008 - Updated: 05/03/2008 ]
Description:
Help:
Tab Level: 1

Table 30: Replication Document - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.ad_replicationdocument.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.ad_replicationdocument.AD_Org_ID numeric(10)
Table Direct
Replication StrategyData Replication StrategyThe Data Replication Strategy determines what and how tables are replicatedad_replicationdocument.AD_ReplicationStrategy_ID numeric(10)
ID
Document TypeDocument type or rulesThe Document Type determines document sequence and processing rulesad_replicationdocument.C_DocType_ID numeric(10)
Table Direct
TableDatabase Table informationThe Database Table provides the information of the table definitionad_replicationdocument.AD_Table_ID numeric(10)
Search
ActiveThe record is active in the systemThere are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.ad_replicationdocument.IsActive character(1)
Yes-No
DescriptionOptional short description of the recordA description is limited to 255 characters.ad_replicationdocument.Description character varying(255)
String
Replication TypeType of Data ReplicationThe Type of data Replication determines the direction of the data replication. Reference means that the data in this system is read only -> Local means that the data in this system is not replicated to other systems - Merge means that the data in this system is synchronized with the other systemad_replicationdocument.ReplicationType character(1)
List