so
5 rows where statusId = 80 sorted by dateIssued descending
This data as json, CSV (advanced)
Suggested facets: billToAddress, billToCity, billToCountryId, billToName, billToStateId, billToZip, customerContact, customerId, dateCalStart, dateCalEnd, dateCreated, dateFirstShip, email, note, paymentTermsId, revisionNum, salesman, salesmanId, salesmanInitials, shipTermsId, shipToAddress, shipToCity, shipToName, shipToStateId, shipToZip, toBePrinted, subTotal, totalPrice, username, dateCalStart (date), dateCalEnd (date), dateCreated (date), dateFirstShip (date), dateIssued (date), dateLastModified (date), dateRevision (date)
statusId 1
- 80 · 5 ✖
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2267 | PO Box 400197 | Charlottesville | 2 | The Rector & Visitors of the University of Virginia | 50 | 22904 | 3 | 0.0 | 9 | 1.0 | University of Virginia | 72 | 2025-01-02 00:00:00.000000 | 2025-01-02 00:15:00.000000 | 2025-01-02 00:00:00.000000 | 2025-01-02 00:00:00.000000 | 2025-01-02 15:21:02.276000 | 2025-01-02 15:22:28.341000 | 2025-01-02 15:20:44.798000 | vendor-invoices@virginia.edu | 0.0 | 10 | 1 | 0.0 | - A purchase order for each project (broken into milestone payments) to be submitted to Innofiber to begin work - Upfront payment of $20,000 for Br project due immediately and applied at project completion - Payment terms: Payments due immediately upon completion of each milestone - Additional sample cost to be quoted separately if necessary | 115587 | 13 | 30 | 1 | _binary | 1 | MLaShombe | 9 | ML | 10 | 131 E. Michigan Avenue Suite E. | Saline | 2 | David J Alpern | 25 | 48176 | 80 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 160500.0 | 160500.0 | 10 | KCrowley | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||
| 151 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test6 | 2023-06-06 00:00:00.000000 | 2023-06-06 00:15:00.000000 | 2023-06-06 00:00:00.000000 | 2023-06-06 00:00:00.000000 | 2023-06-06 11:26:28.888000 | 2023-07-17 16:24:40.042000 | 2023-06-06 11:19:51.230000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test6 | 7 | 30 | 1 | _binary | 3 | TOlivero | 6 | TO | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 80 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.1 | 0.1 | 10 | MDiNallo | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | ||||||||||
| 148 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test3 | 2023-06-06 00:00:00.000000 | 2023-06-06 00:15:00.000000 | 2023-06-06 00:00:00.000000 | 2023-06-06 00:00:00.000000 | 2023-06-06 10:28:28.289000 | 2023-06-09 11:26:11.668000 | 2023-06-06 10:28:01.372000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test3 | 7 | 30 | 1 | _binary | 2 | TOlivero | 6 | TO | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 80 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.15 | 0.15 | 10 | admin | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | ||||||||||
| 147 | Autopista Las Amerias km. 22 Lot B-1 & B-2 | Santo Domingo | 75 | Rockwell Automation Technologies, Inc. | 10100 | 3 | 3 | 0.0 | 9 | 1.0 | Rockwell Automation Technologi | 15 | Test2 | 2023-06-06 00:00:00.000000 | 2023-06-06 00:15:00.000000 | 2023-06-06 00:00:00.000000 | 2023-06-06 00:00:00.000000 | 2023-06-06 10:18:33.371000 | 2023-06-09 11:25:46.925000 | RAACCOUNTSPAYABLEMKE@RA.Rockwell.com | 0.0 | 10 | 1 | 0.0 | Test2 | 4 | 30 | 1 | _binary | 6 | MLaShombe | 9 | ML | 30 | C/O UPS SCS Door 18-19 Assembly 3400 N.W. 74th Avenue | Miami | 2 | Rockwell Automation Technologies, Inc. | 11 | 33122 | 80 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.1 | 0.1 | 10 | admin | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | ||||||||||||
| 146 | Autopista Las Amerias km. 22 Lot B-1 & B-2 | Santo Domingo | 75 | Rockwell Automation Technologies, Inc. | 10100 | 3 | 3 | 0.0 | 9 | 1.0 | Rockwell Automation Technologi | 15 | Test | 2023-06-06 00:00:00.000000 | 2023-06-06 00:15:00.000000 | 2023-06-06 00:00:00.000000 | 2023-06-06 00:00:00.000000 | 2023-06-06 09:45:54.048000 | 2023-06-06 09:46:03.305000 | RAACCOUNTSPAYABLEMKE@RA.Rockwell.com | 0.0 | 10 | 1 | 0.0 | Test1 | 4 | 30 | 1 | _binary | 2 | MLaShombe | 9 | ML | 30 | C/O UPS SCS Door 18-19 Assembly 3400 N.W. 74th Avenue | Miami | 2 | Rockwell Automation Technologies, Inc. | 11 | 33122 | 80 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.01 | 0.01 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} |
Advanced export
JSON shape: default, array, newline-delimited, object
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")
);