# AcceptQuotation: Exact Online Accept Quotation - Catalog: `ExactOnlineREST` - Schema: `CRM` - Primary Keys: `QuotationID` - Label: Accept Quotation The data in this table is partitioned per value of the `Division` column. - Retrieve: False - Insert: True - Update: False - Delete: False ## Parameters of Table Function The following parameters can be used to control the behaviour of the table function `AcceptQuotation`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `division` | `int32` | ☐ | | ID of the division to retrieve data for. | ## Columns of Table Function The columns of the table function `AcceptQuotation` 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. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Action` | `int32` | Action | ☑ | 0 = No action (Default), 1 = create sales order, 2 = create sales invoice, 3 = create project. | | `AddToExistingProjectSuccess` | `varchar2` | | ☐ | | | `CreateItemPriceAgreement` | `char` | | ☐ | | | `CreateProjectWBS` | `char` | Create Project | ☐ | Create a project work breakdown structure. Only needed when ProjectBudgetType = 2. | | `Division` | `int32` | Division | ☑ | Division code. | | `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. | | `ErrorMessage` | `varchar2` | Error Message | ☐ | Contains the error message if an error occurred during the acception of the quotation. | | `InvoiceJournal` | `varchar2` | Invoice Journal | ☐ | The journal in which the sales invoice will be booked. Mandatory for Action = 2. | | `NotificationLayout` | `guid` | Notification Layout | ☐ | | | `ProjectBudgetType` | `int32` | Project Budget Type | ☐ | The budget type of the project that will be created. Default = 0. | | `ProjectClassification` | `guid` | | ☐ | | | `ProjectCode` | `varchar2`(20) | Project Code | ☐ | The code of the project that will be created. Mandatory for Action = 3. | | `ProjectDescription` | `varchar2`(60) | Project Description | ☐ | The description of the project that will be created. Mandatory for Action = 3. | | `ProjectID` | `guid` | Project ID | ☐ | | | `ProjectInvoiceDate` | `datetime` | Project Invoice Date | ☐ | The invoicing date of the project. Mandatory for ProjectInvoicingAction = 2. | | `ProjectInvoicingAction` | `int32` | Project Invoicing Action | ☐ | The project invoicing action: - 0: None (Default) - 1: Create invoice terms - 2: As quoted. | | `ProjectPrepaindTypes` | `int32` | Project Prepaid Types | ☐ | The prepaid type. Mandatory for ProjectType = 5. 1 = Retainer, 2 = Hour type bundle. | | `ProjectPriceAgreement` | `double` | Project Price Agreement | ☐ | PriceAgreement. | | `ProjectSuccess` | `varchar2` | Project Success | ☐ | Contains information if the project was successfully created. | | `ProjectType` | `int32` | Project Type | ☐ | The type of the project that will be created. 2 = Fixed price (Default), 3 = Time and Material, 4 = Non billable, 5 = Prepaid. | | `ProjectWBSPartOf` | `guid` | Project WBS Part of | ☐ | | | `QuotationID` | `guid` | Quotation ID | ☑ | Identifier of the quotation. | | `ReasonCode` | `guid` | Reason Code | ☐ | Reason why the quotation was accepted. | | `SalesInvoiceSuccess` | `varchar2` | Sales Invoice Success | ☐ | Contains information if the sales invoice was successfully created. | | `SalesOrderSuccess` | `varchar2` | Sales Order Success | ☐ | Contains information if the sales order was successfully created. | | `SubscriptionDescription` | `varchar2` | Subscription Description | ☐ | | | `SubscriptionStartDate` | `datetime` | | ☐ | | | `SubscriptionSuccess` | `varchar2` | | ☐ | | | `SubscriptionType` | `guid` | Subscription Type | ☐ | | | `SuccessMessage` | `varchar2` | Success Message | ☐ | Contains information if the quotation was successfully accepted. | | `UpdateProjectBudgetAndPriceAgreement` | `char` | | ☐ | | | `YourRef` | `varchar2` | Your Reference | ☐ | |