xoitem
4 rows
This data as json, CSV (advanced)
Suggested facets: description, lineItem, partId, partNum, qtyFulfilled, qtyPicked, qtyToFulfill, revisionNum, statusId, uomId, xoId, dateLastFulfillment (date), dateScheduledFulfillment (date)
| id ▼ | dateLastFulfillment | dateScheduledFulfillment | description | lineItem | note | partId | partNum | qtyFulfilled | qtyPicked | qtyToFulfill | revisionNum | statusId | totalCost | typeId | uomId | xoId |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2023-03-23 13:28:58.434000 | 2023-03-23 00:00:00.000000 | LABEL(CS12284 STERILE PRODUCT) | 1 | 48 | Z16127 | 4092.0 | 4092.0 | 4092.0 | 2 | 60 | 0.0 | 10 | 18 | 1 | |
| 2 | 2023-03-23 14:26:47.259000 | 2023-03-23 14:26:10.000000 | LABEL(CS12284 STERILE PRODUCT) | 1 | 48 | Z16127 | 4092.0 | 4092.0 | 4092.0 | 1 | 60 | 0.0 | 10 | 18 | 2 | |
| 4 | 2025-05-27 11:16:00.000000 | HOUSING, FO LINEAR ARRAY HALF 1 | 1 | 33332 | 16574 | 0.0 | 2.0 | 2.0 | 1 | 50 | 0.0 | 10 | 1 | 4 | ||
| 5 | 2025-05-27 11:16:12.000000 | HOUSING, FO LINEAR ARRAY HALF 2 | 2 | 33328 | 16575 | 0.0 | 2.0 | 2.0 | 1 | 50 | 0.0 | 10 | 1 | 4 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "xoitem" (
"id" INTEGERNOT NULL ,
"dateLastFulfillment" TEXT DEFAULT NULL,
"dateScheduledFulfillment" TEXT NOT NULL,
"description" TEXT DEFAULT NULL,
"lineItem" INTEGERNOT NULL,
"note" TEXT ,
"partId" INTEGERDEFAULT NULL,
"partNum" TEXT NOT NULL,
"qtyFulfilled" REAL DEFAULT NULL,
"qtyPicked" REAL DEFAULT NULL,
"qtyToFulfill" REAL DEFAULT NULL,
"revisionNum" INTEGERDEFAULT NULL,
"statusId" INTEGERNOT NULL,
"totalCost" REAL DEFAULT NULL,
"typeId" INTEGERNOT NULL,
"uomId" INTEGERDEFAULT NULL,
"xoId" INTEGERNOT NULL,
PRIMARY KEY ("id")
);