Clear filters 📥 Export to Excel (CSV) ⚙ Advanced filters

part

9 rows where activeFlag = "_binary " and typeId = 21

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dateLastModified, inventoryAccountId, lastChangedUser, uomId, customFields, dateCreated (date), dateLastModified (date)

typeId 1

activeFlag 1

  • _binary  · 9 ✖
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"}}
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

CSV options: 

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")
);