moitem
167,157 rows
This data as json, CSV (advanced)
Suggested facets: priorityId, stageLevel, statusId, typeId, uomId, calCategoryId, dateScheduled (date), dateScheduledToStart (date)
| id ▼ | addToService | bomId | bomItemId | dateScheduled | dateScheduledToStart | description | instructionNote | moId | oneTimeItem | parentId | partId | priceAdjustment | priorityId | qbClassId | qtyFulfilled | qtyToFulfill | soItemId | sortIdInstruct | stage | stageLevel | statusId | totalCost | typeId | uomId | calCategoryId |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44 | _binary | 9 | 2023-02-02 12:46:00.000000 | 2023-02-02 12:16:00.000000 | 05961 - 25-27G BRITE LIGHT 20 DEG ANGLE (6) | 3 | _binary | 0.0 | 30 | 1 | 16.0 | 16.0 | 1 | _binary | 1 | 50 | 0.0 | 50 | |||||||
| 45 | _binary | 9 | 43 | Create 05961 | 3 | _binary | 44 | 79 | 0.0 | 1 | 96.0 | 96.0 | 1 | _binary | 1 | 50 | 0.0 | 10 | 1 | ||||||
| 46 | _binary | 9 | 44 | Add 15564 | 3 | _binary | 44 | 28 | 0.0 | 1 | 0.0 | 96.0 | 2 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 47 | _binary | D10463 - Rev:B - DOCUMENT(C OF C) FRM | 3 | _binary | 44 | 0.0 | 1 | 0.0 | 0.0 | 3 | _binary | 1 | 50 | 0.0 | 40 | ||||||||||
| 48 | _binary | 9 | 45 | Add 15567 | 3 | _binary | 44 | 29 | 0.0 | 1 | 0.0 | 96.0 | 4 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 49 | _binary | D10628 - Rev:B - Iridex Grinding Programs Log | 3 | _binary | 44 | 0.0 | 1 | 0.0 | 0.0 | 5 | _binary | 1 | 50 | 0.0 | 40 | ||||||||||
| 50 | _binary | 9 | 46 | Add 15667-1 | 3 | _binary | 44 | 30 | 0.0 | 1 | 0.0 | 96.0 | 6 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 51 | _binary | D10777 - Rev:A - DOCUMENT(LINE CLEARANCE PROCESS) WI | 3 | _binary | 44 | 0.0 | 1 | 0.0 | 0.0 | 7 | _binary | 1 | 50 | 0.0 | 40 | ||||||||||
| 52 | _binary | 9 | 47 | Add 15672 | 3 | _binary | 44 | 31 | 0.0 | 1 | 0.0 | 96.0 | 8 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 53 | _binary | D10782 - Rev:A - OPERATION PROCEDURE FOR BENDING FIXTURE T0853 25-27 G PROBE (20 DEGREE) | 3 | _binary | 44 | 0.0 | 1 | 0.0 | 0.0 | 9 | _binary | 1 | 50 | 0.0 | 40 | ||||||||||
| 54 | _binary | 9 | 48 | Add 15673 | 3 | _binary | 44 | 32 | 0.0 | 1 | 0.0 | 96.0 | 10 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 55 | _binary | D10802 - Rev:AV - DOCUMENT(TIP 13892)PROBE TEST PROCEDURE | 3 | _binary | 44 | 0.0 | 1 | 0.0 | 0.0 | 11 | _binary | 1 | 50 | 0.0 | 40 | ||||||||||
| 56 | _binary | 9 | 49 | Add 15674 | 3 | _binary | 44 | 33 | 0.0 | 1 | 0.0 | 96.0 | 12 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 57 | _binary | D10839 - Rev:A - DOCUMENT(POUCH SEALING INSPECTION) WI | 3 | _binary | 44 | 0.0 | 1 | 0.0 | 0.0 | 13 | _binary | 1 | 50 | 0.0 | 40 | ||||||||||
| 58 | _binary | 9 | 50 | Add 15675 | 3 | _binary | 44 | 34 | 0.0 | 1 | 0.0 | 96.0 | 14 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 59 | _binary | D10842 - Rev:A - DOCUMENT(POUCH SEAL TESTER OPERATION) WI | 3 | _binary | 44 | 0.0 | 1 | 0.0 | 0.0 | 15 | _binary | 1 | 50 | 0.0 | 40 | ||||||||||
| 60 | _binary | 9 | 51 | Add 15677 | 3 | _binary | 44 | 35 | 0.0 | 1 | 0.0 | 96.0 | 16 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 61 | _binary | D10843 - Rev:A - DOCUMENT(POUCH SEALER OPERATION) WI | 3 | _binary | 44 | 0.0 | 1 | 0.0 | 0.0 | 17 | _binary | 1 | 50 | 0.0 | 40 | ||||||||||
| 62 | _binary | 9 | 52 | Add 15678 | 3 | _binary | 44 | 36 | 0.0 | 1 | 0.0 | 96.0 | 18 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 63 | _binary | D10866 - Rev:A - DOCUMENT(CLEANING & POUCHING) WI | 3 | _binary | 44 | 0.0 | 1 | 0.0 | 0.0 | 19 | _binary | 1 | 50 | 0.0 | 40 | ||||||||||
| 64 | _binary | Add 15679 | 3 | _binary | 44 | 37 | 0.0 | 1 | 0.8 | 0.8 | 20 | _binary | 1 | 50 | 0.0 | 20 | 6 | ||||||||
| 65 | _binary | D10867 - Rev:A - DOCUMENT(DRAWING 14559)PACK DETAIL | 3 | _binary | 44 | 0.0 | 1 | 0.0 | 0.0 | 21 | _binary | 1 | 50 | 0.0 | 40 | ||||||||||
| 66 | _binary | Add 15681 | 3 | _binary | 44 | 38 | 0.0 | 1 | 0.0 | 0.8 | 22 | _binary | 1 | 50 | 0.0 | 20 | 6 | ||||||||
| 67 | _binary | D10869 - Rev:AN - DOCUMENT(MIP 12955)LABELING WI | 3 | _binary | 44 | 0.0 | 1 | 0.0 | 0.0 | 23 | _binary | 1 | 50 | 0.0 | 40 | ||||||||||
| 68 | _binary | Add 15701 | 3 | _binary | 44 | 39 | 0.0 | 1 | 0.0 | 160.0 | 24 | _binary | 1 | 50 | 0.0 | 20 | 12 | ||||||||
| 69 | _binary | D10897 - Rev:A - DOCUMENT(LABELING & BOXING) WI | 3 | _binary | 44 | 0.0 | 1 | 0.0 | 0.0 | 25 | _binary | 1 | 50 | 0.0 | 40 | ||||||||||
| 70 | _binary | 9 | 56 | Add 15747 | 3 | _binary | 44 | 40 | 0.0 | 1 | 0.0 | 96.0 | 26 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 71 | _binary | D10898 - Rev:A - DOCUMENT(DHR PACKAGE) | 3 | _binary | 44 | 0.0 | 1 | 0.0 | 0.0 | 27 | _binary | 1 | 50 | 0.0 | 40 | ||||||||||
| 72 | _binary | 9 | 57 | Add 16108 | 3 | _binary | 44 | 41 | 0.0 | 1 | 0.0 | 96.0 | 28 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 73 | _binary | D10899 - Rev:B - DOCUMENT(14558 25-27GA CABLE)DRAWING | 3 | _binary | 44 | 0.0 | 1 | 0.0 | 0.0 | 29 | _binary | 1 | 50 | 0.0 | 40 | ||||||||||
| 74 | _binary | 9 | 58 | Add 16109 | 3 | _binary | 44 | 42 | 0.0 | 1 | 0.0 | 96.0 | 30 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 75 | _binary | D10908 - Rev:A - DOCUMENT(ILL ENDOPROBE ASSY)WI | 3 | _binary | 44 | 0.0 | 1 | 0.0 | 0.0 | 31 | _binary | 1 | 50 | 0.0 | 40 | ||||||||||
| 76 | _binary | 9 | 74 | Add 16110 | 3 | _binary | 44 | 43 | 0.0 | 1 | 0.0 | 2.08 | 32 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 77 | _binary | F1348 - Rev:A - RF.002NA.66(1.0)/.012 X 25' | 3 | _binary | 44 | 0.0 | 1 | 0.0 | 0.0 | 33 | _binary | 1 | 50 | 0.0 | 40 | ||||||||||
| 78 | _binary | 9 | 59 | Add 16111 | 3 | _binary | 44 | 44 | 0.0 | 1 | 0.0 | 16.0 | 34 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 79 | _binary | T0853 - Rev:A - NEEDLE BENDING FIXTURE, "RED" | 3 | _binary | 44 | 0.0 | 1 | 0.0 | 0.0 | 35 | _binary | 1 | 50 | 0.0 | 40 | ||||||||||
| 80 | _binary | 9 | 60 | Add 16112 | 3 | _binary | 44 | 45 | 0.0 | 1 | 0.0 | 96.0 | 36 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 81 | _binary | 9 | 61 | Add 16113 | 3 | _binary | 44 | 46 | 0.0 | 1 | 0.0 | 96.0 | 37 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 82 | _binary | 9 | 62 | Add 16114 | 3 | _binary | 44 | 47 | 0.0 | 1 | 0.0 | 16.0 | 38 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 83 | _binary | Add 16127 | 3 | _binary | 44 | 48 | 0.0 | 1 | 0.0 | 32.0 | 39 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||||
| 84 | _binary | 9 | 64 | Add 16131 | 3 | _binary | 44 | 49 | 0.0 | 1 | 0.0 | 16.0 | 40 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 85 | _binary | 9 | 65 | Add 16134 | 3 | _binary | 44 | 50 | 0.0 | 1 | 0.0 | 2.08 | 41 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 86 | _binary | 9 | 66 | Add 16141 | 3 | _binary | 44 | 51 | 0.0 | 1 | 0.0 | 96.0 | 42 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 87 | _binary | 9 | 67 | Add 16145 | 3 | _binary | 44 | 52 | 0.0 | 1 | 0.0 | 16.0 | 43 | _binary | 1 | 50 | 0.0 | 20 | 18 | ||||||
| 88 | _binary | 9 | 75 | Add 16332 | 3 | _binary | 44 | 53 | 0.0 | 1 | 0.0 | 192.0 | 44 | _binary | 1 | 50 | 0.0 | 20 | 2 | ||||||
| 89 | _binary | 9 | 76 | Add 5285 | 3 | _binary | 44 | 54 | 0.0 | 1 | 0.0 | 5.76 | 45 | _binary | 1 | 50 | 0.0 | 20 | 2 | ||||||
| 90 | _binary | 9 | 77 | Add 5306 | 3 | _binary | 44 | 55 | 0.0 | 1 | 0.0 | 3.84 | 46 | _binary | 1 | 50 | 0.0 | 20 | 2 | ||||||
| 91 | _binary | 9 | 78 | Add 6074 | 3 | _binary | 44 | 56 | 0.0 | 1 | 0.0 | 259.2 | 47 | _binary | 1 | 50 | 0.0 | 20 | 2 | ||||||
| 92 | _binary | Add 7382 | 3 | _binary | 44 | 57 | 0.0 | 1 | 0.0 | 0.16 | 48 | _binary | 1 | 50 | 0.0 | 20 | 6 | ||||||||
| 93 | _binary | Add 7490 | 3 | _binary | 44 | 58 | 0.0 | 1 | 0.0 | 0.16 | 49 | _binary | 1 | 50 | 0.0 | 20 | 6 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "moitem" (
"id" INTEGERNOT NULL ,
"addToService" INTEGER NOT NULL,
"bomId" INTEGERDEFAULT NULL,
"bomItemId" INTEGERDEFAULT NULL,
"dateScheduled" TEXT DEFAULT NULL,
"dateScheduledToStart" TEXT DEFAULT NULL,
"description" TEXT NOT NULL,
"instructionNote" TEXT ,
"moId" INTEGERDEFAULT NULL,
"oneTimeItem" INTEGER NOT NULL,
"parentId" INTEGERDEFAULT NULL,
"partId" INTEGERDEFAULT NULL,
"priceAdjustment" REAL DEFAULT NULL,
"priorityId" INTEGERDEFAULT NULL,
"qbClassId" INTEGERDEFAULT NULL,
"qtyFulfilled" REAL DEFAULT NULL,
"qtyToFulfill" REAL DEFAULT NULL,
"soItemId" INTEGERDEFAULT NULL,
"sortIdInstruct" INTEGERNOT NULL,
"stage" INTEGER NOT NULL,
"stageLevel" INTEGERDEFAULT NULL,
"statusId" INTEGERNOT NULL,
"totalCost" REAL DEFAULT NULL,
"typeId" INTEGERNOT NULL,
"uomId" INTEGERDEFAULT NULL,
"calCategoryId" INTEGERDEFAULT NULL,
PRIMARY KEY ("id")
);