QuotationLinesBulk: Exact Online Quotation Lines
read only per partition webhook REST
- Catalog:
ExactOnlineREST - Schema:
CRM - Primary Keys:
ID - Label: Quotation Lines
The data in this table is partitioned per value of the Division column.
Can only retrieve data.
Changes arrive through the webhook topic Quotations on QuotationID.
API Source
- Endpoint:
/api/v1/{division}/bulk/CRM/QuotationLines - Metadata:
/api/v1/{division}/bulk/CRM/$metadata
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 5 |
| Full scan rows per minute | 20,000 |
| Point query rows per minute | 300 |
| Write rows per minute | 300 |
The result can be cached on the client.
Table Columns
The columns of the table QuotationLinesBulk 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 |
|---|---|---|---|---|---|
Amount |
double |
Amount Division Currency | Amount in the default currency of the company. | ||
Amount |
double |
Amount Foreign Currency | Amount in the currency of the transaction. | ||
Cost |
varchar2 |
Cost Centre | filters on the platform | ||
Cost |
varchar2 |
Cost Centre Description | filters on the platform | ||
Cost |
varchar2 |
Cost Unit | filters on the platform | ||
Cost |
varchar2 |
Cost Unit Description | filters on the platform | ||
Custom |
varchar2 |
Custom Field | writable | ||
Customer |
varchar2 |
Customer Item Code | Code the customer uses for this item. | ||
Description |
varchar2 |
Description | By default this contains the item description. | ||
Discount |
double |
Discount | Discount given on the default price. This is stored as a fraction. ie 5.5% is stored as .055. | ||
Division |
int32 |
Division ID | Unique number of the Exact Online division. | ||
Division |
varchar2 |
Division Chamber of Commerce Number | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Division IBAN Number | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Division Company Name | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Division RSIN Number | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Division VAT Number | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Division Wage Tax Number | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Division Label | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Administration Name | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Subscription Holder Name | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Subscription Holder Number | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Division Short Name | writable | Short name of the Exact Online division. | |
ID |
guid |
ID | Primary key. | ||
Item |
guid |
Item | filters on the platform | Reference to the item that is sold in this quotation line. | |
Item |
varchar2 |
Item Description | Description of the item. | ||
Line |
int32 |
Line Number | filters on the platform | Indicates the sequence of the lines within one quotation. | |
Net |
double |
Net Price | Net price of the quotation line. | ||
Notes |
varchar2 |
Notes | Extra notes. | ||
Optional |
char |
itgen_eol_optional | filters on the platform | ||
Quantity |
double |
Quantity | The number of items sold in default units. The quantity shown in the entry screen is Quantity * UnitFactor. | ||
Quotation |
guid |
Quotation ID | filters on the platform | Identifies the quotation. All the lines of a quotation have the same QuotationID. | |
Quotation |
int32 |
Quotation Number | filters on the platform | Unique number to indentify the quotation. By default this number is based on the setting for first available number. | |
Unit |
varchar2 |
Unit Code | Code of the item unit. | ||
Unit |
varchar2 |
Unit Description | Description of the item unit. | ||
Unit |
double |
Unit Price | Price per item unit. | ||
VAT |
double |
VAT Amount Foreign Currency | VAT amount of the line in the currency of the transaction. | ||
VAT |
varchar2 |
VAT Code | The VAT code that is used when the quotation is invoiced. | ||
VAT |
varchar2 |
VAT Description | Description of the VAT code. | ||
VAT |
double |
VAT Percentage | The VAT percentage of the VAT code. | ||
Version |
int32 |
Version Number | filters on the platform | Number indicating the different reviews which are made for the quotation. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Quotation |
Item |
Items.ID |
Key | |
Quotation |
Quotation |
Quotations. |
Key | |
Quotation |
VAT |
VATCodes.Code |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: