invantive documentation
Invantive Support ForumsLog In / Sign Up

SubscriptionLinesBySubscriptionId: Teamleader Focus Subscription Lines by Subscription ID

read only REST

  • Catalog: Teamleader
  • Schema: V2
  • Primary Keys: id
  • Label: Subscription Lines by Subscription ID

Can only retrieve data.

API Source

  • Endpoint: subscriptions.info

Performance Characteristics

Characteristic Value
Average access latency (ms) 39

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
id ``

Table Columns

The columns of the table SubscriptionLinesBySubscriptionId 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
description varchar2 Description filters on the platform, writable
discount_type varchar2 Discount Type filters on the platform, writable, discount.type
discount_value decimal Discount Value filters on the platform, writable, discount.value
extended_description varchar2 Extended Description filters on the platform, writable
product_category_id varchar2 Product Category ID filters on the platform, writable, product_category.id
product_category_type varchar2 Product Category Type filters on the platform, writable, product_category.type
product_id varchar2 Product ID filters on the platform, writable, product.id
product_type varchar2 Product Type filters on the platform, writable, product.type
quantity decimal Quantity filters on the platform, writable
section_title varchar2 Section Title filters on the platform, writable, ::ancestor.section.title
subscription_billing_cycle_days_in_advance varchar2 Subscription Billing Cycle Days in Advance filters on the platform, writable, ::ancestor.::ancestor.billing_cycle.days_in_advance
subscription_billing_cycle_periodicity_period varchar2 Subscription Billing Cycle Periodicity Period filters on the platform, writable, ::ancestor.::ancestor.billing_cycle.periodicity.period
subscription_billing_cycle_periodicity_unit varchar2 Subscription Billing Cycle Periodicity Unit filters on the platform, writable, ::ancestor.::ancestor.billing_cycle.periodicity.unit
subscription_currency varchar2 Subscription Currency filters on the platform, writable, ::ancestor.::ancestor.currency
subscription_department_id varchar2 Subscription Department ID filters on the platform, writable, ::ancestor.::ancestor.department.id
subscription_ends_on datetime Subscription Ends on filters on the platform, writable, ::ancestor.::ancestor..ends_on
subscription_id varchar2 Subscription ID filters on the platform, writable, ::ancestor.::ancestor.id
subscription_invoicee_customer_id varchar2 Subscription Invoicee Customer ID filters on the platform, writable, ::ancestor.::ancestor.invoicee.customer.id
subscription_invoicee_customer_type varchar2 Subscription Invoicee Customer Type filters on the platform, writable, ::ancestor.::ancestor.invoicee.customer.type
subscription_invoicee_for_attention_of_contact_id varchar2 Subscription Invoicee for Attention of Contact ID filters on the platform, writable, ::ancestor.::ancestor.invoicee.for_attention_of.contact.id
subscription_invoicee_for_attention_of_contact_type varchar2 Subscription Invoicee for Attention of Contact Type filters on the platform, writable, ::ancestor.::ancestor.invoicee.for_attention_of.contact.type
subscription_invoicee_for_attention_of_name varchar2 Subscription Invoicee for Attention of Name filters on the platform, writable, ::ancestor.::ancestor.invoicee.for_attention_of.name
subscription_invoicee_name varchar2 Subscription Invoicee Name filters on the platform, writable, ::ancestor.::ancestor.invoicee.name
subscription_invoicee_vat_number varchar2 Subscription Invoicee VAT Number filters on the platform, writable, ::ancestor.::ancestor.invoicee.vat_number
subscription_next_renewal_date datetime Subscription Next Renewal Date filters on the platform, writable, ::ancestor.::ancestor.next_renewal_date
subscription_note varchar2 Subscription Note filters on the platform, writable, ::ancestor.::ancestor.note Uses Markdown formatting.
subscription_project_id varchar2 Subscription Project ID filters on the platform, writable, ::ancestor.::ancestor.project.id
subscription_starts_on datetime Subscription Starts on filters on the platform, writable, ::ancestor.::ancestor..starts_on
subscription_status varchar2 Subscription Status filters on the platform, writable, ::ancestor.::ancestor.status
subscription_title varchar2 Subscription Title filters on the platform, writable, ::ancestor.::ancestor.title
subscription_total_tax_exclusive_amount decimal Subscription Total Tax Exclusive Amount filters on the platform, writable, ::ancestor.::ancestor.total.tax_exclusive.amount
subscription_total_tax_exclusive_before_discount_amount decimal Subscription Total Tax Exclusive before Discount Amount filters on the platform, writable, ::ancestor.::ancestor.total.tax_exclusive_before_discount.amount
subscription_total_tax_exclusive_before_discount_currency varchar2 Subscription Total Tax Exclusive before Discount Currency filters on the platform, writable, ::ancestor.::ancestor.total.tax_exclusive_before_discount.currency
subscription_total_tax_exclusive_currency varchar2 Subscription Total Tax Exclusive Currency filters on the platform, writable, ::ancestor.::ancestor.total.tax_exclusive.currency
subscription_total_tax_inclusive_amount decimal Subscription Total Tax Inclusive Amount filters on the platform, writable, ::ancestor.::ancestor.total.tax_inclusive.amount
subscription_total_tax_inclusive_before_discount_amount decimal Subscription Total Tax Inclusive before Discount Amount filters on the platform, writable, ::ancestor.::ancestor.total.tax_inclusive_before_discount.amount
subscription_total_tax_inclusive_before_discount_currency varchar2 Subscription Total Tax Inclusive before Discount Currency filters on the platform, writable, ::ancestor.::ancestor.total.tax_inclusive_before_discount.currency
subscription_total_tax_inclusive_currency varchar2 Subscription Total Tax Inclusive Currency filters on the platform, writable, ::ancestor.::ancestor.total.tax_inclusive.currency
subscription_web_url varchar2 Subscription Web URL filters on the platform, writable, ::ancestor.::ancestor.web_url
tax_id varchar2 Tax ID filters on the platform, writable, tax.id
tax_type varchar2 Tax Type filters on the platform, writable, tax.type
total_tax_exclusive_amount decimal Total Amount excluding Taxes filters on the platform, writable, total.tax_exclusive.amount
total_tax_exclusive_before_discount_amount decimal Total Tax Exclusive before Discount Amount filters on the platform, writable, total.tax_exclusive_before_discount.amount
total_tax_exclusive_before_discount_currency varchar2 Total Tax Exclusive before Discount Currency filters on the platform, writable, total.tax_exclusive_before_discount.currency
total_tax_exclusive_currency varchar2 Currency of Total Amount excluding Taxes filters on the platform, writable, total.tax_exclusive.currency
total_tax_inclusive_amount decimal Total Amount including Taxes filters on the platform, writable, total.tax_inclusive.amount
total_tax_inclusive_before_discount_amount decimal Total Tax Inclusive before Discount Amount filters on the platform, writable, total.tax_inclusive_before_discount.amount
total_tax_inclusive_before_discount_currency varchar2 Total Tax Inclusive before Discount Currency filters on the platform, writable, total.tax_inclusive_before_discount.currency
total_tax_inclusive_currency varchar2 Currency of Total Amount including Taxes filters on the platform, writable, total.tax_inclusive.currency
unit_currency varchar2 Unit Currency filters on the platform, writable, unit_price.currency
unit_id varchar2 Unit ID filters on the platform, writable, unit.id
unit_price_amount decimal Unit Price Amount filters on the platform, writable, unit_price.amount
unit_tax varchar2 Unit Tax filters on the platform, writable, unit_price.tax
unit_type varchar2 Unit Type filters on the platform, writable, unit.type
withheld_tax_id varchar2 Withheld Tax ID filters on the platform, writable, withheld_tax.id
withheld_tax_type varchar2 Withheld Tax Type filters on the platform, writable, withheld_tax.type

Release Notes

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