ManPageW Replication
Enjoy it, and help to fill it! But please, always respecting copyright.
Please write your contributions under the Contributions Section
Contents
Window: Replication
Description : Maintain Data Replication Targets
Help : Data Replication Target Details. Set up your system completely on the central system, before setting up the replication. Define the Replication target here and export the database and import it on the remote system.Before(!) entering transactions, Start the Replication Run to set up the remote system.
Tab: Replication Target
Description : Data Replication Target
Help : Data Replication Target Details. Maintained on the central server. Make sure that the IP range is unique for every remote system - Otherwise you will loose data!!
Table Name : AD_Replication
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
| Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
| Name | Alphanumeric identifier of the entity | The 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. | Name
NVARCHAR2(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
| Active | The record is active in the system | There 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. |
IsActive
CHAR(1) YesNo |
| Replication Strategy | Data Replication Strategy | The Data Replication Strategy determines what and how tables are replicated | AD_ReplicationStrategy_ID
NUMBER(10) TableDir |
| Host Address | Host Address URL or DNS | The Host Address identifies the URL or DNS of the target host | HostAddress
NVARCHAR2(60) String |
| Tunnel via HTTP | Connect to Server via HTTP Tunnel | If selected, the connection to the server is via a HTTP tunnel, otherwise it uses an RMI/JNP connection | IsRMIoverHTTP
CHAR(1) YesNo |
| Host port | Host Communication Port | The Host Port identifies the port to communicate with the host. | HostPort
NUMBER(10) Integer |
| Remote Client | Remote Client to be used to replicate / synchronize data with. | The remote client used for data replication. | Remote_Client_ID
NUMBER(10) Table |
| Remote Organization | Remote Organization to be used to replicate / synchronize data with. | The remote organization used for data replication. If not selected, all organizations are replicated/synchronized. | Remote_Org_ID
NUMBER(10) Table |
| ID Range Start | Start of the ID Range used | The ID Range allows to restrict the range of the internally used IDs. The standard rages are 0-899,999 for the Application Dictionary 900,000-999,999 for Application Dictionary customizations/extensions and > 1,000,000 for client data. The standard system limit is 9,999,999,999 but can easily be extended. The ID range is on a per table basis.
Please note that the ID range is NOT enforced. |
IDRangeStart
NUMBER Number |
| ID Range End | End if the ID Range used | The ID Range allows to restrict the range of the internally used IDs. Please note that the ID range is NOT enforced. | IDRangeEnd
NUMBER Number |
| Prefix | Prefix before the sequence number | The Prefix indicates the characters to print in front of the document number. | Prefix
NVARCHAR2(10) String |
| Suffix | Suffix after the number | The Suffix indicates the characters to append to the document number. | Suffix
NVARCHAR2(10) String |
| Start Replication Run | Start Replication with Remote Host | Processing
CHAR(1) Button | |
| Date last run | Date the process was last run. | The Date Last Run indicates the last time that a process was run. | DateLastRun
DATE DateTime |
Tab: Replication Run
Description : Data Replication Run
Help : Historic Info
Table Name : AD_Replication_Run
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
| Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
| Replication | Data Replication Target | Data Replication Target Details. Maintained on the central server. | AD_Replication_ID
NUMBER(10) TableDir |
| Name | Alphanumeric identifier of the entity | The 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. | Name
NVARCHAR2(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
| Active | The record is active in the system | There 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. |
IsActive
CHAR(1) YesNo |
| Replicated | The data is successfully replicated | The data replication was successful. | IsReplicated
CHAR(1) YesNo |
Tab: Run Log
Description : Data Replication Run Log
Help : Detail Info
Table Name : AD_Replication_Log
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
| Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
| Replication Run | Data Replication Run | Data Replication Run information | AD_Replication_Run_ID
NUMBER(10) TableDir |
| Replication Table | Data Replication Strategy Table Info | Determines how the table is replicated | AD_ReplicationTable_ID
NUMBER(10) TableDir |
| Active | The record is active in the system | There 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. |
IsActive
CHAR(1) YesNo |
| Replicated | The data is successfully replicated | The data replication was successful. | IsReplicated
CHAR(1) YesNo |
| Process Message | P_Msg
NVARCHAR2(2000) String |
