Bizview Hogia Adapter Details
This topic contains the following sections:
- Set Up Data Sources for Hogia
- Object Tags for the Hogia Adapter
- Ledger Transaction Columns
- Hogia Tables
Set Up Data Sources for Hogia
Below is a list of data sources:
Column | Comment (enter this value) |
|---|---|
client_id | Bizview client_id. |
module_id | GL (General Ledger). |
system_id | HOG (Hogia adapter). |
db_instance | Linked server name to Hogia database. NULL if database is in the same instance as Bizview database. |
db_name | Database name for Hogia. |
db_schema | Schema name for Hogia tables. |
db_table_prefix | NULL (not applicable for Hogia). |
erp_client_id | NULL (not applicable for Hogia). |
Object Tags for the Hogia Adapter
Below is a list of object tags that are available for the Hogia adapter:
Object Tag | Hogia Table Name | Table Description |
|---|---|---|
Konto | Konto | Chart of Account |
Dim1Nr | tDimSwg | Dimension table |
Dim2Nr | tDimSwg | Dimension table |
ProjektNr | Projekt | Projects |
ProjektGrupp | ProjektGrupp | Project Group |
Ledger Transaction Columns
Below is a list of Ledge Transaction columns:
Column | Corresponding Object Tag |
|---|---|
Konto | Konto |
Dim1Nr | Dim1Nr |
Dim2Nr | Dim2Nr |
ProjektNr | ProjektNr |
Hogia Tables
Below is a list of Hogia tables:
Hogia Table Name | Table Description | Table Type |
|---|---|---|
Konto | Chart of Accounts (kontoplan) | Dimension table |
tDimSwg | Free dimension (idtDimension = 1) | Dimension table |
tDimSwg | Free dimension (idtDimension = 2) | Dimension table |
Projekt | Project | Dimension table |
ProjektGrupp | Project Group | Dimension table |
FinancialYear | Financial calendar | Dimension table |
Verifik | Ledger voucher (header table) | Facts table |
VerTrans | Ledger transactions | Facts table |
IngBalans | Opening balances | Facts table |
LeverantorsFaktura | Suppliers invoices | Facts table |
SupplierInvoiceImage | Scanned invoices | Facts table |