Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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.

 

 

 

Published:

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.

 

 

 

For an optimal Community experience, Please view on Desktop
Powered by Zendesk