# QuotationLinesBulk: Exact Online Quotation Lines - Catalog: `ExactOnlineREST` - Schema: `CRM` - Primary Keys: `ID` - Label: Quotation Lines The data in this table is partitioned per value of the `Division` column. This is a read-only table. The Exact Online API may not support changing the data or the Invantive UniversalSQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API. ## Table Columns The columns of the table `QuotationLinesBulk` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AmountDC` | `double` | Amount Division Currency | ☑ | Amount in the default currency of the company. | | `AmountFC` | `double` | Amount Foreign Currency | ☑ | Amount in the currency of the transaction. | | `CostCenter` | `varchar2` | Cost Centre | ☐ | | | `CostCenterDescription` | `varchar2` | Cost Centre Description | ☐ | | | `CostUnit` | `varchar2` | Cost Unit | ☐ | | | `CostUnitDescription` | `varchar2` | Cost Unit Description | ☐ | | | `CustomerItemCode` | `varchar2` | Customer Item Code | ☐ | Code the customer uses for this item. | | `CustomField` | `varchar2` | Custom Field | ☐ | | | `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. | | `DivisionCompanyCoCNumber` | `varchar2`(60) | Division Chamber of Commerce Number | ☐ | Chamber of commerce number of the Exact Online division. | | `DivisionCompanyIBANNumber` | `varchar2`(50) | Division IBAN Number | ☐ | IBAN number of the Exact Online division. | | `DivisionCompanyName` | `varchar2`(50) | Division Company Name | ☑ | Company name of the Exact Online division. | | `DivisionCompanyRSINNumber` | `varchar2`(9) | Division RSIN Number | ☐ | RSIN number of the Exact Online division. | | `DivisionCompanyVATNumber` | `varchar2`(35) | Division VAT Number | ☐ | VAT number of the Exact Online division. | | `DivisionCompanyWageTaxNumber` | `varchar2`(60) | Division Wage Tax Number | ☐ | Wage tax number of the Exact Online division. | | `DivisionLabel` | `varchar2`(128) | Division Label | ☑ | Label of the Exact Online division. | | `DivisionName` | `varchar2`(50) | Administration Name | ☑ | Name of the Exact Online division. | | `DivisionOwnerCompanyName` | `varchar2`(50) | Subscription Holder Name | ☑ | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionOwnerCompanyNumber` | `varchar2`(18) | Subscription Holder Number | ☑ | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionShortName` | `int64` | Division Short Name | ☑ | Short name of the Exact Online division. | | `ID` | `guid` | ID | ☑ | Primary key. | | `Item` | `guid` | Item | ☐ | Reference to the item that is sold in this quotation line. | | `ItemDescription` | `varchar2` | Item Description | ☐ | Description of the item. | | `LineNumber` | `int32` | Line Number | ☑ | Indicates the sequence of the lines within one quotation. | | `NetPrice` | `double` | Net Price | ☐ | Net price of the quotation line. | | `Notes` | `varchar2` | Notes | ☐ | Extra notes. | | `Optional` | `char` | | ☑ | | | `Quantity` | `double` | Quantity | ☐ | The number of items sold in default units. The quantity shown in the entry screen is Quantity * UnitFactor. | | `QuotationID` | `guid` | Quotation ID | ☑ | Identifies the quotation. All the lines of a quotation have the same QuotationID. | | `QuotationNumber` | `int32` | Quotation Number | ☑ | Unique number to indentify the quotation. By default this number is based on the setting for first available number. | | `UnitCode` | `varchar2` | Unit Code | ☐ | Code of the item unit. | | `UnitDescription` | `varchar2` | Unit Description | ☐ | Description of the item unit. | | `UnitPrice` | `double` | Unit Price | ☐ | Price per item unit. | | `VATAmountFC` | `double` | VAT Amount Foreign Currency | ☐ | VAT amount of the line in the currency of the transaction. | | `VATCode` | `varchar2` | VAT Code | ☐ | The VAT code that is used when the quotation is invoiced. | | `VATDescription` | `varchar2` | VAT Description | ☐ | Description of the VAT code. | | `VATPercentage` | `double` | VAT Percentage | ☐ | The VAT percentage of the VAT code. | | `VersionNumber` | `int32` | Version Number | ☑ | Number indicating the different reviews which are made for the quotation. |