New Teamleader V2 tables and columns

Wiki (en)
,
1

The following new tables have been added to the Teamleader SQL driver:

  • table PaymentMethods;
  • table EmailTracking.

The following columns have been added to already existing Teamleader SQL-tables:

  • table ProductById: column product_category;
  • table InvoiceById: column currency;
  • table InvoiceLinesById: column quotation_currency;
  • table InvoiceGroupedLinesById: column quotation_currency;
  • table QuotationById: columns currency, status, document_template_id, expires_after, lock_after_expiry and action_after_expiry;
  • table QuotationLinesById: column quotation_currency, quotation_status and quotation_document_template_id;
  • table QuotationGroupedLinesById: column quotation_currency, quotation_status and quotation_document_template_id;
  • table Quotations: columns status, expires_after, lock_after_expiry and action_after_expiry
  • table SubscriptionById: column subscription_currency;
  • table SubscriptionLinesBySubscriptionId: column subscription_currency;
  • table SubscriptionGroupedLinesBySubscriptionId: column subscription_currency.

The following columns have been renamed:

  • table InvoiceGroupedLinesById: on_hold_since was changed to invoice_on_hold_since;
  • table InvoiceLinesById: on_hold_since was changed to invoice_on_hold_since.

The new tables and columns are available starting release 24.0.138. This release is scheduled for availability on Invantive Cloud before April 19, 2024.