Select Tables and Fields #

Choose table #

Click on the 'Tables' tile, or click on the SMART menu and select SMARTpush and Tables.
Click on New.
Click in the Table ID field. Here, a list of all available tables is displayed.
Select the desired table

Fields #

To add fields to the table you have just selected, follow these steps:

Click on Field Setup. Here, you will see all available fields for the selected table.
In the Field ID field, choose the field to be included. Add all the fields you want.
Close the page to return to the Table overview.

Update-type #

Choose the type for updating the table. You can choose between All or Incremental.

All: All data (records) in the table are transferred to the SQL database when a change is recorded in the table in BC.
Incremental: New data (records) in the table are transferred to the SQL database when additions are recorded in the table in BC.

Note

Which type should I choose?
Incremental can/should be used on transaction tables that are not changed and deleted in BC. For example, this type is suitable for financial entries, debtor entries, and posted sales invoices, as these tables are "historical." This means that only "new" data is added to these tables. In contrast to Debtors and Sales Orders, these tables will be modified. This is also where you create and delete entries - therefore, these are suitable for the "All" type.

Activate Tables #

After configuring as desired, set the status to Active for the table to be included in the update.

Create Table and Fields on the external source #

Important!

This function requires that SQL user have the rights to create!