Please enable JavaScript to view this site.

Navigation: Schema: V1Flat > Tables

V1ToV2CreditNotes: Teamleader Focus V1 to V2 Mapping for Credit Notes

Catalog: Teamleader

Schema: V1Flat

Label: V1 to V2 Mapping for Credit Notes

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

Name

Data Type

Label

Required

Documentation

contact_or_company_id

int32

Contact or Company ID

 

contact_or_company

string

Contact or Company

 

creditnote_nr_detailed

string

Credit Note Number (Formatted)

 

creditnote_nr

int32

Credit Note Number

 

date_formatted

string(20)

Date (Formatted)

 

date_paid

datetime

Date Paid

 

date

datetime

Date

 

due_date_formatted

string(20)

Due Date (Formatted)

 

due_date

datetime

Due Date

 

id_v2

guid

ID (V2)

 

id

int32

ID

 

name

string

Name

 

paid

boolean

Paid

 

related_invoice_id

int32

Related Invoice ID

 

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