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 |