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

part

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

✎ 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
27570 N     _binary     _binary   _binary 0.0 _binary 0.0 2023-03-23 17:21:58.601000 2023-06-29 16:08:24.809000   27570 10   Labor for Potting   0.0 817 DPike   0.0 Labor - Potting   _binary 0.0     _binary 2 81.0   _binary 20 4       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"}}
27575 N     _binary 618   _binary 388 _binary 0.0 _binary 0.0 2023-03-27 11:59:58.454000 2024-01-04 12:47:12.821000   27575 10   Parylene Coating a part   0.0 611 aminior   0.0 Service - Parylene Coating   _binary 0.0   816 _binary 2 0.0   _binary 20 18       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"}, "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")
);