customer
86 rows sorted by dateLastModified descending
This data as json, CSV (advanced)
Suggested facets: carrierServiceId, defaultCarrierId, defaultPaymentTermsId, defaultSalesmanId, defaultShipTermsId, jobDepth, lastChangedUser, note, taxExempt, toBePrinted, url, 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 | {} | |||||||||||
| 39 | 43 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 21:37:12.795000 | 2025-12-11 08:41:32.332000 | 3 | 4 | 30 | 1 | twilliston | Rankin Industries | Hold all sales to this customer. They are on the fire list. | 43 | 30 | _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 | {} | ||||||||||||
| 6 | 10 | _binary | 16 | 0.0 | 0.0 | 2023-01-25 18:36:10.088000 | 2025-12-11 08:41:02.457000 | 4 | 4 | 10 | 1 | twilliston | NeoChord | 8/13/2025 put on hold per Imran. ML | 10 | 50 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 38 | 42 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 21:24:24.641000 | 2025-12-11 08:40:50.691000 | 3 | 4 | 10 | 1 | twilliston | Jedmed Instrument Company | Hold all sales to this customer. They are on the fire list. | 42 | 30 | _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 | {} | ||||||||||||
| 17 | 21 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 19:02:39.829000 | 2025-12-11 08:40:20.662000 | 3 | 1 | 10 | 1 | twilliston | Fireye, Inc. | Hold all sales to this customer. They are on the fire list. | 21 | 30 | _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 | {} | |||||||||||
| 13 | 17 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 18:04:15.913000 | 2025-07-16 15:59:39.725000 | 3 | 4 | 30 | 1 | MLaShombe | Radwell International, Inc. | Hold all sales to this customer. They are on the fire list. | 17 | 30 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 28 | 32 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 20:04:25.310000 | 2025-07-16 15:56:56.963000 | 3 | 4 | 30 | 1 | MLaShombe | Peregrine Surgical Ltd. | 32 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 59 | 582 | _binary | 0.0 | 0.0 | 2023-07-24 14:07:47.366000 | 2025-07-16 15:56:05.885000 | 1 | 10 | 1 | MLaShombe | Peraton, Inc | Hold all sales to this customer. They are on the fire list. | 582 | 30 | _binary | 1 | _binary | _binary | {} | |||||||||||||
| 25 | 29 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 19:48:43.600000 | 2025-07-16 15:52:28.148000 | 3 | 4 | 10 | 1 | MLaShombe | Pendar Technologies | Pendar has decided to move business overseas 1/21/2025 per Dakota via email. | 29 | 50 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 26 | 30 | _binary | 12 | 0.0 | 0.0 | 2023-01-25 19:52:41.876000 | 2025-07-16 15:48:42.146000 | 8 | 4 | 30 | 1 | MLaShombe | Pantron | Hold all sales to this customer. They are on the fire list. | 30 | 30 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 58 | 62 | _binary | 3 | 0.0 | 0.0 | 2023-01-26 09:37:46.487000 | 2025-07-16 15:48:02.739000 | 3 | 4 | 6 | 30 | 1 | MLaShombe | Palisades Dental LLC/Vista Apex | 62 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 51 | 55 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 22:47:57.113000 | 2025-07-16 15:45:14.718000 | 3 | 4 | 30 | 1 | MLaShombe | Noel-Smyser Engineering | 55 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 21 | 25 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 19:29:19.947000 | 2025-07-16 15:45:02.761000 | 3 | 4 | 30 | 1 | MLaShombe | Nikon Instruments, Inc. | Hold all sales to this customer. They are on the fire list. | 25 | 30 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 40 | 44 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 21:41:34.219000 | 2025-07-16 15:43:10.139000 | 3 | 4 | 10 | 1 | MLaShombe | MTI | 44 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 27 | 31 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 19:58:36.105000 | 2025-07-16 15:38:58.590000 | 3 | 4 | 30 | 1 | MLaShombe | Matdan Aerospace | 31 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 57 | 61 | _binary | 0.0 | 0.0 | 2023-01-25 23:19:57.856000 | 2025-07-16 15:37:49.407000 | 4 | 4 | 30 | 1 | MLaShombe | Lighthouse Imaging LLC | 61 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||||
| 23 | 27 | _binary | 4 | 0.0 | 0.0 | 2023-01-25 19:41:24.318000 | 2025-07-16 15:37:36.652000 | 3 | 1 | 10 | 1 | MLaShombe | Kurdex | 27 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 56 | 60 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 23:08:41.738000 | 2025-07-16 15:27:35.970000 | 3 | 4 | 30 | 1 | MLaShombe | Integral Management Solutions Inc. | Hold all sales to this customer. They are on the fire list. | 60 | 30 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 19 | 23 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 19:22:14.412000 | 2025-07-16 15:26:54.780000 | 3 | 4 | 30 | 1 | MLaShombe | Instrumental Machine & Dev. | Hold all sales to this customer. They are on the fire list. | 23 | 30 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 29 | 33 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 20:07:19.918000 | 2025-07-16 15:12:01.301000 | 3 | 4 | 30 | 1 | MLaShombe | Inertia Dynamics | Hold all sales to this customer. They are on the fire list. | 33 | 30 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 36 | 40 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 20:58:04.184000 | 2025-07-16 12:55:00.088000 | 3 | 4 | 30 | 1 | MLaShombe | iAutomation | 40 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 60 | 586 | _binary | 0.0 | 0.0 | 2023-08-07 11:39:50.074000 | 2025-07-16 12:54:42.399000 | 4 | 10 | 1 | MLaShombe | GE Celma Ltda | 586 | 10 | _binary | 1 | _binary | _binary | {} | ||||||||||||||
| 53 | 57 | _binary | 0.0 | 0.0 | 2023-01-25 22:56:14.073000 | 2025-07-16 12:13:51.066000 | 4 | 4 | 30 | 1 | MLaShombe | Electri-Cord | Hold all sales to this customer. They are on the fire list. | 57 | 30 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 35 | 39 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 20:44:25.858000 | 2025-07-16 11:56:36.094000 | 3 | 4 | 10 | 1 | MLaShombe | DST Output/Broadridge | Hold all sales to this customer. They are on the fire list. | 39 | 30 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 42 | 46 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 21:52:03.042000 | 2025-07-16 11:56:23.456000 | 3 | 4 | 10 | 1 | MLaShombe | Dover Engineered Systems, Inc. | Hold all sales to this customer. They are on the fire list. | 46 | 30 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 16 | 20 | _binary | 3 | 0.0 | 0.0 | 2023-01-25 18:54:21.179000 | 2025-07-16 11:53:32.958000 | 3 | 4 | 30 | 1 | MLaShombe | Balluff, Inc. | Fired 3/10/2025 | 20 | 30 | _binary | 1 | _binary | _binary | {} | |||||||||||
| 55 | 59 | _binary | 0.0 | 0.0 | 2023-01-25 23:03:05.165000 | 2025-07-16 11:52:52.873000 | 4 | 4 | 30 | 1 | MLaShombe | Advanced Instruments | Hold all sales to this customer. They are on the fire list. | 59 | 30 | _binary | 1 | _binary | _binary | {} | ||||||||||||
| 71 | 619 | _binary | 0.0 | 0.0 | 2024-07-10 10:49:42.883000 | 2025-07-16 11:52:44.288000 | 4 | 9 | 10 | 1 | MLaShombe | ChoiceSpine | Fired 5/15/2025 | 619 | 50 | _binary | 1 | _binary | _binary | choicespine.net | {} | |||||||||||
| 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 | {} |
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")
);