invantive documentation
Invantive Support ForumsLog In / Sign Up

ProductCustomFieldValues: Teamleader Focus Product Custom Field Values

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Product 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 ProductCustomFieldValues 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'.
pdt_added_at datetime Added At filters on the platform, writable
pdt_c_artikeltext varchar2 itgen_teamleader_c_artikeltext filters on the platform, writable
pdt_code varchar2 Code filters on the platform, writable
pdt_configuration_stock_threshold_action varchar2 Configuration Stock Threshold Action filters on the platform, writable
pdt_configuration_stock_threshold_minimum decimal Configuration Stock Threshold Minimum filters on the platform, writable
pdt_description varchar2 Description filters on the platform, writable
pdt_id varchar2 ID filters on the platform, writable
pdt_name varchar2 Name filters on the platform, writable
pdt_stock_amount decimal Stock Amount filters on the platform, writable
pdt_unit_id varchar2 Unit ID filters on the platform, writable
pdt_unit_type varchar2 Unit Type filters on the platform, writable
pdt_updated_at datetime Updated At filters on the platform, writable
pfe_definition_id varchar2 Definition ID filters on the platform, writable
pfe_definition_type varchar2 Definition Type filters on the platform, writable Type of the custom field definition.
pfe_product_id varchar2 Record ID filters on the platform, writable ID of the product for which these custom field values provide additional information.
pfe_value_as_array varchar2 Array Value filters on the platform, writable
pfe_value_as_boolean char Boolean Value filters on the platform, writable
pfe_value_as_number decimal Numeric Value filters on the platform, writable
pfe_value_as_string varchar2 Text Value filters on the platform, writable
pfe_value_object_id varchar2 ID of Undefined Type filters on the platform, writable
pfe_value_object_type varchar2 Value of Undefined Type filters on the platform, writable

Release Notes

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