JDBC Driver for Exact Online

Build 22.0.8462

TimeCostTransactions

Usage information for the operation TimeCostTransactions.rsd.

Columns

Name Type Description
Timestamp [KEY] Integer Timestamp
Account Integer Supports webhook Guid ID of account that is linked to the project
AccountName String Name of account that is linked to the project
AmountFC Double Supports webhook Calculated amount of the transaction based on (Quantity * PriceFC)
Attachment String Supports webhook Attachment linked to the transaction (not mandatory)
Created Datetime Date and time the transaction was created
Creator Integer The Guid ID of user that created the transaction
CreatorFullName String The full name of the user that created the record
Currency String Supports webhook Currency of amount FC
Date Datetime Supports webhook Date and time the transaction was done
Division Integer Division code
DivisionDescription String Description of Division
Employee Integer Supports webhook Guid ID of the employee that is linked to the transaction
EndTime Datetime Supports webhook End time of the time transaction
EntryNumber Datetime Supports webhook Number that represents the grouping of transactions
ErrorText String Supports webhook (Only used by backgroundjobs) To determine which transaction has an error
HourStatus String Supports webhook Status of the transaction: 1 = Draft, 2 = Rejected, 10 = Submitted, 11 = Failed on approval, 14 = Processi
ID Integer Primary key
Item Integer Supports webhook Item that is linked to the transaction, which provides the time or cost information
ItemDescription String Description of the item that is linked to the transaction
ItemDivisable Integer Indicates if fractional quantities of the item can be used, for example quantity = 0.4
Modified Datetime The date and time transaction record was modified
Modifier Integer The Guid ID of the user that modified the records
ModifierFullName String The full name of the user that modified the record
Notes String Supports webhook Notes linked to the transaction for providing additional information (not mandatory)
PriceFC Integer Supports webhook For use in AmountFC (Quantiy * Price FC)
Project Integer Supports webhook Guid ID of project that is linked to the transaction
ProjectAccount Integer Project account ID that is linked to the transaction (not mandatory)
ProjectAccountCode String Supports webhook Project account code that is linked to the transaction
ProjectAccountName String Project account name that is linked to the transaction
ProjectCode String Project code that is linked to the transaction
ProjectDescription String Project description that is linked to the transaction
Quantity Double Supports webhook Quantity of the item that is linked to the transaction
StartTime Datetime Supports webhook Start time of the time transaction
Subscription Integer Supports webhook Guid ID of subscription that is linked to the transaction
SubscriptionAccount Integer Subscription account ID that is linked to the transaction, this is to identify the referenced subscription
SubscriptionAccountCode String Subscription account code that is linked to the transaction
SubscriptionAccountName String Subscription account name that is linked to the transaction
SubscriptionDescription String Subscription description that is linked to the transaction
SubscriptionNumber Integer Subscription number that is linked to the transaction
Type Integer The type of transaction. E.g: 1 = Time, 2 = Cost
WBS Integer Supports webhook Guid ID of activity for time transaction or expense for cost transaction that is linked to project WBS
WBSDescription String Name of activity for time transaction or expense for cost transaction that is linked to project WBS (work breakdown structure)

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462