invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

AFAS Profit Data Model

AFAS Online is online accounting, ERP and payrolling software for Dutch companies. AFAS Online has approximately 15.000 customers, including most of the top 30 accounting firms in the Netherlands.

Alternative Name AFAS Online is also popular by the former name AFAS Profit. In most documentation, the term 'AFAS Profit' can be read as the new name 'AFAS Online'.

Authentication Authentication can be done using using a token and subscription number. The token contains both user identification, connector identification as well as environment associated with the subscription. An API token for cobination of user, connector and environment can be generated from the AFAS Online menu: 'Administration' > 'App Connector' > 'app name' > 'User Tokens', as described on https://static-kb.afas.nl/datafiles/help/2_9_7/SE/NL/index.htm#App_Cnr_Rest_Appcon.htm.

Stel dit platform in Invantive Cloud in: https://cloud.invantive.com/afas

Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.

Platform

  • Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
  • Type: een applicatie die via de API toegankelijk is.
  • De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
  • Met één Query kunnen meerdere bedrijven tegelijk worden opgehaald.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://afasstatus.nl/.
  • Language of its user community: Dutch.

Cijfers

Figure Count
Tables 262
Columns 3,097
Tabeller med invoegsel 70
Tabeller med update 18
Tabellen met de functie 'verwijderen' 18
Tabeller gedocumenteerd 186

Poster met datamodel

In dit datamodel zijn nog geen sleutels gedefinieerd; de met punten gescheiden relaties worden afgeleid uit de namen van de kolommen.

PDF, 1 A0-vel

Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.

AFAS Profit Datamodel, Pagina 1 van 1AFAS Profit Datamodelvoor gebruik met Invantive UniversalSQLPersbericht 27.1.33-BETA+6408 · 07-11-2026OverigePagina 1 van 1 · documentation.invantive.euOverigeAfasOnline.GetConnector.profit_featurecombination: itgen_aoe_profit_featurecombinationprofit_featurecombinationAfasOnline.GetConnector.profit_subject_tasks: itgen_aoe_profit_subject_tasksprofit_subject_tasksAfasOnline.GetConnector.workflows: itgen_aoe_workflowsworkflowsAfaspocketAfasOnline.GetConnector.afaspocket_activities: Activities (AFAS Pocket)afaspocket_activitiesAfasOnline.GetConnector.afaspocket_activities_2: itgen_aoe_afaspocket_activities_2afaspocket_activities_2AfasOnline.GetConnector.afaspocket_contacts: Contacts (AFAS Pocket)afaspocket_contactsAfasOnline.GetConnector.afaspocket_expense_types: Expense Types (AFAS Pocket)afaspocket_expense_typesAfasOnline.GetConnector.afaspocket_illness_reasons: Illness Reasons (AFAS Pocket)afaspocket_illness_reasonsAfasOnline.GetConnector.afaspocket_illness_reasons_2: itgen_aoe_afaspocket_illness_reasons_2afaspocket_illness_reasons_2AfasOnline.GetConnector.afaspocket_illness_status: Illness Statusesafaspocket_illness_statusAfasOnline.GetConnector.afaspocket_leave_balance: Leave Balancesafaspocket_leave_balanceAfasOnline.GetConnector.afaspocket_leave_reasons: Leave Reasonsafaspocket_leave_reasonsAfasOnline.GetConnector.afaspocket_leave_types: Leave Typesafaspocket_leave_typesAfasOnline.GetConnector.afaspocket_leaves: Leavesafaspocket_leavesAfasOnline.GetConnector.afaspocket_projects: Projects (AFAS Pocket)afaspocket_projectsAfasOnline.GetConnector.afaspocket_timesheets: Timesheetsafaspocket_timesheetsAfasOnline.GetConnector.afaspocket_user: Usersafaspocket_userBiAfasOnline.GetConnector.bi_abonnementsregels: itgen_aoe_bi_abonnementsregelsbi_abonnementsregelsAfasOnline.GetConnector.bi_contactpersonen: itgen_aoe_bi_contactpersonenbi_contactpersonenAfasOnline.GetConnector.bi_dossieritems_salesforecast: itgen_aoe_bi_dossieritems_salesforecastbi_dossieritems_salesforecastAfasOnline.GetConnector.bi_logactieswf_big: itgen_aoe_bi_logactieswf_bigbi_logactieswf_bigAfasOnline.GetConnector.bi_logactieswf_sua: itgen_aoe_bi_logactieswf_suabi_logactieswf_suaAfasOnline.GetConnector.bi_organisaties_personen: itgen_aoe_bi_organisaties_personenbi_organisaties_personenAfasOnline.GetConnector.bi_verkoopfactuurregels: itgen_aoe_bi_verkoopfactuurregelsbi_verkoopfactuurregelsAfasOnline.GetConnector.bi_verkoopofferteregels: itgen_aoe_bi_verkoopofferteregelsbi_verkoopofferteregelsAfasOnline.GetConnector.bi_verkooporderregels: itgen_aoe_bi_verkooporderregelsbi_verkooporderregelsCasewareAfasOnline.GetConnector.caseware_administraties: Companies (CaseWare)caseware_administratiesAfasOnline.GetConnector.caseware_ledgerbalances: Balances (CaseWare)caseware_ledgerbalancesAfasOnline.GetConnector.caseware_perioden: Periods (CaseWare)caseware_periodenAfasOnline.GetConnector.caseware_periodetabel: itgen_aoe_caseware_periodetabelcaseware_periodetabelAfasOnline.GetConnector.caseware_periods: itgen_aoe_caseware_periodscaseware_periodsAfasOnline.GetConnector.caseware_periodtable: itgen_aoe_caseware_periodtablecaseware_periodtableAfasOnline.GetConnector.caseware_transactions: itgen_aoe_caseware_transactionscaseware_transactionsCheckinAfasOnline.GetConnector.checkin_appointment: itgen_aoe_checkin_appointmentcheckin_appointmentAfasOnline.GetConnector.checkin_appointment_owners: itgen_aoe_checkin_appointment_ownerscheckin_appointment_ownersAfasOnline.GetConnector.checkin_appointments: itgen_aoe_checkin_appointmentscheckin_appointmentsAfasOnline.GetConnector.checkin_event: itgen_aoe_checkin_eventcheckin_eventAfasOnline.GetConnector.checkin_event_teachers: itgen_aoe_checkin_event_teacherscheckin_event_teachersAfasOnline.GetConnector.checkin_locations: itgen_aoe_checkin_locationscheckin_locationsAfasOnline.GetConnector.checkin_printers: itgen_aoe_checkin_printerscheckin_printersAfasOnline.GetConnector.checkin_profile_image: itgen_aoe_checkin_profile_imagecheckin_profile_imageAfasOnline.GetConnector.checkin_theme: itgen_aoe_checkin_themecheckin_themeConnectorAfasOnline.MetaInfoConnector.connectors: ConnectorsconnectorsDdiAfasOnline.GetConnector.ddi_profit_administraties: Companiesddi_profit_administratiesAfasOnline.GetConnector.ddi_profit_btwcode: VAT Codesddi_profit_btwcodeAfasOnline.GetConnector.ddi_profit_crediteuren: itgen_aoe_ddi_profit_crediteurenddi_profit_crediteurenAfasOnline.GetConnector.ddi_profit_dagboeken: Journalsddi_profit_dagboekenAfasOnline.GetConnector.ddi_profit_dimensies: itgen_aoe_ddi_profit_dimensiesddi_profit_dimensiesAfasOnline.GetConnector.ddi_profit_dimensies_2: itgen_aoe_ddi_profit_dimensies_2ddi_profit_dimensies_2AfasOnline.GetConnector.ddi_profit_dimensies_3: itgen_aoe_ddi_profit_dimensies_3ddi_profit_dimensies_3AfasOnline.GetConnector.ddi_profit_grootboek: itgen_aoe_ddi_profit_grootboekddi_profit_grootboekAfasOnline.GetConnector.ddi_profit_kosten: itgen_aoe_ddi_profit_kostenddi_profit_kostenAfasOnline.GetConnector.ddi_profit_kostendragers: itgen_aoe_ddi_profit_kostendragersddi_profit_kostendragersAfasOnline.GetConnector.ddi_profit_kostenplaatsen: itgen_aoe_ddi_profit_kostenplaatsenddi_profit_kostenplaatsenAfasOnline.GetConnector.ddi_profit_periodes: Financial Periodsddi_profit_periodesAfasOnline.GetConnector.ddi_profit_projecten: Projectsddi_profit_projectenAfasOnline.GetConnector.ddi_profit_valuta: itgen_aoe_ddi_profit_valutaddi_profit_valutaFbdeliverynoteAfasOnline.UpdateConnector.fbdeliverynote_fbdeliverynotelines: itgen_aoe_fbdeliverynote_fbdeliverynotelinesfbdeliverynote_fbdeliverynotelinesFbpurchpriceAfasOnline.UpdateConnector.fbpurchprice: itgen_aoe_fbpurchpricefbpurchpriceFbsubscriptionAfasOnline.UpdateConnector.fbsubscription: itgen_aoe_fbsubscriptionfbsubscriptionFibudgetAfasOnline.UpdateConnector.fibudget: itgen_aoe_fibudgetfibudgetFientriescustomAfasOnline.UpdateConnector.fientriescustom: itgen_aoe_fientriescustomfientriescustomFientryAfasOnline.UpdateConnector.fientries: itgen_aoe_fientriesfientriesFiinvoiceAfasOnline.UpdateConnector.fiinvoice: itgen_aoe_fiinvoicefiinvoiceHrcostcarrierAfasOnline.UpdateConnector.hrcostcarrier: itgen_aoe_hrcostcarrierhrcostcarrierHrcostcentreAfasOnline.UpdateConnector.hrcostcentre: itgen_aoe_hrcostcentrehrcostcentreHrempcourseAfasOnline.UpdateConnector.hrempcourse: itgen_aoe_hrempcoursehrempcourseImprovitAfasOnline.GetConnector.improvit_api_dossier_reacties: itgen_aoe_improvit_api_dossier_reactiesimprovit_api_dossier_reactiesAfasOnline.GetConnector.improvit_api_dossier_type: itgen_aoe_improvit_api_dossier_typeimprovit_api_dossier_typeAfasOnline.GetConnector.improvit_test: itgen_aoe_improvit_testimprovit_testInfineAfasOnline.GetConnector.infine_crediteuren: itgen_aoe_infine_crediteureninfine_crediteurenAfasOnline.GetConnector.infine_debiteuren: itgen_aoe_infine_debiteureninfine_debiteurenKnaddressAfasOnline.UpdateConnector.knaddress: itgen_aoe_knaddressknaddressKnappointmentAfasOnline.UpdateConnector.knappointment: itgen_aoe_knappointmentknappointmentKncoursegrouplineAfasOnline.UpdateConnector.kncoursegrouplines: itgen_aoe_kncoursegrouplineskncoursegrouplinesKnpurchaserelationorgAfasOnline.UpdateConnector.knpurchaserelationorg: itgen_aoe_knpurchaserelationorgknpurchaserelationorgKnpurchaserelationperAfasOnline.UpdateConnector.knpurchaserelationper: itgen_aoe_knpurchaserelationperknpurchaserelationperKnsubjectAfasOnline.UpdateConnector.knsubject: itgen_aoe_knsubjectknsubjectLabelAfasOnline.GetConnector.labels_bij_dossieritem_reacties_incl_autorisat_2: itgen_aoe_labels_bij_dossieritem_reacties_incl_autorisat_2labels_bij_dossieritem_reacties_incl_autorisat_2AfasOnline.GetConnector.labels_bij_dossieritem_reacties_incl_autorisatie: itgen_aoe_labels_bij_dossieritem_reacties_incl_autorisatielabels_bij_dossieritem_reacties_incl_autorisatieMedisoftAfasOnline.GetConnector.medisoft_dienstverband_3_50_0: itgen_aoe_medisoft_dienstverband_3_50_0medisoft_dienstverband_3_50_0AfasOnline.GetConnector.medisoft_dienstverband_3_50_1: itgen_aoe_medisoft_dienstverband_3_50_1medisoft_dienstverband_3_50_1AfasOnline.GetConnector.medisoft_dienstverband_3_50_2: itgen_aoe_medisoft_dienstverband_3_50_2medisoft_dienstverband_3_50_2AfasOnline.GetConnector.medisoft_dienstverband_3_50_3: itgen_aoe_medisoft_dienstverband_3_50_3medisoft_dienstverband_3_50_3AfasOnline.GetConnector.medisoft_dienstverband_3_50_4: itgen_aoe_medisoft_dienstverband_3_50_4medisoft_dienstverband_3_50_4AfasOnline.GetConnector.medisoft_dienstverband_3_50_5: itgen_aoe_medisoft_dienstverband_3_50_5medisoft_dienstverband_3_50_5AfasOnline.GetConnector.medisoft_verzuim_3_50_0: itgen_aoe_medisoft_verzuim_3_50_0medisoft_verzuim_3_50_0AfasOnline.GetConnector.medisoft_verzuim_3_50_1: itgen_aoe_medisoft_verzuim_3_50_1medisoft_verzuim_3_50_1AfasOnline.GetConnector.medisoft_verzuim_3_50_2: itgen_aoe_medisoft_verzuim_3_50_2medisoft_verzuim_3_50_2AfasOnline.GetConnector.medisoft_verzuim_3_50_3: itgen_aoe_medisoft_verzuim_3_50_3medisoft_verzuim_3_50_3AfasOnline.GetConnector.medisoft_verzuim_3_50_4: itgen_aoe_medisoft_verzuim_3_50_4medisoft_verzuim_3_50_4AfasOnline.GetConnector.medisoft_verzuim_3_50_5: itgen_aoe_medisoft_verzuim_3_50_5medisoft_verzuim_3_50_5MetainfoAfasOnline.MetaInfoConnector.metainfo: Environment InformationmetainfoMutatieAfasOnline.GetConnector.mutatie_formatiebegroting: itgen_aoe_mutatie_formatiebegrotingmutatie_formatiebegrotingAfasOnline.GetConnector.mutatie_formatieplaats: itgen_aoe_mutatie_formatieplaatsmutatie_formatieplaatsNATIVEPLATFORMSCALARREQUESTSAfasOnline.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSOciAfasOnline.GetConnector.oci_definitie: itgen_aoe_oci_definitieoci_definitieAfasOnline.GetConnector.oci_profielen: itgen_aoe_oci_profielenoci_profielenWinstAfasOnline.GetConnector.profit_accounts: Accountsprofit_accountsAfasOnline.GetConnector.profit_address: Addressesprofit_addressAfasOnline.GetConnector.profit_administrations: itgen_aoe_profit_administrationsprofit_administrationsAfasOnline.GetConnector.profit_allocation_assigments: itgen_aoe_profit_allocation_assigmentsprofit_allocation_assigmentsAfasOnline.GetConnector.profit_article: Articlesprofit_articleAfasOnline.GetConnector.profit_article_basic: Articles (Basic)profit_article_basicAfasOnline.GetConnector.profit_article_image: Article Imagesprofit_article_imageAfasOnline.GetConnector.profit_articlegroups: Article Groupsprofit_articlegroupsAfasOnline.GetConnector.profit_balance_allocated: itgen_aoe_profit_balance_allocatedprofit_balance_allocatedAfasOnline.GetConnector.profit_bankaccounts: Bank Accountsprofit_bankaccountsAfasOnline.GetConnector.profit_barcode_per_item: itgen_aoe_profit_barcode_per_itemprofit_barcode_per_itemAfasOnline.GetConnector.profit_composition: itgen_aoe_profit_compositionprofit_compositionAfasOnline.GetConnector.profit_contacts: Contactsprofit_contactsAfasOnline.GetConnector.profit_costcarrier: Cost Unitsprofit_costcarrierAfasOnline.GetConnector.profit_costcentre: Cost Centreprofit_costcentreAfasOnline.GetConnector.profit_creditor: itgen_aoe_profit_creditorprofit_creditorAfasOnline.GetConnector.profit_creditor_invoices: itgen_aoe_profit_creditor_invoicesprofit_creditor_invoicesAfasOnline.GetConnector.profit_currency: Currenciesprofit_currencyAfasOnline.GetConnector.profit_debtor: Debtorsprofit_debtorAfasOnline.GetConnector.profit_debtor_invoices: Debtor Invoicesprofit_debtor_invoicesAfasOnline.GetConnector.profit_deliverynotelines: itgen_aoe_profit_deliverynotelinesprofit_deliverynotelinesAfasOnline.GetConnector.profit_deliverynotes: itgen_aoe_profit_deliverynotesprofit_deliverynotesAfasOnline.GetConnector.profit_employees: Employeesprofit_employeesAfasOnline.GetConnector.profit_employees_basic: Employees (Basic)profit_employees_basicAfasOnline.GetConnector.profit_employers: Employersprofit_employersAfasOnline.GetConnector.profit_features: Featuresprofit_featuresAfasOnline.GetConnector.profit_featurevalue: Feature Valuesprofit_featurevalueAfasOnline.GetConnector.profit_fin_changedentrydate: itgen_aoe_profit_fin_changedentrydateprofit_fin_changedentrydateAfasOnline.GetConnector.profit_functions: Functionsprofit_functionsAfasOnline.GetConnector.profit_hourtype: Hour Typesprofit_hourtypeAfasOnline.GetConnector.profit_illness: Illnessesprofit_illnessAfasOnline.GetConnector.profit_journals: Journalsprofit_journalsAfasOnline.GetConnector.profit_languages: itgen_aoe_profit_languagesprofit_languagesAfasOnline.GetConnector.profit_leavebalance: Leave Balancesprofit_leavebalanceAfasOnline.GetConnector.profit_leaves: Leavesprofit_leavesAfasOnline.GetConnector.profit_organizationchart: itgen_aoe_profit_organizationchartprofit_organizationchartAfasOnline.GetConnector.profit_orgper: itgen_aoe_profit_orgperprofit_orgperAfasOnline.GetConnector.profit_period_balance: Period Balanceprofit_period_balanceAfasOnline.GetConnector.profit_periods_per_administration: itgen_aoe_profit_periods_per_administrationprofit_periods_per_administrationAfasOnline.GetConnector.profit_projectgroups: Project Groupsprofit_projectgroupsAfasOnline.GetConnector.profit_projects: Projectsprofit_projectsAfasOnline.GetConnector.profit_projectstage: itgen_aoe_profit_projectstageprofit_projectstageAfasOnline.GetConnector.profit_quotation: itgen_aoe_profit_quotationprofit_quotationAfasOnline.GetConnector.profit_rea_changedentrydate: itgen_aoe_profit_rea_changedentrydateprofit_rea_changedentrydateAfasOnline.GetConnector.profit_realization: itgen_aoe_profit_realizationprofit_realizationAfasOnline.GetConnector.profit_residence: itgen_aoe_profit_residenceprofit_residenceAfasOnline.GetConnector.profit_rooster_ouderverlof: itgen_aoe_profit_rooster_ouderverlofprofit_rooster_ouderverlofAfasOnline.GetConnector.profit_salesorderlines: Sales Order Linesprofit_salesorderlinesAfasOnline.GetConnector.profit_salesorders: Sales Ordersprofit_salesordersAfasOnline.GetConnector.profit_salesprice: Sales Pricesprofit_salespriceAfasOnline.GetConnector.profit_sepa_incassomachtigingen: itgen_aoe_profit_sepa_incassomachtigingenprofit_sepa_incassomachtigingenAfasOnline.GetConnector.profit_stock: itgen_aoe_profit_stockprofit_stockAfasOnline.GetConnector.profit_stock_per_warehouse: itgen_aoe_profit_stock_per_warehouseprofit_stock_per_warehouseAfasOnline.GetConnector.profit_subject_attachments: itgen_aoe_profit_subject_attachmentsprofit_subject_attachmentsAfasOnline.GetConnector.profit_subject_reaction_attachments: itgen_aoe_profit_subject_reaction_attachmentsprofit_subject_reaction_attachmentsAfasOnline.GetConnector.profit_subjectfile: itgen_aoe_profit_subjectfileprofit_subjectfileAfasOnline.GetConnector.profit_subjects: Subjectsprofit_subjectsAfasOnline.GetConnector.profit_subjectsdest: itgen_aoe_profit_subjectsdestprofit_subjectsdestAfasOnline.GetConnector.profit_subjecttypes: itgen_aoe_profit_subjecttypesprofit_subjecttypesAfasOnline.GetConnector.profit_subscriptions: itgen_aoe_profit_subscriptionsprofit_subscriptionsAfasOnline.GetConnector.profit_timetable: itgen_aoe_profit_timetableprofit_timetableAfasOnline.GetConnector.profit_transactions: itgen_aoe_profit_transactionsprofit_transactionsAfasOnline.GetConnector.profit_transactions_allocated: itgen_aoe_profit_transactions_allocatedprofit_transactions_allocatedAfasOnline.GetConnector.profit_unit_per_item: itgen_aoe_profit_unit_per_itemprofit_unit_per_itemAfasOnline.GetConnector.profit_usergroups: itgen_aoe_profit_usergroupsprofit_usergroupsAfasOnline.GetConnector.profit_users: Usersprofit_usersAfasOnline.GetConnector.profit_vat_code: VAT Codesprofit_vat_codeAfasOnline.GetConnector.profit_warehouses: Warehousesprofit_warehousesAfasOnline.GetConnector.profit_workflowactions: itgen_aoe_profit_workflowactionsprofit_workflowactionsAfasOnline.GetConnector.profit_workflowactions_2: itgen_aoe_profit_workflowactions_2profit_workflowactions_2AfasOnline.GetConnector.profit_workflowactions_3: itgen_aoe_profit_workflowactions_3profit_workflowactions_3AfasOnline.GetConnector.profit_worktype: Work Typesprofit_worktypeProfitgetconnectorenAfasOnline.GetConnector.profitgetconnectoren: itgen_aoe_profitgetconnectorenprofitgetconnectorenProfitversionAfasOnline.VersionConnector.profitversion: Version InformationprofitversionPtprognosisprojectAfasOnline.UpdateConnector.ptprognosisproject: itgen_aoe_ptprognosisprojectptprognosisprojectPtprojectAfasOnline.UpdateConnector.ptproject_knbasicaddressadr: itgen_aoe_ptproject_knbasicaddressadrptproject_knbasicaddressadrAfasOnline.UpdateConnector.ptproject_ptprojectstage: itgen_aoe_ptproject_ptprojectstageptproject_ptprojectstageAfasOnline.UpdateConnector.ptproject_pttailspend: itgen_aoe_ptproject_pttailspendptproject_pttailspendPtprojectdimcodeAfasOnline.UpdateConnector.ptprojectdimcode: itgen_aoe_ptprojectdimcodeptprojectdimcodePtprojectraiseruleAfasOnline.UpdateConnector.ptprojectraiserules: itgen_aoe_ptprojectraiserulesptprojectraiserulesTypenAfasOnline.GetConnector.typen_dossieritem: itgen_aoe_typen_dossieritemtypen_dossieritemUpdateconnectorenAfasOnline.GetConnector.updateconnectoren: Update ConnectorsupdateconnectorenVisionplannerAfasOnline.GetConnector.visionplanner_administrations: itgen_aoe_visionplanner_administrationsvisionplanner_administrationsAfasOnline.GetConnector.visionplanner_changed_description_gen_ledger: itgen_aoe_visionplanner_changed_description_gen_ledgervisionplanner_changed_description_gen_ledgerAfasOnline.GetConnector.visionplanner_dossieritems: itgen_aoe_visionplanner_dossieritemsvisionplanner_dossieritemsAfasOnline.GetConnector.visionplanner_outstanding_payables: itgen_aoe_visionplanner_outstanding_payablesvisionplanner_outstanding_payablesAfasOnline.GetConnector.visionplanner_outstanding_receivables: itgen_aoe_visionplanner_outstanding_receivablesvisionplanner_outstanding_receivablesAfasOnline.GetConnector.visionplanner_periodvalues: itgen_aoe_visionplanner_periodvaluesvisionplanner_periodvaluesAfasOnline.GetConnector.visionplanner_periodvalues_dimensions: itgen_aoe_visionplanner_periodvalues_dimensionsvisionplanner_periodvalues_dimensionsAfasOnline.GetConnector.visionplanner_transactions: itgen_aoe_visionplanner_transactionsvisionplanner_transactionsVplanAfasOnline.GetConnector.vplan_absence: Absencesvplan_absenceAfasOnline.GetConnector.vplan_employee: Employeesvplan_employeeAfasOnline.GetConnector.vplan_employee_avatar: itgen_aoe_vplan_employee_avatarvplan_employee_avatarAfasOnline.GetConnector.vplan_employeeschedule: itgen_aoe_vplan_employeeschedulevplan_employeescheduleAfasOnline.GetConnector.vplan_employeeschedule_days: itgen_aoe_vplan_employeeschedule_daysvplan_employeeschedule_daysAfasOnline.GetConnector.vplan_item: Articlesvplan_itemAfasOnline.GetConnector.vplan_leave: Leavesvplan_leaveAfasOnline.GetConnector.vplan_productionorder: Production Ordersvplan_productionorderAfasOnline.GetConnector.vplan_productionorder_related: itgen_aoe_vplan_productionorder_relatedvplan_productionorder_relatedAfasOnline.GetConnector.vplan_productionorder_row: itgen_aoe_vplan_productionorder_rowvplan_productionorder_rowAfasOnline.GetConnector.vplan_project: Projectsvplan_projectAfasOnline.GetConnector.vplan_purchaseorder: itgen_aoe_vplan_purchaseordervplan_purchaseorderAfasOnline.GetConnector.vplan_purchaseorder_row: itgen_aoe_vplan_purchaseorder_rowvplan_purchaseorder_rowAfasOnline.GetConnector.vplan_purchaseorder_row_related: itgen_aoe_vplan_purchaseorder_row_relatedvplan_purchaseorder_row_relatedAfasOnline.GetConnector.vplan_purchaserelation: itgen_aoe_vplan_purchaserelationvplan_purchaserelationAfasOnline.GetConnector.vplan_salesorder: itgen_aoe_vplan_salesordervplan_salesorderAfasOnline.GetConnector.vplan_salesorder_row: itgen_aoe_vplan_salesorder_rowvplan_salesorder_rowAfasOnline.GetConnector.vplan_salesrelation: itgen_aoe_vplan_salesrelationvplan_salesrelationAfasOnline.GetConnector.vplan_stock: itgen_aoe_vplan_stockvplan_stockAfasOnline.GetConnector.vplan_warehouse: Warehousesvplan_warehouseAfasOnline.GetConnector.vplan_worktype: Work Typesvplan_worktypeWorkflowtakenAfasOnline.GetConnector.workflowtaken: itgen_aoe_workflowtakenworkflowtakenAFAS ProfitAlternative Name AFAS Online is also popular by the formername AFAS Profit. In most documentation, the term 'AFASProfit' can be read as the new name 'AFAS Online'.NotitiesIn dit datamodel zijn nog geen sleutels gedefinieerd; de met punten gescheiden relaties wordenafgeleid uit de namen van de kolommen.Data DictionaryElke tabel en kolom van dit datamodel wordt beschreven in de bijbehorende documentatie opdocumentation.invantive.eu, waar de poster ook in andere talen beschikbaar is.NotitiesDe boxen zijn gegroepeerd per onderwerp en gekleurd per categorie. In het onderwerp van detabel waarin de sleutel staat, wordt een relatie aangegeven; in een ander onderwerp wordt eenlichtgrijs box gedefinieerd.OnderwerpenOverige1Tabeller uden relationen1LegendaTransactioneelInrichtingTechnischVastgelegde waardenUitgelegd in een ander onderwerpVerklaarde sleutelDe relatie in woorden beschrevenKandidaat afgeleid van kolomnamenVetgedrukt: een populaire tabel+Bulk, +Lezen: de tabel bestaat ook in deze varianten\u00D7n: n toetsen tussen dezelfde tabellenGegenereerd op basis van de metagegevens van Invantive UniversalSQL 27.1.33-BETA+6408 op 07-11-2026. Elketabel bevat een link naar de bijbehorende pagina met kolommen, sleutels en voorbeeldquery's.documentation.invantive.eu/nl/datamodels/afas
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden

Overige

profit_featurecombination, profit_subject_tasks, workflows

Afaspocket (zonder relaties)

afaspocket_activities, afaspocket_activities_2, afaspocket_contacts, afaspocket_expense_types, afaspocket_illness_reasons, afaspocket_illness_reasons_2, afaspocket_illness_status, afaspocket_leave_balance, afaspocket_leave_reasons, afaspocket_leave_types, afaspocket_leaves, afaspocket_projects, afaspocket_timesheets, afaspocket_user

Bi (zonder relaties)

bi_abonnementsregels, bi_contactpersonen, bi_dossieritems_salesforecast, bi_logactieswf_big, bi_logactieswf_sua, bi_organisaties_personen, bi_verkoopfactuurregels, bi_verkoopofferteregels, bi_verkooporderregels

Caseware (zonder relaties)

caseware_administraties, caseware_ledgerbalances, caseware_perioden, caseware_periodetabel, caseware_periods, caseware_periodtable, caseware_transactions

Checkin (zonder relaties)

checkin_appointment, checkin_appointment_owners, checkin_appointments, checkin_event, checkin_event_teachers, checkin_locations, checkin_printers, checkin_profile_image, checkin_theme

Connector (zonder relaties)

connectors

Ddi (zonder relaties)

ddi_profit_administraties, ddi_profit_btwcode, ddi_profit_crediteuren, ddi_profit_dagboeken, ddi_profit_dimensies, ddi_profit_dimensies_2, ddi_profit_dimensies_3, ddi_profit_grootboek, ddi_profit_kosten, ddi_profit_kostendragers, ddi_profit_kostenplaatsen, ddi_profit_periodes, ddi_profit_projecten, ddi_profit_valuta

Fbdeliverynote (zonder relaties)

fbdeliverynote_fbdeliverynotelines

Fbpurchprice (zonder relaties)

fbpurchprice

Fbsubscription (zonder relaties)

fbsubscription

Fibudget (zonder relaties)

fibudget

Fientriescustom (zonder relaties)

fientriescustom

Fientry (zonder relaties)

fientries

Fiinvoice (zonder relaties)

fiinvoice

Hrcostcarrier (zonder relaties)

hrcostcarrier

Hrcostcentre (zonder relaties)

hrcostcentre

Hrempcourse (zonder relaties)

hrempcourse

Improvit (zonder relaties)

improvit_api_dossier_reacties, improvit_api_dossier_type, improvit_test

Infine (zonder relaties)

infine_crediteuren, infine_debiteuren

Knaddress (zonder relaties)

knaddress

Knappointment (zonder relaties)

knappointment

Kncoursegroupline (zonder relaties)

kncoursegrouplines

Knpurchaserelationorg (zonder relaties)

knpurchaserelationorg

Knpurchaserelationper (zonder relaties)

knpurchaserelationper

Knsubject (zonder relaties)

knsubject

Label (zonder relaties)

labels_bij_dossieritem_reacties_incl_autorisat_2, labels_bij_dossieritem_reacties_incl_autorisatie

Medisoft (zonder relaties)

medisoft_dienstverband_3_50_0, medisoft_dienstverband_3_50_1, medisoft_dienstverband_3_50_2, medisoft_dienstverband_3_50_3, medisoft_dienstverband_3_50_4, medisoft_dienstverband_3_50_5, medisoft_verzuim_3_50_0, medisoft_verzuim_3_50_1, medisoft_verzuim_3_50_2, medisoft_verzuim_3_50_3, medisoft_verzuim_3_50_4, medisoft_verzuim_3_50_5

Metainfo (zonder relaties)

metainfo

Mutatie (zonder relaties)

mutatie_formatiebegroting, mutatie_formatieplaats

NATIVEPLATFORMSCALARREQUESTS (zonder relaties)

NATIVEPLATFORMSCALARREQUESTS

Oci (zonder relaties)

oci_definitie, oci_profielen

Winst (zonder relaties)

profit_accounts, profit_address, profit_administrations, profit_allocation_assigments, profit_article, profit_article_basic, profit_article_image, profit_articlegroups, profit_balance_allocated, profit_bankaccounts, profit_barcode_per_item, profit_composition, profit_contacts, profit_costcarrier, profit_costcentre, profit_creditor, profit_creditor_invoices, profit_currency, profit_debtor, profit_debtor_invoices, profit_deliverynotelines, profit_deliverynotes, profit_employees, profit_employees_basic, profit_employers, profit_features, profit_featurevalue, profit_fin_changedentrydate, profit_functions, profit_hourtype, profit_illness, profit_journals, profit_languages, profit_leavebalance, profit_leaves, profit_organizationchart, profit_orgper, profit_period_balance, profit_periods_per_administration, profit_projectgroups, profit_projects, profit_projectstage, profit_quotation, profit_rea_changedentrydate, profit_realization, profit_residence, profit_rooster_ouderverlof, profit_salesorderlines, profit_salesorders, profit_salesprice, profit_sepa_incassomachtigingen, profit_stock, profit_stock_per_warehouse, profit_subject_attachments, profit_subject_reaction_attachments, profit_subjectfile, profit_subjects, profit_subjectsdest, profit_subjecttypes, profit_subscriptions, profit_timetable, profit_transactions, profit_transactions_allocated, profit_unit_per_item, profit_usergroups, profit_users, profit_vat_code, profit_warehouses, profit_workflowactions, profit_workflowactions_2, profit_workflowactions_3, profit_worktype

Profitgetconnectoren (zonder relaties)

profitgetconnectoren

Profitversion (zonder relaties)

profitversion

Ptprognosisproject (zonder relaties)

ptprognosisproject

Ptproject (zonder relaties)

ptproject_knbasicaddressadr, ptproject_ptprojectstage, ptproject_pttailspend

Ptprojectdimcode (zonder relaties)

ptprojectdimcode

Ptprojectraiserule (zonder relaties)

ptprojectraiserules

Typen (zonder relaties)

typen_dossieritem

Updateconnectoren (zonder relaties)

updateconnectoren

Visionplanner (zonder relaties)

visionplanner_administrations, visionplanner_changed_description_gen_ledger, visionplanner_dossieritems, visionplanner_outstanding_payables, visionplanner_outstanding_receivables, visionplanner_periodvalues, visionplanner_periodvalues_dimensions, visionplanner_transactions

Vplan (zonder relaties)

vplan_absence, vplan_employee, vplan_employee_avatar, vplan_employeeschedule, vplan_employeeschedule_days, vplan_item, vplan_leave, vplan_productionorder, vplan_productionorder_related, vplan_productionorder_row, vplan_project, vplan_purchaseorder, vplan_purchaseorder_row, vplan_purchaseorder_row_related, vplan_purchaserelation, vplan_salesorder, vplan_salesorder_row, vplan_salesrelation, vplan_stock, vplan_warehouse, vplan_worktype

Workflowtaken (zonder relaties)

workflowtaken

Relaties

Tabellen

AfasOnline.FileConnector

AfasOnline.GetConnector

AfasOnline.ImageConnector

AfasOnline.MetaInfoConnector

AfasOnline.Native

AfasOnline.ReportConnector

AfasOnline.SubjectConnector

AfasOnline.UpdateConnector

AfasOnline.VersionConnector

Attributen

The attributes of this platform are on the page Attributes.