📥 Export to Excel (CSV) ⚙ Advanced filters

poitem

7,687 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: customerId, qtyPicked, statusId, typeId, uomId, outsourcedPartNumber, outsourcedPartDescription, dateLastFulfillment (date), dateScheduledFulfillment (date)

id ▼ customerId dateLastFulfillment dateScheduledFulfillment description mcTotalCost mcUnitCost note partId outsourcedPartId partNum poId poLineItem qbClassId qtyFulfilled qtyPicked qtyToFulfill repairFlag revLevel statusId taxId taxRate tbdCostFlag totalCost typeId unitCost uomId vendorPartNum outsourcedPartNumber outsourcedPartDescription customFields
1   2023-01-30 14:53:52.109000 2023-02-03 00:00:00.000000 ADHESIVE, LOCTITE WICKING 4014 14.0 0.2   37   15679 1 1 1 70.0 0.0 70.0 _binary   50 1 0.0 _binary 14.0 10 0.2 6 15679     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
2   2023-02-02 12:56:00.512000 2023-02-16 00:00:00.000000 NUT(M8 X P1.0)ST.ST. 2.0 0.02   178   10111 2 1 1 100.0 0.0 100.0 _binary   50 1 0.0 _binary 2.0 10 0.02 18 10111     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
4   2023-02-02 15:02:20.043000 2023-02-02 00:00:00.000000 BRAZING SUPPLY(BRAZE ROD (XFC 18" X 3/64")) 1083.64 1083.64   218   7043 3 1 1 1.0 0.0 1.0 _binary   50 1 0.0 _binary 1083.64 10 1083.64 3 7043     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
11   2024-01-07 12:19:33.702000 2023-03-21 00:00:00.000000 END TIP(UNIVERSAL LONG 5/16-24)4.0MM 850.0 4.25   4921   14051 9 1 1 200.0 0.0 200.0 _binary   60 1 0.0 _binary 850.0 10 4.25 18 14051     {"4": {"name": "ID", "type": "Text", "value": ""}, "14": {"name": "Revision Level", "type": "Text", "value": ""}, "29": {"name": "Vendor Notes", "type": "Text", "value": ""}}
12   2024-01-07 13:45:00.924000 2023-03-21 14:36:49.306000 STRAIN RELIEF(SHORT)SM. ID - GRAY 122 2153.92 4.24   4128   13199 10 1 1 508.0 0.0 508.0 _binary   60 1 0.0 _binary 2153.92 10 4.24 18 13199     {"4": {"name": "ID", "type": "Text", "value": ""}, "14": {"name": "Revision Level", "type": "Text", "value": ""}, "29": {"name": "Vendor Notes", "type": "Text"}}
13   2023-03-21 14:46:58.189000 2023-03-21 14:42:05.480000 COLLAR(SOLDER / 1/8" S/L & M-130) 525.0 1.75   1550   10390 11 1 1 309.0 0.0 300.0 _binary * 50 1 0.0 _binary 525.0 10 1.75 18 10390     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
14   2023-03-21 14:54:03.220000 2023-03-21 14:50:34.286000 Fiber Drawing Supply(Stopcocks w/ Luer Conn) 10 pk 6.53 6.53   7837   7053 12 1 1 1.0 0.0 1.0 _binary   50 1 0.0 _binary 6.53 10 6.53 18 NC-2242404     {"4": {"name": "ID", "type": "Text", "value": ""}, "14": {"name": "Revision Level", "type": "Text", "value": ""}, "29": {"name": "Vendor Notes", "type": "Text"}}
15   2023-03-17 00:00:00.000000 2023-03-21 18:09:36.357000 Fiber Drawing Supply(Stopcocks w/ Luer Conn) 10 pk 58.77 6.53   7837   7053 12 2 1 9.0 0.0 9.0 _binary   50 1 0.0 _binary 58.77 10 6.53 18 NC-2242404     {"4": {"name": "ID", "type": "Text", "value": ""}, "14": {"name": "Revision Level", "type": "Text", "value": ""}, "29": {"name": "Vendor Notes", "type": "Text"}}
16   2024-01-19 16:00:43.027000 2023-03-29 11:41:02.640000 FUSED BUNDLE(5.3MM)NA.55 - RIBBON - 15L 4860.0 60.0   153   16053 13 1 1 81.0 0.0 81.0 _binary B 60 1 0.0 _binary 4860.0 10 60.0 18 16053     {"4": {"name": "ID", "type": "Text", "value": ""}, "14": {"name": "Revision Level", "type": "Text", "value": ""}, "29": {"name": "Vendor Notes", "type": "Text"}}
17     2023-04-13 00:00:00.000000 END TIP, PASSIVATED (UNIVERSAL PROX.) 124.96 11.36   7183   16370 14 1 1 0.0 0.0 11.0 _binary   70 1 0.0 _binary 124.96 10 11.36 18 16370     {"4": {"name": "ID", "type": "Text", "value": ""}, "14": {"name": "Revision Level", "type": "Text", "value": ""}, "29": {"name": "Vendor Notes", "type": "Text"}}
18   2024-01-07 13:26:21.273000 2023-03-29 12:17:43.158000 CORE BAR LF5 34606.060818859 37.525833333   9862   LF5 15 1 1 922.193 0.0 922.193 _binary   60 1 0.0 _binary 34606.060818859 10 37.525833333 3 LF5     {"4": {"name": "ID", "type": "Text", "value": ""}, "14": {"name": "Revision Level", "type": "Text", "value": ""}, "29": {"name": "Vendor Notes", "type": "Text"}}
19     2023-03-29 12:23:41.078000 SHRINK TUBE(3/32" KYNAR CLEAR) 404.5 2.0225   7572   5182 16 1 1 0.0 0.0 200.0 _binary   70 1 0.0 _binary 404.5 10 2.0225 2 5182     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
20   2023-03-29 00:00:00.000000 2023-03-29 12:59:07.051000 QUARTZ FIBER(UV 200/220/245P28)HIGH OH 3750.0 2.5   7762   6057 17 1 1 1500.0 0.0 1500.0 _binary   50 1 0.0 _binary 3750.0 10 2.5 10 6057     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
21     2023-03-29 13:08:00.948000 S/L 5/32"-28" LONG PRE-CUT 322.5 1.29   7297   2036 18 1 1 0.0 0.0 250.0 _binary   70 1 0.0 _binary 322.5 10 1.29 18 2036     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
22     2023-03-29 13:13:18.109000 S/L 5/32"-119" LONG PRE-CUT 1488.0 3.72   7279   2017 19 1 1 0.0 0.0 400.0 _binary   70 1 0.0 _binary 1488.0 10 3.72 18 2017     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
23     2023-03-29 13:22:36.785000 Tissue Paper LG size, 140 per box 307.41 10.247   8046   7269 20 1 1 0.0 0.0 30.0 _binary   70 1 0.0 _binary 307.41 10 10.247 18 7269     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
25   2023-03-29 16:09:54.978000 2023-03-29 00:00:00.000000 S/L 5/32"-34" LONG PRE-CUT 2904.0 1.32   7308   2047 21 1 1 2200.0 0.0 2200.0 _binary   50 1 0.0 _binary 2904.0 10 1.32 18 2047     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
26   2023-09-14 00:00:00.000000 2023-03-14 00:00:00.000000 ILLUMINATION CONNECTOR, ENDOPROBES MACHINED 16203 9061.3 1.85   7208   16399 22 1 1 4924.0 0.0 4898.0 _binary   50 1 0.0 _binary 9061.3 10 1.85 18 16399     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
27   2024-01-07 13:36:51.891000 2023-03-29 16:11:44.360000 S/L 5/32"-29" LONG PRE-CUT 1320.0 1.32   7309   2048 23 1 1 1000.0 0.0 1000.0 _binary   60 1 0.0 _binary 1320.0 10 1.32 18 2048     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
28     2023-03-29 16:13:45.305000 Strain rellief band 530.0 5.3   7233   16430 24 1 1 0.0 0.0 100.0 _binary   70 1 0.0 _binary 530.0 10 5.3 18 16430     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
29   2023-03-29 00:00:00.000000 2023-03-29 16:22:49.397000 TEFLON WIRE(BLACK) 355.2 1.184   1882   10731 25 1 1 300.0 0.0 300.0 _binary   50 1 0.0 _binary 355.2 10 1.184 2 10731     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
30     2023-03-29 16:36:06.830000 CAP(.172 X 1/2" RED) 230.3 0.04439946   190   11459 26 1 1 0.0 0.0 5187.0 _binary   70 1 0.0 _binary 230.3 10 0.04439946 18 11459     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
32     2023-03-29 17:27:16.811000 Fiber Drawing Supply(Oven Element) 786.0 262.0   7834   7050 28 1 1 0.0 0.0 3.0 _binary A 70 1 0.0 _binary 786.0 10 262.0 18 7050     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
33     2023-03-29 17:30:59.263000 Tubing(0.071 X 0.095) 304 SS 125.0 2.5   8663   8036 29 1 1 0.0 0.0 50.0 _binary A 70 1 0.0 _binary 125.0 10 2.5 2 8036     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
34   2023-03-27 00:00:00.000000 2023-03-29 17:37:57.799000 BUSHING(CRESCENT) 10980.0 18.3   87   15946 30 1 1 600.0 0.0 600.0 _binary   50 1 0.0 _binary 10980.0 10 18.3 18 15946     {"4": {"name": "ID", "type": "Text", "value": ""}, "14": {"name": "Revision Level", "type": "Text", "value": ""}, "29": {"name": "Vendor Notes", "type": "Text"}}
35   2023-03-29 17:56:15.088000 2023-03-29 17:48:57.333000 ACMI ADAPTOR ETCHED & PASSIVATED 81.25 16.25   7083   16258 31 1 1 5.0 0.0 5.0 _binary A 50 1 0.0 _binary 81.25 10 16.25 18 16258     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
36   2023-03-29 17:56:15.119000 2023-03-29 17:48:57.333000 OLYMPUS ADAPTOR ETCHED & PASSIVATED 81.25 16.25   7086   16262 31 2 1 5.0 0.0 5.0 _binary A 50 1 0.0 _binary 81.25 10 16.25 18 16262     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
37   2023-03-29 17:56:15.166000 2023-03-29 17:48:57.333000 STORZ ADAPTOR ETCHED & PASSIVATED 81.25 16.25   7087   16263 31 3 1 5.0 0.0 5.0 _binary A 50 1 0.0 _binary 81.25 10 16.25 18 16263     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
38   2023-03-29 17:56:15.182000 2023-03-29 17:48:57.333000 WOLF ADAPTOR ETCHED & PASSIVATED 81.25 16.25   7088   16264 31 4 1 5.0 0.0 5.0 _binary A 50 1 0.0 _binary 81.25 10 16.25 18 16264     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
39     2023-03-29 18:21:12.135000 LABEL - LUMITEX 006967 BARCODE 0.0 0.0   7216   16407 32 1 1 0.0 0.0 63.0 _binary   70 1 0.0 _binary 0.0 10 0.0 18 16407     {"29": {"name": "Vendor Notes", "type": "Text"}}
40     2023-03-29 18:21:12.182000 BAG / BOX LABEL 012742 0.0 0.0   27563   16486 32 2 1 0.0 0.0 3.0 _binary   70 1 0.0 _binary 0.0 10 0.0 1 16486     {"29": {"name": "Vendor Notes", "type": "Text"}}
41     2023-03-29 18:21:12.198000 LABEL - LUMITEX 006966 BARCODE 0.0 0.0   7215   16406 32 3 1 0.0 0.0 63.0 _binary   70 1 0.0 _binary 0.0 10 0.0 18 16406     {"29": {"name": "Vendor Notes", "type": "Text"}}
42     2023-03-29 18:21:12.213000 LABEL - LUMITEX 006965 BARCODE 0.0 0.0   7214   16405 32 4 1 0.0 0.0 63.0 _binary   70 1 0.0 _binary 0.0 10 0.0 18 16405     {"29": {"name": "Vendor Notes", "type": "Text"}}
43     2023-03-29 18:21:12.229000 LABEL - LUMITEX 006964 BARCODE 0.0 0.0   7213   16404 32 5 1 0.0 0.0 63.0 _binary   70 1 0.0 _binary 0.0 10 0.0 18 16404     {"29": {"name": "Vendor Notes", "type": "Text"}}
44   2023-07-14 00:00:00.000000 2023-03-29 18:24:30.500000 BUSHING(.063 X .093) 3600.0 0.72   173   11528 33 1 1 5000.0 0.0 5000.0 _binary   50 1 0.0 _binary 3600.0 10 0.72 18 11528     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
45     2023-03-30 17:45:22.274000 EPOXY, EPOTEK MED-OD2002 629.45 629.45   97   7773 34 1 1 0.0 0.0 1.0 _binary   70 1 0.0 _binary 629.45 10 629.45 18 7773     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
47   2024-01-07 13:27:09.154000 2023-04-05 13:26:53.388000 COLLAR(THREADED 1/2-20) 2541.75 0.75   29   15567 36 1 1 3389.0 0.0 3389.0 _binary   60 1 0.0 _binary 2541.75 10 0.75 18 10364     {"4": {"name": "ID", "type": "Text", "value": ""}, "14": {"name": "Revision Level", "type": "Text", "value": ""}, "29": {"name": "Vendor Notes", "type": "Text"}}
48   2023-04-06 00:00:00.000000 2023-04-05 13:29:29.984000 SHELL FO, DISTAL FIBER, (PASSIVATED 15659-14) 20500.0 410.0   89   16204-17 37 1 1 50.0 0.0 50.0 _binary   50 1 0.0 _binary 20500.0 10 410.0 18 16204-17     {"4": {"name": "ID", "type": "Text", "value": ""}, "14": {"name": "Revision Level", "type": "Text", "value": ""}, "29": {"name": "Vendor Notes", "type": "Text"}}
49   2023-04-05 00:00:00.000000 2023-04-05 13:34:00.194000 MONOCOIL(.260 X .295)UNCOVERED ST. ST. 2030.0 2.03   7382   4038 38 1 1 1037.0 0.0 1000.0 _binary   50 1 0.0 _binary 2030.0 10 2.03 2 4038     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
50   2023-04-10 00:00:00.000000 2023-04-05 13:35:12.920000 STICKYMAT, GREY, 24" X 36" 26.53 0.221083333   8455   7708 39 1 1 120.0 0.0 120.0 _binary   50 1 0.0 _binary 26.53 10 0.221083333 18 7708     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
51   2023-04-06 00:00:00.000000 2023-04-05 13:48:46.752000 CARBIDE TURNING INSERT 3/8 SQUARE X 5/32THK 416.5 8.33   8492   7750 40 1 1 50.0 0.0 50.0 _binary   50 1 0.0 _binary 416.5 10 8.33 18 7750     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
52   2023-04-05 00:00:00.000000 2023-04-05 13:48:46.752000 TORX PLUS SCREW (M3.5 X .60) X 12mm LG 260.4 4.34   8493   7751 40 2 1 60.0 0.0 60.0 _binary   50 1 0.0 _binary 260.4 10 4.34 18 7751     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
53   2023-04-10 00:00:00.000000 2023-04-10 00:00:00.000000 QUARTZ FIBER(UV 200/220/245P22)HIGH OH 1550.0 1.55   7732   6026 41 1 1 1000.0 0.0 1000.0 _binary   50 1 0.0 _binary 1550.0 10 1.55 10 6026     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
54   2024-01-07 13:54:45.032000 2023-04-06 00:00:00.000000 Labeling Supply(Universal Paper Label) 471.57 0.02858   7844   7060 42 1 1 16500.0 0.0 16500.0 _binary   60 1 0.0 _binary 471.57 10 0.02858 18 7060     {"4": {"name": "ID", "type": "Text", "value": ""}, "14": {"name": "Revision Level", "type": "Text", "value": ""}, "29": {"name": "Vendor Notes", "type": "Text"}}
55   2023-04-12 00:00:00.000000 2023-03-15 00:00:00.000000 COLLAR (Solder / .128 O.D. Sheathing 772.5 3.09   1   11262 43 1 1 262.0 0.0 250.0 _binary D 50 1 0.0 _binary 772.5 10 3.09 18 11262     {"4": {"name": "ID", "type": "Text"}, "14": {"name": "Revision Level", "type": "Text"}, "29": {"name": "Vendor Notes", "type": "Text"}}
56   2023-03-22 00:00:00.000000 2023-03-15 00:00:00.000000 TUBE(.046 X .062 X .3 LONG)ST. ST. 544.0 2.72   3055   12008 43 2 1 210.0 0.0 200.0 _binary * 50 1 0.0 _binary 544.0 10 2.72 18 12008     {"4": {"name": "ID", "type": "Text", "value": ""}, "14": {"name": "Revision Level", "type": "Text", "value": ""}, "29": {"name": "Vendor Notes", "type": "Text"}}
57   2023-04-12 00:00:00.000000 2023-04-12 00:00:00.000000 ADAPTOR MOUNT(STORZ FEMALE 4.7MM) 187.5 7.5   3478   12490 44 1 1 25.0 0.0 25.0 _binary A 50 1 0.0 _binary 187.5 10 7.5 18 12490     {"4": {"name": "ID", "type": "Text", "value": ""}, "14": {"name": "Revision Level", "type": "Text", "value": ""}, "29": {"name": "Vendor Notes", "type": "Text"}}
58   2024-01-07 12:23:35.096000 2023-04-18 12:21:59.423000 ADAPTOR MOUNT(ACMI/WOLF FEMALE)4MM 660.0 3.3   5069   14205 45 1 1 200.0 0.0 200.0 _binary A 60 1 0.0 _binary 660.0 10 3.3 18 14205     {"4": {"name": "ID", "type": "Text", "value": ""}, "14": {"name": "Revision Level", "type": "Text", "value": "AAAB"}, "29": {"name": "Vendor Notes", "type": "Text"}}
59   2023-04-18 12:28:36.855000 2023-04-18 12:27:15.526000 END TIP(ACMI MALE - LONG) 775.0 7.75   4197   13271 46 1 1 100.0 0.0 100.0 _binary B 50 1 0.0 _binary 775.0 10 7.75 18 13271     {"4": {"name": "ID", "type": "Text", "value": ""}, "14": {"name": "Revision Level", "type": "Text", "value": ""}, "29": {"name": "Vendor Notes", "type": "Text"}}
61   2023-04-17 00:00:00.000000 2023-04-18 12:39:47.282000 Handle, G-Probe RFID 3400.0 3.4   6920   16047 48 1 1 1000.0 0.0 1000.0 _binary A 50 1 0.0 _binary 3400.0 10 3.4 18 16047     {"4": {"name": "ID", "type": "Text", "value": ""}, "14": {"name": "Revision Level", "type": "Text", "value": ""}, "29": {"name": "Vendor Notes", "type": "Text"}}

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "poitem" (
 "id" INTEGERNOT NULL ,
 "customerId" INTEGERDEFAULT NULL,
 "dateLastFulfillment" TEXT DEFAULT NULL,
 "dateScheduledFulfillment" TEXT NOT NULL,
 "description" TEXT DEFAULT NULL,
 "mcTotalCost" REAL DEFAULT NULL,
 "mcUnitCost" REAL DEFAULT NULL,
 "note" TEXT ,
 "partId" INTEGERDEFAULT NULL,
 "outsourcedPartId" INTEGERDEFAULT NULL,
 "partNum" TEXT NOT NULL,
 "poId" INTEGERNOT NULL,
 "poLineItem" INTEGERNOT NULL,
 "qbClassId" INTEGERDEFAULT NULL,
 "qtyFulfilled" REAL DEFAULT NULL,
 "qtyPicked" REAL DEFAULT NULL,
 "qtyToFulfill" REAL DEFAULT NULL,
 "repairFlag" INTEGER NOT NULL,
 "revLevel" TEXT DEFAULT NULL,
 "statusId" INTEGERNOT NULL,
 "taxId" INTEGERDEFAULT NULL,
 "taxRate" REAL NOT NULL,
 "tbdCostFlag" INTEGER NOT NULL,
 "totalCost" REAL DEFAULT NULL,
 "typeId" INTEGERNOT NULL,
 "unitCost" REAL DEFAULT NULL,
 "uomId" INTEGERDEFAULT NULL,
 "vendorPartNum" TEXT NOT NULL,
 "outsourcedPartNumber" TEXT NOT NULL,
 "outsourcedPartDescription" TEXT NOT NULL,
 "customFields" TEXT DEFAULT NULL,
 PRIMARY KEY ("id")
);