home / fishbowl_archive

📥 Export to Excel (CSV) ⚙ Advanced filters

moitem

167,157 rows

✎ View and edit SQL

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  

Next page

Advanced export

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

CSV options:

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")
);
Powered by Datasette · Queries took 2578.278ms