part
10 rows where typeId = 21
This data as json, CSV (advanced)
Suggested facets: dateLastModified, details, inventoryAccountId, lastChangedUser, stdCost, uomId, customFields, dateCreated (date), dateLastModified (date)
| id ▼ | abcCode | accountingHash | accountingId | activeFlag | adjustmentAccountId | alertNote | alwaysManufacture | cogsAccountId | configurable | consumptionRate | controlledFlag | cycleCountTol | dateCreated | dateLastModified | defaultBomId | defaultOutsourcedReturnItemId | defaultPoItemTypeId | defaultProductId | description | details | height | inventoryAccountId | lastChangedUser | leadTime | len | num | partClassId | pickInUomOfPart | receivingTol | revision | scrapAccountId | serializedFlag | sizeUomId | stdCost | taxId | trackingFlag | typeId | uomId | upc | url | varianceAccountId | weight | weightUomId | width | customFields |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2023-01-26 11:32:58.122000 | 2026-02-27 08:56:58.728000 | 2 | 10 | Labor by machine shop employee | 0.0 | 818 | TWilliams | 0.0 | Labor - Machine Shop | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 21 | 35 | 0.0 | 3 | 0.0 | {"2": {"name": "ID", "type": "Text"}, "3": {"name": "Date", "type": "Date"}, "15": {"name": "Reach Compliant", "type": "Checkbox", "value": "false"}, "16": {"name": "ROHS Compliant", "type": "Checkbox", "value": "false"}, "26": {"name": "Cust Rev", "type": "Text"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | ||||||||||||||||
| 23 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2023-01-26 16:03:20.622000 | 2026-02-27 08:56:58.712000 | 23 | 10 | Labor from assembly worker | 0.0 | 817 | TWilliams | 0.0 | Labor - Assembly | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 21 | 35 | 0.0 | 3 | 0.0 | {"2": {"name": "ID", "type": "Text"}, "3": {"name": "Date", "type": "Date"}, "15": {"name": "Reach Compliant", "type": "Checkbox", "value": "false"}, "16": {"name": "ROHS Compliant", "type": "Checkbox", "value": "false"}, "26": {"name": "Cust Rev", "type": "Text"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | ||||||||||||||||
| 24 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2023-01-26 16:04:04.396000 | 2026-02-27 08:56:58.744000 | 24 | 10 | Labor for Packaging | 0.0 | 817 | TWilliams | 0.0 | Labor - Packaging | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 21 | 35 | 0.0 | 3 | 0.0 | {"2": {"name": "ID", "type": "Text"}, "3": {"name": "Date", "type": "Date"}, "15": {"name": "Reach Compliant", "type": "Checkbox", "value": "false"}, "16": {"name": "ROHS Compliant", "type": "Checkbox", "value": "false"}, "26": {"name": "Cust Rev", "type": "Text"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | ||||||||||||||||
| 25 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2023-01-30 12:53:48.251000 | 2026-02-27 08:56:58.744000 | 25 | 10 | Labor for QC | 0.0 | 819 | TWilliams | 0.0 | Labor - Quality Control | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 21 | 35 | 0.0 | 3 | 0.0 | {"2": {"name": "ID", "type": "Text"}, "3": {"name": "Date", "type": "Date"}, "15": {"name": "Reach Compliant", "type": "Checkbox", "value": "false"}, "16": {"name": "ROHS Compliant", "type": "Checkbox", "value": "false"}, "26": {"name": "Cust Rev", "type": "Text"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | ||||||||||||||||
| 26 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2023-01-30 12:54:46.404000 | 2023-06-29 16:05:15.001000 | 26 | 10 | Polishing & Grinding labor | #N/A | 0.0 | DPike | 0.0 | Labor - Polishing & Grinding | _binary | 0.0 | _binary | 2 | 25.0 | _binary | 21 | 35 | 0.0 | 3 | 0.0 | {"2": {"name": "ID", "type": "Text"}, "3": {"name": "Date", "type": "Date"}, "13": {"name": "Innofiber Rev", "type": "Text"}, "15": {"name": "Reach Compliant", "type": "Checkbox", "value": "false"}, "16": {"name": "ROHS Compliant", "type": "Checkbox", "value": "false"}, "26": {"name": "Cust Rev", "type": "Text"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | ||||||||||||||||
| 81 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2023-02-01 19:27:06.155000 | 2026-02-27 08:56:58.728000 | 81 | 10 | Labor for Grinding and Polishing | 0.0 | 817 | TWilliams | 0.0 | Labor - G&P | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 21 | 35 | 0.0 | 3 | 0.0 | {"2": {"name": "ID", "type": "Text"}, "3": {"name": "Date", "type": "Date"}, "15": {"name": "Reach Compliant", "type": "Checkbox", "value": "false"}, "16": {"name": "ROHS Compliant", "type": "Checkbox", "value": "false"}, "26": {"name": "Cust Rev", "type": "Text"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | ||||||||||||||||
| 26421 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2023-02-10 14:32:22.713000 | 2026-02-27 08:56:58.728000 | 26421 | 10 | Labor for Manufacture of Glass | 0.0 | 817 | TWilliams | 0.0 | Labor - Glass | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 21 | 35 | 0.0 | 3 | 0.0 | {"2": {"name": "ID", "type": "Text"}, "3": {"name": "Date", "type": "Date"}, "15": {"name": "Reach Compliant", "type": "Checkbox", "value": "false"}, "16": {"name": "ROHS Compliant", "type": "Checkbox", "value": "false"}, "26": {"name": "Cust Rev", "type": "Text"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | ||||||||||||||||
| 27603 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2023-05-30 14:35:25.781000 | 2026-02-27 08:56:58.744000 | 27603 | 10 | Labor for potting | 0.0 | 817 | TWilliams | 0.0 | Labor - Potting Labor | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 21 | 4 | 0.0 | 3 | 0.0 | {"2": {"name": "ID", "type": "Text"}, "3": {"name": "Date", "type": "Date"}, "15": {"name": "Reach Compliant", "type": "Checkbox", "value": "false"}, "16": {"name": "ROHS Compliant", "type": "Checkbox", "value": "false"}, "26": {"name": "Cust Rev", "type": "Text"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | ||||||||||||||||
| 27616 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2023-06-12 10:47:08.403000 | 2026-02-27 08:56:58.712000 | 27616 | 10 | Labor | 0.0 | TWilliams | 0.0 | Labor- | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 21 | 4 | 0.0 | 3 | 0.0 | {"2": {"name": "ID", "type": "Text"}, "3": {"name": "Date", "type": "Date"}, "15": {"name": "Reach Compliant", "type": "Checkbox", "value": "false"}, "16": {"name": "ROHS Compliant", "type": "Checkbox", "value": "false"}, "26": {"name": "Cust Rev", "type": "Text"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | |||||||||||||||||
| 34086 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2026-03-18 16:59:06.341000 | 2026-03-18 16:59:34.132000 | 34086 | 10 | Cleaning Parts in Ox Out for brazing | 0.0 | EReed | 0.0 | Labor - OX Out Cleaning | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 21 | 4 | 0.0 | 3 | 0.0 | {"2": {"name": "ID", "type": "Text", "value": ""}, "3": {"name": "Date", "type": "Date"}, "13": {"name": "Innofiber Rev", "type": "Text", "value": ""}, "15": {"name": "Reach Compliant", "type": "Checkbox", "value": "false"}, "16": {"name": "ROHS Compliant", "type": "Checkbox", "value": "false"}, "26": {"name": "Cust Rev", "type": "Text", "value": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity", "value": "3"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Make"}} |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "part" (
"id" INTEGERNOT NULL ,
"abcCode" TEXT DEFAULT NULL,
"accountingHash" TEXT DEFAULT NULL,
"accountingId" TEXT DEFAULT NULL,
"activeFlag" INTEGER NOT NULL,
"adjustmentAccountId" INTEGERDEFAULT NULL,
"alertNote" TEXT DEFAULT NULL,
"alwaysManufacture" INTEGER NOT NULL,
"cogsAccountId" INTEGERDEFAULT NULL,
"configurable" INTEGER NOT NULL,
"consumptionRate" REAL NOT NULL DEFAULT '0.000000000',
"controlledFlag" INTEGER NOT NULL,
"cycleCountTol" REAL DEFAULT NULL,
"dateCreated" TEXT DEFAULT NULL,
"dateLastModified" TEXT DEFAULT NULL,
"defaultBomId" INTEGERDEFAULT NULL,
"defaultOutsourcedReturnItemId" INTEGERDEFAULT NULL,
"defaultPoItemTypeId" INTEGERDEFAULT NULL,
"defaultProductId" INTEGERDEFAULT NULL,
"description" TEXT DEFAULT NULL,
"details" TEXT ,
"height" REAL DEFAULT NULL,
"inventoryAccountId" INTEGERDEFAULT NULL,
"lastChangedUser" TEXT DEFAULT NULL,
"leadTime" INTEGERDEFAULT NULL,
"len" REAL DEFAULT NULL,
"num" TEXT NOT NULL,
"partClassId" INTEGERDEFAULT NULL,
"pickInUomOfPart" INTEGER NOT NULL,
"receivingTol" REAL DEFAULT NULL,
"revision" TEXT DEFAULT NULL,
"scrapAccountId" INTEGERDEFAULT NULL,
"serializedFlag" INTEGER NOT NULL,
"sizeUomId" INTEGERDEFAULT NULL,
"stdCost" REAL DEFAULT NULL,
"taxId" INTEGERDEFAULT NULL,
"trackingFlag" INTEGER NOT NULL,
"typeId" INTEGERNOT NULL,
"uomId" INTEGERNOT NULL,
"upc" TEXT DEFAULT NULL,
"url" TEXT DEFAULT NULL,
"varianceAccountId" INTEGERDEFAULT NULL,
"weight" REAL DEFAULT NULL,
"weightUomId" INTEGERDEFAULT NULL,
"width" REAL DEFAULT NULL,
"customFields" TEXT DEFAULT NULL,
PRIMARY KEY ("id")
);