invantive documentation
Invantive Support ForumsLog In / Sign Up

InvoiceCustomFieldValues: Teamleader Focus Invoice Custom Field Values

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Invoice Custom Field Values

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 InvoiceCustomFieldValues 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
cfd_group varchar2 Group filters on the platform, writable, cfd_group Group for grouping multiple custom fields in the web frontend.
cfd_label varchar2 Label filters on the platform, writable, cfd_label Label for display with the value in the web frontend.
cfd_required char Required filters on the platform, writable, cfd_required Whether a value must be provided.
cfd_type varchar2 Type filters on the platform, writable, cfd_type Type of the values stored, such as 'auto_increment', 'integer', 'contact', 'number' or 'multi_line'.
ife_definition_id varchar2 Definition ID filters on the platform, writable
ife_definition_type varchar2 Definition Type filters on the platform, writable Type of the custom field definition.
ife_invoice_id varchar2 Record ID filters on the platform, writable ID of the invoice for which these custom field values provide additional information.
ife_value_as_array varchar2 Array Value filters on the platform, writable
ife_value_as_boolean char Boolean Value filters on the platform, writable
ife_value_as_number decimal Numeric Value filters on the platform, writable
ife_value_as_string varchar2 Text Value filters on the platform, writable
ife_value_object_id varchar2 ID of Undefined Type filters on the platform, writable
ife_value_object_type varchar2 Value of Undefined Type filters on the platform, writable
ive_c_ookpernotaris char itgen_teamleader_c_ookpernotaris filters on the platform, writable
ive_created_at datetime Created at filters on the platform, writable
ive_currency_exchange_rate_from varchar2 Currency Exchange Rate From filters on the platform, writable
ive_currency_exchange_rate_rate decimal Currency Exchange Rate filters on the platform, writable
ive_currency_exchange_rate_to varchar2 Currency Exchange Rate To filters on the platform, writable
ive_deal_id varchar2 Deal ID filters on the platform, writable
ive_deal_type varchar2 Deal Type filters on the platform, writable
ive_department_id varchar2 Department ID filters on the platform, writable
ive_department_type varchar2 Department Type filters on the platform, writable
ive_due_on datetime Due on filters on the platform, writable
ive_file_id varchar2 File ID filters on the platform, writable
ive_file_type varchar2 File Type filters on the platform, writable
ive_id varchar2 ID filters on the platform, writable
ive_invoice_date datetime Invoice Date filters on the platform, writable
ive_invoice_number varchar2 Invoice Number filters on the platform, writable
ive_invoicee_customer_id varchar2 Invoicee Customer ID filters on the platform, writable
ive_invoicee_customer_type varchar2 Invoicee Customer Type filters on the platform, writable
ive_invoicee_for_attention_of_contact_id varchar2 Invoice for Attention of Contact ID filters on the platform, writable
ive_invoicee_for_attention_of_contact_type varchar2 Invoice for Attention of Contact Type filters on the platform, writable
ive_invoicee_for_attention_of_name varchar2 Invoice for Attention of Name filters on the platform, writable
ive_invoicee_name varchar2 Invoicee Name filters on the platform, writable
ive_invoicee_vat_number varchar2 Invoicee VAT Number filters on the platform, writable
ive_paid char Paid filters on the platform, writable
ive_paid_at datetime Paid at filters on the platform, writable
ive_payment_reference varchar2 Payment Reference filters on the platform, writable
ive_project_id varchar2 Project ID filters on the platform, writable
ive_purchase_order_number varchar2 Purchase Order Number filters on the platform, writable
ive_sent char Sent filters on the platform, writable
ive_status varchar2 Status filters on the platform, writable
ive_total_due_amount decimal Total Due Amount filters on the platform, writable
ive_total_due_currency varchar2 Currency of Total Due Amount filters on the platform, writable
ive_total_payable_amount decimal Total Payable Amount filters on the platform, writable
ive_total_payable_currency varchar2 Currency of Total Payable Amount filters on the platform, writable
ive_total_tax_exclusive_amount decimal Total Amount excluding Taxes filters on the platform, writable
ive_total_tax_exclusive_currency varchar2 Currency of Total Amount excluding Taxes filters on the platform, writable
ive_total_tax_inclusive_amount decimal Total Amount including Taxes filters on the platform, writable
ive_total_tax_inclusive_currency varchar2 Currency of Total Amount including Taxes filters on the platform, writable
ive_updated_at datetime Updated At filters on the platform, writable
ive_web_url varchar2 Web (URL) filters on the platform, writable

Release Notes

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