Visma Lite
Visma is a cloud accounting, payroll, and administration software.
Features
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | CURRENCY , CUSTOMER_PAYMENT_METHOD , FINANCIAL_PERIOD , JOURNAL_TRANSACTION , and WAREHOUSE tables. |
History mode | ||
Custom data | ||
Data blocking | check | |
Column hashing | check | |
Re-sync | check | |
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking | ||
Authorization via API | check |
Setup guide
Follow our step-by-step Visma setup guide to connect Visma with your destination using Fivetran connectors.
Sync overview
To capture new records and updates, we incrementally sync the following tables and their child tables:
ATTRIBUTE
ACCOUNT
BRANCH
CARRIER
CASH_ACCOUNT
CASH_SALE
CURRENCY_RATE
CUSTOMER
CUSTOMER_CREDIT_NOTE
CUSTOMER_DEBIT_NOTE
CUSTOMER_INVOICE
CUSTOMER_PAYMENT
GENERAL_LEDGER_BALANCE
GENERAL_LEDGER_TRANSACTION
INVENTORY
INVENTORY_ADJUSTMENT
INVENTORY_ISSUE
INVENTORY_RECEIPT
INVENTORY_TRANSFER
KIT_ASSEMBLY
KIT_SPECIFICATION
LEDGER
LOCATION
ORGANIZATION
PAYMENT_METHOD
PURCHASE_ORDER
PURCHASE_RECEIPT
SALE_ORDER
SALES_ORDER_TYPE
SHIPMENT
SUB_ACCOUNT
SUPPLIER
SUPPLIER_INVOICE
SUPPLIER_PAYMENT
To capture updates, we re-import the following tables during every sync:
CURRENCY
CUSTOMER_PAYMENT_METHOD
FINANCIAL_PERIOD
JOURNAL_TRANSACTION
WAREHOUSE
Schema information
This schema applies to all Visma connectors.
Explore Visma schema ERD