Bizview Visma Global Adapter Details
This topic contains the following sections:
Set Up Data Sources for Visma Global
Below is a list of data sources:
Column | Comment (enter this value) |
|---|---|
client_id | Bizview client_id. |
module_id | GL (General Ledger). |
system_id | VG (Visma Global adapter). |
db_instance | Linked server name to Visma Global database. NULL if database is in the same instance as Bizview database. |
db_name | Database name for Visma Global. |
db_schema | Schema name for Visma Global tables. |
db_table_prefix | NULL (not applicable for Visma Global). |
erp_client_id | NULL (not applicable for Visma Global). |
Object Tags for the Visma Global Adapter
The following object tags are available for the Visma Global adapter:
Object Tag | Visma Global Table Name | Table Description |
|---|---|---|
Account | GLAccount | Chart of Account |
Dep | Department | Department table |
Product | Product | Product table |
Project | Project | Project table |
Cust | Customer | Customer table |
Sup | Supplier | Supplier table |
Emp | Employee | Employee table |
CustGrp | CustomerGroup | Customer Group table |
Ledger Transaction Columns
Below is a list of Ledger Transaction columns:
Column | Corresponding Object Tag |
|---|---|
GLAccountNo | Account |
DepNo | Dep |
ProductNo | Product |
ProjectNo | Project |
CustomerNo | Cust |
SupplierNo | Sup |
EmployeeNo | Emp |
Visma Global Tables
Below is a list of the Visma Global tables that are sources for this data adapter:
Visma Global Table Name | Table Description | Table Type |
|---|---|---|
GLAccount | Chart of Accounts (kontoplan). | Dimension table |
Department | Department table. | Dimension table |
Product | Product table. | Dimension table |
Project | Project table. | Dimension table |
Customer | Customer table. | Dimension table |
Supplier | Supplier table. | Dimension table |
Employee | Employee table. | Dimension table |
CustomerGroup | CustomerGroup table. | Dimension table |
GLAccountTransaction | Ledger transactions. | Facts table |
CurrencyTable | Currency table (needed for lookup Currency Codes). | Facts table |