Please enable JavaScript to view this site.

Exact Online API Data Model

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

TransactionLinesIncremental

Contents Previous Home Next More

Catalog: ExactOnlineREST

Schema: Incremental

Primary Keys: ID

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

This is a read-only view. 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.

Field Selection Method: NotRequired

View Columns

The columns of the view TransactionLinesIncremental are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

Account

guid

Account

Reference to 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.

CostCenter

string

Cost Center

Reference to cost center.

CostUnit

string

Cost Unit

Reference to cost unit.

Created

datetime

Created

Creation date.

Creator

guid

Creator

User ID of creator.

Currency

string

Currency

Currency.

Date

datetime

Date

Entry date.

Description

string

Description

Description.

Division

int32

Division

Division code.

Document

guid

Document

Reference to 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.

ID

guid

ID

Primary key.

InvoiceNumber

int32

Invoice Number

Invoice number.

Item

guid

Item

Reference to item.

JournalCode

string

Journal Code

Journal code.

LineNumber

int32

Line Number

Line number.

LineType

int16

Line Type

Line type.

Modified

datetime

Modified

Last modified date.

Modifier

guid

Modifier

User ID of modifier.

Notes

string

Notes

Extra remarks.

OffsetID

guid

Offset GL Account ID

Offset ID.

OrderNumber

int32

Order Number

Order number.

PaymentDiscountAmount

double

Payment Discount Amount

Discount amount when paid in time.

PaymentReference

string

Payment Reference

Payment reference.

Project

guid

Project

Reference to project.

Quantity

double

Quantity

Quantity.

Status

int16

Status

Status, 20 = Open, 50 = Processed.

Subscription

guid

Subscription

Reference to subscription line.

Timestamp

int64

 

Timestamp.

TrackingNumber

string

Tracking Number

Tracking number.

Type

int32

Type

Transaction type.

VATCode

string

VAT Code

VAT code.

VATPercentage

double

VAT Percentage

VAT percentage.

VATType

string

VAT Type

VAT type.

YourRef

string

Your Reference

Your reference (of customer).

 

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