Quotations: Teamleader Focus Quotations |
Catalog: Teamleader
Schema: V2
Primary Keys: id
Label: Quotations
This is a read-only table function. 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.
Columns of Table Function
The columns of the table function Quotations are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
created_at |
datetime |
Created at |
☐ |
|
currency_exchange_rate_from |
string |
|
☐ |
|
currency_exchange_rate_rate |
decimal |
|
☐ |
|
currency_exchange_rate_to |
string |
|
☐ |
|
deal_id |
string |
Deal ID |
☐ |
|
deal_type |
string |
|
☐ |
|
id |
string |
ID |
☑ |
|
total_purchase_price_amount |
decimal |
|
☐ |
|
total_purchase_price_currency |
string |
|
☐ |
|
total_tax_exclusive_amount |
decimal |
Total Amount excluding Taxes |
☐ |
|
total_tax_exclusive_before_discount_amount |
decimal |
|
☐ |
|
total_tax_exclusive_before_discount_currency |
string |
|
☐ |
|
total_tax_exclusive_currency |
string |
Currency of Total Amount excluding Taxes |
☐ |
|
total_tax_inclusive_amount |
decimal |
Total Amount including Taxes |
☐ |
|
total_tax_inclusive_before_discount_amount |
decimal |
|
☐ |
|
total_tax_inclusive_before_discount_currency |
string |
|
☐ |
|
total_tax_inclusive_currency |
string |
Currency of Total Amount including Taxes |
☐ |
|
updated_at |
datetime |
Updated At |
☐ |
|
16-08-2023 19:47 Version 22.1.262-BETA+4120