Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Teamleader API Data Model

Navigation: Schema: V1Flat > Tables

V1ToV2Invoices

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 V1ToV2Invoices are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

contact_or_company

string

Contact or Company

 

contact_or_company_id

int32

Contact or Company ID

 

date

datetime

Date

 

date_formatted

string(20)

Date (Formatted)

 

date_paid

datetime

Date Paid

 

due_date

datetime

Due Date

 

due_date_formatted

string(20)

Due Date (Formatted)

 

entry_date_formatted

string(20)

Entry Date (Formatted)

 

for_attention_of

string

For Attention of

 

id

int32

ID

 

id_v2

guid

ID (V2)

 

incasso_interest_amount

float

Collection Interest Amount

 

incasso_recall_costs

float

 

 

invoice_nr

int32

Invoice Number

 

latest_activity_date

datetime

Latest Activity Date

 

latest_activity_date_formatted

string(20)

Latest Activity Date (Formatted)

 

name

string

Name

 

paid

boolean

Paid

 

structured_communication

string

Structured Communication

 

total_price_excl_vat

float

Total Price excl. VAT

 

total_price_incl_vat

float

Total Price incl. VAT

 

 

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