# QuotationsBulk: Exact Online Quotations - Catalog: `ExactOnlineREST` - Schema: `CRM` - Primary Keys: `QuotationID` - Label: Quotations 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 `QuotationsBulk` 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. | | `AmountDiscount` | `double` | Amount Discount | ☐ | | | `AmountDiscountExclVat` | `double` | Amount Discount excluding VAT | ☐ | | | `AmountFC` | `double` | Amount Foreign Currency | ☑ | Amount in the currency of the transaction. | | `CloseDate` | `datetime` | Date Closed | ☐ | Date on which the customer accepted or rejected the quotation version. | | `ClosingDate` | `datetime` | Date Closing | ☐ | Date on which you expect to close/win the deal. | | `Created` | `datetime` | Created | ☑ | Date and time on which the quotation was created. | | `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. | | `Creator` | `guid` | Creator | ☐ | User ID of the creator. | | `CreatorFullName` | `varchar2` | Creator Full Name | ☐ | Name of the creator. | | `Currency` | `varchar2` | Currency | ☐ | The currency of the quotation. | | `DeliveryAccount` | `guid` | Delivery Account | ☐ | The account where the items should delivered. | | `DeliveryAccountCode` | `varchar2` | Delivery Account Code | ☐ | The code of the delivery account. | | `DeliveryAccountContact` | `guid` | Delivery Account Contact | ☐ | The contact person of the delivery account. | | `DeliveryAccountContactFullName` | `varchar2` | Delivery Account Contact Full Name | ☐ | Full name of the delivery account contact person. | | `DeliveryAccountName` | `varchar2` | Delivery Account Name | ☐ | The name of the delivery account. | | `DeliveryAddress` | `guid` | Delivery Address | ☐ | The id of the delivery address. | | `DeliveryDate` | `datetime` | Delivery Date | ☐ | | | `Description` | `varchar2` | Description | ☐ | The description of the quotation. | | `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. | | `Document` | `guid` | Document | ☐ | Document linked to the quotation. | | `DocumentSubject` | `varchar2` | Document Subject | ☐ | The subject of the document. | | `DueDate` | `datetime` | Due Date | ☐ | Date after which the quotation is no longer valid. | | `IncotermAddress` | `varchar2` | Incoterm Address | ☐ | | | `IncotermCode` | `varchar2` | Incoterm Code | ☐ | | | `IncotermVersion` | `int16` | Incoterm Version | ☐ | | | `InvoiceAccount` | `guid` | Invoice Account | ☐ | The account to which the invoice is sent. | | `InvoiceAccountCode` | `varchar2` | Invoice Account Code | ☐ | The code of the invoice account. | | `InvoiceAccountContact` | `guid` | Invoice Account Contact | ☐ | The contact person of the invoice account. | | `InvoiceAccountContactFullName` | `varchar2` | Invoice Account Contact Full Name | ☐ | Full name of the invoice account contact person. | | `InvoiceAccountName` | `varchar2` | Invoice Account Name | ☐ | The name of the invoice account. | | `Modified` | `datetime` | Modified | ☑ | Date and time on which the quotation was last modified. | | `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. | | `Modifier` | `guid` | Modifier | ☐ | User ID of the modifier. | | `ModifierFullName` | `varchar2` | Modified Full Name | ☐ | Name of the modifier. | | `Opportunity` | `guid` | Opportunity | ☐ | Opportunity linked to the quotation. | | `OpportunityName` | `varchar2` | Opportunity Name | ☐ | The name of the opportunity. | | `OrderAccount` | `guid` | Order Account | ☐ | The account that requested the quotation. | | `OrderAccountCode` | `varchar2` | Order Account Code | ☐ | The code of the order account. | | `OrderAccountContact` | `guid` | Order Account Contact | ☐ | The contact person of the order account. | | `OrderAccountContactFullName` | `varchar2` | | ☐ | Full name of the order account contact person. | | `OrderAccountName` | `varchar2` | Order Account Name | ☐ | The name of the order account. | | `PaymentCondition` | `varchar2` | Payment Condition | ☐ | | | `PaymentConditionDescription` | `varchar2` | Payment Condition Description | ☐ | | | `Project` | `guid` | Project | ☐ | The project linked to the quotation. | | `ProjectCode` | `varchar2` | Project Code | ☐ | The code of the project. | | `ProjectDescription` | `varchar2` | Project Description | ☐ | The description of the project. | | `QuotationDate` | `datetime` | Quotation Date | ☐ | Date on which the quotation version is entered or printed. Both during entering and printing this date can be adjusted. | | `QuotationID` | `guid` | Quotation ID | ☑ | Identifier of the quotation. | | `QuotationNumber` | `int32` | Quotation Number | ☑ | Unique number to indentify the quotation. By default this number is based on the setting for first available number. | | `Remarks` | `varchar2` | Remarks | ☐ | Extra text that can be added to the quotation. | | `SalesChannel` | `guid` | Sales Channel | ☐ | | | `SalesChannelCode` | `varchar2` | Sales Channel Code | ☐ | | | `SalesChannelDescription` | `varchar2` | Sales Channel Description | ☐ | | | `SalesPerson` | `guid` | Sales Person | ☐ | The user that is responsible for the quotation version. | | `SalesPersonFullName` | `varchar2` | Sales Person Full Name | ☐ | Full name of the sales person. | | `SelectionCode` | `guid` | Selection Code | ☐ | ID of selection code. Only supported by the Advanced and Premium editions for Wholesale & Distribution and Manufacturing. | | `SelectionCodeCode` | `varchar2` | Selection Code | ☐ | Code of selection code. | | `SelectionCodeDescription` | `varchar2` | | ☐ | Description of selection code. | | `ShippingMethod` | `guid` | Shipping Method | ☐ | | | `ShippingMethodDescription` | `varchar2` | Shipping Method Description | ☐ | | | `Status` | `int16` | Status | ☐ | The status of the quotation version. 5 = Rejected, 6 = Reviewed and closed, 10 = Recovery, 20 = Draft, 25 = Open, 35 = Processing... , 40 = Printed, 50 = Accepted. | | `StatusDescription` | `varchar2` | Status Description | ☐ | The description of the status. | | `VATAmountFC` | `double` | VAT Amount Foreign Currency | ☐ | Total VAT amount in the currency of the transaction. | | `VersionNumber` | `int32` | Version Number | ☑ | Number indicating the different reviews which are made for the quotation. | | `YourRef` | `varchar2` | Your Reference | ☐ | The number by which this quotation is identified by the order account. |