xo
3 rows
This data as json, CSV (advanced)
Suggested facets: fromAddress, fromCity, fromName, fromZip, shipToAddress, shipToAttn, shipToCity, shipToName, shipToZip, statusId, typeId, userId, dateCompleted (date), dateCreated (date), dateIssued (date), dateLastModified (date), dateScheduled (date)
| id ▼ | carrierId | carrierServiceId | dateCompleted | dateConfirmed | dateCreated | dateFirstShip | dateIssued | dateLastModified | dateScheduled | fromAddress | fromAttn | fromCity | fromCountryId | fromLGId | fromName | fromStateId | fromZip | mainLocationTagId | note | num | ownerIsFrom | revisionNum | shipToAddress | shipToAttn | shipToCity | shipToCountryId | shipToLGId | shipToName | shipToStateId | shipToZip | statusId | typeId | userId | customFields |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 3 | 2023-03-23 13:28:58.434000 | 2023-03-23 13:26:04.358000 | 2023-03-23 13:26:04.373000 | 2023-03-23 13:28:58.481000 | 2023-03-23 00:00:00.000000 | 1 | 4 | _binary | 2 | 1 | 70 | 20 | 1 | {} | |||||||||||||||||||
| 2 | 3 | 2023-03-23 14:26:47.259000 | 2023-03-23 14:26:16.597000 | 2023-03-23 14:26:16.613000 | 2023-03-23 14:26:47.290000 | 2023-03-23 14:25:38.000000 | 1 | 6 | _binary | 1 | 1 | 70 | 20 | 1 | {} | |||||||||||||||||||
| 4 | 3 | 2025-05-27 11:17:02.609000 | 2025-05-27 11:20:46.841000 | 2025-05-27 11:34:14.668000 | 2025-05-27 00:00:00.000000 | 2 Spratt Technology Way | Sterling | 2 | 1 | Innofiber, LLC | 24 | 01564 | 8 | _binary | 3 | 251 Route 5 West | Acrolite, Inc. | Elbridge | 2 | 1 | Main Address | 35 | 13060 | 60 | 10 | 9 | {} |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "xo" (
"id" INTEGERNOT NULL ,
"carrierId" INTEGERNOT NULL,
"carrierServiceId" INTEGERDEFAULT NULL,
"dateCompleted" TEXT DEFAULT NULL,
"dateConfirmed" TEXT DEFAULT NULL,
"dateCreated" TEXT DEFAULT NULL,
"dateFirstShip" TEXT DEFAULT NULL,
"dateIssued" TEXT DEFAULT NULL,
"dateLastModified" TEXT DEFAULT NULL,
"dateScheduled" TEXT DEFAULT NULL,
"fromAddress" TEXT DEFAULT NULL,
"fromAttn" TEXT DEFAULT NULL,
"fromCity" TEXT DEFAULT NULL,
"fromCountryId" INTEGERDEFAULT NULL,
"fromLGId" INTEGERNOT NULL,
"fromName" TEXT DEFAULT NULL,
"fromStateId" INTEGERDEFAULT NULL,
"fromZip" TEXT DEFAULT NULL,
"mainLocationTagId" INTEGERDEFAULT NULL,
"note" TEXT ,
"num" TEXT NOT NULL,
"ownerIsFrom" INTEGER NOT NULL,
"revisionNum" INTEGERDEFAULT NULL,
"shipToAddress" TEXT DEFAULT NULL,
"shipToAttn" TEXT DEFAULT NULL,
"shipToCity" TEXT DEFAULT NULL,
"shipToCountryId" INTEGERDEFAULT NULL,
"shipToLGId" INTEGERNOT NULL,
"shipToName" TEXT DEFAULT NULL,
"shipToStateId" INTEGERDEFAULT NULL,
"shipToZip" TEXT DEFAULT NULL,
"statusId" INTEGERNOT NULL,
"typeId" INTEGERNOT NULL,
"userId" INTEGERNOT NULL,
"customFields" TEXT DEFAULT NULL,
PRIMARY KEY ("id")
);