home / fishbowl_archive

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

part

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dateLastModified, defaultPoItemTypeId, lastChangedUser, revision, stdCost, uomId, customFields, dateCreated (date), dateLastModified (date)

typeId 1

  • 20 · 31 ✖

activeFlag 1

  • _binary  · 31 ✖
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
11 N     _binary  618   _binary 388 _binary 0.0 _binary 0.0 2023-01-26 13:38:44.655000 2026-02-27 08:56:51.558000   11 30   Machine shop manufactures part   0.0 611 TWilliams   0.0 End Tip Creation   _binary 0.0   816 _binary 2 1.0   _binary 20 18       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"}}
27560 N     _binary      _binary   _binary 0.0 _binary 0.0 2023-03-21 17:11:13.091000 2026-02-27 08:56:58.728000   27560 10   Laser Marking Labor   0.0 817 TWilliams   0.0 Labor - Laser Marking   _binary 0.0     _binary 2 0.0   _binary 20 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"}}
33121 N     _binary      _binary   _binary 0.0 _binary 0.0 2023-07-27 16:42:02.656000 2026-02-27 08:56:58.918000   33121 10   Measurement Service   0.0   TWilliams   0.0 Measurement Service   _binary 0.0     _binary 2 0.0   _binary 20 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", "value": "SERVICE"}}
33125 N     _binary      _binary   _binary 0.0 _binary 0.0 2023-08-08 14:13:39.256000 2026-02-27 08:56:59.327000   33125 10   3rd Part NRE fees   0.0 839 TWilliams   0.0 NRE - #rd Party   _binary 0.0     _binary 2 0.0   _binary 20 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"}}
33135 N     _binary      _binary   _binary 0.0 _binary 0.0 2023-10-02 15:20:23.823000 2026-02-27 08:57:00.225000   33135 10   When a Service is completed on a materials   0.0   TWilliams   0.0 Service Fee   _binary 0.0     _binary 2 0.0   _binary 20 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", "value": "Service"}}
33171 N     _binary      _binary   _binary 0.0 _binary 0.0 2024-01-04 12:19:01.695000 2026-02-27 08:57:00.163000   33171 10   Service - Parylene Coating   0.0   TWilliams   0.0 Serv-0001   _binary 0.0 *   _binary 2 3.49   _binary 20 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", "value": "Service"}}
33172 N     _binary      _binary   _binary 0.0 _binary 0.0 2024-01-04 16:12:49.074000 2026-02-27 08:57:00.163000   33172 10   Service - Laser Marked & Passivated   0.0   TWilliams   0.0 Serv-0002   _binary 0.0 *   _binary 2 0.0   _binary 20 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", "value": "Service"}}
33173 N     _binary      _binary   _binary 0.0 _binary 0.0 2024-01-09 10:21:29.568000 2026-02-27 08:57:00.163000   33173 10   Service - Laser Marked   0.0   TWilliams   0.0 Serv-0003   _binary 0.0 *   _binary 2 0.0   _binary 20 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", "value": "Service"}}
33174 N     _binary      _binary   _binary 0.0 _binary 0.0 2024-01-09 10:25:46.719000 2026-02-27 08:57:00.178000   33174 10   Service - Passivation   0.0   TWilliams   0.0 Serv-0004   _binary 0.0 *   _binary 2 0.0   _binary 20 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", "value": "Service"}}
33175 N     _binary      _binary   _binary 0.0 _binary 0.0 2024-01-09 15:09:44.889000 2026-02-27 08:57:00.149000   33175 10   Service - Description   0.0   TWilliams   0.0 Serv-0000-TEMPLATE   _binary 0.0 *   _binary 2 0.0   _binary 20 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", "value": "*"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Service"}}
33176 N     _binary      _binary   _binary 0.0 _binary 0.0 2024-01-09 15:10:53.491000 2026-02-27 08:57:00.178000   33176 10   Service - Coat CSM with AlMgF   0.0   TWilliams   0.0 Serv-0005   _binary 0.0 *   _binary 2 3.89   _binary 20 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", "value": "Service"}}
33177 N     _binary      _binary   _binary 0.0 _binary 0.0 2024-01-10 11:08:42.202000 2026-02-27 08:57:00.178000   33177 10   Service - Fiber Fusing   0.0   TWilliams   0.0 Serv-0006   _binary 0.0 *   _binary 2 60.0   _binary 20 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", "value": "Service"}}
33200 N     _binary      _binary   _binary 0.0 _binary 0.0 2024-01-25 15:07:29.166000 2026-02-27 08:57:00.194000   33200 10   Service - Anodizing   0.0   TWilliams   0.0 Serv-0007   _binary 0.0 *   _binary 2 0.0   _binary 20 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", "value": "Service"}}
33207 N     _binary      _binary   _binary 0.0 _binary 0.0 2024-02-13 08:20:41.641000 2026-02-27 08:57:00.194000   33207 10   Service - Inspect & Report of 16204-17   0.0   TWilliams   0.0 Serv-0008   _binary 0.0 *   _binary 2 0.0   _binary 20 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", "value": "Service"}}
33218 N     _binary      _binary   _binary 0.0 _binary 0.0 2024-03-11 09:58:10.748000 2026-02-27 08:57:00.209000   33218 10   Service - Powder Coating   0.0   TWilliams   0.0 Serv-0009   _binary 0.0 *   _binary 2 0.0   _binary 20 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", "value": "*"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Service"}}
33230 N     _binary      _binary   _binary 0.0 _binary 0.0 2024-04-16 16:01:53.827000 2026-02-27 08:57:00.209000   33230 10   Service - Cutting & Passivation   0.0   TWilliams   0.0 Serv-0010   _binary 0.0 *   _binary 2 0.0   _binary 20 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", "value": "*"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Service"}}
34008 N     _binary      _binary   _binary 0.0 _binary 0.0 2026-02-09 15:12:09.065000 2026-02-27 08:57:00.069000   34008 10   When all other option to revised receiving costs fails and cost needs to be captured   0.0   TWilliams   0.0 Reconciliation Difference   _binary 0.0     _binary 2 0.0   _binary 20 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"}}
34024 N     _binary      _binary   _binary 0.0 _binary 0.0 2026-02-18 11:04:51.508000 2026-02-27 08:57:00.209000   34024 10   e-cable soldering   0.0   TWilliams   0.0 Serv-0011   _binary 0.0     _binary 2 0.0   _binary 20 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", "value": "*"}, "37": {"name": "Vendor Lead Time", "type": "Quantity", "value": "5"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Service"}}
34039 N     _binary      _binary   _binary 0.0 _binary 0.0 2026-03-04 14:12:35.184000 2026-03-04 14:13:27.271000   34039 10   Passivated 15918   0.0   EReed   0.0 Serv-00012   _binary 0.0     _binary 2 0.0   _binary 20 1       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": "*"}, "37": {"name": "Vendor Lead Time", "type": "Quantity", "value": "15"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Outsourced"}}
34056 N     _binary      _binary   _binary 0.0 _binary 0.0 2026-03-09 11:56:08.950000 2026-03-09 12:07:52.107000   34056 10   Parylene Coating - 5345 (VSI)   0.0   EReed   0.0 Serv-00013   _binary 0.0     _binary 2 0.0   _binary 20 1       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": "15"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Outsourced"}}
34058 N     _binary      _binary   _binary 0.0 _binary 0.0 2026-03-11 08:50:42.992000 2026-03-11 09:57:29.830000   34058 10   16502-Etching and Passivation (DP)   0.0   EReed 15 0.0 Serv-00014   _binary 0.0     _binary 2 0.0   _binary 20 1       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": "*"}, "37": {"name": "Vendor Lead Time", "type": "Quantity", "value": "15"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Outsourced"}}
34059 N     _binary      _binary   _binary 0.0 _binary 0.0 2026-03-11 09:56:38.237000 2026-03-11 09:57:49.217000   34059 10   16504-Etching and Passivation (DP)   0.0   EReed 15 0.0 Serv-00015   _binary 0.0     _binary 2 0.0   _binary 20 1       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": "*"}, "37": {"name": "Vendor Lead Time", "type": "Quantity", "value": "15"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Outsourced"}}
34062 N     _binary      _binary   _binary 0.0 _binary 0.0 2026-03-11 10:43:42.957000 2026-03-11 10:48:45.799000   34062 10   16505-Etching and Passivation (DP)   0.0   EReed   0.0 Serv-00016   _binary 0.0 C   _binary 2 0.0   _binary 20 1       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": "*"}, "37": {"name": "Vendor Lead Time", "type": "Quantity", "value": "15"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Outsourced"}}
34065 N     _binary      _binary   _binary 0.0 _binary 0.0 2026-03-13 11:57:56.406000 2026-03-13 11:58:45.837000   34065 10   15954-Etching and Passivation (DP)   0.0   EReed   0.0 Serv-00017   _binary 0.0     _binary 2 0.0   _binary 20 1       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": "*"}, "37": {"name": "Vendor Lead Time", "type": "Quantity", "value": "15"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Outsourced"}}
34077 N     _binary      _binary   _binary 0.0 _binary 0.0 2026-03-17 11:14:21.487000 2026-03-30 14:28:15.150000   34077 10   15952-Etching and Passivation (DP)   0.0   EReed   0.0 Serv-00018   _binary 0.0     _binary 2 0.0   _binary 20 1       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": "*"}, "37": {"name": "Vendor Lead Time", "type": "Quantity", "value": "15"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Outsourced"}}
34081 N     _binary      _binary   _binary 0.0 _binary 0.0 2026-03-18 10:25:15.231000 2026-03-18 10:26:16.365000   34081 10   17763-Etching and Passivation (DP)   0.0   EReed   0.0 Serv-00019   _binary 0.0     _binary 2 0.0   _binary 20 1       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": "*"}, "37": {"name": "Vendor Lead Time", "type": "Quantity", "value": "15"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Outsourced"}}
34082 N     _binary      _binary   _binary 0.0 _binary 0.0 2026-03-18 10:53:06.717000 2026-03-18 10:53:29.480000   34082 10   17762-Etching and Passivation (DP)   0.0   EReed   0.0 Serv-00020   _binary 0.0     _binary 2 0.0   _binary 20 1       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": "*"}, "37": {"name": "Vendor Lead Time", "type": "Quantity", "value": "15"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Outsourced"}}
34084 N     _binary      _binary   _binary 0.0 _binary 0.0 2026-03-18 15:01:30.331000 2026-03-18 15:02:53.800000   34084 10   12019 passivation of 10039   0.0   EReed   0.0 Serv-0021   _binary 0.0     _binary 2 0.0   _binary 20 1       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": "15"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Outsourced"}}
34085 N     _binary      _binary   _binary 0.0 _binary 0.0 2026-03-18 16:46:25.582000 2026-03-18 16:46:53.534000   34085 10   12019 passivation of 10039 (Dav-Tech)   0.0   EReed   0.0 serv-0022   _binary 0.0     _binary 2 0.0   _binary 20 1       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": "15"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Outsourced"}}
34087 N     _binary      _binary   _binary 0.0 _binary 0.0 2026-03-23 14:43:12.109000 2026-03-23 14:43:35.531000   34087 10   16369 Laser Marking (Permanent Mark)   0.0   EReed   0.0 Serv-0023   _binary 0.0     _binary 2 0.0   _binary 20 1       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": "7"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Service"}}
34101 N     _binary      _binary   _binary 0.0 _binary 0.0 2026-04-15 09:50:07.898000 2026-04-15 09:53:37.150000   34101 10   16712-Parylene Coating (VSI)   0.0   EReed 15 0.0 Serv-0024   _binary 0.0     _binary 2 0.0   _binary 20 1       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": "*"}, "37": {"name": "Vendor Lead Time", "type": "Quantity", "value": "15"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "Outsourced"}}

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")
);
Powered by Datasette · Queries took 987.251ms