invantive documentation
Invantive Support ForumsLog In / Sign Up

SubscriptionNotesAll: Teamleader Focus Subscription Notes

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Subscription Notes

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 39

The result can be cached on the client.

Table Columns

The columns of the table SubscriptionNotesAll are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
added_at datetime Added At filters on the platform, writable
content varchar2 Content filters on the platform, writable
id varchar2 ID filters on the platform, writable
subject_id varchar2 Subject ID filters on the platform, writable
subject_type varchar2 Subject Type filters on the platform, writable
subscription_billing_cycle_days_in_advance varchar2 Billing Cycle Days in Advance filters on the platform, writable
subscription_billing_cycle_periodicity_period varchar2 Billing Cycle Periodicity Period filters on the platform, writable
subscription_billing_cycle_periodicity_unit varchar2 Billing Cycle Periodicity Unit filters on the platform, writable
subscription_c_abonnementtext varchar2 itgen_teamleader_c_abonnementtext filters on the platform, writable
subscription_department_id varchar2 Department ID filters on the platform, writable
subscription_ends_on datetime Ends On filters on the platform, writable
subscription_id varchar2 ID filters on the platform, writable
subscription_invoicee_customer_id varchar2 Invoicee Customer ID filters on the platform, writable
subscription_invoicee_customer_type varchar2 Invoicee Customer Type filters on the platform, writable
subscription_invoicee_for_attention_of_contact_id varchar2 Invoice for Attention of Contact ID filters on the platform, writable
subscription_invoicee_for_attention_of_contact_type varchar2 Invoice for Attention of Contact Type filters on the platform, writable
subscription_invoicee_for_attention_of_name varchar2 Invoice for Attention of Name filters on the platform, writable
subscription_invoicee_name varchar2 Invoicee Name filters on the platform, writable
subscription_invoicee_vat_number varchar2 Invoicee VAT Number filters on the platform, writable
subscription_next_renewal_date datetime Next Renewal Date filters on the platform, writable
subscription_note varchar2 Note filters on the platform, writable Uses Markdown formatting.
subscription_project_id varchar2 Project ID filters on the platform, writable
subscription_starts_on datetime Starts on filters on the platform, writable
subscription_status varchar2 Status filters on the platform, writable
subscription_title varchar2 Title filters on the platform, writable
subscription_total_tax_exclusive_amount decimal Total Amount excluding Taxes filters on the platform, writable
subscription_total_tax_exclusive_before_discount_amount decimal Total Tax Exclusive before Discount Amount filters on the platform, writable
subscription_total_tax_exclusive_before_discount_currency varchar2 Total Tax Exclusive before Discount Currency filters on the platform, writable
subscription_total_tax_exclusive_currency varchar2 Currency of Total Amount excluding Taxes filters on the platform, writable
subscription_total_tax_inclusive_amount decimal Total Amount including Taxes filters on the platform, writable
subscription_total_tax_inclusive_before_discount_amount decimal Total Tax Inclusive before Discount Amount filters on the platform, writable
subscription_total_tax_inclusive_before_discount_currency varchar2 Total Tax Inclusive before Discount Currency filters on the platform, writable
subscription_total_tax_inclusive_currency varchar2 Currency of Total Amount including Taxes filters on the platform, writable
subscription_web_url varchar2 Web (URL) filters on the platform, writable

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: