invantive documentation
Invantive Support ForumsLog In / Sign Up

CreditNoteLinesByCreditNoteId: Teamleader Focus Credit Note Lines by ID

read only REST

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

Can only retrieve data.

API Source

  • Endpoint: creditNotes.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 CreditNoteLinesByCreditNoteId 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
credit_note_id varchar2 Credit Note ID filters on the platform, writable, ::ancestor.::ancestor.id
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
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
group_section_title varchar2 Group Section Title filters on the platform, writable, ::ancestor.section.title
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
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

Release Notes

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