customer
45 rows where activeFlag = "_binary " and statusId = 10 sorted by dateLastModified descending
This data as json, CSV (advanced)
Suggested facets: carrierServiceId, defaultCarrierId, defaultPaymentTermsId, defaultSalesmanId, defaultShipTermsId, lastChangedUser, note, taxExempt, toBePrinted, dateCreated (date), dateLastModified (date)
| id | accountId | accountingHash | accountingId | activeFlag | carrierServiceId | creditLimit | currencyId | currencyRate | dateCreated | dateLastModified ▲ | defaultCarrierId | defaultPaymentTermsId | defaultPriorityId | defaultSalesmanId | defaultShipTermsId | jobDepth | lastChangedUser | name | note | number | parentId | qbClassId | statusId | sysUserId | taxExempt | taxExemptNumber | taxRateId | toBeEmailed | toBePrinted | url | issuableStatusId | customFields |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 90 | 684 | _binary | 16 | 0.0 | 0.0 | 2026-04-27 09:31:35.555000 | 2026-04-27 09:53:37.128000 | 4 | 4 | 60 | 10 | 1 | twilliston | Ferguson Industrial | 69 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 12 | 16 | _binary | 0.0 | 0.0 | 2023-01-25 17:55:46.542000 | 2026-04-24 14:48:16.215000 | 3 | 4 | 30 | 1 | LWallace | Intuitive Surgical, Inc. | Waiting for report from Made to Measure LW 4-22-2026 | 16 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 82 | 645 | _binary | 0.0 | 0.0 | 2025-04-08 10:22:22.514000 | 2026-03-19 14:02:43.530000 | 4 | 38 | 10 | 1 | twilliston | General Aesthetic Manufacturing | 645 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||||
| 89 | 677 | _binary | 0.0 | 0.0 | 2026-03-16 15:42:42.245000 | 2026-03-16 15:42:42.294000 | 1 | 60 | 10 | 1 | twilliston | Myriad Fiber Imaging | 68 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||||
| 9 | 13 | _binary | 0.0 | 0.0 | 2023-01-25 19:21:26.683000 | 2026-03-05 08:56:40.284000 | 4 | 4 | 41 | 1 | EReed | Lumitex, Inc. | Fedex Account: 107322418 | 13 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 68 | 616 | _binary | 0.0 | 0.0 | 2024-06-19 17:10:56.416000 | 2026-02-18 17:08:16.982000 | 1 | 10 | 1 | lthibodeau | Althea Nederland B.V. | 616 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||||
| 49 | 53 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 22:32:37.104000 | 2026-02-13 16:50:26.191000 | 3 | 4 | 10 | 1 | LWallace | Openwater | See Lorri Shipping Procedure needs to be created while shipping. Shipped 4 samples 2/13/2026 need approval before shipping production product. | 53 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 5 | 9 | _binary | 0.0 | 0.0 | 2023-01-25 18:31:13.173000 | 2026-01-20 15:14:20.260000 | 3 | 4 | 10 | 1 | LWallace | CEMAS ELETTRA SRL | See Lorri, Shippping procedure needs to be created while shipping. | 9 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 88 | 673 | _binary | 0.0 | 0.0 | 2025-12-24 10:57:43.387000 | 2026-01-05 17:09:38.190000 | 1 | 60 | 10 | 1 | lthibodeau | NTX Neurotherapeutics, Inc. | 67 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||||
| 3 | 7 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 15:36:27.491000 | 2025-12-29 13:05:03.885000 | 3 | 4 | 30 | 1 | twilliston | Acclarent, Inc | 7 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 31 | 35 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 20:19:51.418000 | 2025-12-11 08:42:01.810000 | 3 | 4 | 10 | 1 | twilliston | TSI Solutions | 35 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 48 | 52 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 22:24:36.989000 | 2025-12-11 08:41:37.116000 | 3 | 4 | 30 | 1 | twilliston | Reinhausen Manufacturing, Inc. | Do not ship early unless approved by sales | 52 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 43 | 47 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 21:56:21.384000 | 2025-12-11 08:41:17.145000 | 3 | 4 | 10 | 1 | twilliston | Nova Biomedical Corp. | 47 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 30 | 34 | _binary | 0.0 | 0.0 | 2023-01-25 20:14:27.919000 | 2025-12-11 08:41:12.308000 | 3 | 4 | 10 | 1 | twilliston | Norlase | 34 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||||
| 34 | 38 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 20:34:34.135000 | 2025-12-11 08:41:06.958000 | 3 | 4 | 30 | 1 | twilliston | Nexus CMF | 38 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 10 | 14 | _binary | 0.0 | 0.0 | 2023-01-25 19:28:52.709000 | 2025-12-11 08:40:44.559000 | 4 | 4 | 30 | 1 | twilliston | Iridex Corporation | 14 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||||
| 86 | 664 | _binary | 3 | 0.0 | 0.0 | 2025-09-24 12:19:22.349000 | 2025-12-11 08:40:29.391000 | 3 | 4 | 30 | 1 | twilliston | Inter-Med, Inc/Vista Dental Products | 65 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 11 | 15 | _binary | 0.0 | 0.0 | 2023-01-25 19:33:36.113000 | 2025-12-11 08:40:12.619000 | 4 | 30 | 1 | twilliston | Fiberoptic Systems, Inc. | 15 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||||
| 4 | 8 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 18:14:05.696000 | 2025-12-11 08:39:55.441000 | 3 | 4 | 30 | 1 | twilliston | Agilent Technologies, Inc. | 8 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 14 | 18 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 18:29:50.048000 | 2025-12-03 14:18:21.118000 | 3 | 4 | 9 | 20 | 1 | twilliston | SICK Prod. Center Americas, LLC | 18 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 87 | 669 | _binary | 3 | 0.0 | 0.0 | 2025-11-20 09:02:31.270000 | 2025-11-20 09:03:39.174000 | 3 | 1 | 60 | 10 | 1 | twilliston | WOET (Jiangsu) Co., Ltd. | 66 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 22 | 26 | _binary | 0.0 | 0.0 | 2023-01-25 19:36:26.340000 | 2025-08-26 09:37:12.610000 | 3 | 4 | 9 | 30 | 1 | lthibodeau | Diamond Systems | Hold all sales to this customer. They are on the fire list. | 26 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 8 | 12 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 19:15:02.388000 | 2025-07-10 14:57:58.862000 | 3 | 4 | 9 | 30 | 1 | MLaShombe | Pepperl+Fuchs America, Inc. | 12 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 20 | 24 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 19:25:21.795000 | 2025-06-19 10:01:45.599000 | 3 | 4 | 9 | 10 | 1 | MLaShombe | Weco Manufacturing Group | Hold all sales to this customer. They are on the fire list. | 24 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||
| 72 | 621 | _binary | 3 | 0.0 | 0.0 | 2024-08-28 16:51:25.887000 | 2025-06-16 12:14:43.717000 | 3 | 13 | 38 | 10 | 1 | Gleblanc1 | University of Virginia | 621 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 73 | 622 | _binary | 0.0 | 0.0 | 2024-09-12 13:32:57.446000 | 2025-06-16 12:09:17.184000 | 4 | 9 | 10 | 1 | Gleblanc1 | Pepperl + Fuchs Manufacturing, Inc. | 622 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||||
| 76 | 625 | _binary | 12 | 0.0 | 0.0 | 2024-09-30 14:44:45.796000 | 2025-06-16 08:40:18.841000 | 8 | 4 | 38 | 30 | 1 | Gleblanc1 | Vita Imaging Inc. | 625 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 81 | 641 | _binary | 0.0 | 0.0 | 2025-03-12 17:23:52.421000 | 2025-06-16 08:32:19.078000 | 1 | 33 | 10 | 1 | Gleblanc1 | TEST COMPANY | 1234 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||||
| 45 | 49 | _binary | 0.0 | 0.0 | 2023-01-25 22:09:30.241000 | 2025-06-16 08:31:09.946000 | 5 | 30 | 1 | Gleblanc1 | Stryker Spine | 49 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||||
| 67 | 615 | _binary | 0.0 | 0.0 | 2024-06-19 12:52:35.155000 | 2025-06-16 08:24:36.496000 | 4 | 9 | 30 | 1 | Gleblanc1 | Ryan Equipment Sales Co. | 64 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||||
| 41 | 45 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 21:46:45.201000 | 2025-05-20 12:17:51.917000 | 3 | 4 | 9 | 30 | 1 | MLaShombe | Maxon Corporation | 45 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 83 | 649 | _binary | 3 | 0.0 | 0.0 | 2025-05-08 09:23:58.670000 | 2025-05-12 10:35:48.021000 | 3 | 4 | 9 | 10 | 1 | MLaShombe | Quality Aspirators, Inc. | 649 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 77 | 627 | _binary | 3 | 0.0 | 0.0 | 2024-10-11 13:27:16.745000 | 2025-04-29 12:44:09.135000 | 3 | 4 | 38 | 41 | 1 | kcrowley | Sensory Analytics, LLC | 627 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 70 | 618 | _binary | 0.0 | 0.0 | 2024-06-25 09:45:55.045000 | 2025-04-08 12:10:45.393000 | 4 | 10 | 1 | MLaShombe | Donatelle Plastics | Donatelle | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||||
| 66 | 606 | _binary | 8 | 0.0 | 0.0 | 2024-01-23 16:57:52.417000 | 2025-03-19 12:27:14.448000 | 4 | 4 | 9 | 10 | 1 | MLaShombe | Mattson Thermal Products Gmbh | MOQ is 5 pcs for their PN 1014556 | 606 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||
| 69 | 617 | _binary | 0.0 | 0.0 | 2024-06-21 13:37:07.935000 | 2025-03-17 15:57:51.042000 | 4 | 38 | 10 | 1 | MLaShombe | Verity Instruments, Inc. | 617 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||||
| 7 | 11 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 18:46:42.659000 | 2025-03-14 11:43:48.770000 | 3 | 7 | 9 | 30 | 1 | MLaShombe | Rockwell Automation, Inc. | 11 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 80 | 639 | _binary | 0.0 | 0.0 | 2025-02-03 12:31:45.196000 | 2025-02-10 10:15:57.363000 | 3 | 2 | 33 | 41 | 1 | kcrowley | A.R.C. Laser GmbH | 639 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 78 | 632 | _binary | 0.0 | 0.0 | 2024-12-11 11:04:23.668000 | 2024-12-11 11:04:23.736000 | 4 | 10 | 1 | kcrowley | Boda Products | 632 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||||
| 15 | 19 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 18:44:28.013000 | 2024-10-25 12:57:05.458000 | 3 | 4 | 9 | 30 | 1 | MLaShombe | Rockwell Automation Technologies, Inc. | 19 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 65 | 603 | _binary | 0.0 | 0.0 | 2024-01-12 11:47:09.916000 | 2024-01-12 11:47:09.944000 | 1 | 10 | 1 | jbedard | Engineering / New Product Development | 603 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||||
| 63 | 599 | _binary | 8 | 0.0 | 0.0 | 2023-12-14 11:01:57.210000 | 2023-12-14 17:16:17.873000 | 4 | 6 | 9 | 10 | 1 | MLaShombe | Intuitive Surgical Optics GmbH | Shipping to ISI Germany | 63 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||
| 52 | 56 | _binary | 0.0 | 0.0 | 2023-01-25 22:52:14.622000 | 2023-01-25 22:53:31.202000 | 4 | 4 | 30 | 1 | admin | Robling Medical, Inc. | 56 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||||
| 46 | 50 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 22:14:39.878000 | 2023-01-25 22:14:43.007000 | 3 | 4 | 10 | 1 | admin | Thompson Surgical Instruments, Inc. | 50 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 37 | 41 | _binary | 0.0 | 0.0 | 2023-01-25 21:06:06.153000 | 2023-01-25 21:11:18.477000 | 4 | 4 | 30 | 1 | admin | Thermal Products GmbH | 41 | 10 | _binary | 1 | _binary | _binary | {} |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "customer" (
"id" INTEGERNOT NULL ,
"accountId" INTEGERNOT NULL,
"accountingHash" TEXT DEFAULT NULL,
"accountingId" TEXT DEFAULT NULL,
"activeFlag" INTEGER NOT NULL,
"carrierServiceId" INTEGERDEFAULT NULL,
"creditLimit" REAL DEFAULT NULL,
"currencyId" INTEGERDEFAULT NULL,
"currencyRate" REAL DEFAULT NULL,
"dateCreated" TEXT DEFAULT NULL,
"dateLastModified" TEXT DEFAULT NULL,
"defaultCarrierId" INTEGERDEFAULT NULL,
"defaultPaymentTermsId" INTEGERNOT NULL,
"defaultPriorityId" INTEGERDEFAULT NULL,
"defaultSalesmanId" INTEGERDEFAULT NULL,
"defaultShipTermsId" INTEGERNOT NULL,
"jobDepth" INTEGERDEFAULT NULL,
"lastChangedUser" TEXT DEFAULT NULL,
"name" TEXT NOT NULL,
"note" TEXT DEFAULT NULL,
"number" TEXT NOT NULL,
"parentId" INTEGERDEFAULT NULL,
"qbClassId" INTEGERDEFAULT NULL,
"statusId" INTEGERNOT NULL,
"sysUserId" INTEGERDEFAULT NULL,
"taxExempt" INTEGER NOT NULL,
"taxExemptNumber" TEXT DEFAULT NULL,
"taxRateId" INTEGERDEFAULT NULL,
"toBeEmailed" INTEGER NOT NULL,
"toBePrinted" INTEGER NOT NULL,
"url" TEXT DEFAULT NULL,
"issuableStatusId" INTEGERDEFAULT NULL,
"customFields" TEXT DEFAULT NULL,
PRIMARY KEY ("id")
);