invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

AFAS Profit Data Model

Esta página aún no está disponible en tu idioma; se muestra la versión original.

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

Póster del Modelo de Datos

Este modelo de datos aún no declara ninguna clave; las relaciones con puntos se derivan de los nombres de las columnas.

PDF, hoja A0 1

En una tabla del póster: Zoom para ampliar y reducir; las teclas de flecha sirven para desplazarse; el 0 ajusta la imagen.

AFAS Profit Modelo de Datos, Hoja 1 de 1AFAS Profit Modelo de Datospara su uso con Invantive UniversalSQLComunicado 27.1.33-BETA+6408 · 07-11-2026OtroHoja 1 de 1 · documentation.invantive.euOtroAfasOnline.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_themeConectorAfasOnline.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_knsubjectknsubjectEtiquetaAfasOnline.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_profielenBeneficioAfasOnline.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'.NotasEste modelo de datos aún no declara ninguna clave; las relaciones con puntos se derivan de losnombres de las columnas.Diccionario de datosCada tabla y columna de este Modelo de Datos se describe en su documentación, disponible endocumentation.invantive.eu, donde el documento también está disponible en otros idiomas.NotasLas cajas están agrupadas por tema y se distinguen por colores según la categoría. Se estableceuna relación en el tema de la tabla que contiene la clave; en otro tema se define un Box de colorgris pálido.TemasOtro1Tablas sin relaciones1LeyendaTransaccionalConfiguraciónTécnicoValores fijosSe explica en otro temaClave declaradaRelación descrita con palabrasCandidato derivado de los nombres de las columnasNegrita: una tabla muy popular+Bulk, +Read: la tabla también existe en estas variantes\u00D7n: n claves entre las mismas tablasGenerado a partir de los metadatos de Invantive UniversalSQL 27.1.33-BETA+6408 el 07-11-2026. Cada tablaincluye un enlace a su página, donde se muestran las columnas, las claves y ejemplos de queries.documentation.invantive.eu/es/datamodels/afas
El póster en forma de texto: tablas por tema y sus relaciones

Otro

profit_featurecombination, profit_subject_tasks, workflows

Afaspocket (sin relaciones)

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 (sin relaciones)

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

Caseware (sin relaciones)

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

Checkin (sin relaciones)

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

Conector (sin relaciones)

connectors

Ddi (sin relaciones)

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 (sin relaciones)

fbdeliverynote_fbdeliverynotelines

Fbpurchprice (sin relaciones)

fbpurchprice

Fbsubscription (sin relaciones)

fbsubscription

Fibudget (sin relaciones)

fibudget

Fientriescustom (sin relaciones)

fientriescustom

Fientry (sin relaciones)

fientries

Fiinvoice (sin relaciones)

fiinvoice

Hrcostcarrier (sin relaciones)

hrcostcarrier

Hrcostcentre (sin relaciones)

hrcostcentre

Hrempcourse (sin relaciones)

hrempcourse

Improvit (sin relaciones)

improvit_api_dossier_reacties, improvit_api_dossier_type, improvit_test

Infine (sin relaciones)

infine_crediteuren, infine_debiteuren

Knaddress (sin relaciones)

knaddress

Knappointment (sin relaciones)

knappointment

Kncoursegroupline (sin relaciones)

kncoursegrouplines

Knpurchaserelationorg (sin relaciones)

knpurchaserelationorg

Knpurchaserelationper (sin relaciones)

knpurchaserelationper

Knsubject (sin relaciones)

knsubject

Etiqueta (sin relaciones)

labels_bij_dossieritem_reacties_incl_autorisat_2, labels_bij_dossieritem_reacties_incl_autorisatie

Medisoft (sin relaciones)

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 (sin relaciones)

metainfo

Mutatie (sin relaciones)

mutatie_formatiebegroting, mutatie_formatieplaats

NATIVEPLATFORMSCALARREQUESTS (sin relaciones)

NATIVEPLATFORMSCALARREQUESTS

Oci (sin relaciones)

oci_definitie, oci_profielen

Beneficio (sin relaciones)

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 (sin relaciones)

profitgetconnectoren

Profitversion (sin relaciones)

profitversion

Ptprognosisproject (sin relaciones)

ptprognosisproject

Ptproject (sin relaciones)

ptproject_knbasicaddressadr, ptproject_ptprojectstage, ptproject_pttailspend

Ptprojectdimcode (sin relaciones)

ptprojectdimcode

Ptprojectraiserule (sin relaciones)

ptprojectraiserules

Typen (sin relaciones)

typen_dossieritem

Updateconnectoren (sin relaciones)

updateconnectoren

Visionplanner (sin relaciones)

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

Vplan (sin relaciones)

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 (sin relaciones)

workflowtaken

Relaciones

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.