CompaniesAll: Teamleader Focus Companies
read only
- Catalog:
Teamleader - Schema:
V2Flat - Label: Companies
Can only retrieve data.
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 39 |
The result can be cached on the client.
Table Columns
The columns of the table CompaniesAll are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
added_ |
datetime |
Added At | filters on the platform, writable | ||
bic |
varchar2 |
BIC Number | filters on the platform, writable | ||
business_ |
varchar2 |
Business Type ID | filters on the platform, writable | ||
business_ |
varchar2 |
Business Type | filters on the platform, writable | ||
c_ |
varchar2 |
itgen_teamleader_c_regio | filters on the platform, writable | ||
c_ |
varchar2 |
itgen_teamleader_c_regio | filters on the platform, writable | ||
c_test |
varchar2 |
itgen_teamleader_c_test | filters on the platform, writable | ||
c_ |
varchar2 |
itgen_teamleader_c_test | filters on the platform, writable | ||
c_ |
int32 |
itgen_teamleader_c_transport_2020 | filters on the platform, writable | ||
c_ |
int32 |
itgen_teamleader_c_transport_2020 | filters on the platform, writable | ||
iban |
varchar2 |
IBAN Number | filters on the platform, writable | ||
id |
varchar2 |
ID | filters on the platform, writable | ||
invoicing_ |
varchar2 |
Invoicing Preferences Electronic Invoicing Address | filters on the platform, writable | ||
language |
varchar2 |
Language | filters on the platform, writable | ||
local_ |
varchar2 |
Local Business Number | filters on the platform, writable | Also known as Chamber of Commerce number in many countries. | |
marketing_ |
char |
Marketing Mails Consent | filters on the platform, writable | ||
name |
varchar2 |
Name | filters on the platform, writable | ||
national_ |
varchar2 |
National Identification Number | filters on the platform, writable | Also known as Chamber of Commerce number in many countries. | |
payment_ |
decimal |
Payment Term (days) | filters on the platform, writable | ||
payment_ |
varchar2 |
Payment Term Type | filters on the platform, writable | ||
preferred_ |
varchar2 |
Preferred Currency | filters on the platform, writable | ||
price_ |
varchar2 |
itgen_teamleader_price_list_id | filters on the platform, writable | ||
price_ |
varchar2 |
itgen_teamleader_price_list_type | filters on the platform, writable | ||
primary_ |
varchar2 |
Primary Address City | filters on the platform, writable | ||
primary_ |
varchar2 |
Primary Address Country | filters on the platform, writable | ||
primary_ |
varchar2 |
Primary Address Line 1 | filters on the platform, writable | ||
primary_ |
varchar2 |
Primary Address Postal Code | filters on the platform, writable | ||
remarks |
varchar2 |
Remarks | filters on the platform, writable | ||
responsible_ |
varchar2 |
Responsible User ID | filters on the platform, writable | ||
responsible_ |
varchar2 |
Responsible User Type | filters on the platform, writable | ||
status |
varchar2 |
Status | filters on the platform, writable | ||
updated_ |
datetime |
Updated At | filters on the platform, writable | ||
vat_ |
varchar2 |
VAT Number | filters on the platform, writable | VAT number. | |
web_ |
varchar2 |
Web (URL) | filters on the platform, writable | ||
website |
varchar2 |
Website | filters on the platform, writable | ||
website2 |
varchar2 |
Website | filters on the platform, writable |
Sample Queries
--
-- List of companies with all detail and custom fields. Very slow, with solely 1 row per second over prolonged periods of time.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/teamleader-data-model/webhelp/teamleader-focus-connector-v2flat-companiesall.html
--
-- Related forum post: https://forums.invantive.eu/t/what-are-table-functions-and-table-function-parameters/1868
--
select *
from Teamleader.V2Flat.CompaniesAll@tlr
limit 100
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: