Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Exact Online API Data Model

Navigation: » No topics above this level «

TransactionLines2: Exact Online Transaction Lines

Contents Previous Home Next More

Catalog: ExactOnlineREST

Schema: FinancialTransaction

Primary Keys: ID

Label: Transaction Lines

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

Can retrieve data and change data using insert, update and delete.

Select Exact Online API URL: /api/v1/{division}/financialtransaction/TransactionLines2

Insert Exact Online API URL: /api/v1/{division}/financialtransaction/TransactionLines2

Update Exact Online API URL: /api/v1/{division}/financialtransaction/TransactionLines2

Delete Exact Online API URL: /api/v1/{division}/financialtransaction/TransactionLines2

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

Field Selection Method: Required

Table Columns

The columns of the table TransactionLines2 are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert or update.

Name

Data Type

Label

Required

Documentation

Account

guid

Account

 

AccountCode

string

Account Code

 

AccountName

string

Account Name

 

AmountDC

double

Amount Division Currency

 

AmountFC

double

Amount Foreign Currency

 

AmountVATBaseFC

double

Amount VAT Base Foreign Currency

 

AmountVATFC

double

Amount VAT Foreign Currency

 

Asset

guid

Asset

 

AssetCode

string

Asset Code

 

AssetDescription

string

Asset Description

 

CostCenter

string

Cost Center

 

CostCenterDescription

string

Cost Center Description

 

CostUnit

string

Cost Unit

 

CostUnitDescription

string

Cost Unit Description

 

Created

datetime

Created

 

CreatedUtc

datetime

Created (UTC)

Creation date in UTC.

Creator

guid

Creator

 

CreatorFullName

string

Creator Full Name

 

Currency

string

Currency

 

Date

datetime

Date

 

Description

string

Description

 

Division

int32

Division ID

Unique number of the Exact Online division.

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

 

DocumentNumber

int32

Document Number

 

DocumentSubject

string

Document Subject

 

DueDate

datetime

Due Date

 

EntryID

guid

Entry ID

 

EntryNumber

int32

Entry Number

 

ExchangeRate

double

Exchange Rate

 

ExtraDutyAmountFC

double

Extra Duty Amount Foreign Currency

 

ExtraDutyPercentage

double

Extra Duty (%)

 

FinancialPeriod

int16

Financial Period

 

FinancialYear

int16

Financial Year

 

GLAccount

guid

General Ledger Account

 

GLAccountCode

string

GL Account Code

 

GLAccountDescription

string

GL Account Description

 

ID

guid

ID

 

InvoiceNumber

int32

Invoice Number

 

Item

guid

Item

 

ItemCode

string

Item Code

 

ItemDescription

string

Item Description

 

JournalCode

string

Journal Code

 

JournalDescription

string

Journal Description

 

LineNumber

int32

Line Number

 

LineType

int16

Line Type

 

Modified

datetime

Modified

 

ModifiedUtc

datetime

Modified (UTC)

Last modified date in UTC.

Modifier

guid

Modifier

 

ModifierFullName

string

Modified Full Name

 

Notes

string

Notes

 

OffsetID

guid

Offset GL Account ID

 

OrderNumber

int32

Order Number

 

PaymentDiscountAmount

double

Payment Discount Amount

 

PaymentReference

string

Payment Reference

 

Project

guid

Project

 

ProjectCode

string

Project Code

 

ProjectDescription

string

Project Description

 

Quantity

double

Quantity

 

SerialNumber

string

Serial Number

 

Status

int16

Status

 

Subscription

guid

Subscription

 

SubscriptionDescription

string

Subscription Description

 

Timestamp

int64

 

 

TrackingNumber

string

Tracking Number

 

TrackingNumberDescription

string

Tracking Number Description

 

Type

int32

Type

 

VATCode

string

VAT Code

 

VATCodeDescription

string

VAT Code Description

 

VATPercentage

double

VAT Percentage

 

VATType

string

VAT Type

 

YourRef

string

Your Reference

 

 

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