Please enable JavaScript to view this site.

Navigation: Catalog: ExactOnlineREST > Schemas > Schema: Views > Views

PjtTimeTransactionsIncremental: Exact Online Project Time Transactions

Catalog: ExactOnlineREST

Schema: Views

Label: Project Time Transactions

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.

View Columns

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

Name

Data Type

Label

Required

Documentation

Account

guid

Account

 

AmountFC

double

Amount Foreign Currency

 

Attachment

guid

Attachment

 

Created

datetime

Created

 

Creator

guid

Creator

 

Currency

string

Currency

 

Date

datetime

Date

 

Division

int32

Division

 

Employee

guid

Employee

 

EndTime

datetime

End Time

 

EntryNumber

int32

Entry Number

 

ErrorText

string

Error Text

 

HourStatus

int16

Hour Status

 

ID

guid

ID

 

Item

guid

Item

 

ItemDivisable

boolean

Item Divisable

 

Modified

datetime

Modified

 

Modifier

guid

Modifier

 

Notes

string

Notes

 

PriceFC

double

Price Foreign Currency

 

Project

guid

Project

 

Quantity

double

Quantity

 

StartTime

datetime

Start Time

 

Subscription

guid

Subscription

 

Timestamp

int64

Timestamp

 

Type

int16

Type

 

WBS

guid

 

 

 

15-06-2022 19:32 Version 22.0.232-PROD+3445