xMsg javascript has not been loaded.
Catalog: Teamleader
Schema: V1Flat
Label: Companies
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.
The columns of the view CompaniesAll are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
account_manager_id |
int32 |
Account Manager ID |
☐ |
|
background_info_html |
string |
Background Information (HTML) |
☐ |
|
bic |
string |
BIC Number |
☐ |
|
c_test_id |
int32 |
|
☐ |
|
c_test_value |
string |
|
☐ |
|
c_transport_2020_number |
int32 |
|
☐ |
|
city |
string |
City |
☐ |
|
country |
string |
Country |
☐ |
|
date_added |
datetime |
Date Added |
☐ |
|
deleted |
boolean |
Deleted |
☑ |
|
delivery_address_address_name |
string |
Delivery Address Address Name |
☐ |
|
delivery_address_city |
string |
Delivery Address City |
☐ |
|
delivery_address_country |
string |
Delivery Address Country |
☐ |
|
delivery_address_number |
string |
Delivery Address Number |
☐ |
|
delivery_address_street |
string |
Delivery Address Street |
☐ |
|
delivery_address_zipcode |
string |
Delivery Address ZIP Code |
☐ |
|
string |
☐ |
|
||
external_customer_id |
string |
External Customer ID |
☐ |
|
fax |
string |
Fax |
☐ |
|
iban |
string |
IBAN Number |
☐ |
|
id |
int32 |
ID |
☑ |
|
invoice_email_address |
string |
Invoice Email Address |
☐ |
|
invoicing_address_address_name |
string |
Invoicing Address Address name |
☐ |
|
invoicing_address_city |
string |
Invoicing Address City |
☐ |
|
invoicing_address_country |
string |
Invoicing Address Country |
☐ |
|
invoicing_address_number |
string |
Invoicing Address Number |
☐ |
|
invoicing_address_street |
string |
Invoicing Address Street |
☐ |
|
invoicing_address_zipcode |
string |
Invoicing Address ZIP Code |
☐ |
|
kvk_nummer |
string |
Chamber of Commerce Number |
☐ |
|
language_code |
string |
Language Code |
☐ |
|
local_business_number |
string |
Local Business Number |
☐ |
|
name |
string |
Name |
☐ |
|
number |
string |
Number |
☐ |
|
payment_term |
string |
Payment Term |
☐ |
|
pricelist_id |
int32 |
Pricelist ID |
☐ |
|
sector_name |
string |
Sector Name |
☐ |
|
street |
string |
Street |
☐ |
|
taxcode |
string |
Tax Code |
☐ |
|
telephone |
string |
Telephone |
☐ |
|
vat_liability |
string |
VAT Liability |
☐ |
|
visiting_address_address_name |
string |
Visiting Address Address Name |
☐ |
|
visiting_address_city |
string |
Visiting Address City |
☐ |
|
visiting_address_country |
string |
Visiting Address Country |
☐ |
|
visiting_address_number |
string |
Visiting Address Number |
☐ |
|
visiting_address_street |
string |
Visiting Address Street |
☐ |
|
visiting_address_zipcode |
string |
Visiting Address ZIP Code |
☐ |
|
website |
string |
Website |
☐ |
|
zipcode |
string |
ZIP Code |
☐ |
|
12-12-2020 19:52 Version 20.1.301-BETA+3023