TimeTrackingMaterials: Teamleader Focus Time Tracking Materials |
Catalog: Teamleader
Schema: V2Flat
Label: Time Tracking Materials
This is a read-only view. The Teamleader Focus API may not support changing the data or the Invantive UniversalSQL driver for Teamleader Focus does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Teamleader Focus API.
View Columns
The columns of the view TimeTrackingMaterials are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
description |
varchar2 |
Description |
☑ |
|
product_id |
varchar2 |
Product ID |
☐ |
|
quantity |
decimal |
Quantity |
☑ |
|
time_billing_info_invoice_id |
varchar2 |
Time Billing Info Invoice ID |
☐ |
|
time_billing_info_invoice_type |
varchar2 |
Time Billing Info Invoice Type |
☐ |
|
time_billing_info_type |
varchar2 |
Time Billing Info Type |
☐ |
|
time_description |
varchar2 |
Time Description |
☐ |
|
time_duration |
int64 |
Time Duration |
☑ |
Duration in seconds. |
time_ended_at |
datetime |
Time Ended at |
☐ |
|
time_id |
varchar2 |
Time ID |
☑ |
|
time_invoiceable |
char |
Time Invoiceable |
☐ |
|
time_locked |
char |
Time Locked |
☐ |
If true, the freeze time window has passed since creating it. |
time_started_at |
datetime |
Time Started at |
☐ |
|
time_started_on |
datetime |
Time Started on |
☑ |
|
time_subject_id |
varchar2 |
Time Subject ID |
☐ |
|
time_subject_type |
varchar2 |
Time Subject Type |
☐ |
|
time_user_id |
varchar2 |
Time User ID |
☑ |
|
time_user_type |
varchar2 |
Time User Type |
☑ |
|
time_work_type_id |
varchar2 |
Time Work Type ID |
☐ |
|
time_work_type_type |
varchar2 |
Time Work Type Type |
☐ |
|
unit_price_amount |
decimal |
Unit Price Amount |
☐ |
|
unit_price_currency |
varchar2 |
Unit Price Currency |
☐ |
|