so
36 rows where statusId = 85 sorted by dateIssued descending
This data as json, CSV (advanced)
Suggested facets: billToAddress, billToCity, billToCountryId, billToName, billToStateId, billToZip, carrierId, carrierServiceId, cost, createdByUserId, customerContact, customerId, dateCalStart, dateCalEnd, dateCreated, dateFirstShip, email, note, paymentTermsId, phone, revisionNum, salesman, salesmanId, salesmanInitials, shipTermsId, shipToAddress, shipToCity, shipToName, shipToStateId, shipToZip, toBePrinted, subTotal, totalPrice, username, customFields, dateCalStart (date), dateCalEnd (date), dateCreated (date), dateFirstShip (date), dateIssued (date), dateLastModified (date), dateRevision (date)
statusId 1
- 85 · 36 ✖
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3075 | 661 Snowville Rd | Brecksville | 2 | Lumitex, Inc. | 39 | 44141 | 4 | 0.0 | 35 | 1.0 | Lumitex, LLC. | 9 | 63798-00 | 2025-12-18 00:00:00.000000 | 2025-12-18 00:15:00.000000 | 2025-10-07 00:00:00.000000 | 2025-12-18 00:00:00.000000 | 2025-10-07 10:32:52.600000 | 2025-11-21 13:20:43.210000 | 0.0 | 10 | 1 | 0.0 | 116425 | 4 | 800-969-5483 | 30 | 1 | _binary | 4 | TOlivero | 6 | TO | 41 | 6611 W Snowville Rd. | Brecksville | 2 | Lumitex, LLC. | 39 | 44141 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 1150.0 | 1150.0 | 10 | TWilliston | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text", "value": ""}, "38": {"name": "Budget Amount", "type": "Money"}} | ||||||||||||
| 3009 | 1212 Terra Bella Avenue | Mountain View | 2 | Iridex Corporation | 6 | 94043-1824 | 4 | 0.0 | 60 | 1.0 | Iridex Corporation | 10 | 60806 | 2025-09-15 00:00:00.000000 | 2025-09-15 00:15:00.000000 | 2025-09-15 00:00:00.000000 | 2025-09-15 00:00:00.000000 | 2025-09-15 10:18:07.918000 | 2025-09-15 10:20:23.879000 | Accountspayable@iridex.com | 0.0 | 10 | 1 | 0.0 | 116351 | 4 | 650-962-8848 | 30 | 1 | _binary | 14 | TOlivero | 6 | TO | 30 | 1212 Terra Bella Avenue | Mountain View | 2 | Iridex Corporation | 6 | 94043-1824 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 275.25 | 275.25 | 10 | TWilliston | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text", "value": ""}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||
| 2085 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 35 | 1.0 | Rockwell Automation, Inc. | 7 | 3011784166 | 2024-12-13 00:00:00.000000 | 2024-12-13 00:15:00.000000 | 2024-10-29 00:00:00.000000 | 2024-12-13 00:00:00.000000 | 2024-10-29 13:23:41.912000 | 2024-11-06 16:04:45.427000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | 115406 | 7 | 30 | 1 | _binary | 3 | HClarke | 35 | HC | 30 | Whitestown Distribution Center Rockwell Automation C/O Ryder 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 652.5 | 652.5 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||
| 2067 | 8443 Dow Circle | Strongsville | 2 | Lumitex, Inc. | 39 | 44136 | 4 | 0.0 | 35 | 1.0 | Lumitex, LLC. | 9 | 62419-00 | 2024-12-03 00:00:00.000000 | 2024-12-03 00:15:00.000000 | 2024-10-23 00:00:00.000000 | 2024-12-03 00:00:00.000000 | 2024-10-23 12:54:20.219000 | 2024-10-24 09:52:17.075000 | 0.0 | 10 | 1 | 0.0 | Fedex Account: 345 972 820 | 115384 | 4 | 800-969-5483 | 30 | 1 | _binary | 3 | HClarke | 35 | HC | 41 | 8300 Dow Circle Suite 400 | Strongsville | 2 | Lumitex, LLC. | 39 | 44136 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 4125.0 | 4125.0 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||
| 1921 | 6900 West 110th Street | Bloomington | 2 | Sick Optic-Electronic, Inc. | 26 | 55438 | 8 | 12 | 0.0 | 35 | 1.0 | SICK PCA | 14 | 4701917582 | 2024-10-11 00:00:00.000000 | 2024-10-11 00:15:00.000000 | 2024-09-05 00:00:00.000000 | 2024-10-11 00:00:00.000000 | 2024-09-05 07:57:09.433000 | 2024-09-11 09:32:38.461000 | pdf-invoices.pca@sick.com | 0.0 | 10 | 1 | 0.0 | 115232 | 4 | 30 | 1 | _binary | 2 | HClarke | 35 | HC | 20 | Minneapolis Campus 2601 American Blvd E | Minneapolis | 2 | SICK PCA | 26 | 55425-1321 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 720.0 | 720.0 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||
| 1767 | 2901 EISENHOWER STREET | CARROLLTON | 2 | Verity Instruments, Inc. | 47 | 75007 | 3 | 0.0 | 9 | 1.0 | Verity Instruments, Inc. | 69 | 039103-00 | 2024-09-03 00:00:00.000000 | 2024-09-03 00:15:00.000000 | 2024-07-16 00:00:00.000000 | 2024-09-03 00:00:00.000000 | 2024-07-16 08:39:02.661000 | 2025-01-10 15:55:52.460000 | 0.0 | 10 | 1 | 0.0 | 115064 | 4 | 9724469990 | 30 | 1 | _binary | 6 | SMoran | 38 | SM | 10 | 2901 EISENHOWER STREET | CARROLLTON | 2 | Verity Instruments, Inc. | 47 | 75007 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 485.65 | 485.65 | 10 | Tolivero | {"33": {"name": "Commission?", "type": "Checkbox", "value": "true"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | ||||||||||||
| 1031 | 51 Britain Drive | New Britain | 2 | Peregrine Surgical Ltd. | 42 | 18901 | 3 | 3 | 0.0 | 9 | 1.0 | Peregrine Surgical Ltd. | 28 | 30552 | 2023-12-04 00:00:00.000000 | 2023-12-04 00:15:00.000000 | 2023-12-01 00:00:00.000000 | 2023-12-04 00:00:00.000000 | 2023-12-04 12:58:58.225000 | 2024-04-01 09:20:33.135000 | 0.0 | 10 | 1 | 0.0 | Peregrine cancelled order 2/27/2024 | 114346 | 4 | 215-348-0456 | 30 | 1 | _binary | 4 | MLaShombe | 9 | ML | 30 | 51 Britain Drive | New Britain | 2 | Peregrine Surgical Ltd. | 42 | 18901 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 18380.0 | 18380.0 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | ||||||||||
| 616 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 12 | 1.0 | Rockwell Automation, Inc. | 7 | 3011127324 | 2023-10-04 00:00:00.000000 | 2023-10-04 00:15:00.000000 | 2023-09-07 00:00:00.000000 | 2023-10-04 00:00:00.000000 | 2023-09-07 10:37:20.464000 | 2023-09-14 14:50:37.225000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | 113928 | 7 | 30 | 1 | _binary | 2 | DMoyen | 12 | DM | 30 | Whitestown Distribution Center Rockwell Automation C/O Ryder 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 500.0 | 500.0 | 10 | DMoyen | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||
| 585 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 12 | 1.0 | Rockwell Automation, Inc. | 7 | 3011101262 | 2023-10-04 00:00:00.000000 | 2023-10-04 00:15:00.000000 | 2023-09-07 00:00:00.000000 | 2023-10-04 00:00:00.000000 | 2023-09-07 09:36:29.805000 | 2023-09-21 14:35:42.792000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | 113898 | 7 | 30 | 1 | _binary | 2 | DMoyen | 12 | DM | 30 | Whitestown Distribution Center Rockwell Automation C/O Ryder 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 550.0 | 550.0 | 10 | DMoyen | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||
| 557 | 8443 Dow Circle | Strongsville | 2 | Lumitex, Inc. | 39 | 44136 | 4 | 0.0 | 16 | 1.0 | Lumitex, LLC. | 9 | TEST100 | 2023-08-28 00:00:00.000000 | 2023-08-28 00:15:00.000000 | 2023-08-28 00:00:00.000000 | 2023-08-28 00:00:00.000000 | 2023-08-28 13:28:52.384000 | 2023-08-28 16:25:35.219000 | 0.0 | 10 | 1 | 0.0 | TEST100 | 4 | 800-969-5483 | 30 | 1 | _binary | 5 | MDiNallo | 16 | M | 30 | 8300 Dow Circle Suite 400 | Strongsville | 2 | Lumitex, LLC. | 39 | 44136 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.11 | 0.11 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | ||||||||||||
| 482 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 12 | 1.0 | Rockwell Automation, Inc. | 7 | 3011033454 | 2023-08-17 00:00:00.000000 | 2023-08-17 00:15:00.000000 | 2023-07-31 00:00:00.000000 | 2023-08-17 00:00:00.000000 | 2023-07-31 13:29:27.939000 | 2023-08-02 16:05:00.193000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | 113733 | 7 | 30 | 1 | _binary | 2 | DMoyen | 12 | DM | 30 | Whitestown Distribution Center Rockwell Automation C/O Ryder 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 1125.0 | 1125.0 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||
| 252 | Autopista Las Amerias km. 22 Lot B-1 & B-2 | Santo Domingo | 75 | Rockwell Automation Technologies, Inc. | 10100 | 3 | 3 | 0.0 | 16 | 1.0 | Rockwell Automation Technologi | 15 | 2023-06-14 00:00:00.000000 | 2023-06-14 00:15:00.000000 | 2023-06-14 00:00:00.000000 | 2023-06-14 00:00:00.000000 | 2023-06-14 11:41:49.934000 | 2023-12-11 14:48:55.270000 | RAACCOUNTSPAYABLEMKE@RA.Rockwell.com | 0.0 | 10 | 1 | 0.0 | Test_Reject | 4 | 30 | 1 | _binary | 12 | MDiNallo | 16 | M | 30 | C/O UPS SCS Door 18-19 Assembly 3400 N.W. 74th Avenue | Miami | 2 | Rockwell Automation Technologies, Inc. | 11 | 33122 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.1 | 0.1 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||||
| 170 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test28 | 2023-06-12 00:00:00.000000 | 2023-06-12 00:15:00.000000 | 2023-06-09 00:00:00.000000 | 2023-06-12 00:00:00.000000 | 2023-06-09 15:47:43.720000 | 2023-07-17 16:34:19.937000 | 2023-06-09 15:43:36.210000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test28 | 7 | 30 | 1 | _binary | 5 | TOlivero | 6 | TO | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 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"}} | ||||||||||
| 169 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test27 | 2023-06-12 00:00:00.000000 | 2023-06-12 00:15:00.000000 | 2023-06-09 00:00:00.000000 | 2023-06-12 00:00:00.000000 | 2023-06-09 15:47:30.911000 | 2023-07-17 16:34:35.190000 | 2023-06-09 15:43:21.159000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test27 | 7 | 30 | 1 | _binary | 4 | TOlivero | 6 | TO | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 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"}} | ||||||||||
| 168 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test26 | 2023-06-12 00:00:00.000000 | 2023-06-12 00:15:00.000000 | 2023-06-09 00:00:00.000000 | 2023-06-12 00:00:00.000000 | 2023-06-09 15:47:02.848000 | 2023-07-17 16:34:39.688000 | 2023-06-09 15:42:59.576000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test26 | 7 | 30 | 1 | _binary | 4 | TOlivero | 6 | TO | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 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"}} | ||||||||||
| 167 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test25 | 2023-06-12 00:00:00.000000 | 2023-06-12 00:15:00.000000 | 2023-06-09 00:00:00.000000 | 2023-06-12 00:00:00.000000 | 2023-06-09 15:46:36.488000 | 2023-07-17 16:34:43.653000 | 2023-06-09 15:42:35.035000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test25 | 7 | 30 | 1 | _binary | 4 | TOlivero | 6 | TO | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 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"}} | ||||||||||
| 166 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.00238416 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test24 | 2023-06-12 00:00:00.000000 | 2023-06-12 00:15:00.000000 | 2023-06-09 00:00:00.000000 | 2023-06-12 00:00:00.000000 | 2023-06-09 15:46:22.051000 | 2023-12-11 14:47:32.963000 | 2023-06-09 15:42:04.101000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test24 | 7 | 30 | 1 | _binary | 4 | TOlivero | 6 | TO | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.1 | 0.1 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | ||||||||||
| 165 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.00238416 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test23 | 2023-06-12 00:00:00.000000 | 2023-06-12 00:15:00.000000 | 2023-06-09 00:00:00.000000 | 2023-06-12 00:00:00.000000 | 2023-06-09 15:46:00.738000 | 2023-12-11 14:46:54.487000 | 2023-06-09 15:41:44.788000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test23 | 7 | 30 | 1 | _binary | 4 | TOlivero | 6 | TO | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.1 | 0.1 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | ||||||||||
| 164 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.00238416 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test22 | 2023-06-12 00:00:00.000000 | 2023-06-12 00:15:00.000000 | 2023-06-09 00:00:00.000000 | 2023-06-12 00:00:00.000000 | 2023-06-09 15:45:44.340000 | 2023-12-11 14:46:37.746000 | 2023-06-09 15:41:03.102000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test22 | 7 | 30 | 1 | _binary | 5 | TOlivero | 6 | TO | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.1 | 0.1 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | ||||||||||
| 163 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.00238416 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test21 | 2023-06-12 00:00:00.000000 | 2023-06-12 00:15:00.000000 | 2023-06-09 00:00:00.000000 | 2023-06-12 00:00:00.000000 | 2023-06-09 15:44:59.224000 | 2023-12-11 14:46:17.635000 | 2023-06-09 15:40:09.105000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test21 | 7 | 30 | 1 | _binary | 4 | TOlivero | 6 | TO | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.1 | 0.1 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | ||||||||||
| 162 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.00238416 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test20 | 2023-06-12 00:00:00.000000 | 2023-06-12 00:15:00.000000 | 2023-06-09 00:00:00.000000 | 2023-06-12 00:00:00.000000 | 2023-06-09 15:44:48.356000 | 2023-12-11 14:45:48.164000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test20 | 7 | 30 | 1 | _binary | 4 | MLaShombe | 9 | ML | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.1 | 0.1 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||
| 161 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test16 | 2023-06-09 00:00:00.000000 | 2023-06-09 00:15:00.000000 | 2023-06-09 00:00:00.000000 | 2023-06-09 00:00:00.000000 | 2023-06-09 11:20:28.872000 | 2023-12-11 14:45:34.621000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test16 | 7 | 30 | 1 | _binary | 2 | MLaShombe | 9 | ML | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.1 | 0.1 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||
| 160 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test15 | 2023-06-09 00:00:00.000000 | 2023-06-09 00:15:00.000000 | 2023-06-09 00:00:00.000000 | 2023-06-09 00:00:00.000000 | 2023-06-09 10:35:18.354000 | 2023-12-11 14:45:20.985000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test15 | 7 | 30 | 1 | _binary | 2 | MLaShombe | 9 | ML | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.1 | 0.1 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||
| 159 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test14 | 2023-06-09 00:00:00.000000 | 2023-06-09 00:15:00.000000 | 2023-06-09 00:00:00.000000 | 2023-06-09 00:00:00.000000 | 2023-06-09 09:06:47.552000 | 2023-12-11 13:47:24.239000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test14 | 7 | 30 | 1 | _binary | 2 | MLaShombe | 9 | ML | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.1 | 0.1 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||
| 158 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test13 | 2023-06-08 00:00:00.000000 | 2023-06-08 00:15:00.000000 | 2023-06-08 00:00:00.000000 | 2023-06-08 00:00:00.000000 | 2023-06-08 14:19:19.839000 | 2023-12-11 13:47:04.416000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test13 | 7 | 30 | 1 | _binary | 2 | MLaShombe | 9 | ML | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.2 | 0.2 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||
| 157 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test12 | 2023-06-08 00:00:00.000000 | 2023-06-08 00:15:00.000000 | 2023-06-08 00:00:00.000000 | 2023-06-08 00:00:00.000000 | 2023-06-08 11:17:37.598000 | 2023-12-11 13:44:50.177000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test12 | 7 | 30 | 1 | _binary | 2 | MLaShombe | 9 | ML | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.1 | 0.1 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||
| 155 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test9 | 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 13:19:45.592000 | 2023-12-11 13:45:32.270000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test9 | 7 | 30 | 1 | _binary | 2 | MLaShombe | 9 | ML | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.1 | 0.1 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||
| 153 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test7 | 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:33:50.986000 | 2023-07-17 16:35:02.934000 | 2023-06-06 11:32:17.220000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test7 | 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 | 85 | 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"}} | ||||||||||
| 149 | 1212 Terra Bella Avenue | Mountain View | 2 | Iridex Corporation | 6 | 94043-1824 | 4 | 8 | 0.0 | 9 | 1.0 | Iridex Corporation | 10 | Test4 | 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:40:36.283000 | 2023-12-11 13:46:01.486000 | Accountspayable@iridex.com | 0.0 | 10 | 1 | 0.0 | Test4 | 4 | 650-962-8848 | 30 | 1 | _binary | 6 | MLaShombe | 9 | ML | 30 | 1212 Terra Bella Avenue | Mountain View | 2 | Iridex Corporation | 6 | 94043-1824 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.1 | 0.1 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | ||||||||||
| 145 | 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-10 00:00:00.000000 | 2023-06-10 00:15:00.000000 | 2023-06-06 00:00:00.000000 | 2023-06-10 00:00:00.000000 | 2023-06-06 09:40:24.012000 | 2023-06-06 09:42:30.648000 | RAACCOUNTSPAYABLEMKE@RA.Rockwell.com | 0.0 | 10 | 1 | 0.0 | Test | 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 | 85 | 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"}} | ||||||||||||
| 34 | 1212 Terra Bella Avenue | Mountain View | 2 | Iridex Corporation | 6 | 94043-1824 | 3 | 0.0 | 9 | 1.0 | Iridex Corporation | 10 | Testing | 2023-05-31 00:00:00.000000 | 2023-05-31 00:15:00.000000 | 2023-04-19 00:00:00.000000 | 2023-05-31 00:00:00.000000 | 2023-04-19 16:21:41.861000 | 2023-09-08 08:50:29.569000 | Accountspayable@iridex.com | 0.0 | 10 | 1 | 0.0 | 113325 | 4 | 650-962-8848 | 30 | 1 | _binary | 5 | MLaShombe | 9 | ML | 30 | 1212 Terra Bella Avenue | Mountain View | 2 | Iridex Corporation | 6 | 94043-1824 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.0 | 0.0 | 10 | DMoyen | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||
| 150 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test5 | 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-07-17 16:24:24.071000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test5 | 7 | 30 | 1 | _binary | 3 | MLaShombe | 9 | ML | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 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"}} | ||||||||||||
| 156 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 16 | 1.0 | Rockwell Automation, Inc. | 7 | TEST11 | 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-12-11 13:46:28.393000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | TEST11 | 7 | 30 | 1 | _binary | 2 | MDiNallo | 16 | M | 30 | Whitestown Distribution Center Rockwell Automation C/O Kuehne + Nagle 4255 S 500 E | Whitestown | 2 | Rockwell Automation, Inc. | 17 | 46075 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 0.1 | 0.1 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text"}, "38": {"name": "Budget Amount", "type": "Money"}} | ||||||||||||
| 171 | P.O. Box 2167 | Milwaukee | 2 | Rockwell Automation, Inc. | 54 | 53201 | 3 | 3 | 0.0 | 9 | 1.0 | Rockwell Automation, Inc. | 7 | Test29 | 2023-06-12 00:00:00.000000 | 2023-06-12 00:15:00.000000 | 2023-06-09 00:00:00.000000 | 2023-06-12 00:00:00.000000 | 2023-07-17 16:34:15.107000 | 2023-06-09 15:43:58.241000 | RAAccountspayableMKE@RA.rockwell.com | 0.0 | 10 | 1 | 0.0 | Test29 | 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 | 85 | 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"}} | |||||||||||
| 2589 | USPS Central Repair Facility 7215 SW Topeka Blvd Building 7 | Topeka | 2 | Peraton, Inc | 19 | 66630-1111 | 3 | 0.0 | 35 | 1.0 | Peraton, Inc | 59 | 8005132 | 2025-05-07 00:00:00.000000 | 2025-05-07 00:15:00.000000 | 2025-03-31 00:00:00.000000 | 2025-05-07 00:00:00.000000 | 2025-05-05 11:39:45.240000 | 0.0 | 10 | 1 | 0.0 | Hold all sales to this customer. They are on the fire list. | 115916 | 1 | 30 | 1 | _binary | 3 | HClarke | 35 | HC | 10 | USPS Central Repair Facility 7215 SW Topeka Blvd Building 8 Suite B | Topeka | 2 | Peraton, Inc | 19 | 66624-8702 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 7030.0 | 7030.0 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "false"}, "35": {"name": "Project Number", "type": "Text", "value": ""}, "38": {"name": "Budget Amount", "type": "Money"}} | |||||||||||||
| 2868 | 1212 Terra Bella Avenue | Mountain View | 2 | Iridex Corporation | 6 | 94043-1824 | 6 | 0.0 | 5 | 1.0 | Iridex Corporation | 10 | 2025-07-18 14:27:34.960000 | 2025-07-18 14:42:34.960000 | 2025-07-18 14:27:34.960000 | 2025-07-18 14:27:34.960000 | 2025-07-21 10:30:15.495000 | Accountspayable@iridex.com | 0.0 | 10 | 1 | 0.0 | Created from RMA #2494 | 116204 | 4 | 650-962-8848 | 30 | 1 | _binary | 1 | TOlivero | 6 | TO | 30 | 1212 Terra Bella Avenue | Mountain View | 2 | Iridex Corporation | 6 | 94043-1824 | 85 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | -31706.88 | -31706.88 | 10 | JBedard | {} |
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")
);