customer
12 rows where activeFlag = "_binary " and statusId = 10 sorted by dateLastModified descending
This data as json, CSV (advanced)
Suggested facets: carrierServiceId, defaultCarrierId, defaultPaymentTermsId, defaultSalesmanId, defaultShipTermsId, jobDepth, lastChangedUser, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | {} | ||||||||||||
| 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 | {} | ||||||||||||
| 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 | {} | ||||||||||||
| 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 | {} | ||||||||||||||
| 85 | 654 | _binary | 0.0 | 0.0 | 2025-06-17 10:07:08.533000 | 2025-06-17 10:07:13.440000 | 1 | 52 | 10 | 1 | TTierney | Unidentified New Business | 654 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||||
| 84 | 653 | _binary | 0.0 | 0.0 | 2025-06-17 10:06:40.159000 | 2025-06-17 10:06:52.009000 | 1 | 52 | 10 | 1 | TTierney | NRE | 653 | 10 | _binary | 1 | _binary | _binary | {} | |||||||||||||
| 64 | 602 | _binary | 0.0 | 0.0 | 2024-01-11 15:53:06.222000 | 2024-01-24 12:08:03.464000 | 1 | 10 | 2 | dzawalick | 114446 RGA 2454 | 602 | 9 | 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")
);