part
1 row where typeId = 22
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27580 | N | _binary | 618 | _binary | 388 | _binary | 0.0 | _binary | 0.0 | 2023-04-18 15:15:01.523000 | 2026-02-27 08:56:58.933000 | 27580 | 10 | Miscellaneous Supplies | 0.0 | 611 | TWilliams | 0.0 | Misc - Supply | _binary | 0.0 | 816 | _binary | 2 | 0.0 | _binary | 22 | 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
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")
);