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 |