invantive documentation
Invantive Support ForumsLog In / Sign Up

QuotationById: Teamleader Focus Quotation by ID

read only REST

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

Can only retrieve data.

API Source

  • Endpoint: quotations.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 QuotationById 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
action_after_expiry varchar2 Action after Expiry filters on the platform, writable, expiry.action_after_expiry
created_at datetime Created at filters on the platform, writable
currency varchar2 Currency filters on the platform, writable
currency_exchange_rate_from varchar2 Currency Exchange Rate From filters on the platform, writable, currency_exchange_rate.from
currency_exchange_rate_rate decimal Currency Exchange Rate filters on the platform, writable, currency_exchange_rate.rate
currency_exchange_rate_to varchar2 Currency Exchange Rate To filters on the platform, writable, currency_exchange_rate.to
deal_id varchar2 Deal ID filters on the platform, writable, deal.id
deal_type varchar2 Deal Type filters on the platform, writable, deal.type
document_template_id varchar2 Document Template ID filters on the platform, writable, document_template.id
expires_after datetime Expires After filters on the platform, writable, expiry.expires_after
id varchar2 ID filters on the platform, writable
lock_after_expiry char Lock after Expiry filters on the platform, writable, expiry.lock_after_expiry
name varchar2 Name filters on the platform, writable
periodicity_period varchar2 Periodicity Period filters on the platform, writable, periodicity.period
periodicity_unit varchar2 Periodicity Unit filters on the platform, writable, periodicity.unit
status varchar2 Status filters on the platform, writable
total_purchase_price_amount decimal Total Purchase Price Amount filters on the platform, writable, total.purchase_price.amount
total_purchase_price_currency varchar2 Total Purchase Price Currency filters on the platform, writable, total.purchase_price.currency
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
updated_at datetime Updated At filters on the platform, writable

Release Notes

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