Bizview Integration Interfaces (Inbound)
Field |
Description |
Mandatory (logically) |
Aggregated to fin_ledgersum |
Example Data |
---|---|---|---|---|
[client_id] [nvarchar](50) NULL, |
The ID of the client/company where the transaction is booked. |
x |
x |
10 |
[version_id] [nvarchar](50) NULL, |
The ID of the version the record belongs to. Should normally be set to "ACT". |
x |
x |
ACT |
[isomonth] [nvarchar](50) NULL, |
The transaction month number in format YYYYMM. Used during update for updating full-month-data. |
x |
x |
201401 |
[isodate] [int] NULL, |
The transaction date in format YYYYMMDD. |
x |
|
20140115 |
[ic_client_id] [nvarchar](50) NULL, |
The inter company (client) that the transaction is related to. |
x - if consolidation |
x |
30 |
[dim1] [nvarchar](50) NULL, |
The ID of the dimension 1, depending on configuration. Normally the GL AccountID. |
x |
x |
4010 |
[dim2] [nvarchar](50) NULL, |
The ID of the dimension 2, depending on configuration. Normally the GL org/costcenter ID. |
x |
110 |
|
[dim3] [nvarchar](50) NULL, |
The ID of the dimension 3, depending on configuration. |
|
x |
|
[dim4] [nvarchar](50) NULL, |
The ID of the dimension 4, depending on configuration. |
|
x |
|
[dim5] [nvarchar](50) NULL, |
The ID of the dimension 5, depending on configuration. |
|
x |
|
[dim6] [nvarchar](50) NULL, |
The ID of the dimension 6, depending on configuration. |
|
x |
|
[dim7] [nvarchar](50) NULL, |
The ID of the dimension 7, depending on configuration. |
|
x |
|
[dim8] [nvarchar](50) NULL, |
The ID of the dimension 8, depending on configuration. |
|
x |
|
[dim9] [nvarchar](50) NULL, |
The ID of the dimension 9, depending on configuration. |
|
x |
|
[dim10] [nvarchar](50) NULL, |
The ID of the dimension 10, depending on configuration. |
|
x |
|
[ledger_amount] [decimal](18, 4) NULL, |
The ledger amount from the general ledger transaction. Negative for assets and revenues, positive for debts and costs. |
x |
x |
-65000 |
[ledger_amount_debit] [decimal](18, 4) NULL, |
The ledger amount from the general ledger transaction in debt (should be positive value). |
x |
65000 |
|
[ledger_amount_credit] [decimal](18, 4) NULL, |
The ledger amount from the general ledger transaction in credit (should be positive value). |
x |
|
|
[invoice_amount] [decimal](18, 4) NULL, |
Optional field. Can be different then ledger amount (i.e. different currency). |
|
x |
6500 |
[ledger_curr_id] [nvarchar](50) NULL, |
The transaction currency. |
x |
x |
SEK |
[invoice_curr_id] [nvarchar](50) NULL, |
The related invoice currency. |
|
x |
EUR |
[quantity] [decimal](18, 4) NULL, |
If transaction contains 'quantity information' and this should be reported, then this field can be used. |
x |
56 |
|
[vouch_text] [nvarchar](255) NULL, |
The text on the voucher/header for the transaction. |
|
|
Invoice 99 |
[trans_text] [nvarchar](255) NULL, |
The text on the transaction line for the transaction. |
|
|
Invoice 99 |
[vouch_no] [nvarchar](50) NULL, |
The voucher number or identity of the voucher. |
x |
|
1633 |
[vouch_type] [nvarchar](50) NULL, |
A voucher might be of different type. This is a description of the type. |
|
|
INV |
[entry_date] [datetime] NULL, |
The date when the transaction is registered in the GL. |
x |
|
01/01/2014 |
[entry_sign] [nvarchar](255) NULL, |
Some kind of identity/signature of the user that has created the transaction. |
|
|
ERLI |
[journalno] [nvarchar](255) NULL, |
If the transaction belongs to a journal this field can be used to show the journal nr on the transaction. |
|
201 |
|
[invoiceid] [nvarchar](255) NULL, |
The ID of a related supplier (or customer) invoice. |
|
|
12366 |
[doc_reference] [nvarchar](1000) NULL, |
A reference string to a document related to the transaction (for example, a URL to a PDF-invoice). |
|
|
|
[trans_at1] [nvarchar](255) NULL, |
Extra field for storing additional attribute on the transaction. |
|
|
|
[trans_at2] [nvarchar](255) NULL, |
Extra field for storing additional attribute on the transaction. |
|
|
|
[trans_at3] [nvarchar](255) NULL, |
Extra field for storing additional attribute on the transaction. |
|
|
|
[trans_at1_num] [decimal](18, 4) NULL, |
Extra field for storing additional measures on the transaction, similar to quantity above. |
|
x |
|
[trans_at2_num] [decimal](18, 4) NULL, |
Extra field for storing additional measures on the transaction, similar to quantity above. |
|
x |
|
[trans_at3_num] [decimal](18, 4) NULL, |
Extra field for storing additional measures on the transaction, similar to quantity above. |
|
x |
|
[opbal_flag] [int] NULL, |
Flag indicating if the is an 'opening balance' record or a normal transaction. |
|
x |
|
[created] [datetime] NULL, |
Bizview internal field. Should not be populated by data integrator. |
|
|
|
[job_id] [bigint] NULL, |
Bizview internal field. Should not be populated by data integrator. |
|
|
|
[row_id] [bigint] NOT NULL, |
Bizview internal field. Should not be populated by data integrator. |
|
|
|