invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

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.

Configurez cette plateforme dans Invantive Cloud : https://cloud.invantive.com/afas

Les comparaisons de texte sur cette plateforme tiennent compte de la casse.

Plate-forme

  • Utilisable depuis : Invantive Cloud et les produits Invantive installés sur votre ordinateur ou votre serveur.
  • Type : une application accessible via son API.
  • Les données sont regroupées par catégorie, par exemple par entreprise ou par administration.
  • Une Query peut interroger plusieurs entreprises à la fois.
  • 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.

Chiffres

Figure Count
Tables 262
Columns 3,097
Tableaux avec insert 70
Tables avec mise à jour 18
Tables avec la clause DELETE 18
Tableaux documentés 186

Affiche sur le modèle de données

Ce modèle de données ne déclare pour l'instant aucune clé ; les relations indiquées par des points sont dérivées des noms de colonnes.

PDF, 1 feuille A0

Sur une table de l'affiche : Zoom avant et arrière, les touches fléchées permettent de se déplacer, la touche 0 permet de revenir à la taille normale.

AFAS Profit Modèle de données, Page 1 sur 1AFAS Profit Modèle de donnéesà utiliser avec Invantive UniversalSQLCommuniqué 27.1.33-BETA+6408 · 07-11-2026AutrePage 1 sur 1 · documentation.invantive.euAutreAfasOnline.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_themeConnecteurAfasOnline.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_knsubjectknsubjectÉtiquetteAfasOnline.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_profielenBénéficeAfasOnline.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'.NotesCe modèle de données ne déclare pour l'instant aucune clé ; les relations indiquées par des pointssont dérivées des noms de colonnes.Dictionnaire de donnéesChaque table et chaque colonne de ce Modèle de données sont décrites dans la documentationdisponible sur documentation.invantive.eu, où cette documentation est également accessibledans d'autres langues.NotesLes boîtes sont regroupées par thème et identifiées par une couleur selon leur catégorie. Unerelation est établie dans la rubrique du tableau contenant la clé ; une Box de couleur gris pâle estdéfinie dans une autre rubrique.SujetsAutre1Tables sans relations1LégendeTransactionnelSetupTechniqueValeurs codées en durDéfini dans une autre rubriqueClé déclaréeRelation décrite avec des motsCandidat dérivé des noms de colonnesEn gras : une table très appréciée+Bulk, +Read : la Table existe également sous ces variantes: n clés entre les mêmes tablesGénéré à partir des métadonnées d'Invantive UniversalSQL 27.1.33-BETA+6408 le 07-11-2026. Chaque tablerenvoie vers sa page présentant les colonnes, les clés et des exemples de requêtes.documentation.invantive.eu/fr/datamodels/afas
L'affiche sous forme de texte : tableaux par thème et leurs relations

Autre

profit_featurecombination, profit_subject_tasks, workflows

Afaspocket (sans 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 (sans relations)

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

Caseware (sans relations)

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

Checkin (sans relations)

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

Connecteur (sans relations)

connectors

Ddi (sans 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 (sans relations)

fbdeliverynote_fbdeliverynotelines

Fbpurchprice (sans relations)

fbpurchprice

Fbsubscription (sans relations)

fbsubscription

Fibudget (sans relations)

fibudget

Fientriescustom (sans relations)

fientriescustom

Fientry (sans relations)

fientries

Fiinvoice (sans relations)

fiinvoice

Hrcostcarrier (sans relations)

hrcostcarrier

Hrcostcentre (sans relations)

hrcostcentre

Hrempcourse (sans relations)

hrempcourse

Improvit (sans relations)

improvit_api_dossier_reacties, improvit_api_dossier_type, improvit_test

Infine (sans relations)

infine_crediteuren, infine_debiteuren

Knaddress (sans relations)

knaddress

Knappointment (sans relations)

knappointment

Kncoursegroupline (sans relations)

kncoursegrouplines

Knpurchaserelationorg (sans relations)

knpurchaserelationorg

Knpurchaserelationper (sans relations)

knpurchaserelationper

Knsubject (sans relations)

knsubject

Étiquette (sans relations)

labels_bij_dossieritem_reacties_incl_autorisat_2, labels_bij_dossieritem_reacties_incl_autorisatie

Medisoft (sans 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 (sans relations)

metainfo

Mutatie (sans relations)

mutatie_formatiebegroting, mutatie_formatieplaats

NATIVEPLATFORMSCALARREQUESTS (sans relations)

NATIVEPLATFORMSCALARREQUESTS

Oci (sans relations)

oci_definitie, oci_profielen

Bénéfice (sans 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 (sans relations)

profitgetconnectoren

Profitversion (sans relations)

profitversion

Ptprognosisproject (sans relations)

ptprognosisproject

Ptproject (sans relations)

ptproject_knbasicaddressadr, ptproject_ptprojectstage, ptproject_pttailspend

Ptprojectdimcode (sans relations)

ptprojectdimcode

Ptprojectraiserule (sans relations)

ptprojectraiserules

Typen (sans relations)

typen_dossieritem

Updateconnectoren (sans relations)

updateconnectoren

Visionplanner (sans relations)

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

Vplan (sans 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 (sans relations)

workflowtaken

Relations

Tableaux

AfasOnline.FileConnector

AfasOnline.GetConnector

AfasOnline.ImageConnector

AfasOnline.MetaInfoConnector

AfasOnline.Native

AfasOnline.ReportConnector

AfasOnline.SubjectConnector

AfasOnline.UpdateConnector

AfasOnline.VersionConnector

Attributs

The attributes of this platform are on the page Attributes.