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

part

3 rows where typeId = 60

✎ View and edit SQL

This data as json, CSV (advanced)

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

typeId 1

activeFlag 1

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
27558 N     _binary      _binary   _binary 0.0 _binary 0.0 2023-02-27 13:29:39.643000 2026-02-27 08:56:56.743000   27558 10   Freight   0.0 501 TWilliams   0.0 Freight   _binary 0.0     _binary 2 0.0   _binary 60 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"}}
33271 N     _binary  505   _binary 505 _binary 0.0 _binary 0.0 2024-06-28 16:03:17.961000 2026-02-27 08:57:00.225000   33271 10 91210 Shipping Charge   0.0 505 TWilliams   0.0 Shipping   _binary 0.0     _binary 2 0.0   _binary 60 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"}}
34010 N     _binary      _binary   _binary 0.0 _binary 0.0 2026-02-13 11:37:34.188000 2026-02-27 08:57:05.979000   34010 10   Use this to capture taxes on invoices   0.0   TWilliams   0.0 Taxes   _binary 0.0     _binary 2 0.0   _binary 60 1       0.0 3 0.0 {"2": {"name": "ID", "type": "Text", "value": "TAXES"}, "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")
);