# bi_dossieritems_salesforecast ## Documentation Bi_Dossieritems_SalesForecast - Catalog: `AfasOnline` - Schema: `GetConnector` This is a read-only table. The AFAS Online API may not support changing the data or the Invantive UniversalSQL driver for AFAS Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the AFAS Online API. ## Table Columns The columns of the table `bi_dossieritems_salesforecast` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `sfc_accountmanager_sp` | `int32` | Accountmanager SP | | | | `sfc_afgehandeld` | `char` | Afgehandeld SFC | | | | `sfc_begindatum` | `datetime` | Begindatum | | | | `sfc_datum_afgehandeld` | `datetime` | Datum afgehandeld SFC | | | | `sfc_direct_contact` | `int32` | Direct contact | | | | `sfc_doelgroep` | `varchar2(50)` | Doelgroep | | | | `sfc_dossieritem` | `int32` | Dossieritem | | | | `sfc_einddatum` | `datetime` | Einddatum | | | | `sfc_id_reacties` | `int32` | Id_reacties | | | | `sfc_indirect_contact` | `int32` | Indirect contact | | | | `sfc_instuurdatum_reacties` | `datetime` | Instuurdatum_reacties | | | | `sfc_instuurdatum` | `datetime` | Instuurdatum | | | | `sfc_instuurder_reactie` | `varchar2(80)` | Instuurder_reactie | | | | `sfc_klant_forecast_profiel_plaats` | `varchar2(50)` | Klant_forecast_profiel_plaats | | | | `sfc_klantforecast_profiel_nr` | `varchar2(15)` | Klantforecast profiel nr | | | | `sfc_klantforecast_profiel` | `varchar2(255)` | Klantforecast profiel | | | | `sfc_klantpiramide_2023` | `varchar2(50)` | Klantpiramide 2023 | | | | `sfc_klantpiramide_doel_2024` | `varchar2(50)` | Klantpiramide doel | | | | `sfc_klantstrategie_2024` | `varchar2(50)` | Klantstrategie | | | | `sfc_klarnt_forecast_profiel_pc` | `varchar2(15)` | Klarnt_forecast_profiel_pc | | | | `sfc_laatst_gewijzigde_veld` | `datetime` | Laatst gewijzigde veld SFC | | | | `sfc_naam_accountm` | `varchar2(255)` | Naam accountmanager | | | | `sfc_omzet_2023` | `number` | Omzet 2023 | | | | `sfc_omzet_2024_tot_nu` | `number` | Omzet 2024 | | | | `sfc_omzetpotentieel` | `number` | Omzetpotentieel | | | | `sfc_onderbouwing_verwachting` | `varchar2` | Onderbouwing verwachting | | | | `sfc_onderwerp` | `varchar2(255)` | Onderwerp SFC | | | | `sfc_reacties_omschr` | `varchar2` | Reacties omschr | | | | `sfc_servicepartn_contractlev` | `varchar2(50)` | Servicepartn/Contractlev | | | | `sfc_status_wf` | `varchar2(100)` | Status WF SFC | | | | `sfc_verantw` | `varchar2(80)` | Verantwoordelijk | | | | `sfc_verwachte_omzet_2024` | `number` | Verwachte omzet 2024 | | | | `sfc_voortgang_salesforecast` | `varchar2(100)` | Voortgang salesforecast | | |