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 UniversalSQL 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 |
☐ |
|
10-06-2024 18:37 Version 24.1.3-BETA+4689