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

part

2 rows where activeFlag = "_binary " and typeId = 40

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dateCreated (date), dateLastModified (date)

typeId 1

activeFlag 1

  • _binary  · 2 ✖
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
33180 N     _binary      _binary   _binary 0.0 _binary 0.0 2024-01-17 13:36:16.602000 2026-02-27 08:56:58.650000 114433 33180 10   40 deg needle touch grind fixture   0.0   TWilliams   0.0 G0510   _binary 0.0     _binary 2 0.0   _binary 40 1       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"}}
33181 N     _binary      _binary    _binary 0.0 _binary 0.0 2024-01-17 13:38:36.194000 2026-02-27 08:56:58.650000 114615 33181 10   G0510 Base Block   0.0   TWilliams   0.0 G0510-1   _binary 0.0     _binary 2 0.0   _binary 40 1       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"}}

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