ADO.NET Provider for Exact Online

Build 26.0.9655

TimedTimeTransactions

Use this endpoint to start, stop, and delete timed time transactions for shop order operations. Tracks labor hours, machine hours, and production metrics for manufacturing shop floor activities.

Columns

Name Type ReadOnly Description
ID [KEY] String False

Primary key

Created Datetime False

Creation date

Creator String False

User ID of creator

CreatorFullName String False

Name of creator

Division Int False

Division code

Employee String False

ID of employee

EmployeeFullName String False

Name of employee

EndTime Datetime False

Time that operation was stopped

IsOperationFinished Int False

Whether the operation has been completed

LaborHours Double False

Adjustable labor hours

MachineHours Double False

Adjustable machine hours

Modified Datetime False

Modified date

Modifier String False

User ID of modifier

ModifierFullName String False

Name of modifier

Notes String False

Notes - viewable in data collection

Operation String False

ID of operation

OperationCode String False

Code of operation

OperationDescription String False

Description of operation

PercentComplete Double False

Percentage of operation completed within time period

ProducedQuantity Double False

Quantity of make item produced within time period

ProductionArea String False

Production area of the work center

ProductionAreaCode String False

Production area code

ProductionAreaDescription String False

Production area details

ShopOrder String False

ID of shop order

ShopOrderDescription String False

Description of shop order

ShopOrderNumber Int False

Number of shop order

ShopOrderRoutingStepPlan String False

Shop order routing step where work occurred

ShopOrderRoutingStepPlanDescription String False

Description of shop order routing step plan

ShopOrderRoutingStepPlanRemainingRunHours Double False

Remaining run hours for the shop order routing step plan

ShopOrderRoutingStepPlanRemainingSetupHours Double False

Remaining setup hours for the shop order routing step plan

Source Int False

Source of the time transaction

StartTime Datetime False

Time that operation was started

Status Int False

Status of the timed time transaction

Type Int False

Setup = 10, Run = 20

Workcenter String False

Work center where work occurred

WorkcenterCode String False

Code of the work center

WorkcenterDescription String False

Description of the work center

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655