invantive documentation
Invantive Support ForumsLog In / Sign Up

CreditNotes: Teamleader Focus Credit Notes

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Credit 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 CreditNotes 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
created_at datetime Created at filters on the platform, writable
credit_note_date datetime Credit Note Date filters on the platform, writable
credit_note_number varchar2 Credit Note Number 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
department_id varchar2 Department ID filters on the platform, writable
department_type varchar2 Department Type filters on the platform, writable
document_template_id varchar2 Document Template ID filters on the platform, writable
document_template_type varchar2 Document Template Type filters on the platform, writable
id varchar2 ID filters on the platform, writable
invoice_id varchar2 Invoice ID filters on the platform, writable
invoice_type varchar2 Invoice Type filters on the platform, writable
invoicee_customer_id varchar2 Invoicee Customer ID filters on the platform, writable
invoicee_customer_type varchar2 Invoicee Customer Type filters on the platform, writable
invoicee_email varchar2 Invoicee Email filters on the platform, writable
invoicee_name varchar2 Invoicee Name filters on the platform, writable
invoicee_national_identification_number varchar2 Invoicee National Identification Number filters on the platform, writable
invoicee_vat_number varchar2 Invoicee VAT Number filters on the platform, writable
paid char Paid filters on the platform, writable
paid_at datetime Paid at filters on the platform, writable
project_id varchar2 Project ID filters on the platform, writable
status varchar2 Status filters on the platform, writable
total_payable_amount decimal Total Payable Amount filters on the platform, writable
total_payable_currency varchar2 Currency of Total Payable Amount filters on the platform, writable
total_tax_exclusive_amount decimal Total Amount excluding Taxes 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_currency varchar2 Currency of Total Amount including Taxes filters on the platform, writable
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: