Please enable JavaScript to view this site.

Exact Online API Data Model

Navigation: Catalog: ExactOnlineREST > Schemas > Schema: FinancialTransaction > Tables

TransactionLinesBulk: Exact Online Transaction Lines (Bulk)

Contents Previous Home Next More

Catalog: ExactOnlineREST

Schema: FinancialTransaction

Primary Keys: ID

Label: Transaction Lines (Bulk)

The data in this table is partitioned per value of the Division column.

This is a read-only table. The Exact Online API may not support changing the data or the Invantive SQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API.

Webhook Topic: FinancialTransactions

Webhook Key Field: EntryID

Select Exact Online API URL: /api/v1/{division}/bulk/financial/TransactionLines

Insert Exact Online API URL: /api/v1/{division}/bulk/financial/TransactionLines

Update Exact Online API URL: /api/v1/{division}/bulk/financial/TransactionLines

Delete Exact Online API URL: /api/v1/{division}/bulk/financial/TransactionLines

Exact Online API Metadata URL: /api/v1/{division}/bulk/financial/$metadata

Field Selection Method: Required

Table Columns

The columns of the table TransactionLinesBulk are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

Account

guid

Account

Reference to account.

AccountCode

string(18)

Account Code

Code of the Account.

AccountName

string(50)

Account Name

Name of account.

AmountDC

double

Amount Division Currency

Amount in the default currency of the company.

AmountFC

double

Amount Foreign Currency

Amount in the currency of the transaction.

AmountVATBaseFC

double

Amount VAT Base Foreign Currency

Vat base amount in the currency of the transaction.

AmountVATFC

double

Amount VAT Foreign Currency

Vat amount in the currency of the transaction.

Asset

guid

Asset

Reference to asset.

AssetCode

string(30)

Asset Code

Code of Asset.

AssetDescription

string(60)

Asset Description

Description of Asset.

CostCenter

string(8)

Cost Center

Reference to cost center.

CostCenterDescription

string(60)

Cost Center Description

Description of CostCenter.

CostUnit

string(8)

Cost Unit

Reference to cost unit.

CostUnitDescription

string(60)

Cost Unit Description

Description of CostUnit.

Created

datetime

Created

Creation date.

CreatedUtc

datetime

Created (UTC)

Creation date in UTC.

Creator

guid

Creator

User ID of creator.

CreatorFullName

string(240)

Creator Full Name

Name of creator.

Currency

string(30)

Currency

Currency.

Date

datetime

Date

Date.

Description

string(60)

Description

Description.

DisplayDocumentsUrl

string

Display Documents (URL)

URL to display documents attached to this transaction using Get My Report.

Division

int32

Division

Division code.

DivisionCompanyCoCNumber

string(20)

Division Chamber of Commerce Number

Chamber of commerce number of the Exact Online division.

DivisionCompanyIBANNumber

string(50)

Division IBAN Number

IBAN number of the Exact Online division.

DivisionCompanyName

string(50)

Division Company Name

Company name of the Exact Online division.

DivisionCompanyRSINNumber

string(9)

Division RSIN Number

RSIN number of the Exact Online division.

DivisionCompanyVATNumber

string(35)

Division VAT Number

VAT number of the Exact Online division.

DivisionCompanyWageTaxNumber

string(60)

Division Wage Tax Number

Wage tax number of the Exact Online division.

DivisionLabel

string(128)

Division Label

Label of the Exact Online division.

DivisionName

string(50)

Administration Name

Name of the Exact Online division.

DivisionOwnerCompanyName

string(50)

Subscription Holder Name

Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.

DivisionOwnerCompanyNumber

string(18)

Subscription Holder Number

Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.

DivisionShortName

int64

Division Short Name

Short name of the Exact Online division.

Document

guid

Document

Reference to document.

DocumentNumber

int32

Document Number

Number of the document.

DocumentSubject

string(256)

Document Subject

Subject of the document.

DueDate

datetime

Due Date

Date that payment should be done.

EntryID

guid

Entry ID

The transaction lines that make up a financial entry share the same EntryID.

EntryNumber

int32

Entry Number

Entry number of the header.

ExchangeRate

double

Exchange Rate

Exchange rate.

ExtraDutyAmountFC

double

Extra Duty Amount Foreign Currency

Extra duty amount.

ExtraDutyPercentage

double

Extra Duty (%)

Extra duty percentage.

FinancialPeriod

int16

Financial Period

Financial period.

FinancialYear

int16

Financial Year

Financial year.

GLAccount

guid

General Ledger Account

General ledger account.

GLAccountBalanceSide

string(1)

GL Account Balance Side

Balance side of transactions on this GL account.

GLAccountBalanceType

string(1)

GL Account Balance Type

Balance type of transactions on this GL account, being either 'B' for Balance or 'W' for Profit and Loss.

GLAccountCode

string(30)

GL Account Code

Code of the G/L account.

GLAccountDescription

string(60)

GL Account Description

Description of the G/L account.

GLAccountRevalueCurrency

boolean

GL Account Revalue Currency

Whether to revalue amounts posted on this GL account.

GLAccountSearchCode

string(9)

GL Account Search Code

User-friendly search code for the GL account.

GLAccountType

int32

GL Account Type

Type of GL account. See view GLAccountTypes.

GLAccountTypeDescription

string

GL Account Type Description

Description of the GL account type.

GLAccountUseCostCenter

boolean

Use Cost Center

Indicator whether to use cost centers for transaction lines on the GL account.

GLAccountUseCostUnit

boolean

Use Cost Unit

Indicator whether to use cost units for transaction lines on the GL account.

GLAccountVatCode

string(3)

VAT Code of GL Account

Associated VAT code of the GL account.

ID

guid

ID

Primary key.

InvoiceNumber

int32

Invoice Number

Invoice number.

Item

guid

Item

Reference to item.

ItemCode

string(30)

Item Code

Code of Item.

ItemDescription

string(60)

Item Description

Description of Item.

JournalCode

string(20)

Journal Code

The journal code.

JournalDescription

string(60)

Journal Description

The journal description.

LineNumber

int32

Line Number

Line number.

LineType

int16

Line Type

Line type.

Modified

datetime

Modified

Last modified date.

ModifiedUtc

datetime

Modified (UTC)

Last modified date in UTC.

Modifier

guid

Modifier

User ID of modifier.

ModifierFullName

string(240)

Modified Full Name

Name of modifier.

Notes

string

Notes

Extra remarks.

OffsetID

guid

Offset GL Account ID

OffsetID.

OrderNumber

int32

Order Number

Order number.

PaymentDiscountAmount

double

Payment Discount Amount

Discount amount when paid in time.

PaymentReference

string(60)

Payment Reference

Payment reference.

Project

guid

Project

Reference to project.

ProjectCode

string(20)

Project Code

Code of Project.

ProjectDescription

string(60)

Project Description

Description of Project.

Quantity

double

Quantity

Quantity.

SerialNumber

string(30)

Serial Number

Serial number of item.

ShopOrder

guid

Shop Order

Reference to shop order.

Status

int16

Status

20 = Open, 50 = Processed.

Subscription

guid

Subscription

Reference to subscription line.

SubscriptionDescription

string(60)

Subscription Description

Description of subscription line.

TrackingNumber

string(100)

Tracking Number

Tracking number of item.

TrackingNumberDescription

string(240)

Tracking Number Description

Tracking number description.

Type

int32

Type

The transaction type. Possible values: see TransactionLineTypes.

VATCode

string(3)

VAT Code

VAT code.

VATCodeDescription

string(60)

VAT Code Description

Description of VAT code.

VATPercentage

double

VAT Percentage

Vat percentage.

VATType

string(1)

VAT Type

VAT type.

YourRef

string(30)

Your Reference

Your reference (of customer).

 

14-04-2021 14:43 Version 20.1.394-BETA+3155