StartedTimedTimeTransactions
Use this endpoint to read started timed time transactions for manufacturing shop orders. Returns details of in-progress timed operations including employee, work center, operation, and production metrics.
Columns
| Name | Type | Description |
| ID [KEY] | String | Primary key |
| Created | Datetime | Date when the record was created |
| Creator | String | User ID of the person who created the record |
| CreatorFullName | String | Full name of the creator |
| CustomerCode | String | Code identifying the customer |
| CustomerCount | Int | Number of customers associated |
| CustomerName | String | Name of the customer |
| DataType | Int | Type of data returned by query for internal purposes |
| Division | Int | Division code |
| Employee | String | ID of the employee involved |
| EndTime | Datetime | Timestamp when the operation stopped |
| IsFractionAllowedItem | Bool | Boolean indicating if fractional quantities are allowed |
| IsOperationFinished | Int | Byte value indicating completion status |
| Item | String | ID of the shop order item being manufactured |
| ItemCode | String | Code for the make item |
| ItemPictureUrl | String | URL to retrieve item image |
| ItemUnit | String | Unit of measurement for the item |
| LaborHours | Double | Adjustable labor hours tracked |
| MachineHours | Double | Adjustable machine hours tracked |
| Modified | Datetime | Date of last modification |
| Modifier | String | User ID of the person who modified the record |
| ModifierFullName | String | Full name of the modifier |
| Notes | String | Notes visible in data collection |
| Operation | String | ID of the routing step operation |
| OperationCode | String | Code for the routing operation |
| PercentComplete | Double | Percentage of operation completed in the period |
| ProducedQuantity | Double | Quantity produced within the time period |
| Project | String | Project ID linked to the shop order |
| ProjectCode | String | Project code identifier |
| ProjectDescription | String | Description of the project |
| SalesOrderCount | Int | Number of related sales orders |
| SalesOrderLineNumber | Int | Line number on the sales order |
| SalesOrderNumber | Int | Sales order number reference |
| ShopOrder | String | ID of the shop order |
| ShopOrderDescription | String | Description of the shop order |
| ShopOrderNumber | Int | Numeric identifier for the shop order |
| ShopOrderPlannedQuantity | Double | Planned production quantity |
| ShopOrderRoutingStepPlan | String | ID of the routing step location |
| ShopOrderRoutingStepPlanAttendedPercentage | Double | Time attendance percentage |
| ShopOrderRoutingStepPlanDescription | String | Description of the routing plan |
| Source | Int | Origin of the timed transaction |
| StartTime | Datetime | Timestamp when the operation began |
| Status | Int | Current status of the transaction |
| Type | Int | Category (Setup = 10, Run = 20) |
| Warehouse | String | ID of the warehouse location |
| Workcenter | String | ID of the work center |
| WorkcenterCode | String | Code for the work center |
| WorkcenterDescription | String | Description of the work center |