invantive documentation
Invantive Support ForumsLog In / Sign Up

TimeTrackingMaterials: Teamleader Focus Time Tracking Materials

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Time Tracking Materials

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 TimeTrackingMaterials 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
description varchar2 Description filters on the platform, writable
product_id varchar2 Product ID filters on the platform, writable
quantity decimal Quantity filters on the platform, writable
time_billing_info_invoice_id varchar2 Time Billing Info Invoice ID filters on the platform, writable
time_billing_info_invoice_type varchar2 Time Billing Info Invoice Type filters on the platform, writable
time_billing_info_type varchar2 Time Billing Info Type filters on the platform, writable
time_description varchar2 Time Description filters on the platform, writable
time_duration int64 Time Duration filters on the platform, writable Duration in seconds.
time_ended_at datetime Time Ended at filters on the platform, writable
time_id varchar2 Time ID filters on the platform, writable
time_invoiceable char Time Invoiceable filters on the platform, writable
time_locked char Time Locked filters on the platform, writable If true, the freeze time window has passed since creating it.
time_started_at datetime Time Started at filters on the platform, writable
time_started_on datetime Time Started on filters on the platform, writable
time_subject_id varchar2 Time Subject ID filters on the platform, writable
time_subject_type varchar2 Time Subject Type filters on the platform, writable
time_user_id varchar2 Time User ID filters on the platform, writable
time_user_type varchar2 Time User Type filters on the platform, writable
time_work_type_id varchar2 Time Work Type ID filters on the platform, writable
time_work_type_type varchar2 Time Work Type Type filters on the platform, writable
unit_price_amount decimal Unit Price Amount filters on the platform, writable
unit_price_currency varchar2 Unit Price Currency filters on the platform, writable

Release Notes

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