ShopOrderRoutingStepPlansAvailableToWork
Use this endpoint to read shop order routing step plans that are available to work. Returns manufacturing routing step details including operation, work center, planned quantities, and status information.
Columns
| Name | Type | Description |
| RoutingStep [KEY] | String | Routing Step ID |
| CustomerCode | String | Customer code |
| CustomerCount | Int | Count of customers |
| CustomerName | String | Customer name |
| DataType | Int | Type of data returned by query - for internal use |
| DateAscendingOrder | Int | Planned dates ascending order |
| DateDescendingOrder | Int | Planned dates descending order |
| ExtraDescription | String | Extra description |
| IsFractionAllowedItem | Bool | Is fraction allowed item |
| IsReleased | Bool | Is released |
| IsRunOperationFinished | Bool | Is run operation finished |
| IsSetupOperationFinished | Bool | Is setup operation finished |
| Item | String | Item |
| ItemCode | String | Item code |
| ItemCodeAscendingOrder | Int | Shop order item code ascending order |
| ItemCodeDescendingOrder | Int | Shop order item code descending order |
| ItemDescription | String | Item description |
| ItemVersion | String | Item version ID |
| ItemVersionNotes | String | Item version notes |
| LineNumber | Int | Sequence |
| Mode | Int | Mode of priority |
| Notes | String | Shop order notes |
| Operation | String | Operation |
| OperationCode | String | Operation code |
| PictureThumbnailPath | String | PictureThumbnailPath |
| PlannedDate | Datetime | Planned date |
| PlannedQuantity | Double | Planned quantity |
| PlannedSetupHours | Double | Planned setup hours |
| Priority | Int | Priority of the shop order |
| PriorityDescendingOrder | Int | Priority of the shop order |
| Project | String | Shop order project |
| ProjectCode | String | Shop order project code |
| ProjectDescription | String | Project description |
| QuantityCompleted | Double | QuantityCompleted |
| RoutingStepDescription | String | Routing step description |
| RoutingStepRealizationNotes | String | RoutingStepRealizationNotes |
| RoutingStepStatus | Int | Routing step status |
| RoutingStepStatusDescription | String | Routing step status description |
| RoutingStepType | Int | Routing step type |
| RunStartTime | Datetime | Run start time |
| RunStatus | Int | Run timed status |
| RunTimedTimeTransaction | String | Run timed time transaction |
| SalesOrderCount | Int | Count of Sales order |
| SalesOrderLineNumber | Int | Sales order line number |
| SalesOrderNumber | Int | Sales order number |
| SetupPercentComplete | Double | SetupPercentComplete |
| SetupStartTime | Datetime | Setup start time |
| SetupStatus | Int | Setup timed status |
| SetupTimedTimeTransaction | String | Setup timed time transaction |
| ShopOrder | String | Shop order ID |
| ShopOrderDescription | String | Shop order description |
| ShopOrderNumber | Int | Shop order number |
| ShopOrderNumberAscendingOrder | Int | Shop order number ascending order |
| ShopOrderNumberDescendingOrder | Int | Shop order number descending order |
| ShopOrderStatus | Int | Shop order status |
| Unit | String | Description of unit |
| Warehouse | String | ID of warehouse where shop order is finished |
| Workcenter | String | Workcenter |
| WorkcenterCode | String | Workcenter code |
| Division | String | Division code |