Exact Online API Data Model
PjtTimeTransactions: Exact Online Project Time Transactions |
Time transactions registered on persons.
Catalog: ExactOnlineREST
Schema: Project
Primary Keys: ID
Label: Project Time Transactions
The data in this table is partitioned per value of the Division column.
Can retrieve data and change data using insert, update and delete.
Webhook Topic: TimeTransactions
Select Exact Online API URL: /api/v1/{division}/project/TimeTransactions
Insert Exact Online API URL: /api/v1/{division}/project/TimeTransactions
Update Exact Online API URL: /api/v1/{division}/project/TimeTransactions
Delete Exact Online API URL: /api/v1/{division}/project/TimeTransactions
Exact Online API Metadata URL: /api/v1/{division}/project/$metadata
Field Selection Method: Required
Table Columns
The columns of the table PjtTimeTransactions 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 |
☐ |
Account linked to the transaction. |
AccountName |
string(50) |
Account Name |
☐ |
Name of Account. |
Activity |
guid |
Activity |
☐ |
Reference to ProjectWBS (work breakdown structure). |
ActivityDescription |
string |
Activity Description |
☐ |
Description of ProjectWBS. |
Amount |
double |
Amount |
☐ |
This property is obsolete. Use property 'AmountFC' instead. |
AmountFC |
double |
Amount Foreign Currency |
☐ |
Amount in the currency of the transaction of the transaction. |
Attachment |
guid |
Attachment |
☐ |
Attachment linked to the transaction. |
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 of the amount. |
Date |
datetime |
Date |
☐ |
Date. |
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. |
DivisionDescription |
string |
Division Description |
☐ |
Description of 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. |
Employee |
guid |
Employee |
☐ |
Employee linked to the transaction. |
EndTime |
datetime |
End Time |
☐ |
End time of the transaction. |
EntryNumber |
int32 |
Entry Number |
☐ |
Entrynumber. |
ErrorText |
string |
Error Text |
☐ |
Errortext, used for the backgroundjobs. |
HourStatus |
int16 |
Hour Status |
☐ |
Status of the transaction. |
ID |
guid |
ID |
☑ |
Primary key. |
Item |
guid |
Item |
☐ |
Item linked to the transaction. Items of type 'time' are linked to time transactions. Items of other types are linked to cost transactions. |
ItemDescription |
string(60) |
Item Description |
☐ |
Description of Item. |
ItemDivisable |
boolean |
Item Divisable |
☐ |
True if you can use decimals for item quantity. |
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 |
☐ |
Notes linked to the transaction. |
Price |
double |
Price |
☐ |
This property is obsolete. Use property 'PriceFC' instead. |
PriceFC |
double |
Price Foreign Currency |
☐ |
PriceFC (AmountFC = Quantity * PriceFC). |
Project |
guid |
Project |
☐ |
Project linked to the transaction. |
ProjectAccount |
guid |
Project Account |
☐ |
Reference to project account. |
ProjectAccountCode |
string(18) |
Project Account Code |
☐ |
Project account code. |
ProjectAccountName |
string(50) |
Project Account Name |
☐ |
Project account name. |
ProjectCode |
string(20) |
Project Code |
☐ |
Code of Project. |
ProjectDescription |
string(60) |
Project Description |
☐ |
Description of Project. |
Quantity |
double |
Quantity (h) |
☐ |
Number of hours. |
SkipValidation |
boolean |
Skip Validation |
☑ |
|
StartTime |
datetime |
Start Time |
☐ |
Start time of the transaction. |
Subscription |
guid |
Subscription |
☐ |
Subscription linked to the transaction. |
SubscriptionAccount |
guid |
Subscription Account |
☐ |
Account linked to the subscription. |
SubscriptionAccountCode |
string(18) |
Subscription Account Code |
☐ |
Subscription account code. |
SubscriptionAccountName |
string(50) |
Subscription Account Name |
☐ |
Subscription account name. |
SubscriptionDescription |
string(60) |
Subscription Description |
☐ |
Description of the subscription. |
SubscriptionNumber |
int32 |
Subscription Number |
☐ |
Subscription number. |
Type |
int16 |
Type |
☐ |
Type of the transaction. |
15-06-2022 19:32 Version 22.0.232-PROD+3445
