/
Specification of Integration

Specification of Integration

The attached excel file contains a list of tables with columns description for each function block data load. It also highlights required and optional tables/fields that are only used when certain features are enabled.

All tables are separated into blocks, just like in the user interface.

Overview

  1. The MySales system works with a wide range of databases (Oracle, Microsoft SQL Server, MySQL, PostgreeSQL, Oracle Teradata and etc.).

  2. We recommend that you choose the database that matches the database of your ERP or similar system where you already have data on sales, stock balances and which is used to register purchase orders and goods receipts.

  3. You can use the following options to create a database:

    1. Database instance on separate server

    2. Separate database instance on the same server as the ERP database instance.

    3. Separate database on ERP server database instance (recommended).

    4. Separate database schema on same database on ERP server database instance.

  4. The main workload usually occurs at night, when sales and stock balance data are exchanged between MySales and ERP system and forecasts and orders calculated.

If you are tackle with difficulties when preparing data for loading or with performance issues, you can always contact us, but you must know the data structure of your ERP system.

We may change the data structure, lengths and types of some fields for data storage optimization and compatibility purposes.

Not all tables are required for integration. The list of tables is determined by the capabilities of the ERP system used and the customer's processes.

Data types

The following data types are used in the MySales system:

Data type

MSSQL

ORACLE