Please enable JavaScript to view this site.

Navigation: Schema: V1Flat > Tables

SubscriptionItemsAll: Teamleader Focus Subscription Items

Catalog: Teamleader

Schema: V1Flat

Label: Subscription Items

This is a read-only view. The Teamleader Focus API may not support changing the data or the Invantive SQL 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 SubscriptionItemsAll are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

active

boolean

Active

 

date_end_formatted

string(20)

Date End (Formatted)

 

date_end

datetime

Date End

 

date_start_formatted

string(20)

Date Start (Formatted)

 

date_start

datetime

Date Start

 

department_id

int32

Department ID

 

for_id

int32

ID of Concerns

 

for

string

Concerns

 

id

int32

ID

 

items_account

string

 

 

items_amount

float

 

 

items_line_total_excl_vat

string

 

 

items_line_total_incl_vat

string

 

 

items_price_per_unit

float

 

 

items_product_id

int32

 

 

items_subtitle

string

Items Subtitle

 

items_text

string

Items Text

 

items_vat_rate

string(4)

Items VAT Rate

Label of the VAT rate. For custom VAT rates typically 'CUST' will be used. Default Belgium rates are: '00' for 0%, '06' for 6%, '12' for 12%, '21' for 21%, 'CM' for 'Sales inside EU', 'EX' for 'Sales outside EU', 'MC' for 'Sales medecontractant' and 'VCMD' for 'Sales inside EU services'.

next_renewal_date_formatted

string(20)

Next Renewal Date (Formatted)

 

next_renewal_date

datetime

Next Renewal Date

 

repeat

string

Repeat

 

subscription_active

boolean

Active

 

subscription_client_name

string

Client Name

 

subscription_contact_or_company_id

int32

Contact or Company ID

 

subscription_contact_or_company

string

Contact or Company

 

subscription_date_end_formatted

string(20)

Date End (Formatted)

 

subscription_date_end

datetime

Date End

 

subscription_date_start_formatted

string(20)

Date Start (Formatted)

 

subscription_date_start

datetime

Date Start

 

subscription_department_id

int32

Department ID

 

subscription_department_name

string

Department Name

 

subscription_id

int32

ID

 

subscription_next_renewal_date_formatted

string(20)

Next Renewal Date (Formatted)

 

subscription_next_renewal_date

datetime

Next Renewal Date

 

subscription_repeat

string

Repeat

 

subscription_title

string

Title

 

subscription_total_price_excl_vat

float

Total Price excl. VAT

 

subscription_total_price_incl_vat

float

Total Price incl. VAT

 

title

string

Title

 

total_price_excl_vat

float

Total Price excl. VAT

 

total_price_incl_vat

float

Total Price incl. VAT

 

 

22-12-2022 21:06 Version 22.1.101-BETA+3681