January 2026

Schema changes

Visma

Effective January 20, 2026 we use a new January 2026 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to prevent or resolve data integrity issues.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

298 total changes • 138 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`JOURNAL_TRANSACTION_LINE`
column	Discontinued Column	`index` 🔑
column	Primary Key Change	`line_number`	`line_number` 🔑	New primary key.
`SALES_ORDER`
column	Discontinued Column	`branch_number`
column	Discontinued Column	`canceled`
column	Discontinued Column	`cash_account`
column	Discontinued Column	`cash_discount_date`
column	Discontinued Column	`commission_amount`
column	Discontinued Column	`commission_percent`
column	Discontinued Column	`commissionable_amount`
column	Discontinued Column	`contact_id`
column	Discontinued Column	`currency_id`
column	Discontinued Column	`customer_vat_zone_default_tax_category_description`
column	Discontinued Column	`customer_vat_zone_default_tax_category_number`
column	Discontinued Column	`customer_vat_zone_default_vat_category`
column	Discontinued Column	`customer_vat_zone_description`
column	Discontinued Column	`customer_vat_zone_id`
column	Discontinued Column	`due_date`
column	Discontinued Column	`exchange_rate`
column	Discontinued Column	`fob_point_description`
column	Discontinued Column	`fob_point_id`
column	Discontinued Column	`hold`
column	Discontinued Column	`insurance`
column	Discontinued Column	`invoice_date`
column	Discontinued Column	`invoice_nbr`
column	Discontinued Column	`invoice_separately`
column	Discontinued Column	`last_modified_date_time`
column	Discontinued Column	`location_country_id`
column	Discontinued Column	`location_id`
column	Discontinued Column	`location_name`
column	Discontinued Column	`order_type`
column	Discontinued Column	`orig_order_nbr`
column	Discontinued Column	`orig_order_type`
column	Discontinued Column	`owner_employee_id`
column	Discontinued Column	`owner_name`
column	Discontinued Column	`payment_method_id`
column	Discontinued Column	`payment_ref`
column	Discontinued Column	`post_period`
column	Discontinued Column	`preferred_warehouse_description`
column	Discontinued Column	`preferred_warehouse_id`
column	Discontinued Column	`print_note_on_external_documents`
column	Discontinued Column	`print_note_on_internal_documents`
column	Discontinued Column	`priority`
column	Discontinued Column	`project_cd`
column	Discontinued Column	`residential_delivery`
column	Discontinued Column	`sales_order_shipping_address_city`
column	Discontinued Column	`sales_order_shipping_address_country`
column	Discontinued Column	`sales_order_shipping_address_country_id`
column	Discontinued Column	`sales_order_shipping_address_country_name`
column	Discontinued Column	`sales_order_shipping_address_county_id`
column	Discontinued Column	`sales_order_shipping_address_county_name`
column	Discontinued Column	`sales_order_shipping_address_id`
column	Discontinued Column	`sales_order_shipping_address_line_1`
column	Discontinued Column	`sales_order_shipping_address_line_2`
column	Discontinued Column	`sales_order_shipping_address_override_address`
column	Discontinued Column	`sales_order_shipping_address_postal_code`
column	Discontinued Column	`sales_order_shipping_contact_attention`
column	Discontinued Column	`sales_order_shipping_contact_email`
column	Discontinued Column	`sales_order_shipping_contact_fax`
column	Discontinued Column	`sales_order_shipping_contact_id`
column	Discontinued Column	`sales_order_shipping_contact_name`
column	Discontinued Column	`sales_order_shipping_contact_override_contact`
column	Discontinued Column	`sales_order_shipping_contact_phone_1`
column	Discontinued Column	`sales_order_shipping_contact_phone_2`
column	Discontinued Column	`sales_order_shipping_contact_web`
column	Discontinued Column	`saturday_delivery`
column	Discontinued Column	`sched_shipment`
column	Discontinued Column	`ship_complete`
column	Discontinued Column	`ship_separately`
column	Discontinued Column	`ship_via_description`
column	Discontinued Column	`ship_via_id`
column	Discontinued Column	`shipping_terms_description`
column	Discontinued Column	`shipping_terms_id`
column	Discontinued Column	`so_billing_address_city`
column	Discontinued Column	`so_billing_address_country`
column	Discontinued Column	`so_billing_address_country_id`
column	Discontinued Column	`so_billing_address_country_name`
column	Discontinued Column	`so_billing_address_county_id`
column	Discontinued Column	`so_billing_address_county_name`
column	Discontinued Column	`so_billing_address_id`
column	Discontinued Column	`so_billing_address_line_1`
column	Discontinued Column	`so_billing_address_line_2`
column	Discontinued Column	`so_billing_address_override_address`
column	Discontinued Column	`so_billing_address_postal_code`
column	Discontinued Column	`so_billing_contact_attention`
column	Discontinued Column	`so_billing_contact_email`
column	Discontinued Column	`so_billing_contact_fax`
column	Discontinued Column	`so_billing_contact_id`
column	Discontinued Column	`so_billing_contact_name`
column	Discontinued Column	`so_billing_contact_override_contact`
column	Discontinued Column	`so_billing_contact_phone_1`
column	Discontinued Column	`so_billing_contact_phone_2`
column	Discontinued Column	`so_billing_contact_web`
column	Discontinued Column	`tax_total_in_base_currency`
column	Discontinued Column	`terms_description`
column	Discontinued Column	`terms_id`
column	Discontinued Column	`transaction_type_description`
column	Discontinued Column	`transaction_type_id`
column	Discontinued Column	`vat_exempt_total`
column	Discontinued Column	`vat_exempt_total_in_base_currency`
column	Discontinued Column	`vat_taxable_total`
column	Discontinued Column	`vat_taxable_total_in_base_currency`
column	New Column		`billing_address`
column	New Column		`billing_contact`
column	New Column		`branch_id`
column	New Column		`created_by`
column	New Column		`currency`
column	New Column		`custom_field`
column	New Column		`financial_information_cash_discount_date`
column	New Column		`financial_information_due_date`
column	New Column		`financial_information_invoice_date`
column	New Column		`financial_information_invoice_id`
column	New Column		`financial_information_invoice_separately`
column	New Column		`financial_information_post_period`
column	New Column		`financial_information_term_description`
column	New Column		`financial_information_term_id`
column	New Column		`freight_amount`
column	New Column		`freight_amount_in_base_currency`
column	New Column		`freight_cost`
column	New Column		`freight_cost_in_base_currency`
column	New Column		`freight_premium_amount`
column	New Column		`freight_premium_amount_in_base_currency`
column	New Column		`freight_tax_category_id`
column	New Column		`freight_volume`
column	New Column		`freight_weight`
column	New Column		`last_modified`
column	New Column		`location`
column	New Column		`order_total`
column	New Column		`origin_link`
column	New Column		`origin_order_id`
column	New Column		`origin_order_type`
column	New Column		`original_order_id`
column	New Column		`original_order_type`
column	New Column		`owner_internal_id`
column	New Column		`parent_customer_id`
column	New Column		`parent_customer_internal_id`
column	New Column		`parent_customer_name`
column	New Column		`payment_settings_cash_account_id`
column	New Column		`payment_settings_payment_method_description`
column	New Column		`payment_settings_payment_method_id`
column	New Column		`payment_settings_payment_reference`
column	New Column		`print_note_on_external_document`
column	New Column		`print_note_on_internal_document`
column	New Column		`project_description`
column	New Column		`project_id`
column	New Column		`project_internal_id`
column	New Column		`rot_rut_apartment`
column	New Column		`rot_rut_distributed_amount`
column	New Column		`rot_rut_distributed_automatically`
column	New Column		`rot_rut_distribution_amount`
column	New Column		`rot_rut_distribution_extra`
column	New Column		`rot_rut_distribution_line_id`
column	New Column		`rot_rut_distribution_personal_id`
column	New Column		`rot_rut_estate`
column	New Column		`rot_rut_material_cost_amount`
column	New Column		`rot_rut_organization_number`
column	New Column		`rot_rut_other_cost_amount`
column	New Column		`rot_rut_total_deductable_amount`
column	New Column		`rot_rut_type`
column	New Column		`rot_rut_work_price_amount`
column	New Column		`shipping_address_city`
column	New Column		`shipping_address_country_id`
column	New Column		`shipping_address_country_name`
column	New Column		`shipping_address_county_id`
column	New Column		`shipping_address_county_name`
column	New Column		`shipping_address_id`
column	New Column		`shipping_address_line_1`
column	New Column		`shipping_address_line_2`
column	New Column		`shipping_address_line_3`
column	New Column		`shipping_address_override_Default`
column	New Column		`shipping_address_postal_code`
column	New Column		`shipping_contact_attention`
column	New Column		`shipping_contact_email`
column	New Column		`shipping_contact_fax`
column	New Column		`shipping_contact_id`
column	New Column		`shipping_contact_name`
column	New Column		`shipping_contact_overrides_default`
column	New Column		`shipping_contact_phone_1`
column	New Column		`shipping_contact_phone_2`
column	New Column		`shipping_fob_point_description`
column	New Column		`shipping_fob_point_id`
column	New Column		`shipping_insurance`
column	New Column		`shipping_intrastat_transaction_type_description`
column	New Column		`shipping_intrastat_transaction_type_id`
column	New Column		`shipping_preferred_warehouse_description`
column	New Column		`shipping_preferred_warehouse_id`
column	New Column		`shipping_priority`
column	New Column		`shipping_residential_delivery`
column	New Column		`shipping_rule`
column	New Column		`shipping_saturday_delivery`
column	New Column		`shipping_scheduled_date`
column	New Column		`shipping_ship_separately`
column	New Column		`shipping_ship_via_description`
column	New Column		`shipping_ship_via_id`
column	New Column		`shipping_term_description`
column	New Column		`shipping_term_id`
column	New Column		`status_details_cancelled`
column	New Column		`status_details_description`
column	New Column		`status_details_hold`
column	New Column		`type`
column	New Column		`use_replacement_cost_for_margin_and_profit`
column	New Column		`version`
`SALES_ORDER_COMMISSION`
table	New Table		`SALES_ORDER_COMMISSION`
`SALES_ORDER_DISCOUNT`
table	New Table		`SALES_ORDER_DISCOUNT`
`SALES_ORDER_LINE`
column	Discontinued Column	`alternate_id`
column	Discontinued Column	`branch_number`
column	Discontinued Column	`disc_unit_price`
column	Discontinued Column	`expiration_date`
column	Discontinued Column	`ext_price`
column	Discontinued Column	`index` 🔑		No longer a primary key.
column	Discontinued Column	`inventory_number`
column	Discontinued Column	`invoice_nbr`
column	Discontinued Column	`line_description`
column	Discontinued Column	`line_nbr`
column	Discontinued Column	`lot_serial_nbr`
column	Discontinued Column	`manual_discount`
column	Discontinued Column	`mark_for_purchase_order`
column	Discontinued Column	`open_qty`
column	Discontinued Column	`project_task`
column	Discontinued Column	`project_task_cd`
column	Discontinued Column	`qty_on_shipments`
column	Discontinued Column	`requested_on`
column	Discontinued Column	`ship_complete`
column	Discontinued Column	`ship_on`
column	Discontinued Column	`sub_account_id`
column	Discontinued Column	`tax_category`
column	Discontinued Column	`unbilled_amount`
column	Discontinued Column	`unit_price_in_base_currency`
column	Discontinued Column	`uom`
column	New Column		`auto_create_issue`
column	New Column		`base_order_quantity`
column	New Column		`billed_quantity`
column	New Column		`custom_field`
column	New Column		`description`
column	New Column		`discount_code`
column	New Column		`discount_sequence_id`
column	New Column		`discounted_unit_price`
column	New Column		`excise_duty`
column	New Column		`extended_price`
column	New Column		`external_link`
column	New Column		`has_manual_discount`
column	New Column		`has_manual_price`
column	Primary Key Change		`id` 🔑	New primary key.
column	New Column		`inventory_alternate_id`
column	New Column		`inventory_base_unit`
column	New Column		`inventory_id`
column	New Column		`invoice_line_number`
column	New Column		`invoice_number`
column	New Column		`invoice_type`
column	New Column		`is_rot_rut_deductible`
column	New Column		`kit_assembly_reference_number`
column	New Column		`line_total_before_discount`
column	New Column		`line_type`
column	New Column		`open_line`
column	New Column		`open_quantity`
column	New Column		`order_date`
column	New Column		`project_task_id`
column	New Column		`purchase_order_number`
column	New Column		`quantity_on_shipment`
column	New Column		`replacement_unit_cost`
column	New Column		`request_date`
column	New Column		`rot_rut_deductible_amount`
column	New Column		`rot_rut_item_type_description`
column	New Column		`rot_rut_item_type_id`
column	New Column		`rot_rut_work_type`
column	New Column		`sales_account_id`
column	New Column		`ship_date`
column	New Column		`shipping_rule`
column	New Column		`subaccount`
column	New Column		`supplier_id`
column	New Column		`supplier_price`
column	New Column		`tax_category_id`
column	New Column		`unit_of_measure`
column	New Column		`warehouse_location_description`
column	New Column		`warehouse_location_id`
`SALES_ORDER_LINE_ALLOCATION`
table	New Table		`SALES_ORDER_LINE_ALLOCATION`
`SALES_ORDER_LINE_ATTACHMENT`
column	Discontinued Column	`sales_order_line_index` 🔑		No longer a primary key.
column	Primary Key Change		`sales_order_line_id` 🔑	New primary key.
`SALES_ORDER_PAYMENT`
table	New Table		`SALES_ORDER_PAYMENT`
`SALES_ORDER_ROT_RUT_DISTRIBUTION`
table	New Table		`SALES_ORDER_ROT_RUT_DISTRIBUTION`
`SALES_ORDER_SHIPMENT`
column	Discontinued Column	`index` 🔑		No longer a primary key.
column	Discontinued Column	`inventory_doc_type`
column	Discontinued Column	`inventory_ref_no`
column	Discontinued Column	`invoice_no`
column	Discontinued Column	`shipment_id`
column	Discontinued Column	`shipped_qty`
column	Discontinued Column	`shipped_volume`
column	Discontinued Column	`shipped_weight`
column	Primary Key Change		`id` 🔑	New primary key.
column	New Column		`inventory_correction_document_type`
column	New Column		`inventory_correction_reference_id`
column	New Column		`inventory_document_type`
column	New Column		`inventory_reference_id`
column	New Column		`invoice_id`
column	New Column		`quantity`
column	New Column		`status`
column	New Column		`volume`
column	New Column		`weight`
`SALES_ORDER_TAX`
table	New Table		`SALES_ORDER_TAX`