part
31 rows where activeFlag = "_binary " and typeId = 20
This data as json, CSV (advanced)
Suggested facets: dateLastModified, defaultPoItemTypeId, lastChangedUser, revision, stdCost, uomId, customFields, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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
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")
);