invantive documentation
Invantive Support ForumsLog In / Sign Up

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.

Set up this platform in Invantive Cloud: https://cloud.invantive.com/afas

Text comparisons on this platform are case sensitive.

Platform

  • Used from: Invantive Cloud and the Invantive products on your own computer or server.
  • Kind: an application reached over its API.
  • The data is partitioned, such as per company or administration.
  • One query can read several companies at once.
  • 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.

Figures

Figure Count
Tables 262
Columns 3,097
Tables with insert 70
Tables with update 18
Tables with delete 18
Tables documented 186

Data Model Poster

This data model declares no keys yet; the dotted relations are derived from column names.

PDF, 1 A0 sheet

On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.

AFAS Profit data model, Sheet 1 of 1AFAS Profit data modelfor use with Invantive UniversalSQLRelease 27.1.33-BETA+6408 · 07-11-2026OtherSheet 1 of 1 · documentation.invantive.euOtherAfasOnline.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_profielenProfitAfasOnline.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'.NotesThis data model declares no keys yet; the dotted relations are derived from column names.Data dictionaryEvery table and column of this data model is described with its documentation ondocumentation.invantive.eu, where the poster is also available in other languages.NotesThe boxes are grouped by topic and coloured by category. A relation is drawn in the topic of thetable holding the key; a box in pale grey is defined in another topic.TopicsOther1Tables without relations1LegendTransactionalSetupTechnicalHard-coded valuesDefined in another topicDeclared keyRelation described in wordsCandidate derived from column namesBold: a popular table+Bulk, +Read: the table also exists as these variants×n: n keys between the same tablesGenerated from the metadata of Invantive UniversalSQL 27.1.33-BETA+6408 on 07-11-2026. Every table links toits page with columns, keys and sample queries.documentation.invantive.eu/en/datamodels/afas
The poster as text: tables per topic and their relations

Other

profit_featurecombination, profit_subject_tasks, workflows

Afaspocket (without relations)

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 (without relations)

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

Caseware (without relations)

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

Checkin (without relations)

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

Connector (without relations)

connectors

Ddi (without relations)

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 (without relations)

fbdeliverynote_fbdeliverynotelines

Fbpurchprice (without relations)

fbpurchprice

Fbsubscription (without relations)

fbsubscription

Fibudget (without relations)

fibudget

Fientriescustom (without relations)

fientriescustom

Fientry (without relations)

fientries

Fiinvoice (without relations)

fiinvoice

Hrcostcarrier (without relations)

hrcostcarrier

Hrcostcentre (without relations)

hrcostcentre

Hrempcourse (without relations)

hrempcourse

Improvit (without relations)

improvit_api_dossier_reacties, improvit_api_dossier_type, improvit_test

Infine (without relations)

infine_crediteuren, infine_debiteuren

Knaddress (without relations)

knaddress

Knappointment (without relations)

knappointment

Kncoursegroupline (without relations)

kncoursegrouplines

Knpurchaserelationorg (without relations)

knpurchaserelationorg

Knpurchaserelationper (without relations)

knpurchaserelationper

Knsubject (without relations)

knsubject

Label (without relations)

labels_bij_dossieritem_reacties_incl_autorisat_2, labels_bij_dossieritem_reacties_incl_autorisatie

Medisoft (without relations)

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 (without relations)

metainfo

Mutatie (without relations)

mutatie_formatiebegroting, mutatie_formatieplaats

NATIVEPLATFORMSCALARREQUESTS (without relations)

NATIVEPLATFORMSCALARREQUESTS

Oci (without relations)

oci_definitie, oci_profielen

Profit (without relations)

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 (without relations)

profitgetconnectoren

Profitversion (without relations)

profitversion

Ptprognosisproject (without relations)

ptprognosisproject

Ptproject (without relations)

ptproject_knbasicaddressadr, ptproject_ptprojectstage, ptproject_pttailspend

Ptprojectdimcode (without relations)

ptprojectdimcode

Ptprojectraiserule (without relations)

ptprojectraiserules

Typen (without relations)

typen_dossieritem

Updateconnectoren (without relations)

updateconnectoren

Visionplanner (without relations)

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

Vplan (without relations)

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 (without relations)

workflowtaken

Relations

Tables

AfasOnline.FileConnector

AfasOnline.GetConnector

AfasOnline.ImageConnector

AfasOnline.MetaInfoConnector

AfasOnline.Native

AfasOnline.ReportConnector

AfasOnline.SubjectConnector

AfasOnline.UpdateConnector

AfasOnline.VersionConnector

Attributes

The attributes of this platform are on the page Attributes.