invantive documentation
Invantive Support ForumsLog In / Sign Up

CreditNoteLines: Teamleader Focus Credit Note Lines

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Credit Note Lines

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 CreditNoteLines 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
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_rate decimal Currency Exchange Rate filters on the platform, writable
currency_exchange_rate_to varchar2 Currency Exchange Rate To filters on the platform, writable
description varchar2 Description filters on the platform, writable
discount_type varchar2 Discount Type filters on the platform, writable
discount_value decimal Discount Value filters on the platform, writable
extended_description varchar2 Extended Description filters on the platform, writable
group_section_title varchar2 Group Section Title filters on the platform, writable
product_category_id varchar2 Product Category ID filters on the platform, writable
product_category_type varchar2 Product Category Type filters on the platform, writable
product_id varchar2 Product ID filters on the platform, writable
product_type varchar2 Product Type filters on the platform, writable
quantity decimal Quantity filters on the platform, writable
tax_id varchar2 Tax ID filters on the platform, writable
tax_type varchar2 Tax Type filters on the platform, writable
total_tax_exclusive_amount decimal Total Amount excluding Taxes filters on the platform, writable
total_tax_exclusive_before_discount_amount decimal Total Tax Exclusive before Discount Amount filters on the platform, writable
total_tax_exclusive_before_discount_currency varchar2 Total Tax Exclusive before Discount Currency filters on the platform, writable
total_tax_exclusive_currency varchar2 Currency of Total Amount excluding Taxes filters on the platform, writable
total_tax_inclusive_amount decimal Total Amount including Taxes filters on the platform, writable
total_tax_inclusive_before_discount_amount decimal Total Tax Inclusive before Discount Amount filters on the platform, writable
total_tax_inclusive_before_discount_currency varchar2 Total Tax Inclusive before Discount Currency filters on the platform, writable
total_tax_inclusive_currency varchar2 Currency of Total Amount including Taxes filters on the platform, writable
unit_currency varchar2 Unit Currency filters on the platform, writable
unit_id varchar2 Unit ID filters on the platform, writable
unit_price_amount decimal Unit Price Amount filters on the platform, writable
unit_tax varchar2 Unit Tax filters on the platform, writable
unit_type varchar2 Unit Type filters on the platform, writable

Release Notes

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