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.
On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.
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)
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)
Fbsubscription (without relations)
Fibudget (without relations)
Fientriescustom (without relations)
Fientry (without relations)
Fiinvoice (without relations)
Hrcostcarrier (without relations)
Hrcostcentre (without relations)
Hrempcourse (without relations)
Improvit (without relations)
improvit_api_dossier_reacties, improvit_api_dossier_type, improvit_test
Infine (without relations)
infine_crediteuren, infine_debiteuren
Knaddress (without relations)
Knappointment (without relations)
Kncoursegroupline (without relations)
Knpurchaserelationorg (without relations)
Knpurchaserelationper (without relations)
Knsubject (without relations)
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)
Mutatie (without relations)
mutatie_formatiebegroting, mutatie_formatieplaats
NATIVEPLATFORMSCALARREQUESTS (without relations)
Oci (without relations)
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)
Profitversion (without relations)
Ptprognosisproject (without relations)
Ptproject (without relations)
ptproject_knbasicaddressadr, ptproject_ptprojectstage, ptproject_pttailspend
Ptprojectdimcode (without relations)
Ptprojectraiserule (without relations)
Typen (without relations)
Updateconnectoren (without relations)
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)
Relations
- profit_featurecombination → workflows (candidate): Derived from the column workflowid.
- profit_subject_tasks → workflows (candidate): Derived from the column workflowid.
Tables
AfasOnline.FileConnector
- file: Files
AfasOnline.GetConnector
- afaspocket_activities: Activities (AFAS Pocket)
- afaspocket_activities_2: itgen_aoe_afaspocket_activities_2
- afaspocket_contacts: Contacts (AFAS Pocket)
- afaspocket_expense_types: Expense Types (AFAS Pocket)
- afaspocket_illness_reasons: Illness Reasons (AFAS Pocket)
- afaspocket_illness_reasons_2: itgen_aoe_afaspocket_illness_reasons_2
- afaspocket_illness_status: Illness Statuses
- afaspocket_leave_balance: Leave Balances
- afaspocket_leave_reasons: Leave Reasons
- afaspocket_leave_types: Leave Types
- afaspocket_leaves: Leaves
- afaspocket_projects: Projects (AFAS Pocket)
- afaspocket_timesheets: Timesheets
- afaspocket_user: Users
- bi_abonnementsregels: itgen_aoe_bi_abonnementsregels
- bi_contactpersonen: itgen_aoe_bi_contactpersonen
- bi_dossieritems_salesforecast: itgen_aoe_bi_dossieritems_salesforecast
- bi_logactieswf_big: itgen_aoe_bi_logactieswf_big
- bi_logactieswf_sua: itgen_aoe_bi_logactieswf_sua
- bi_organisaties_personen: itgen_aoe_bi_organisaties_personen
- bi_verkoopfactuurregels: itgen_aoe_bi_verkoopfactuurregels
- bi_verkoopofferteregels: itgen_aoe_bi_verkoopofferteregels
- bi_verkooporderregels: itgen_aoe_bi_verkooporderregels
- caseware_administraties: Companies (CaseWare)
- caseware_ledgerbalances: Balances (CaseWare)
- caseware_perioden: Periods (CaseWare)
- caseware_periodetabel: itgen_aoe_caseware_periodetabel
- caseware_periods: itgen_aoe_caseware_periods
- caseware_periodtable: itgen_aoe_caseware_periodtable
- caseware_transactions: itgen_aoe_caseware_transactions
- checkin_appointment: itgen_aoe_checkin_appointment
- checkin_appointment_owners: itgen_aoe_checkin_appointment_owners
- checkin_appointments: itgen_aoe_checkin_appointments
- checkin_event: itgen_aoe_checkin_event
- checkin_event_teachers: itgen_aoe_checkin_event_teachers
- checkin_locations: itgen_aoe_checkin_locations
- checkin_printers: itgen_aoe_checkin_printers
- checkin_profile_image: itgen_aoe_checkin_profile_image
- checkin_theme: itgen_aoe_checkin_theme
- ddi_profit_administraties: Companies
- ddi_profit_btwcode: VAT Codes
- ddi_profit_crediteuren: itgen_aoe_ddi_profit_crediteuren
- ddi_profit_dagboeken: Journals
- ddi_profit_dimensies: itgen_aoe_ddi_profit_dimensies
- ddi_profit_dimensies_2: itgen_aoe_ddi_profit_dimensies_2
- ddi_profit_dimensies_3: itgen_aoe_ddi_profit_dimensies_3
- ddi_profit_grootboek: itgen_aoe_ddi_profit_grootboek
- ddi_profit_kosten: itgen_aoe_ddi_profit_kosten
- ddi_profit_kostendragers: itgen_aoe_ddi_profit_kostendragers
- ddi_profit_kostenplaatsen: itgen_aoe_ddi_profit_kostenplaatsen
- ddi_profit_periodes: Financial Periods
- ddi_profit_projecten: Projects
- ddi_profit_valuta: itgen_aoe_ddi_profit_valuta
- improvit_api_dossier_reacties: itgen_aoe_improvit_api_dossier_reacties
- improvit_api_dossier_type: itgen_aoe_improvit_api_dossier_type
- improvit_test: itgen_aoe_improvit_test
- infine_crediteuren: itgen_aoe_infine_crediteuren
- infine_debiteuren: itgen_aoe_infine_debiteuren
- labels_bij_dossieritem_reacties_incl_autorisat_2: itgen_aoe_labels_bij_dossieritem_reacties_incl_autorisat_2
- labels_bij_dossieritem_reacties_incl_autorisatie: itgen_aoe_labels_bij_dossieritem_reacties_incl_autorisatie
- medisoft_dienstverband_3_50_0: itgen_aoe_medisoft_dienstverband_3_50_0
- medisoft_dienstverband_3_50_1: itgen_aoe_medisoft_dienstverband_3_50_1
- medisoft_dienstverband_3_50_2: itgen_aoe_medisoft_dienstverband_3_50_2
- medisoft_dienstverband_3_50_3: itgen_aoe_medisoft_dienstverband_3_50_3
- medisoft_dienstverband_3_50_4: itgen_aoe_medisoft_dienstverband_3_50_4
- medisoft_dienstverband_3_50_5: itgen_aoe_medisoft_dienstverband_3_50_5
- medisoft_verzuim_3_50_0: itgen_aoe_medisoft_verzuim_3_50_0
- medisoft_verzuim_3_50_1: itgen_aoe_medisoft_verzuim_3_50_1
- medisoft_verzuim_3_50_2: itgen_aoe_medisoft_verzuim_3_50_2
- medisoft_verzuim_3_50_3: itgen_aoe_medisoft_verzuim_3_50_3
- medisoft_verzuim_3_50_4: itgen_aoe_medisoft_verzuim_3_50_4
- medisoft_verzuim_3_50_5: itgen_aoe_medisoft_verzuim_3_50_5
- mutatie_formatiebegroting: itgen_aoe_mutatie_formatiebegroting
- mutatie_formatieplaats: itgen_aoe_mutatie_formatieplaats
- oci_definitie: itgen_aoe_oci_definitie
- oci_profielen: itgen_aoe_oci_profielen
- profit_accounts: Accounts
- profit_address: Addresses
- profit_administrations: itgen_aoe_profit_administrations
- profit_allocation_assigments: itgen_aoe_profit_allocation_assigments
- profit_article: Articles
- profit_article_basic: Articles (Basic)
- profit_article_image: Article Images
- profit_articlegroups: Article Groups
- profit_balance_allocated: itgen_aoe_profit_balance_allocated
- profit_bankaccounts: Bank Accounts
- profit_barcode_per_item: itgen_aoe_profit_barcode_per_item
- profit_composition: itgen_aoe_profit_composition
- profit_contacts: Contacts
- profit_costcarrier: Cost Units
- profit_costcentre: Cost Centre
- profit_creditor: itgen_aoe_profit_creditor
- profit_creditor_invoices: itgen_aoe_profit_creditor_invoices
- profit_currency: Currencies
- profit_debtor: Debtors
- profit_debtor_invoices: Debtor Invoices
- profit_deliverynotelines: itgen_aoe_profit_deliverynotelines
- profit_deliverynotes: itgen_aoe_profit_deliverynotes
- profit_employees: Employees
- profit_employees_basic: Employees (Basic)
- profit_employers: Employers
- profit_featurecombination: itgen_aoe_profit_featurecombination
- profit_features: Features
- profit_featurevalue: Feature Values
- profit_fin_changedentrydate: itgen_aoe_profit_fin_changedentrydate
- profit_functions: Functions
- profit_hourtype: Hour Types
- profit_illness: Illnesses
- profit_journals: Journals
- profit_languages: itgen_aoe_profit_languages
- profit_leavebalance: Leave Balances
- profit_leaves: Leaves
- profit_organizationchart: itgen_aoe_profit_organizationchart
- profit_orgper: itgen_aoe_profit_orgper
- profit_period_balance: Period Balance
- profit_periods_per_administration: itgen_aoe_profit_periods_per_administration
- profit_projectgroups: Project Groups
- profit_projects: Projects
- profit_projectstage: itgen_aoe_profit_projectstage
- profit_quotation: itgen_aoe_profit_quotation
- profit_rea_changedentrydate: itgen_aoe_profit_rea_changedentrydate
- profit_realization: itgen_aoe_profit_realization
- profit_residence: itgen_aoe_profit_residence
- profit_rooster_ouderverlof: itgen_aoe_profit_rooster_ouderverlof
- profit_salesorderlines: Sales Order Lines
- profit_salesorders: Sales Orders
- profit_salesprice: Sales Prices
- profit_sepa_incassomachtigingen: itgen_aoe_profit_sepa_incassomachtigingen
- profit_stock: itgen_aoe_profit_stock
- profit_stock_per_warehouse: itgen_aoe_profit_stock_per_warehouse
- profit_subject_attachments: itgen_aoe_profit_subject_attachments
- profit_subject_reaction_attachments: itgen_aoe_profit_subject_reaction_attachments
- profit_subject_tasks: itgen_aoe_profit_subject_tasks
- profit_subjectfile: itgen_aoe_profit_subjectfile
- profit_subjects: Subjects
- profit_subjectsdest: itgen_aoe_profit_subjectsdest
- profit_subjecttypes: itgen_aoe_profit_subjecttypes
- profit_subscriptions: itgen_aoe_profit_subscriptions
- profit_timetable: itgen_aoe_profit_timetable
- profit_transactions: itgen_aoe_profit_transactions
- profit_transactions_allocated: itgen_aoe_profit_transactions_allocated
- profit_unit_per_item: itgen_aoe_profit_unit_per_item
- profit_usergroups: itgen_aoe_profit_usergroups
- profit_users: Users
- profit_vat_code: VAT Codes
- profit_warehouses: Warehouses
- profit_workflowactions: itgen_aoe_profit_workflowactions
- profit_workflowactions_2: itgen_aoe_profit_workflowactions_2
- profit_workflowactions_3: itgen_aoe_profit_workflowactions_3
- profit_worktype: Work Types
- profitgetconnectoren: itgen_aoe_profitgetconnectoren
- typen_dossieritem: itgen_aoe_typen_dossieritem
- updateconnectoren: Update Connectors
- visionplanner_administrations: itgen_aoe_visionplanner_administrations
- visionplanner_changed_description_gen_ledger: itgen_aoe_visionplanner_changed_description_gen_ledger
- visionplanner_dossieritems: itgen_aoe_visionplanner_dossieritems
- visionplanner_outstanding_payables: itgen_aoe_visionplanner_outstanding_payables
- visionplanner_outstanding_receivables: itgen_aoe_visionplanner_outstanding_receivables
- visionplanner_periodvalues: itgen_aoe_visionplanner_periodvalues
- visionplanner_periodvalues_dimensions: itgen_aoe_visionplanner_periodvalues_dimensions
- visionplanner_transactions: itgen_aoe_visionplanner_transactions
- vplan_absence: Absences
- vplan_employee: Employees
- vplan_employee_avatar: itgen_aoe_vplan_employee_avatar
- vplan_employeeschedule: itgen_aoe_vplan_employeeschedule
- vplan_employeeschedule_days: itgen_aoe_vplan_employeeschedule_days
- vplan_item: Articles
- vplan_leave: Leaves
- vplan_productionorder: Production Orders
- vplan_productionorder_related: itgen_aoe_vplan_productionorder_related
- vplan_productionorder_row: itgen_aoe_vplan_productionorder_row
- vplan_project: Projects
- vplan_purchaseorder: itgen_aoe_vplan_purchaseorder
- vplan_purchaseorder_row: itgen_aoe_vplan_purchaseorder_row
- vplan_purchaseorder_row_related: itgen_aoe_vplan_purchaseorder_row_related
- vplan_purchaserelation: itgen_aoe_vplan_purchaserelation
- vplan_salesorder: itgen_aoe_vplan_salesorder
- vplan_salesorder_row: itgen_aoe_vplan_salesorder_row
- vplan_salesrelation: itgen_aoe_vplan_salesrelation
- vplan_stock: itgen_aoe_vplan_stock
- vplan_warehouse: Warehouses
- vplan_worktype: Work Types
- workflows: itgen_aoe_workflows
- workflowtaken: itgen_aoe_workflowtaken
- workflowtaken_en_acties: itgen_aoe_workflowtaken_en_acties
AfasOnline.ImageConnector
- image: itgen_aoe_image
AfasOnline.MetaInfoConnector
- connectors: Connectors
- metainfo: Environment Information
AfasOnline.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
AfasOnline.ReportConnector
- report: itgen_aoe_report
AfasOnline.SubjectConnector
- subject: itgen_aoe_subject
AfasOnline.UpdateConnector
- fbdeliverynote_fbdeliverynotelines: itgen_aoe_fbdeliverynote_fbdeliverynotelines
- fbpurchprice: itgen_aoe_fbpurchprice
- fbsubscription: itgen_aoe_fbsubscription
- fbsubscription_fbsubscriptionlines: itgen_aoe_fbsubscription_fbsubscriptionlines
- fibudget: itgen_aoe_fibudget
- fibudget_budgetlines: itgen_aoe_fibudget_budgetlines
- fientries: itgen_aoe_fientries
- fientries_fientries: itgen_aoe_fientries_fientries
- fientriescustom: itgen_aoe_fientriescustom
- fiinvoice: itgen_aoe_fiinvoice
- hrcostcarrier: itgen_aoe_hrcostcarrier
- hrcostcentre: itgen_aoe_hrcostcentre
- hrempcourse: itgen_aoe_hrempcourse
- knaddress: itgen_aoe_knaddress
- knappointment: itgen_aoe_knappointment
- knappointment_knappointmentlines: itgen_aoe_knappointment_knappointmentlines
- kncoursegrouplines: itgen_aoe_kncoursegrouplines
- knpurchaserelationorg: itgen_aoe_knpurchaserelationorg
- knpurchaserelationper: itgen_aoe_knpurchaserelationper
- knsubject: itgen_aoe_knsubject
- knsubject_kns01: itgen_aoe_knsubject_kns01
- knsubject_kns02: itgen_aoe_knsubject_kns02
- knsubject_kns03: itgen_aoe_knsubject_kns03
- knsubject_kns05: itgen_aoe_knsubject_kns05
- knsubject_kns07: itgen_aoe_knsubject_kns07
- knsubject_kns08: itgen_aoe_knsubject_kns08
- knsubject_kns09: itgen_aoe_knsubject_kns09
- knsubject_kns10: itgen_aoe_knsubject_kns10
- knsubject_kns11: itgen_aoe_knsubject_kns11
- knsubject_kns12: itgen_aoe_knsubject_kns12
- knsubject_kns13: itgen_aoe_knsubject_kns13
- knsubject_kns14: itgen_aoe_knsubject_kns14
- knsubject_kns16: itgen_aoe_knsubject_kns16
- knsubject_kns17: itgen_aoe_knsubject_kns17
- knsubject_kns18: itgen_aoe_knsubject_kns18
- knsubject_kns19: itgen_aoe_knsubject_kns19
- knsubject_kns20: itgen_aoe_knsubject_kns20
- knsubject_kns21: itgen_aoe_knsubject_kns21
- knsubject_kns22: itgen_aoe_knsubject_kns22
- knsubject_kns24: itgen_aoe_knsubject_kns24
- knsubject_kns25: itgen_aoe_knsubject_kns25
- knsubject_kns26: itgen_aoe_knsubject_kns26
- knsubject_kns27: itgen_aoe_knsubject_kns27
- knsubject_kns29: itgen_aoe_knsubject_kns29
- knsubject_kns31: itgen_aoe_knsubject_kns31
- knsubject_kns32: itgen_aoe_knsubject_kns32
- knsubject_kns33: itgen_aoe_knsubject_kns33
- knsubject_kns35: itgen_aoe_knsubject_kns35
- knsubject_kns37: itgen_aoe_knsubject_kns37
- knsubject_kns38: itgen_aoe_knsubject_kns38
- knsubject_kns40: itgen_aoe_knsubject_kns40
- knsubject_kns41: itgen_aoe_knsubject_kns41
- knsubject_kns42: itgen_aoe_knsubject_kns42
- knsubject_kns43: itgen_aoe_knsubject_kns43
- knsubject_kns46: itgen_aoe_knsubject_kns46
- knsubject_kns47: itgen_aoe_knsubject_kns47
- knsubject_kns48: itgen_aoe_knsubject_kns48
- knsubject_kns49: itgen_aoe_knsubject_kns49
- knsubject_kns50: itgen_aoe_knsubject_kns50
- knsubject_kns51: itgen_aoe_knsubject_kns51
- knsubject_kns52: itgen_aoe_knsubject_kns52
- knsubject_knsubjectattachment: itgen_aoe_knsubject_knsubjectattachment
- knsubject_knsubjectlink: itgen_aoe_knsubject_knsubjectlink
- ptprognosisproject: itgen_aoe_ptprognosisproject
- ptproject_knbasicaddressadr: itgen_aoe_ptproject_knbasicaddressadr
- ptproject_ptprojectstage: itgen_aoe_ptproject_ptprojectstage
- ptproject_pttailspend: itgen_aoe_ptproject_pttailspend
- ptprojectdimcode: itgen_aoe_ptprojectdimcode
- ptprojectraiserules: itgen_aoe_ptprojectraiserules
AfasOnline.VersionConnector
- profitversion: Version Information
Attributes
The attributes of this platform are on the page Attributes.