Bizview Visma Business Adapter Details
This topic contains the following sections:
Set Up Data Sources for Visma Business
Below is a list of data sources:
Column |
Comment (enter this value) |
|---|---|
client_id |
Bizview client_id. |
module_id |
GL (General Ledger). |
system_id |
VB (Visma Business adapter). |
db_instance |
Linked server name to Visma Business database. NULL if database is in the same instance as Bizview database. |
db_name |
Database name for Visma Business. |
db_schema |
Schema name for Visma Business tables. |
db_table_prefix |
NULL (not applicable for Visma Business). |
erp_client_id |
NULL (not applicable for Visma Business). |
Object Tags for the Visma Business Adapter
Below is a list of object tags that are available for the Visma Business adapter:
Object Tag |
Visma Business Table Name |
Table Description |
|---|---|---|
Ac |
Ac |
Chart of Account |
R1 |
R1 |
Free dimension (integer) |
R2 |
R2 |
Free dimension (integer) |
R3 |
R3 |
Free dimension (integer) |
R4 |
R4 |
Free dimension (integer) |
R5 |
R5 |
Free dimension (integer) |
R6 |
R6 |
Free dimension (integer) |
R7 |
R7 |
Free dimension (varchar) |
R8 |
R8 |
Free dimension (varchar) |
R9 |
R9 |
Free dimension (varchar) |
R10 |
R10 |
Free dimension (varchar) |
R11 |
R11 |
Free dimension (varchar) |
R12 |
R12 |
Free dimension (varchar) |
Cust |
CustV |
Customers |
Sup |
SupV |
Suppliers |
Emp |
EmpV |
Employees |
Ledger Transaction Columns
Below is a list of Ledger Transaction columns:
Column |
Corresponding Object Tag |
|---|---|
Ac |
Ac |
R1 |
R1 |
R2 |
R2 |
R3 |
R3 |
R4 |
R4 |
R5 |
R5 |
R6 |
R6 |
R7 |
R7 |
R8 |
R8 |
R9 |
R9 |
R10 |
R10 |
R11 |
R11 |
R12 |
R12 |
Cust |
Cust |
Sup |
Sup |
Emp |
Emp |
Visma Business Tables
Below is a list of the Visma Business tables that are sources for this data adapter:
Visma Business Table Name |
Table Description |
Table Type |
|---|---|---|
Ac |
Chart of Accounts (kontoplan). |
Dimension table |
R1 |
Free dimension. |
Dimension table |
R2 |
Free dimension. |
Dimension table |
R3 |
Free dimension. |
Dimension table |
R4 |
Free dimension. |
Dimension table |
R5 |
Free dimension. |
Dimension table |
R6 |
Free dimension. |
Dimension table |
R7 |
Free dimension. |
Dimension table |
R8 |
Free dimension. |
Dimension table |
R9 |
Free dimension. |
Dimension table |
R10 |
Free dimension. |
Dimension table |
R11 |
Free dimension. |
Dimension table |
R12 |
Free dimension. |
Dimension table |
AcTr |
Ledger transactions. |
Facts table |
Cur |
Currency table (needed for lookup Currency Codes). |
Facts table |
VWDocumentFile |
Table with references to scanned invoice documents. |
Facts table |