Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Teamleader API Data Model

Navigation: Schema: V1Flat > Tables

V1ToV2Products

Contents Previous Home Next More

Catalog: Teamleader

Schema: V1Flat

This is a read-only view. The Teamleader API may not support changing the data or the Invantive SQL driver for Teamleader does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Teamleader API.

View Columns

The columns of the view V1ToV2Products are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

booking_account

string

Booking Account

 

booking_account_id

int32

Booking Account ID

 

date_formatted

string(20)

Date (Formatted)

 

external_id

string

External ID

 

id

int32

ID

 

id_v2

guid

ID (V2)

 

name

string

Name

 

price_value

float

Price Value

 

stock

int32

Stock

 

total_price_excl_vat

float

Total Price excl. VAT

 

vat

string

VAT

 

 

12-12-2020 19:52 Version 20.1.301-BETA+3023