part
192 rows where activeFlag = "_binary " and typeId = 30
This data as json, CSV (advanced)
Suggested facets: alwaysManufacture, details, inventoryAccountId, lastChangedUser, len, revision, uomId, width, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80 | N | _binary | 618 | _binary | 388 | _binary | 0.0 | _binary | 0.0 | 2023-02-01 18:58:37.071000 | 2026-02-27 08:55:55.936000 | 108439 | 80 | 10 | CRATE(STERILIZATION) | 0.0 | 611 | TWilliams | 0.0 | 7684 | _binary | 0.0 | * | 816 | _binary | 2 | 0.0 | _binary | 30 | 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", "value": "BUY"}} | |||||||||||
| 5508 | N | _binary | 618 | _binary | 388 | _binary | 0.0 | _binary | 0.0 | 2023-02-08 17:10:51.569000 | 2026-02-27 08:56:23.494000 | 5508 | 10 | LABEL(STRYKER SHIPPING LABEL) | 0.0 | 611 | TWilliams | 0.0 | 14677 | -1 | _binary | 0.0 | A | 816 | _binary | 2 | 0.0 | _binary | 30 | 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", "value": "MAKE"}} | |||||||||||
| 5555 | N | _binary | 618 | _binary | 388 | _binary | 0.0 | _binary | 0.0 | 2023-02-08 17:10:51.990000 | 2026-02-27 08:56:23.825000 | 5555 | 10 | LABEL(602439)CLAMSHELL | 0.0 | 611 | TWilliams | 0.0 | 14732 | -1 | _binary | 0.0 | BC | 816 | _binary | 2 | 0.0 | _binary | 30 | 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", "value": "BUY"}} | |||||||||||
| 5991 | N | _binary | 618 | _binary | 388 | _binary | 0.0 | _binary | 0.0 | 2023-02-08 17:10:56.319000 | 2026-02-27 08:56:25.779000 | 113919 | 5991 | 10 | TUBE (0.085 X 0.125 X 3.15L) | ST.ST. | 0.0 | 611 | TWilliams | 0.0 | 15065 | -1 | _binary | 0.0 | B | 816 | _binary | 2 | 0.0 | _binary | 30 | 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", "value": "BUY"}} | |||||||||
| 10541 | N | _binary | 618 | _binary | 388 | _binary | 0.0 | _binary | 0.0 | 2023-02-08 17:11:40.622000 | 2026-02-27 08:57:02.811000 | 114747 | 10541 | 10 | CURING ADAPTOR FIXTURE | 0.0 | 611 | TWilliams | 0.0 | T0794 | -1 | _binary | 0.0 | A | 816 | _binary | 2 | 0.0 | _binary | 30 | 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"}} | ||||||||||
| 27578 | N | _binary | 618 | _binary | _binary | 0.0 | _binary | 0.0 | 2023-04-06 09:49:56.493000 | 2026-02-27 08:57:05.995000 | 27578 | 10 | 89784 | test_1 | 0.0 | 609 | TWilliams | 0.0 | test_1 | _binary | 0.0 | 816 | _binary | 2 | 0.0 | _binary | 30 | 2 | 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"}} | |||||||||||||
| 27589 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2023-05-08 11:42:11.963000 | 2026-02-27 08:57:00.258000 | 27589 | 10 | Various Consumable Supplies | 0.0 | 788 | TWilliams | 0.0 | Supplies - Misc | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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"}} | ||||||||||||||||
| 33228 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2024-04-10 14:51:33.435000 | 2026-02-27 08:56:51.458000 | 33228 | 10 | Fiber Randomization Procedure | 0.0 | TWilliams | 0.0 | D10976 | _binary | 0.0 | A | _binary | 2 | 0.0 | _binary | 30 | 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", "value": "*"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | ||||||||||||||||
| 33283 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2024-07-17 11:38:29.224000 | 2026-02-27 08:55:57.588000 | 33283 | 10 | Brazing Supply - Braze Rod (1020xfc-15-454g) | 0.0 | TWilliams | 0.0 | 7919 | _binary | 0.0 | * | _binary | 2 | 0.0 | _binary | 30 | 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": "BUY"}} | ||||||||||||||||
| 33284 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2024-07-17 14:14:03.156000 | 2026-02-27 08:55:57.588000 | 33284 | 10 | 3M Double Sided Tape 1" - Fiber Drawing Supply | 0.0 | TWilliams | 0.0 | 7920 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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": "BUY"}} | |||||||||||||||||
| 33361 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2024-10-11 09:11:05.030000 | 2026-02-27 08:56:51.410000 | 33361 | 10 | DOCUMENT(C OF C) FRM | 0.0 | TWilliams | 0.0 | D10463 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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", "value": "*"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | |||||||||||||||||
| 33388 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2024-10-23 13:58:17.257000 | 2026-02-27 08:55:52.396000 | 33388 | 10 | Labeling Supply(4.02" X 1345' RIBBON) | 0.0 | TWilliams | 1345.0 | 7176 | _binary | 0.0 | A | _binary | 2 | 0.0 | _binary | 30 | 2 | 0.0 | 3 | 0.335 | {"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": "BUY"}} | ||||||||||||||||
| 33483 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-02-12 10:55:14.148000 | 2026-02-27 08:56:35.435000 | 33483 | 10 | Label - Verity - 06463 - 1/4 | 0.0 | TWilliams | 0.0 | 16661 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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": "BUY"}} | |||||||||||||||||
| 33484 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-02-12 10:55:37.557000 | 2026-02-27 08:56:35.435000 | 33484 | 10 | Label - Verity - 06463 - 2/4 | 0.0 | TWilliams | 0.0 | 16662 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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": "BUY"}} | |||||||||||||||||
| 33485 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-02-12 10:56:06.232000 | 2026-02-27 08:56:35.435000 | 33485 | 10 | Label - Verity - 06463 - 3/4 | 0.0 | TWilliams | 0.0 | 16663 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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": "BUY"}} | |||||||||||||||||
| 33486 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-02-12 10:56:27.155000 | 2026-02-27 08:56:35.451000 | 33486 | 10 | Label - Verity - 06463 - 4/4 | 0.0 | TWilliams | 0.0 | 16664 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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": "BUY"}} | |||||||||||||||||
| 33506 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-03-04 11:47:17.864000 | 2026-02-27 08:55:57.463000 | 33506 | 10 | DCX Belts 3X41-1/2 800X/FJ | 0.0 | TWilliams | 0.0 | 7897 | _binary | 0.0 | * | _binary | 2 | 0.0 | _binary | 30 | 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": "BUY"}} | ||||||||||||||||
| 33522 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-03-20 08:45:51.732000 | 2026-02-27 08:56:35.519000 | 114680 | 33522 | 10 | Estique Label | 0.0 | TWilliams | 0.0 | 16678 | _binary | 0.0 | A | _binary | 2 | 0.0 | _binary | 30 | 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": "BUY"}} | |||||||||||||||
| 33543 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-04-01 12:42:11.896000 | 2026-02-27 08:57:05.902000 | 33543 | 10 | ARBOR PRESS | 0.0 | TWilliams | 0.0 | T1197 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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"}} | |||||||||||||||||
| 33552 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-04-13 11:49:23.359000 | 2026-02-27 08:56:51.378000 | 33552 | 10 | Document(Assembly Procedure) | 0.0 | TWilliams | 0.0 | D10101 | _binary | 0.0 | J | _binary | 2 | 0.0 | _binary | 30 | 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": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | ||||||||||||||||
| 33553 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-04-13 11:52:27.656000 | 2026-02-27 08:56:51.393000 | 33553 | 10 | Document(Pacaging Process) | 0.0 | TWilliams | 0.0 | D10102 | _binary | 0.0 | H | _binary | 2 | 0.0 | _binary | 30 | 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": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | ||||||||||||||||
| 33554 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-04-13 11:54:28.188000 | 2026-02-27 08:56:51.399000 | 33554 | 10 | Document(QC Process) | 0.0 | TWilliams | 0.0 | D10103 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | |||||||||||||||||
| 33555 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-04-13 11:59:23.627000 | 2026-02-27 08:56:51.399000 | 33555 | 10 | Document(Transmission Log) | 0.0 | TWilliams | 0.0 | D10126 | _binary | 0.0 | C | _binary | 2 | 0.0 | _binary | 30 | 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": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | ||||||||||||||||
| 33556 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-04-13 12:02:37.091000 | 2026-02-27 08:56:51.410000 | 33556 | 10 | Document(Cable Log) | 0.0 | TWilliams | 0.0 | D10314 | _binary | 0.0 | D | _binary | 2 | 0.0 | _binary | 30 | 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": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | ||||||||||||||||
| 33557 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-04-13 12:05:46.467000 | 2026-02-27 08:56:51.425000 | 33557 | 10 | Document(FAIR) | 0.0 | TWilliams | 0.0 | D10681 | _binary | 0.0 | F | _binary | 2 | 0.0 | _binary | 30 | 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": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | ||||||||||||||||
| 33558 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-04-13 12:07:55.405000 | 2026-02-27 08:56:51.441000 | 33558 | 10 | Document(Line Clearance WI) | 0.0 | TWilliams | 0.0 | D10777 | _binary | 0.0 | A | _binary | 2 | 0.0 | _binary | 30 | 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": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | ||||||||||||||||
| 33559 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-04-13 12:09:43.765000 | 2026-02-27 08:56:51.473000 | 33559 | 10 | Document(C of C) | 0.0 | TWilliams | 0.0 | D11177 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | |||||||||||||||||
| 33560 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-04-15 14:18:12.585000 | 2026-02-27 08:56:51.410000 | 33560 | 10 | Document( C of C) | 0.0 | TWilliams | 0.0 | D10206 | _binary | 0.0 | * | _binary | 2 | 0.0 | _binary | 30 | 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": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | ||||||||||||||||
| 33562 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-04-17 14:13:48.670000 | 2026-02-27 08:57:05.917000 | 33562 | 10 | Ceramic Fiber Scribe | 0.0 | TWilliams | 0.0 | T1198 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | |||||||||||||||||
| 33564 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-04-22 12:23:07.071000 | 2026-02-27 08:56:57.657000 | 114703 | 33564 | 10 | POLISHING FIXTURE(14521) | 0.0 | TWilliams | 0.0 | G0310 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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", "value": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | ||||||||||||||||
| 33568 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-05-09 08:08:16.446000 | 2026-02-27 08:56:51.473000 | 33568 | 10 | Estiq Process Build Procedure | 0.0 | TWilliams | 0.0 | D11229 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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"}} | |||||||||||||||||
| 33585 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-05-20 11:08:34.878000 | 2026-02-27 08:57:05.917000 | 33585 | 10 | STRIPPER BLADES (.025) | 0.0 | TWilliams | 0.0 | T1205 | _binary | 0.0 | * | _binary | 2 | 0.0 | _binary | 30 | 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"}} | ||||||||||||||||
| 33600 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-05-22 15:27:18.527000 | 2026-02-27 08:56:58.665000 | 33600 | 10 | SMA 905 POLISHING PUCK | 0.0 | TWilliams | 0.0 | G0522 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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", "value": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | |||||||||||||||||
| 33618 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-06-17 16:26:51.348000 | 2026-02-27 08:56:51.441000 | 33618 | 10 | DOCUMENT(ASSEMBLY PROCEDURE G-PROBE) | 0.0 | TWilliams | 0.0 | D10794 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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"}} | |||||||||||||||||
| 33647 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-07-02 11:29:48.020000 | 2026-02-27 08:57:02.827000 | 114745 | 33647 | 10 | RETAINER - CURING ADAPTOR FIXTURE | 0.0 | TWilliams | 0.0 | T0794-1 | _binary | 0.0 | B | _binary | 2 | 0.0 | _binary | 30 | 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"}} | |||||||||||||||
| 33648 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-07-02 11:30:52.833000 | 2026-02-27 08:57:02.827000 | 114746 | 33648 | 10 | BASE- CURING ADAPTOR FIXTURE | 0.0 | TWilliams | 0.0 | T0794-2 | _binary | 0.0 | B | _binary | 2 | 0.0 | _binary | 30 | 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"}} | |||||||||||||||
| 33699 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-07-11 08:57:58.347000 | 2026-02-27 08:56:51.458000 | 33699 | 10 | 91263 | Certificate of Conformance | 0.0 | TWilliams | 0.0 | D11160 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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"}} | ||||||||||||||||
| 33718 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-08-04 14:08:57.889000 | 2026-02-27 08:56:51.488000 | 33718 | 10 | ISI Dexter Cable Final QC Log | 0.0 | TWilliams | 0.0 | D11243 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | |||||||||||||||||
| 33719 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-08-04 14:09:49.605000 | 2026-02-27 08:56:51.488000 | 33719 | 10 | ISI Dexter Cable C of C | 0.0 | TWilliams | 0.0 | D11245 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | |||||||||||||||||
| 33720 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-08-04 14:10:42.761000 | 2026-02-27 08:56:35.767000 | 114795 | 33720 | 10 | ISI Dexter Cable Label | 0.0 | TWilliams | 0.0 | 16727 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List", "value": "BUY"}} | ||||||||||||||||
| 33721 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-08-05 16:03:49.057000 | 2026-02-27 08:56:51.488000 | 33721 | 10 | ISI Dexter Optical Test Procedure | 0.0 | TWilliams | 0.0 | D11246 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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", "value": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | |||||||||||||||||
| 33727 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-08-06 11:33:48.516000 | 2026-02-27 08:57:05.932000 | 33727 | 10 | CRESCENT BUSHING TEMPERATURE CONTROLLER | 0.0 | TWilliams | 0.0 | T1215 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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"}} | |||||||||||||||||
| 33728 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-08-07 15:14:05.575000 | 2026-02-27 08:57:05.932000 | 33728 | 10 | POTTING PLATE ASSEMBLY(CEMAS) | 0.0 | TWilliams | 0.0 | T1213 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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", "value": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity", "value": "15"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | |||||||||||||||||
| 33738 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-08-12 11:03:23.240000 | 2026-02-27 08:56:35.783000 | 33738 | 10 | Openwater Label 06500 | 0.0 | TWilliams | 0.0 | 16730 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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": "BUY"}} | |||||||||||||||||
| 33757 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-09-08 11:54:35.467000 | 2026-02-27 08:56:51.488000 | 33757 | 10 | Assembly Procedure - Dexter Fiber Cable | 0.0 | TWilliams | 0.0 | D11242 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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", "value": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | |||||||||||||||||
| 33788 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-09-26 09:54:07.068000 | 2026-02-27 08:56:51.504000 | 33788 | 10 | INSPECTION LOG | 0.0 | TWilliams | 0.0 | D11252 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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", "value": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity", "value": "5"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | |||||||||||||||||
| 33789 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-09-26 09:54:58.023000 | 2026-02-27 08:56:51.504000 | 33789 | 10 | INSPECTION INSTRUCTIONS (OPENWATER) | 0.0 | TWilliams | 0.0 | D11255 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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": "NA"}, "37": {"name": "Vendor Lead Time", "type": "Quantity", "value": "5"}, "42": {"name": "Make/Buy", "type": "Drop-Down List"}} | |||||||||||||||||
| 33800 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-10-08 09:16:08.818000 | 2026-02-27 08:57:05.948000 | 33800 | 10 | BASE SMALL ID INSERT STRAIN RELIEF MOLD | 0.0 | TWilliams | 0.0 | T1219-1 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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"}} | |||||||||||||||||
| 33801 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-10-08 09:16:55.797000 | 2026-02-27 08:57:05.948000 | 33801 | 10 | LONG SMALL ID INSERT STRAIN RELIEF MOLD | 0.0 | TWilliams | 0.0 | T1219-2 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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"}} | |||||||||||||||||
| 33802 | N | _binary | _binary | _binary | 0.0 | _binary | 0.0 | 2025-10-08 09:17:21.807000 | 2026-02-27 08:57:05.948000 | 33802 | 10 | SHORT SMALL ID INSERT STRAIN RELIEF MOLD | 0.0 | TWilliams | 0.0 | T1219-3 | _binary | 0.0 | _binary | 2 | 0.0 | _binary | 30 | 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"}} |
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")
);