woinstruction
56,578 rows
This data as json, CSV (advanced)
Suggested facets: url, dateFirstReady (date), dateLastFulfilled (date)
| id ▼ | bomInstructionItemId | dateFirstReady | dateLastFulfilled | description | details | name | qtyFulfilled | qtyReady | sortOrder | url | woId | customFields |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2023-02-02 12:50:57.794000 | 2023-02-02 13:02:10.404000 | Start | 16 | 0 | 1 | 1 | {} | ||||
| 2 | 2023-02-02 13:02:10.404000 | 2023-02-02 13:05:01.121000 | Finish | 16 | 0 | 2 | 1 | {} | ||||
| 106 | 2023-05-31 13:39:37.055000 | 2023-05-31 13:42:47.364000 | Start | 1 | 0 | 1 | 35 | {} | ||||
| 107 | 2023-05-31 13:42:47.364000 | 2023-05-31 13:43:34.315000 | Finish | 1 | 0 | 2 | 35 | {} | ||||
| 108 | 2023-06-06 11:00:05.869000 | 2023-06-06 11:03:54.579000 | Start | 2 | 0 | 1 | 36 | {} | ||||
| 109 | 2023-06-06 11:03:54.579000 | 2023-06-06 11:03:54.579000 | Finish | 2 | 0 | 2 | 36 | {} | ||||
| 110 | 2023-06-06 11:00:05.916000 | 2023-06-06 11:03:05.167000 | Start | 12 | 0 | 1 | 37 | {} | ||||
| 111 | 2023-06-06 11:03:05.167000 | 2023-06-06 11:03:05.167000 | Finish | 12 | 0 | 2 | 37 | {} | ||||
| 112 | 2023-06-06 11:00:05.994000 | 2023-06-06 11:04:11.032000 | Start | 5 | 0 | 1 | 38 | {} | ||||
| 113 | 2023-06-06 11:04:11.032000 | 2023-06-06 11:04:11.032000 | Finish | 5 | 0 | 2 | 38 | {} | ||||
| 114 | 2023-06-06 11:00:06.213000 | 2023-06-06 11:04:25.760000 | Start | 12 | 0 | 1 | 39 | {} | ||||
| 115 | 2023-06-06 11:04:25.760000 | 2023-06-06 11:04:25.760000 | Finish | 12 | 0 | 2 | 39 | {} | ||||
| 116 | 2023-06-06 11:00:06.245000 | 2023-06-06 11:04:36.295000 | Start | 2 | 0 | 1 | 40 | {} | ||||
| 117 | 2023-06-06 11:04:36.295000 | 2023-06-06 11:04:36.295000 | Finish | 2 | 0 | 2 | 40 | {} | ||||
| 126 | 2023-06-06 11:44:54.561000 | 2023-06-06 12:55:35.697000 | Start | 10 | 0 | 1 | 45 | {} | ||||
| 127 | 2023-06-06 12:55:35.697000 | 2023-06-06 13:11:20.162000 | Finish | 10 | 0 | 2 | 45 | {} | ||||
| 128 | 2023-06-06 11:44:54.592000 | 2023-06-06 13:14:15.464000 | Start | 1 | 0 | 1 | 46 | {} | ||||
| 129 | 2023-06-06 13:14:15.464000 | 2023-06-06 13:14:58.148000 | Finish | 1 | 0 | 2 | 46 | {} | ||||
| 130 | 2023-06-06 13:20:40.937000 | 2023-06-06 13:40:38.538000 | Start | 10 | 0 | 1 | 47 | {} | ||||
| 131 | 2023-06-06 13:40:38.538000 | 2023-06-06 13:42:52.630000 | Finish | 10 | 0 | 2 | 47 | {} | ||||
| 138 | 2023-06-06 17:06:20.525000 | 2023-06-09 09:36:31.859000 | Start | 10 | 0 | 1 | 51 | {} | ||||
| 139 | 2023-06-09 09:38:01.597000 | 2023-06-09 09:39:43.441000 | Finish | 10 | 0 | 6 | 51 | {} | ||||
| 140 | 2023-06-09 09:37:25.559000 | 2023-06-09 09:39:43.441000 | Picking | Materials handler | 10 | 0 | 3 | 51 | {} | |||
| 141 | 2023-06-09 09:37:51.122000 | 2023-06-09 09:39:43.441000 | WIP Location | Industrial | 10 | 0 | 4 | 51 | {} | |||
| 142 | 2023-06-09 09:37:58.740000 | 2023-06-09 09:39:43.441000 | QC Final Inspection | Final Inspection | 10 | 0 | 5 | 51 | {} | |||
| 143 | 2023-06-09 09:36:31.859000 | 2023-06-09 09:39:43.441000 | Create Sales Order | This is where you would place the Sales order and Create Traveler | Create Sale Order | 10 | 0 | 2 | 51 | {} | ||
| 152 | 2023-06-08 11:57:58.948000 | 2023-06-08 11:59:27.677000 | Start | 10 | 0 | 1 | 54 | {} | ||||
| 153 | 2023-06-08 11:59:38.387000 | 2023-06-08 11:59:42.955000 | Assemble | Step 1 (Assy) | 10 | 0 | 3 | 54 | {} | |||
| 154 | 2023-06-08 11:59:42.955000 | 2023-06-08 11:59:46.830000 | Grinding & Polishing | Step 2 (G&P | 10 | 0 | 4 | 54 | {} | |||
| 155 | 2023-06-08 12:00:27.765000 | 2023-06-08 12:06:35.231000 | Finish | 10 | 0 | 7 | 54 | {} | ||||
| 156 | 2023-06-08 11:59:27.677000 | 2023-06-08 11:59:38.387000 | Picking | 10 | 0 | 2 | 54 | {} | ||||
| 157 | 2023-06-08 11:59:46.830000 | 2023-06-08 12:00:15.737000 | QC inspection | 10 | 0 | 5 | 54 | {} | ||||
| 158 | 2023-06-08 12:00:15.737000 | 2023-06-08 12:00:27.765000 | Packaging | 10 | 0 | 6 | 54 | {} | ||||
| 159 | 2023-06-08 14:28:52.379000 | 2023-06-08 14:35:36.514000 | Start | 10 | 0 | 1 | 55 | {} | ||||
| 160 | 2023-06-08 14:35:36.514000 | 2023-06-08 15:06:21.686000 | Assemble | Step 1 (Assy) | 10 | 0 | 2 | 55 | {} | |||
| 161 | 2023-06-08 15:06:21.686000 | 2023-06-08 15:06:24.809000 | Grinding & Polishing | Step 2 (G&P | 10 | 0 | 3 | 55 | {} | |||
| 162 | 2023-06-08 15:06:24.809000 | 2023-06-08 15:07:14.033000 | Finish | 10 | 0 | 4 | 55 | {} | ||||
| 163 | 2023-06-08 14:28:52.458000 | 2023-06-08 14:55:12.359000 | Start | 10 | 0 | 1 | 56 | {} | ||||
| 164 | 2023-06-08 14:55:12.359000 | 2023-06-08 15:08:09.493000 | Finish | 10 | 0 | 2 | 56 | {} | ||||
| 165 | 2023-06-09 09:20:31.804000 | 2023-06-09 09:21:51.580000 | Start | 10 | 0 | 1 | 57 | {} | ||||
| 166 | 2023-06-09 09:21:51.580000 | 2023-06-09 09:21:55.399000 | Pick Materials per BoM | Step 1 - Pick | 10 | 0 | 2 | 57 | {} | |||
| 167 | 2023-06-09 09:21:55.399000 | 2023-06-09 09:21:57.946000 | Products are being assembled | Assemble | Step 2 - Assemble | 10 | 0 | 3 | 57 | {} | ||
| 168 | 2023-06-09 09:21:57.946000 | 2023-06-09 09:22:04.847000 | Grinding & Polishing | Step 3 - G&P | 10 | 0 | 4 | 57 | {} | |||
| 169 | 2023-06-09 09:22:15.218000 | 2023-06-09 09:25:44.075000 | Pack materials for shipping | Step 4 - Packaging | 10 | 0 | 6 | 57 | {} | |||
| 170 | 2023-06-09 09:22:04.847000 | 2023-06-09 09:25:39.950000 | QC Final Inspection of Product | Step 5 - Final Inspection | 10 | 0 | 5 | 57 | {} | |||
| 171 | 2023-06-09 09:25:47.794000 | 2023-06-09 09:26:33.874000 | Finish | 10 | 0 | 8 | 57 | {} | ||||
| 172 | 2023-06-09 09:25:44.075000 | 2023-06-09 09:25:47.794000 | final inspection of documentation | QC | 10 | 0 | 7 | 57 | {} | |||
| 173 | 2023-06-09 09:53:28.256000 | 2023-06-09 09:54:24.342000 | Start | 1 | 0 | 1 | 58 | {} | ||||
| 174 | 2023-06-09 09:54:24.342000 | 2023-06-09 09:55:54.000000 | Pick Materials per BoM | Step 1 - Pick | 1 | 0 | 2 | 58 | {} | |||
| 175 | 2023-06-09 09:55:54.000000 | 2023-06-09 09:55:57.688000 | Products are being assembled | Assemble | Step 2 - Assemble | 1 | 0 | 3 | 58 | {} |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "woinstruction" (
"id" INTEGERNOT NULL ,
"bomInstructionItemId" INTEGERDEFAULT NULL,
"dateFirstReady" TEXT DEFAULT NULL,
"dateLastFulfilled" TEXT DEFAULT NULL,
"description" TEXT DEFAULT NULL,
"details" TEXT ,
"name" TEXT NOT NULL,
"qtyFulfilled" INTEGERDEFAULT '0',
"qtyReady" INTEGERDEFAULT '0',
"sortOrder" INTEGERNOT NULL,
"url" TEXT DEFAULT NULL,
"woId" INTEGERNOT NULL,
"customFields" TEXT DEFAULT NULL,
PRIMARY KEY ("id")
);