24 new Exact Online tables, bringing total to over 1150 for SQL and Power BI

Across all product lines, the Exact Online driver Invantive SQL has been updated to add 24 new tables. The four new Fiscaal Gemak-tables have been left out since they seem not yet ready for production use. Additionally, approximately 50 columns have been added to various previously available tables.

New regular tables are:

  • CommercialBuildingValues
  • PurchaseReturnLineBatchNumbers
  • PurchaseReturnLineSerialNumbers
  • QuotationOrderChargeLines
  • SalesInvoiceOrderChargeLines
  • SalesOrderOrderChargeLines

New fast and incremental tables are:

  • GLClassificationsIncremental
  • GoodsDeliveriesIncremental
  • GoodsDeliveryLinesIncremental
  • ItemWarehousesIncremental
  • SalesOrderLinesV2Incremental
  • SalesOrdersV2Incremental
  • SalesPriceListVolumeDiscountsIncremental
  • SerialBatchNumbersIncremental
  • StockSerialBatchNumbersIncremental

New technical sync-tables are:

  • SyncPurchaseItemPrices
  • SyncQuotationLinesV2
  • SyncQuotationsV2
  • SyncSalesOrderLinesV2
  • SyncSalesOrdersV2
  • SyncSalesPriceListVolumeDiscounts
  • SyncSerialBatchNumbers
  • SyncStockSerialBatchNumbers
  • SyncSupplierItems

The tables are available starting release 22.0.339. The new tables will be available in Invantive Cloud within seven days.