Bizview Jeeves Adapter Details
This topic contains the following sections:
Set Up Data Sources for Jeeves
Below is a list of data soures:
Column | Comment (enter this value) |
|---|---|
client_id | Bizview client_id. |
module_id | GL (General Ledger). |
system_id | JV (Jeeves adapter). |
db_instance | Linked server name to Jeeves database. NULL if database is in the same instance as Bizview database. |
db_name | Database name for Jeeves. |
db_schema | Schema name for Jeeves tables. |
db_table_prefix | NULL (not applicable for Jeeves). |
erp_client_id | Client number in Jeeves. |
Object Tags for the Jeeves Adapter
Below is a list of object tags that are available for the Jeeves adapter:
Object Tag | Jeeves Table Name | Table Description |
|---|---|---|
ko | ko | Chart of Account |
kt | kt | Cost centers |
kb | kb | Cost units |
k4 | k4 | Free dimension |
k5 | k5 | Free dimension |
k6 | k6 | Free dimension |
k7 | k7 | Free dimension |
k8 | k8 | Free dimension |
prj | prj | Project |
ar | ar | Items |
pg | pg | Productions Groups |
Ledger Transaction Columns
Below is a list of Ledge Transaction columns:
Column | Corresponding Object Tag |
|---|---|
ktonr | ko |
koststallekod | kt |
kostbar | kb |
k4 | k4 |
k5 | k5 |
k6 | k6 |
k7 | k7 |
k8 | k8 |
projcode | prj |
artnr | ar |
Jeeves Tables
Below is a list of the Jeeves tables that are sources for this data adapter:
Jeeves Table Name | Table Description | Table Type |
|---|---|---|
ko | Chart of Accounts (kontoplan). | Dimension table |
kt | Cost centers (kostnadsställen). | Dimension table |
kb | Cost units (kostnadsbärare). | Dimension table |
k4 | Free dimension. | Dimension table |
k5 | Free dimension. | Dimension table |
k6 | Free dimension. | Dimension table |
k7 | Free dimension. | Dimension table |
k8 | Free dimension. | Dimension table |
prj | Project. | Dimension table |
ar | Items. | Dimension table |
pg | Production Groups. | Dimension table |
vr | Ledger voucher (header table). | Facts table |
vt | Ledger transactions. | Facts table |
tkt | Ledger period balances, budget, opening balances (only opening balances used by adapter). | Facts table |