location
569 rows
This data as json, CSV (advanced)
Suggested facets: activeFlag, countedAsAvailable, defaultCustomerId, defaultFlag, locationGroupId, pickable, receivable, typeId, dateLastModified (date)
| id ▼ | activeFlag | countedAsAvailable | dateLastModified | defaultCustomerId | defaultFlag | defaultVendorId | description | locationGroupId | name | parentId | pickable | receivable | sortOrder | typeId | customFields |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | _binary | _binary | 2023-06-22 08:58:16.713000 | _binary | The default stock location. | 1 | Stock | _binary | _binary | 10000 | 10 | {} | |||
| 2 | _binary | _binary | 2023-06-22 08:58:16.713000 | _binary | The staging area for shipping. | 1 | Shipping | _binary | _binary | 10001 | 20 | {} | |||
| 3 | _binary | _binary | 2023-06-22 08:58:16.713000 | _binary | The staging area for receiving. | 1 | Receiving | _binary | _binary | 10002 | 30 | {} | |||
| 4 | _binary | _binary | 2024-10-16 14:18:52.643000 | _binary | To be inspected | 1 | Incoming Inspection | _binary | _binary | 10003 | 30 | {} | |||
| 5 | _binary | _binary | 2023-06-22 08:58:16.728000 | _binary | Machine shop area | 1 | Machine Shop | _binary | _binary | 10004 | 80 | {} | |||
| 6 | _binary | _binary | 2023-06-22 08:58:16.728000 | _binary | QC Area | 1 | Quality Control | _binary | _binary | 10005 | 50 | {} | |||
| 7 | _binary | _binary | 2023-06-22 08:58:16.728000 | _binary | Grinding and Polishing | 1 | Grinding & Polishing | _binary | _binary | 10006 | 80 | {} | |||
| 8 | _binary | _binary | 2023-06-22 08:58:16.728000 | _binary | Finished Goods | 1 | FG | _binary | _binary | 10007 | 10 | {} | |||
| 9 | _binary | _binary | 2024-02-28 11:19:36.711000 | _binary | Engineering | 1 | ENG | _binary | _binary | 10008 | 10 | {} | |||
| 10 | _binary | _binary | 2023-06-22 08:58:16.728000 | _binary | Obsolete | 1 | obs | _binary | _binary | 10009 | 10 | {} | |||
| 11 | _binary | _binary | 2023-06-22 08:58:16.728000 | _binary | Packaging | 1 | PAK | _binary | _binary | 10010 | 10 | {} | |||
| 12 | _binary | _binary | 2023-06-22 08:58:16.728000 | _binary | Plastic | 1 | PLS | _binary | _binary | 10011 | 10 | {} | |||
| 13 | _binary | _binary | 2023-06-22 08:58:16.728000 | _binary | Quartz | 1 | QTZ | _binary | _binary | 10012 | 10 | {} | |||
| 14 | _binary | _binary | 2025-12-17 07:47:16.210000 | 48 | _binary | Reinhausen point of use inventory. Inventory is combined with soldering station nearby. | 1 | REI | _binary | _binary | 10010 | 10 | {} | ||
| 15 | _binary | _binary | 2024-06-12 09:28:45.728000 | 14 | _binary | Sick 5 Branch | 1 | 5BR | _binary | _binary | 10011 | 10 | {} | ||
| 16 | _binary | _binary | 2023-06-22 08:58:16.776000 | 43 | _binary | Nova | 1 | NOV | _binary | _binary | 10034 | 10 | {} | ||
| 17 | _binary | _binary | 2023-06-22 08:58:16.776000 | _binary | Clean Room | 1 | CR | _binary | _binary | 10035 | 10 | {} | |||
| 18 | _binary | _binary | 2023-06-22 08:58:16.776000 | 10 | _binary | Iridex | 1 | IRX | _binary | _binary | 10036 | 10 | {} | ||
| 19 | _binary | _binary | 2024-06-12 12:22:07.808000 | 12 | _binary | Intuitive Surgical point of use inventory. Inventory is scattered throughout flowline. If material needs to be brought to this location, alert one of the operators that you have material for them and they will put it away for you. | 1 | ISI | _binary | _binary | 10037 | 10 | {} | ||
| 20 | _binary | _binary | 2024-05-02 12:37:17.148000 | 10 | _binary | Iridex parts that are pre-bagged and ready for use. Located in the Inventory Cage on its own shelf. Used in the MP3 assembly. | 1 | MP3 | _binary | _binary | 10038 | 10 | {} | ||
| 21 | _binary | _binary | 2024-06-12 12:08:51.710000 | _binary | MSC Direct | 1 | MSC | _binary | _binary | 10039 | 10 | {} | |||
| 22 | _binary | _binary | 2024-06-12 11:45:19.618000 | _binary | Inventory Cage | 1 | A1 | _binary | _binary | 10018 | 10 | {} | |||
| 23 | _binary | _binary | 2023-06-22 08:58:16.776000 | 10 | _binary | Iridex provided material | 1 | Iridex | _binary | _binary | 10040 | 110 | {} | ||
| 24 | _binary | _binary | 2023-06-22 08:58:16.776000 | 9 | _binary | Location for Lumitex owned Inventory | 1 | Lumitex | _binary | _binary | 10041 | 110 | {} | ||
| 25 | _binary | _binary | 2024-06-12 12:22:20.017000 | 12 | _binary | ISI Inventory | 1 | Intuitive Surgical | _binary | _binary | 10042 | 110 | {} | ||
| 26 | _binary | _binary | 2023-06-22 08:58:16.776000 | _binary | This is the location where materials will be placed while being assembled | 1 | WiP | _binary | _binary | 10043 | 80 | {} | |||
| 27 | _binary | _binary | 2023-06-22 08:58:16.792000 | _binary | Product final inspection location | 1 | Final Inspection | _binary | _binary | 10044 | 50 | {} | |||
| 28 | _binary | _binary | 2024-10-16 12:39:15.022000 | _binary | Table locations for fiber | 1 | Fiber | _binary | _binary | 10045 | 10 | {} | |||
| 29 | _binary | _binary | 2024-06-12 11:44:41.967000 | _binary | Inventory Cage | 1 | A3 | _binary | _binary | 10025 | 10 | {} | |||
| 76 | _binary | _binary | 2024-06-12 11:49:45.135000 | 5 | _binary | CEMAS Point of Use Inventory Rack | 1 | CEMAS | _binary | _binary | 10013 | 10 | {} | ||
| 77 | _binary | _binary | 2024-06-13 14:56:49.735000 | _binary | Cemas Line | 1 | CEM.2 | _binary | _binary | 10014 | 10 | {} | |||
| 78 | _binary | _binary | 2024-06-13 14:57:17.101000 | _binary | Cemas Line | 1 | CEM.3 | _binary | _binary | 10015 | 10 | {} | |||
| 79 | _binary | _binary | 2024-06-13 14:57:27.295000 | _binary | Cemas Line | 1 | CEM.4 | _binary | _binary | 10016 | 10 | {} | |||
| 80 | _binary | _binary | 2024-06-13 14:57:39.015000 | _binary | Cemas Line | 1 | CEM.5 | _binary | _binary | 10017 | 10 | {} | |||
| 81 | _binary | _binary | 2024-06-13 14:57:45.247000 | _binary | Cemas Line | 1 | CEM.6 | _binary | _binary | 10018 | 10 | {} | |||
| 82 | _binary | _binary | 2024-06-12 13:25:24.124000 | _binary | Reinhausen Line | 1 | REI.1 | _binary | _binary | 10019 | 10 | {} | |||
| 83 | _binary | _binary | 2024-06-12 13:25:27.856000 | _binary | Reinhausen Line | 1 | REI.2 | _binary | _binary | 10020 | 10 | {} | |||
| 84 | _binary | _binary | 2024-06-12 13:25:33.474000 | _binary | Reinhausen Line | 1 | REI.3 | _binary | _binary | 10021 | 10 | {} | |||
| 85 | _binary | _binary | 2024-06-12 13:25:37.862000 | _binary | Reinhausen Line | 1 | REI.4 | _binary | _binary | 10022 | 10 | {} | |||
| 86 | _binary | _binary | 2024-06-12 13:25:42.715000 | _binary | Reinhausen Line | 1 | REI.5 | _binary | _binary | 10023 | 10 | {} | |||
| 87 | _binary | _binary | 2024-06-12 13:25:47.839000 | _binary | Reinhausen Line | 1 | REI.6 | _binary | _binary | 10024 | 10 | {} | |||
| 88 | _binary | _binary | 2024-06-12 13:25:53.646000 | _binary | Reinhausen Line | 1 | REI.7 | _binary | _binary | 10025 | 10 | {} | |||
| 89 | _binary | _binary | 2024-06-12 09:14:56.749000 | _binary | 5 branch | 1 | 5BR.1 | _binary | _binary | 10026 | 10 | {} | |||
| 90 | _binary | _binary | 2024-06-12 09:29:11.577000 | _binary | 5 branch | 1 | 5BR.2 | _binary | _binary | 10027 | 10 | {} | |||
| 91 | _binary | _binary | 2024-06-12 09:29:14.531000 | _binary | 5 branch | 1 | 5BR.3 | _binary | _binary | 10028 | 10 | {} | |||
| 92 | _binary | _binary | 2024-06-12 09:28:15.232000 | _binary | 5 branch | 1 | 5BR.4 | _binary | _binary | 10029 | 10 | {} | |||
| 93 | _binary | _binary | 2024-06-12 09:29:20.667000 | _binary | 5 branch | 1 | 5BR.5 | _binary | _binary | 10030 | 10 | {} | |||
| 94 | _binary | _binary | 2024-06-12 09:29:29.921000 | _binary | 5 branch | 1 | 5BR.6 | _binary | _binary | 10031 | 10 | {} | |||
| 95 | _binary | _binary | 2024-06-12 09:29:34.693000 | _binary | 5 branch | 1 | 5BR.7 | _binary | _binary | 10032 | 10 | {} | |||
| 96 | _binary | _binary | 2024-06-12 09:29:38.342000 | _binary | 5 branch | 1 | 5BR.8 | _binary | _binary | 10033 | 10 | {} |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "location" (
"id" INTEGERNOT NULL ,
"activeFlag" INTEGER NOT NULL,
"countedAsAvailable" INTEGER NOT NULL,
"dateLastModified" TEXT DEFAULT NULL,
"defaultCustomerId" INTEGERDEFAULT NULL,
"defaultFlag" INTEGER NOT NULL,
"defaultVendorId" INTEGERDEFAULT NULL,
"description" TEXT DEFAULT NULL,
"locationGroupId" INTEGERNOT NULL,
"name" TEXT NOT NULL,
"parentId" INTEGERDEFAULT NULL,
"pickable" INTEGER NOT NULL,
"receivable" INTEGER NOT NULL,
"sortOrder" INTEGERDEFAULT NULL,
"typeId" INTEGERNOT NULL,
"customFields" TEXT DEFAULT NULL,
PRIMARY KEY ("id")
);