# HostingOpportunitiesRead: Exact Online Hosting Opportunities - Catalog: `ExactOnlineREST` - Schema: `CRM` - Primary Keys: `ID` - Label: Hosting Opportunities 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 `HostingOpportunitiesRead` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Account` | `guid` | Account | ☐ | Lead to which the opportunity applies. | | `Accountant` | `guid` | Accountant | ☐ | Accountant linked to the opportunity. | | `AccountantCode` | `varchar2` | Accountant Code | ☐ | Code of the Accountant. | | `AccountantName` | `varchar2` | Accountant Name | ☐ | Name of the Accountant. | | `AccountCode` | `varchar2` | Account Code | ☐ | Code of Account. | | `AccountName` | `varchar2` | Account Name | ☐ | Name of Account. | | `ActionDate` | `datetime` | Action Date | ☐ | Indicates the date before/on the NextAction is supposed to be done. | | `AmountDC` | `double` | Amount Division Currency | ☐ | Amount in the default currency of the company. AmountDC = AmountFC * RateFC. | | `AmountFC` | `double` | Amount Foreign Currency | ☐ | Amount in the currency of the transaction. | | `BackToLeadDevelopment` | `datetime` | | ☐ | Indicate the date back to lead development. | | `Campaign` | `guid` | Campaign | ☐ | Reference to the campaign opportunity is related to. | | `CampaignDescription` | `varchar2` | Campaign Description | ☐ | Description of Campaign. | | `Channel` | `int16` | Channel | ☐ | Reference to the channel opportunity is related to. | | `ChannelDescription` | `varchar2` | Channel Description | ☐ | Description of Channel. | | `CloseDate` | `datetime` | Date Closed | ☐ | The date when the opportunity is expected to be closed. | | `Created` | `datetime` | Created | ☐ | Creation date. | | `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. | | `Creator` | `guid` | Creator | ☐ | User ID of creator. | | `CreatorFullName` | `varchar2` | Creator Full Name | ☐ | Name of the creator. | | `Currency` | `varchar2` | Currency | ☐ | Currency code. | | `CustomerDemandsDescription` | `varchar2` | | ☐ | Description related to customer demand. | | `DecisionMakingUnitName` | `varchar2` | | ☐ | DMU fields-Unit Name. | | `DecisionMakingUnitRole` | `varchar2` | | ☐ | DMU fields- Unit Role. | | `DecisionTimeframe` | `varchar2` | Decision Timeframe | ☐ | Description of the time frame. | | `DispatchToSales` | `datetime` | | ☐ | Indicate the date when dispatch to sales. | | `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. | | `IsAssociatedPrice` | `int16` | Is Associated Price | ☐ | Aware of associated prices. | | `IsCustomerDemandsMeet` | `int16` | | ☐ | Standard product solves customer demands. | | `LeadDeveloper` | `guid` | Lead Developer | ☐ | Name of the lead developer. | | `LeadSource` | `guid` | Lead Source | ☐ | The source of the lead/opportunity. | | `LeadSourceDescription` | `varchar2` | Lead Source Description | ☐ | Description of LeadSource. | | `Modified` | `datetime` | Modified | ☐ | Last modified date. | | `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. | | `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. | | `ModifierFullName` | `varchar2` | Modified Full Name | ☐ | Name of the last modifier. | | `Name` | `varchar2` | Name | ☐ | Name of the opportunity. | | `NextAction` | `varchar2` | Next Action | ☐ | Indicates what follow up action is to be undertaken to move the opportunity towards a deal. Is used in combination with ActionDate. | | `Notes` | `varchar2` | Notes | ☐ | Notes of the opportunity. | | `Number` | `int32` | Number | ☑ | | | `OpportunityDepartmentCode` | `int16` | | ☐ | Code of Opportunity Department. | | `OpportunityDepartmentDescription` | `varchar2` | | ☐ | Description of Opportunity Department. | | `OpportunityStage` | `guid` | Opportunity Stage | ☐ | The stage of the opportunity. This is a list defined by the user. | | `OpportunityStageDescription` | `varchar2` | Opportunity Stage Description | ☐ | Description of OpportunityStage. | | `OpportunityStatus` | `int32` | Opportunity Status | ☐ | Status: 1=Open, 2=Closed won, 3=Closed lost. | | `OpportunityType` | `int16` | Opportunity Type | ☐ | Code of Opportunity Type. | | `OpportunityTypeDescription` | `varchar2` | Opportunity Type Description | ☐ | Description of Opportunity Type. | | `Owner` | `guid` | Owner | ☐ | The resource who owns the opportunity and is responsible to close the opportunity (either won or lost). | | `OwnerFullName` | `varchar2` | Owner Full Name | ☐ | Name of Owner. | | `Probability` | `double` | Probability | ☐ | The chance that the opportunity will be closed and won. The default for the probability depends on the default from the opportunity stage. | | `Project` | `guid` | Project | ☐ | Reference to project. | | `ProjectCode` | `varchar2` | Project Code | ☐ | Code of Project. | | `ProjectDescription` | `varchar2` | Project Description | ☐ | Description of Project. | | `RateFC` | `double` | Rate Foreign Currency | ☐ | Exchange rate from original to division currency. | | `ReasonBack` | `varchar2` | Reason Back | ☐ | Indicate the reason back. | | `ReasonCode` | `guid` | Reason Code | ☐ | Indicates the reason why the opportunity was lost. | | `ReasonCodeDescription` | `varchar2` | Reason Code Description | ☐ | Description of ReasonCode. | | `Reseller` | `guid` | Reseller | ☐ | Reseller linked to the opportunity. | | `ResellerCode` | `varchar2` | Reseller Code | ☐ | Code of the Reseller. | | `ResellerName` | `varchar2` | Reseller Name | ☐ | Name of the Reseller. | | `SalesType` | `guid` | Sales Type | ☐ | Reference to Sales type. | | `SalesTypeDescription` | `varchar2` | Sales Type Description | ☐ | Description of SalesType. |