invantive documentation
Invantive Support ForumsLog In / Sign Up

MaterialsV2: Teamleader Focus Materials

read only REST

  • Catalog: Teamleader
  • Schema: V2
  • Primary Keys: id
  • Label: Materials

Can only retrieve data.

API Source

  • Endpoint: projects-v2/materials.list

Performance Characteristics

Characteristic Value
Average access latency (ms) 39

The result can be cached on the client.

Table Columns

The columns of the table MaterialsV2 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
amount_billed_amount decimal Amount Billed Amount filters on the platform, writable, amount_billed.amount
amount_billed_currency varchar2 Amount Billed Currency filters on the platform, writable, amount_billed.currency
billing_method varchar2 Billing Method filters on the platform, writable
billing_status varchar2 Billing Status filters on the platform, writable
cost_amount decimal Cost Amount filters on the platform, writable, cost.amount
cost_currency varchar2 Cost Currency filters on the platform, writable, cost.currency
end_date datetime End Date filters on the platform, writable
external_budget_amount decimal External Budget Amount filters on the platform, writable, external_budget.amount
external_budget_currency varchar2 External Budget Currency filters on the platform, writable, external_budget.currency
external_budget_spent_amount decimal External Budget Spent Amount filters on the platform, writable, external_budget_spent.amount
external_budget_spent_currency varchar2 External Budget Spent Currency filters on the platform, writable, external_budget_spent.currency
fixed_price_amount decimal Fixed Price Amount filters on the platform, writable, fixed_price.amount
fixed_price_currency varchar2 Fixed Price Currency filters on the platform, writable, fixed_price.currency
group_id varchar2 Group ID filters on the platform, writable, group.id
group_type varchar2 Group Type filters on the platform, writable, group.type
id varchar2 ID filters on the platform, writable
internal_budget_amount decimal Internal Budget Amount filters on the platform, writable, internal_budget.amount
internal_budget_currency varchar2 Internal Budget Currency filters on the platform, writable, internal_budget.currency
margin_amount decimal Margin Amount filters on the platform, writable, margin.amount
margin_currency varchar2 Margin Currency filters on the platform, writable, margin.currency
margin_percentage decimal Margin Percentage filters on the platform, writable Null if the user does not have access to "Costs on projects".
price_amount decimal Price Amount filters on the platform, writable, price.amount
price_currency varchar2 Price Currency filters on the platform, writable, price.currency
product_id varchar2 Product ID filters on the platform, writable, product.id
product_type varchar2 Product Type filters on the platform, writable, product.type
project_id varchar2 Project ID filters on the platform, writable, project.id
project_type varchar2 Project Type filters on the platform, writable, project.id
quantity decimal Quantity filters on the platform, writable
start_date datetime Start Date filters on the platform, writable
status varchar2 Status filters on the platform, writable
time_estimated_value decimal Time Estimated Value filters on the platform, writable, time_estimated.value
title varchar2 Title filters on the platform, writable
unit_cost_amount decimal Unit Cost Amount filters on the platform, writable, unit_cost.amount
unit_cost_currency varchar2 Unit Cost Currency filters on the platform, writable, unit_cost.currency
unit_id varchar2 Unit ID filters on the platform, writable, unit.id
unit_price_amount decimal Unit Price Amount filters on the platform, writable, unit_price.amount
unit_price_currency varchar2 Unit Price Currency filters on the platform, writable, unit_price.currency
unit_type varchar2 Unit Type filters on the platform, writable, unit.type

Keys

Key Column Refers to Kind Description
MaterialsV2_group_id_fk group_id ProjectGroupsV2.id Key
MaterialsV2_product_id_fk product_id Products.id Key
MaterialsV2_project_id_fk project_id ProjectsV2.id Key
MaterialsV2_unit_id_fk unit_id UnitsOfMeasure.id Key

Release Notes

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