invantive documentation
Forum di supporto InvantiveAccedi / Registrati

AFAS Profit Data Model

Questa pagina non è ancora disponibile nella tua lingua; viene visualizzata la versione originale.

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

Poster sul modello di dati

Questo modello di dati non dichiara ancora alcuna chiave; le relazioni indicate da punti derivano dai nomi delle colonne.

PDF, 1 foglio A0

Su una tabella del poster: Zoom avanti e indietro, i tasti freccia per spostarsi, 0 per adattare.

AFAS Profit Modello di dati, Foglio 1 di 1AFAS Profit Modello di datida utilizzare con Invantive UniversalSQLComunicato 27.1.33-BETA+6408 · 07-11-2026AltroFoglio 1 di 1 · documentation.invantive.euAltroAfasOnline.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_themeConnettoreAfasOnline.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_knsubjectknsubjectEtichettaAfasOnline.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_profielenProfittoAfasOnline.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'.NoteQuesto modello di dati non dichiara ancora alcuna chiave; le relazioni indicate da punti derivanodai nomi delle colonne.Dizionario dei datiOgni tabella e colonna di questo modello di dati è descritta nella relativa documentazionedisponibile su documentation.invantive.eu, dove il poster è disponibile anche in altre lingue.NoteLe box sono raggruppate per argomento e contrassegnate da colori diversi a seconda dellacategoria. Nel nodo della tabella che contiene la chiave viene tracciata una relazione; in un altronodo viene definito un Box di colore grigio chiaro.ArgomentiAltro1Tabella senza relazioni1LeggendaTransazionaleInstallazioneAspetti tecniciValori hardcodedDescritto in un altro argomentoChiave dichiarataRelazione descritta a paroleCandidato derivato dai nomi delle colonneIn grassetto: una tabella molto diffusa+Bulk, +Read: la tabella è disponibile anche in queste varianti\u00D7n: n chiavi tra le stesse tabelleGenerato dai metadati di Invantive UniversalSQL 27.1.33-BETA+6408 il 07-11-2026. Ogni tabella rimanda allarelativa pagina con le colonne, le chiavi e le Query di esempio.documentation.invantive.eu/it/datamodels/afas
Il poster come testo: tabelle per argomento e le loro relazioni

Altro

profit_featurecombination, profit_subject_tasks, workflows

Afaspocket (senza relazioni)

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 (senza relazioni)

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

Caseware (senza relazioni)

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

Checkin (senza relazioni)

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

Connettore (senza relazioni)

connectors

Ddi (senza relazioni)

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 (senza relazioni)

fbdeliverynote_fbdeliverynotelines

Fbpurchprice (senza relazioni)

fbpurchprice

Fbsubscription (senza relazioni)

fbsubscription

Fibudget (senza relazioni)

fibudget

Fientriescustom (senza relazioni)

fientriescustom

Fientry (senza relazioni)

fientries

Fiinvoice (senza relazioni)

fiinvoice

Hrcostcarrier (senza relazioni)

hrcostcarrier

Hrcostcentre (senza relazioni)

hrcostcentre

Hrempcourse (senza relazioni)

hrempcourse

Improvit (senza relazioni)

improvit_api_dossier_reacties, improvit_api_dossier_type, improvit_test

Infine (senza relazioni)

infine_crediteuren, infine_debiteuren

Knaddress (senza relazioni)

knaddress

Knappointment (senza relazioni)

knappointment

Kncoursegroupline (senza relazioni)

kncoursegrouplines

Knpurchaserelationorg (senza relazioni)

knpurchaserelationorg

Knpurchaserelationper (senza relazioni)

knpurchaserelationper

Knsubject (senza relazioni)

knsubject

Etichetta (senza relazioni)

labels_bij_dossieritem_reacties_incl_autorisat_2, labels_bij_dossieritem_reacties_incl_autorisatie

Medisoft (senza relazioni)

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 (senza relazioni)

metainfo

Mutatie (senza relazioni)

mutatie_formatiebegroting, mutatie_formatieplaats

NATIVEPLATFORMSCALARREQUESTS (senza relazioni)

NATIVEPLATFORMSCALARREQUESTS

Oci (senza relazioni)

oci_definitie, oci_profielen

Profitto (senza relazioni)

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 (senza relazioni)

profitgetconnectoren

Profitversion (senza relazioni)

profitversion

Ptprognosisproject (senza relazioni)

ptprognosisproject

Ptproject (senza relazioni)

ptproject_knbasicaddressadr, ptproject_ptprojectstage, ptproject_pttailspend

Ptprojectdimcode (senza relazioni)

ptprojectdimcode

Ptprojectraiserule (senza relazioni)

ptprojectraiserules

Typen (senza relazioni)

typen_dossieritem

Updateconnectoren (senza relazioni)

updateconnectoren

Visionplanner (senza relazioni)

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

Vplan (senza relazioni)

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 (senza relazioni)

workflowtaken

Relazioni

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.