Clear filters 📥 Export to Excel (CSV) ⚙ Advanced filters

so

3 rows where statusId = 10 sorted by dateIssued descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdByUserId, phone, salesman, salesmanId, salesmanInitials, shipTermsId, toBePrinted, dateCalStart (date), dateCalEnd (date), dateCreated (date), dateFirstShip (date), dateLastModified (date)

statusId 1

id billToAddress billToCity billToCountryId billToName billToStateId billToZip calCategoryId carrierId carrierServiceId cost createdByUserId currencyId currencyRate customerContact customerId customerPO dateCalStart dateCalEnd dateCompleted dateCreated dateExpired dateFirstShip dateIssued ▲ dateLastModified dateRevision estimatedTax fobPointId locationGroupId mcTotalTax note num paymentTermsId phone priorityId qbClassId registerId shipToResidential revisionNum salesman salesmanId salesmanInitials shipTermsId shipToAddress shipToCity shipToCountryId shipToName shipToStateId shipToZip statusId taxRate taxRateId taxRateName toBeEmailed toBePrinted totalIncludesTax totalTax subTotal totalPrice typeId url username vendorPO customFields paymentLink
3038 PO Box 400197 Charlottesville 2 The Rector & Visitors of the University of Virginia 50 22904   3 3 0.0 35   1.0 John E Gerding 72 PO-0360250 2025-11-04 00:00:00.000000 2025-11-04 00:15:00.000000   2025-09-23 00:00:00.000000   2025-11-04 00:00:00.000000   2025-09-24 14:31:41.612000   0.0 10 1 0.0   116383 13   30 1   _binary 2 SMoran 38 SM 10 University Of Virginia AURBACH MEDICAL RESEARCH BUILDING Floor 01 450 Ray C Hunt Dr CHARLOTTESVILLE 2 John E Gerding 50 22903 10 0.0 1 None _binary  _binary  _binary 0.0 0.0 0.0 10   HClarke   {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text", "value": ""}, "38": {"name": "Budget Amount", "type": "Money"}}  
3481 1201 South Second Street Milwaukee 2 Rockwell Automation, Inc. 54 53204   3 3 0.0 63   1.0 Rockwell Automation, Inc. 7 3012576814 2026-04-22 00:00:00.000000 2026-04-22 00:15:00.000000   2026-02-25 00:00:00.000000   2026-04-22 00:00:00.000000   2026-02-25 09:25:00.041000   0.0 10 1 0.0   116857 7   30 1   _binary 3 MLaShombe 9 ML 30 Whitestown Distribution Center Rockwell Automation C/O Ryder 4255 S 500 E Whitestown 2 Rockwell Automation, Inc. 17 46075 10 0.0 1 None _binary  _binary _binary 0.0 1500.0 1500.0 10   Holli   {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text", "value": ""}, "38": {"name": "Budget Amount", "type": "Money"}}  
3616 275 Commerce Drive Rochester 2 Weco Manufacturing Group 35 14623   3 3 0.0 63   1.0 Weco Manufacturing Group 20 707060 2026-06-24 00:00:00.000000 2026-06-24 00:15:00.000000   2026-04-21 00:00:00.000000   2026-06-24 00:00:00.000000   2026-04-29 12:14:47.841000   0.0 10 1 0.0   1200129 4 585-444-0980 30 1   _binary 4 MLaShombe 9 ML 10 275 Commerce Drive Rochester 2 Weco Manufacturing Group 35 14623 10 0.0 1 None _binary  _binary  _binary 0.0 5300.0 5300.0 10   twilliston   {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text", "value": ""}, "38": {"name": "Budget Amount", "type": "Money"}}  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "so" (
 "id" INTEGERNOT NULL ,
 "billToAddress" TEXT DEFAULT NULL,
 "billToCity" TEXT DEFAULT NULL,
 "billToCountryId" INTEGERDEFAULT NULL,
 "billToName" TEXT DEFAULT NULL,
 "billToStateId" INTEGERDEFAULT NULL,
 "billToZip" TEXT DEFAULT NULL,
 "calCategoryId" INTEGERDEFAULT NULL,
 "carrierId" INTEGERNOT NULL,
 "carrierServiceId" INTEGERDEFAULT NULL,
 "cost" REAL DEFAULT NULL,
 "createdByUserId" INTEGERDEFAULT NULL,
 "currencyId" INTEGERDEFAULT NULL,
 "currencyRate" REAL DEFAULT NULL,
 "customerContact" TEXT DEFAULT NULL,
 "customerId" INTEGERNOT NULL,
 "customerPO" TEXT DEFAULT NULL,
 "dateCalStart" TEXT DEFAULT NULL,
 "dateCalEnd" TEXT DEFAULT NULL,
 "dateCompleted" TEXT DEFAULT NULL,
 "dateCreated" TEXT DEFAULT NULL,
 "dateExpired" TEXT DEFAULT NULL,
 "dateFirstShip" TEXT DEFAULT NULL,
 "dateIssued" TEXT DEFAULT NULL,
 "dateLastModified" TEXT DEFAULT NULL,
 "dateRevision" TEXT DEFAULT NULL,
 "email" TEXT DEFAULT NULL,
 "estimatedTax" REAL DEFAULT NULL,
 "fobPointId" INTEGERNOT NULL,
 "locationGroupId" INTEGERNOT NULL,
 "mcTotalTax" REAL DEFAULT NULL,
 "note" TEXT ,
 "num" TEXT NOT NULL,
 "paymentTermsId" INTEGERNOT NULL,
 "phone" TEXT DEFAULT NULL,
 "priorityId" INTEGERNOT NULL,
 "qbClassId" INTEGERDEFAULT NULL,
 "registerId" INTEGERDEFAULT NULL,
 "shipToResidential" INTEGER NOT NULL,
 "revisionNum" INTEGERDEFAULT NULL,
 "salesman" TEXT DEFAULT NULL,
 "salesmanId" INTEGERNOT NULL,
 "salesmanInitials" TEXT DEFAULT NULL,
 "shipTermsId" INTEGERDEFAULT NULL,
 "shipToAddress" TEXT DEFAULT NULL,
 "shipToCity" TEXT DEFAULT NULL,
 "shipToCountryId" INTEGERDEFAULT NULL,
 "shipToName" TEXT DEFAULT NULL,
 "shipToStateId" INTEGERDEFAULT NULL,
 "shipToZip" TEXT DEFAULT NULL,
 "statusId" INTEGERNOT NULL,
 "taxRate" REAL DEFAULT NULL,
 "taxRateId" INTEGERDEFAULT NULL,
 "taxRateName" TEXT DEFAULT NULL,
 "toBeEmailed" INTEGER NOT NULL,
 "toBePrinted" INTEGER NOT NULL,
 "totalIncludesTax" INTEGER NOT NULL,
 "totalTax" REAL DEFAULT NULL,
 "subTotal" REAL NOT NULL DEFAULT '0.000000000',
 "totalPrice" REAL NOT NULL DEFAULT '0.000000000',
 "typeId" INTEGERNOT NULL,
 "url" TEXT DEFAULT NULL,
 "username" TEXT DEFAULT NULL,
 "vendorPO" TEXT DEFAULT NULL,
 "customFields" TEXT DEFAULT NULL,
 "paymentLink" TEXT DEFAULT NULL,
 PRIMARY KEY ("id")
);