📥 Export to Excel (CSV) ⚙ Advanced filters

bomitem

79,044 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: bomItemGroupId, groupDefault, oneTimeItem, stage, typeId, uomId, variableQty

id ▼ addToService bomId bomItemGroupId description groupDefault maxQty minQty oneTimeItem partId priceAdjustment productId quantity sortIdConfig stage stageBomId typeId uomId useItemLocation variableQty customFields
4 _binary 2   Create 13299 _binary  0.0 0.0 _binary 4 0.0 -1 1.0 1 _binary -1 10 18 _binary _binary {}
5 _binary 2   Add Machine Shop Labor _binary  0.0 0.0 _binary 2 0.0 -1 15.0 2 _binary -1 20 35 _binary _binary {}
6 _binary 2   Add 11262 _binary  0.0 0.0 _binary 1 0.0 -1 1.0 1 _binary -1 20 18 _binary _binary {}
7 _binary 3   Create 12248 _binary  0.0 0.0 _binary 6 0.0 -1 1.0 1 _binary -1 10 18 _binary _binary {}
8 _binary 3   Add 8027 _binary  0.0 0.0 _binary 5 0.0 -1 0.112 1 _binary -1 20 2 _binary _binary {}
9 _binary 3   Add Machine Shop Labor _binary  0.0 0.0 _binary 2 0.0 -1 3.3 3 _binary -1 20 35 _binary _binary {}
10 _binary 3   Add 13299 _binary  0.0 0.0 _binary 4 0.0 -1 1.0 2 _binary  2 20 18 _binary _binary {}
26 _binary 8   Create AB2319 _binary  0.0 0.0 _binary 22 0.0 -1 1.0 1 _binary -1 10 1 _binary _binary {}
27 _binary 8   Add 10050 _binary  0.0 0.0 _binary 7 0.0 -1 2.0 3 _binary -1 20 18 _binary _binary {}
28 _binary 8   Add 10763-2 _binary  0.0 0.0 _binary 8 0.0 -1 1.0 1 _binary -1 20 18 _binary _binary {}
29 _binary 8   Add 10978 _binary  0.0 0.0 _binary 14 0.0 -1 1.0 2 _binary  113148 20 1 _binary _binary {}
30 _binary 8   Add 11467 _binary  0.0 0.0 _binary 21 0.0 -1 1.0 4 _binary -1 20 18 _binary _binary {}
31 _binary 8   Add 12248 _binary  0.0 0.0 _binary 6 0.0 -1 1.0 5 _binary -1 20 18 _binary _binary {}
32 _binary 8   Add 12252 _binary  0.0 0.0 _binary 16 0.0 -1 1.0 6 _binary  113312 20 18 _binary _binary {}
36 _binary 8   Add 4020 _binary  0.0 0.0 _binary 20 0.0 -1 3.8 7 _binary -1 20 2 _binary _binary {}
37 _binary 8   Add Assembly Labor _binary  0.0 0.0 _binary 23 0.0 -1 1.0 8 _binary -1 20 35 _binary _binary {}
38 _binary 8   Add Packaging Labor _binary  0.0 0.0 _binary 24 0.0 -1 1.0 9 _binary -1 20 35 _binary _binary {}
39 _binary 8   Add Quality Control Labor _binary  0.0 0.0 _binary 25 0.0 -1 1.0 10 _binary -1 20 35 _binary _binary {}
40 _binary 8   Add Labor - Polishing & Grinding _binary  0.0 0.0 _binary 81 0.0 -1 1.0 11 _binary -1 20 35 _binary _binary {}
43 _binary 9   Create 05961 _binary  0.0 0.0 _binary 79 0.0 -1 6.0 1 _binary -1 10 1 _binary _binary {}
44 _binary 9   Add 15564 _binary  0.0 0.0 _binary 28 0.0 -1 6.0 1 _binary -1 20 18 _binary _binary {}
45 _binary 9   Add 15567 _binary  0.0 0.0 _binary 29 0.0 -1 6.0 2 _binary -1 20 18 _binary _binary {}
46 _binary 9   Add 15667-1 _binary  0.0 0.0 _binary 30 0.0 -1 6.0 3 _binary -1 20 18 _binary _binary {}
47 _binary 9   Add 15672 _binary  0.0 0.0 _binary 31 0.0 -1 6.0 4 _binary -1 20 18 _binary _binary {}
48 _binary 9   Add 15673 _binary  0.0 0.0 _binary 32 0.0 -1 6.0 5 _binary -1 20 18 _binary _binary {}
49 _binary 9   Add 15674 _binary  0.0 0.0 _binary 33 0.0 -1 6.0 6 _binary -1 20 18 _binary _binary {}
50 _binary 9   Add 15675 _binary  0.0 0.0 _binary 34 0.0 -1 6.0 7 _binary -1 20 18 _binary _binary {}
51 _binary 9   Add 15677 _binary  0.0 0.0 _binary 35 0.0 -1 6.0 8 _binary -1 20 18 _binary _binary {}
52 _binary 9   Add 15678 _binary  0.0 0.0 _binary 36 0.0 -1 6.0 9 _binary -1 20 18 _binary _binary {}
56 _binary 9   Add 15747 _binary  0.0 0.0 _binary 40 0.0 -1 6.0 10 _binary  114121 20 18 _binary _binary {}
57 _binary 9   Add 16108 _binary  0.0 0.0 _binary 41 0.0 -1 6.0 11 _binary -1 20 18 _binary _binary {}
58 _binary 9   Add 16109 _binary  0.0 0.0 _binary 42 0.0 -1 6.0 12 _binary -1 20 18 _binary _binary {}
59 _binary 9   Add 16111 _binary  0.0 0.0 _binary 44 0.0 -1 1.0 14 _binary -1 20 18 _binary _binary {}
60 _binary 9   Add 16112 _binary  0.0 0.0 _binary 45 0.0 -1 6.0 15 _binary -1 20 18 _binary _binary {}
61 _binary 9   Add 16113 _binary  0.0 0.0 _binary 46 0.0 -1 6.0 16 _binary -1 20 18 _binary _binary {}
62 _binary 9   Add 16114 _binary  0.0 0.0 _binary 47 0.0 -1 1.0 17 _binary -1 20 18 _binary _binary {}
64 _binary 9   Add 16131 _binary  0.0 0.0 _binary 49 0.0 -1 1.0 18 _binary  108459 20 18 _binary _binary {}
65 _binary 9   Add 16134 _binary  0.0 0.0 _binary 50 0.0 -1 0.125 19 _binary  108460 20 18 _binary _binary {}
66 _binary 9   Add 16141 _binary  0.0 0.0 _binary 51 0.0 -1 6.0 20 _binary  108461 20 18 _binary _binary {}
67 _binary 9   Add 16145 _binary  0.0 0.0 _binary 52 0.0 -1 1.0 21 _binary  108462 20 18 _binary _binary {}
74 _binary 9   Add 16110 _binary  0.0 0.0 _binary 43 0.0 -1 0.13 13 _binary -1 20 18 _binary _binary {}
75 _binary 9   Add 16332 _binary  0.0 0.0 _binary 53 0.0 -1 12.0 22 _binary  108447 20 2 _binary _binary {}
76 _binary 9   Add 5285 _binary  0.0 0.0 _binary 54 0.0 -1 0.375 23 _binary -1 20 2 _binary _binary {}
77 _binary 9   Add 5306 _binary  0.0 0.0 _binary 55 0.0 -1 0.24 24 _binary -1 20 2 _binary _binary {}
78 _binary 9   Add 6074 _binary  0.0 0.0 _binary 56 0.0 -1 16.2 25 _binary -1 20 2 _binary _binary {}
83 _binary 9   Add 7684 _binary  0.0 0.0 _binary 80 0.0 -1 1.0 26 _binary -1 20 18 _binary _binary {}
84 _binary 9   Add Labor - Quality Control _binary  0.0 0.0 _binary 25 0.0 -1 19.0 34 _binary -1 20 35 _binary _binary {}
90 _binary 9   Add Labor - Assembly _binary  0.0 0.0 _binary 23 0.0 -1 155.0 31 _binary -1 20 35 _binary _binary {}
98 _binary 9   Add Labor - G&P _binary  0.0 0.0 _binary 81 0.0 -1 24.0 33 _binary -1 20 35 _binary _binary {}
451 _binary 15   Create 06040 _binary  0.0 0.0 _binary 98 0.0 -1 1.0 1 _binary -1 10 1 _binary _binary {}

Next page

Advanced export

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

CSV options: 

CREATE TABLE "bomitem" (
 "id" INTEGERNOT NULL ,
 "addToService" INTEGER NOT NULL,
 "bomId" INTEGERNOT NULL,
 "bomItemGroupId" INTEGERDEFAULT NULL,
 "description" TEXT NOT NULL,
 "groupDefault" INTEGER NOT NULL,
 "maxQty" REAL DEFAULT NULL,
 "minQty" REAL DEFAULT NULL,
 "oneTimeItem" INTEGER NOT NULL,
 "partId" INTEGERDEFAULT NULL,
 "priceAdjustment" REAL DEFAULT NULL,
 "productId" INTEGERDEFAULT NULL,
 "quantity" REAL NOT NULL,
 "sortIdConfig" INTEGERNOT NULL,
 "stage" INTEGER NOT NULL,
 "stageBomId" INTEGERDEFAULT NULL,
 "typeId" INTEGERNOT NULL,
 "uomId" INTEGERDEFAULT NULL,
 "useItemLocation" INTEGER NOT NULL,
 "variableQty" INTEGER NOT NULL,
 "customFields" TEXT DEFAULT NULL,
 PRIMARY KEY ("id")
);