po
18 rows where statusId = 10 sorted by dateIssued descending
This data as json, CSV (advanced)
Suggested facets: buyer, buyerId, carrierId, carrierServiceId, dateCreated, dateFirstShip, email, note, paymentTermsId, phone, remitAddress, remitCity, remitCountryId, remitStateId, remitToName, remitZip, revisionNum, shipTermsId, shipToName, username, vendorContact, vendorId, customFields, dateCreated (date), dateFirstShip (date), dateLastModified (date), dateRevision (date)
statusId 1
- 10 · 18 ✖
| id | buyer | buyerId | carrierId | carrierServiceId | currencyId | currencyRate | customerSO | dateCompleted | dateConfirmed | dateCreated | dateFirstShip | dateIssued ▲ | dateLastModified | dateRevision | deliverTo | fobPointId | issuedByUserId | locationGroupId | note | num | paymentTermsId | phone | qbClassId | remitAddress | remitCity | remitCountryId | remitStateId | remitToName | remitZip | revisionNum | shipTermsId | shipToAddress | shipToCity | shipToCountryId | shipToName | shipToStateId | shipToZip | statusId | taxRateId | taxRateName | totalIncludesTax | totalTax | typeId | url | username | vendorContact | vendorId | vendorSO | customFields | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2197 | MDavan | 10 | 3 | 3 | 1 | 1.0 | 2025-05-01 00:00:00.000000 | 2025-05-01 00:00:00.000000 | 2026-02-04 11:37:30.657000 | Rich@davidpackardcompany.com | 10 | 1 | 82707 | 6 | 1 | 15 Industrial Pk, East | Oxford | 24 | David Packard Company, Inc. | 01540 | 5 | 30 | 2 Spratt Technology Way | Sterling | 2 | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | MDavan | Rich Shine | 121 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": ""}} | ||||||||||||||
| 3199 | amarchetti | 67 | 3 | 3 | 1 | 1.0 | 2026-02-12 00:00:00.000000 | 2026-02-12 00:00:00.000000 | 2026-04-15 15:21:57.719000 | Rich@davidpackardcompany.com | 10 | 1 | 1) Product to be machined to comply with 15801(15517) current rev listed on drawing and PO 2) Product and packaging to be free of oil and debris. 3) No visible tool marks on OD of handle. 4) Certificate of Compliance to be provided with all shipments. 5) Certification to anodize per mil-A-8625 type ll class 2 required with all shipments. 6) Certification to print image with ITW trans tech epoxy ink medical grade type B, class VI with all shipments. 7) REACH and RoHS certification to be provided with all shipments. 8) All documentation to include Innofibers PO, Part number and Revision. 9) This PO is for FAI only | 83854 | 6 | 1 | 15 Industrial Pk, East | Oxford | 24 | David Packard Company, Inc. | 01540 | 2 | 30 | 2 Spratt Technology Way | Sterling | 2 | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | Ejoshi | Rich Shine | 121 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": ""}} | |||||||||||||
| 3202 | amarchetti | 67 | 3 | 1 | 1.0 | 2026-02-13 00:00:00.000000 | 2026-02-13 00:00:00.000000 | 2026-02-13 09:45:22.666000 | BDesjardins@needletech.com | 10 | 1 | 83857 | 4 | 1 | PO Box 531820 | Atlanta | 12 | NeedleTech Products/Arrotek Medical Limited | 30353-1820 | 1 | 30 | 2 Spratt Technology Way | Sterling | 2 | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | amarchetti | Needle Tech/Arrotek Medical Li | 323 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": ""}} | |||||||||||||||
| 3307 | EReed | 46 | 3 | 3 | 1 | 1.0 | 2026-03-13 00:00:00.000000 | 2026-03-13 00:00:00.000000 | 2026-03-23 16:16:30.779000 | Rich@davidpackardcompany.com | 10 | 1 | Line 1: Parts to be machined per print 12620 current rev received with purchase order, include 10620 C-Clip and perform laser marking and passivation on the total of 50 pieces. Line 2: Innofiber to supply 31 pieces of PN 12620 to be laser marked and passivated per print 15954. Parts to be laser marked per print 15954 and with lot code referenced on current purchase order. Product to passivated per Innofiber print 15954 current revision listed on purchase order. Certificate of conformance to state that product was passivated per ASTM spec listed in note one on print 15954. Product and packaging to be free of oil and debris. Product to be packaged to prevent damage during transit. All labels and documentation accompanying shipment to include Innofiber purchase order number, part number, revision, and date of processing. | 83983 | 6 | 1 | 15 Industrial Pk, East | Oxford | 24 | David Packard Company, Inc. | 01540 | 17 | 30 | 2 Spratt Technology Way | Sterling | 2 | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | EReed | Rich Shine | 121 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": ""}} | |||||||||||||
| 3323 | EReed | 46 | 3 | 3 | 1 | 1.0 | 2026-03-18 00:00:00.000000 | 2026-03-18 00:00:00.000000 | 2026-04-13 11:14:47.640000 | Rich@davidpackardcompany.com | 10 | 1 | Parts to be machined to print 17760 current revision of print received with purchase order. Parts to be laser marked per print 17760 and with lot code referenced on current purchase order. Product to passivated per Innofiber print 17760 current revision listed on purchase order. Certificate of conformance to state that product was passivated per ASTM spec listed on print 17760. Product and packaging to be free of oil and debris. Product to be packaged to prevent damage during transit. All labels and documentation accompanying shipment to include Innofiber purchase order number, part number, revision, and date of processing. (Note: Machined specification the same as previous PN 14196) | 84003 | 6 | 1 | 15 Industrial Pk, East | Oxford | 24 | David Packard Company, Inc. | 01540 | 7 | 30 | 2 Spratt Technology Way | Sterling | 2 | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | Ejoshi | Rich Shine | 121 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": ""}} | |||||||||||||
| 3401 | bwimmer | 74 | 3 | 3 | 1 | 1.0 | 2026-04-14 00:00:00.000000 | 2026-04-09 00:00:00.000000 | 2026-04-14 13:14:16.112000 | nj.sales@mcmastercarr.com | 10 | 1 | 84095 | 6 | 1 | 200 New Canton Way | Robbinsville | 2 | 33 | McMaster-Carr Supply Co | 08691 | 1 | 30 | 2 Spratt Technology Way | Sterling | 2 | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | bwimmer | Sales Email | 284 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": ""}} | |||||||||||||
| 3459 | Ejoshi | 64 | 7 | 1 | 1.0 | 2026-04-20 00:00:00.000000 | 2026-04-20 00:00:00.000000 | 2026-05-04 08:54:14.482000 | 10 | 1 | 84163 | 6 | 1 | 472 High Street | Clinton | 2 | 24 | Clinton Offset Printers | 01510 | 4 | 20 | 2 Spratt Technology Way | Sterling | 2 | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | Ejoshi | Clinton Offset Printers | 87 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": ""}} | |||||||||||||||
| 3467 | Ejoshi | 64 | 8 | 12 | 1 | 1.0 | 2026-04-21 00:00:00.000000 | 2026-04-21 00:00:00.000000 | 2026-05-04 08:52:07.728000 | 2026-04-21 09:22:52.627000 | ruben.addax@gmail.com | 10 | 1 | 1) Material is Brass. 2) Remove Burrs and Sharp Edges 0.005" Max Chamfer Unless Otherwise Stated. 3) Diameters to be Concentric to 0.004" unless otherwise stated. 4) Product to be machined to comply with Current Rev listed on drawing and PO. 5) Product and packaging to be free of oil and debris 6) Certificate of compliance to be provided with all shipments 7) REACH and RoHS certification to be provided with all shipments 8) All documentation to include Innofiber PO, Part Number, and Revision | 84171 | 4 | 1 | 230 Pepe's Farm Rd Unit A | Milford | 8 | Addax Technologies, LLC | 6460 | 4 | 30 | 2 Spratt Technology Way | Sterling | 2 | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | Ejoshi | Ruben Santof | 13 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": "UPS1ZA89W970437030805"}} | ||||||||||||
| 3538 | MDavan | 10 | 8 | 12 | 1 | 1.0 | 2026-04-29 00:00:00.000000 | 2026-04-29 00:00:00.000000 | 2026-04-29 11:28:17.482000 | www.ceramoptec.com | 10 | 1 | Innofiber purchases and consumes in feet. Purchase order quantity is to be interpreted in the total number of feet and not meters. Material certification to be supplied with shipment Run test data documentation to include fiber diameter and concentricity Product and packaging to be free of oil and debris Certificate of compliance to be provided with all shipments REACH and RoHS certification to be provided with all shipments All documentation to include Innofiber PO, Part Number, and Revision Product to be labeled with date of manufacture and expiration date if applicable | 84246 | 4 | 437-914-9233 | 1 | (Ceram Optec SIA (CO SIA) 100 York Boulevard, Suite 240 | Richmond Hill | 3 | 68 | Biolitec Biomedical Technology Canada Ltd | L4B1J8 | 3 | 10 | 2 Spratt Technology Way | Sterling | 2 | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | MDavan | Biolitec Biomedical Technology | 549 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": ""}} | |||||||||||
| 3548 | Ejoshi | 64 | 3 | 3 | 1 | 1.0 | 2026-04-29 00:00:00.000000 | 2026-04-29 00:00:00.000000 | 2026-04-29 16:27:06.336000 | Rich@davidpackardcompany.com | 10 | 1 | 84257 | 6 | 1 | 15 Industrial Pk, East | Oxford | 24 | David Packard Company, Inc. | 01540 | 1 | 30 | 2 Spratt Technology Way | Sterling | 2 | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | Ejoshi | Rich Shine | 121 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": ""}} | ||||||||||||||
| 3562 | Ejoshi | 64 | 3 | 3 | 1 | 1.0 | 2026-05-01 00:00:00.000000 | 2026-05-01 00:00:00.000000 | 2026-05-04 11:27:52.179000 | 2026-05-01 14:46:43.220000 | j.turner@estiq.ai | 10 | 1 | 1) This is the cardboard insert for Estique 2) Thickness is to be 0.0175" 3) Certificate of Compliance required with each shipment. 4) Certification to current Reach and RoHS standards is required. 5) Dimension is the Punch Cut separation distance. The DIM is reference only. | 84275 | 1 | 1 | 4383 North Forestdale Drive | Park City | 2 | 48 | General Aesthetic Manufacturing. | 84098 | 3 | 10 | 2 Spratt Technology Way | Sterling | 2 | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | Ejoshi | James Turner | 559 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": ""}} | |||||||||||
| 3566 | Ejoshi | 64 | 8 | 1 | 1.0 | 2026-05-04 00:00:00.000000 | 2026-05-04 00:00:00.000000 | 2026-05-04 15:01:01.126000 | 2026-05-04 14:56:19.544000 | 10 | 1 | 84279 | 6 | 1 | PO Box 594 | Oxford | 24 | David Packard Company, Inc. | 1540 | 2 | 10 | 2 Spratt Technology Way | Sterling | 2 | Innofiber, LLC | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | Ejoshi | David Packard Company, Inc. | 121 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": ""}} | ||||||||||||||
| 3567 | Ejoshi | 64 | 1 | 1 | 1.0 | 2026-05-04 00:00:00.000000 | 2026-05-04 00:00:00.000000 | 2026-05-04 15:13:28.143000 | 2026-05-04 15:03:03.448000 | 10 | 1 | 1) BLACK DELRIN 2) Certificate of compliance to be provided with all shipments 3)PARTS TO CONFORM TO CURRENT REVISION STATED ON DRAWING AND PURCHASE ORDER. 4) CERTIFICATE OF COMPLIANCE TO REACH AND ROHS REQUIRED WITH EVERY ORDER. 5) PRODUCT AND PACKAGING TO BE FREE OF OIL AND DEBRIS. 6) ALL DOCUMENTATION TO INCLUDE INNOFIBER PO, PART NUMBER AND REVISION. 7) Material certification to be supplied | 84280 | 6 | 1 | PartsBadger, LLC 1700 S. Silverbrook Dr. Ste 300 | West Bend | 54 | PartsBadger, LLC | 53095-0497 | 2 | 10 | 2 Spratt Technology Way | Sterling | 2 | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | Ejoshi | PartsBadger, LLC | 358 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": ""}} | ||||||||||||||
| 3572 | DBarylski | 75 | 3 | 3 | 1 | 1.0 | 2026-05-05 00:00:00.000000 | 2026-05-05 00:00:00.000000 | 2026-05-05 11:55:57.131000 | Rich@davidpackardcompany.com | 10 | 1 | ALERT: All purchase orders must include the correct revision level for each line item. Please ensure the revision is entered and verified before processing | 84286 | 6 | 1 | 15 Industrial Pk, East | Oxford | 24 | David Packard Company, Inc. | 01540 | 2 | 30 | 2 Spratt Technology Way | Sterling | 2 | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | DBarylski | Rich Shine | 121 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": ""}} | |||||||||||||
| 3575 | DBarylski | 75 | 8 | 12 | 1 | 1.0 | 2026-05-05 00:00:00.000000 | 2026-05-05 00:00:00.000000 | 2026-05-06 14:06:42.159000 | 2026-05-05 12:43:10.951000 | 10 | 1 | 16445 16447- 1) Product comply with drawing 16447 current revision listed on drawing and PO. 2) Material certification to be supplied that states specific material type and lot. 3) Certificate of compliance to be provided with all shipments 4) REACH and RoHS certification to be provided with all shipments 5) All documentation to include Innofiber PO, Part Number, and Revision 6) Product and packaging to be free of oil and debris | 84289 | 4 | Sameer Ahmed | 1 | 1725 West 1st Street | Tempe | 2 | 4 | 85281 | 3 | 30 | 2 Spratt Technology Way | Sterling | 2 | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | Ejoshi | sahmed@i-fiberoptics.com | 511 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": ""}} | ||||||||||||
| 3576 | Ejoshi | 64 | 3 | 3 | 1 | 1.0 | 2026-05-05 00:00:00.000000 | 2026-05-05 00:00:00.000000 | 2026-05-05 13:35:30.859000 | Christiane.ott@schott.com | 10 | 1 | 84290 | 4 | +49(0)6131/66-3843 | 1 | Hattenbergstr. 10, | Mainz | 11 | 84 | Schott AG Advanced Optics | 55122 | 1 | 10 | 2 Spratt Technology Way | Sterling | 2 | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | Ejoshi | Schott AG Advanced Optics | 573 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": ""}} | ||||||||||||
| 3577 | Ejoshi | 64 | 3 | 3 | 1 | 1.0 | 2026-05-05 00:00:00.000000 | 2026-05-05 00:00:00.000000 | 2026-05-05 13:36:06.675000 | Christiane.ott@schott.com | 10 | 1 | 84291 | 4 | +49(0)6131/66-3843 | 1 | Hattenbergstr. 10, | Mainz | 11 | 84 | Schott AG Advanced Optics | 55122 | 1 | 10 | 2 Spratt Technology Way | Sterling | 2 | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | Ejoshi | Schott AG Advanced Optics | 573 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": ""}} | ||||||||||||
| 3581 | Ejoshi | 64 | 3 | 3 | 1 | 1.0 | 2026-05-06 00:00:00.000000 | 2026-05-06 00:00:00.000000 | 2026-05-06 09:24:59.353000 | 2026-05-06 09:24:44.187000 | nj.sales@mcmastercarr.com | 10 | 1 | 84295 | 6 | 1 | 200 New Canton Way | Robbinsville | 2 | 33 | McMaster-Carr Supply Co | 08691 | 2 | 30 | 2 Spratt Technology Way | Sterling | 2 | 24 | 01564 | 10 | None | _binary | 0.0 | 10 | Ejoshi | Sales Email | 284 | {"22": {"name": "Need REACH and RoHs Certification", "type": "Text", "value": ""}, "23": {"name": "Need REACH Certification With Shipment", "type": "Text", "value": ""}, "24": {"name": "Need RoHs Certification with Shipment", "type": "Text", "value": ""}, "34": {"name": "Project Number", "type": "Text", "value": ""}, "40": {"name": "Freight Tracking Number", "type": "Text", "value": ""}} |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "po" (
"id" INTEGERNOT NULL ,
"buyer" TEXT DEFAULT NULL,
"buyerId" INTEGERNOT NULL,
"carrierId" INTEGERNOT NULL,
"carrierServiceId" INTEGERDEFAULT NULL,
"currencyId" INTEGERDEFAULT NULL,
"currencyRate" REAL DEFAULT NULL,
"customerSO" TEXT DEFAULT 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,
"dateRevision" TEXT DEFAULT NULL,
"deliverTo" TEXT DEFAULT NULL,
"email" TEXT DEFAULT NULL,
"fobPointId" INTEGERNOT NULL,
"issuedByUserId" INTEGERDEFAULT NULL,
"locationGroupId" INTEGERNOT NULL,
"note" TEXT ,
"num" TEXT NOT NULL,
"paymentTermsId" INTEGERNOT NULL,
"phone" TEXT DEFAULT NULL,
"qbClassId" INTEGERDEFAULT NULL,
"remitAddress" TEXT DEFAULT NULL,
"remitCity" TEXT DEFAULT NULL,
"remitCountryId" INTEGERDEFAULT NULL,
"remitStateId" INTEGERDEFAULT NULL,
"remitToName" TEXT DEFAULT NULL,
"remitZip" TEXT DEFAULT NULL,
"revisionNum" INTEGERDEFAULT NULL,
"shipTermsId" INTEGERNOT 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,
"taxRateId" INTEGERDEFAULT NULL,
"taxRateName" TEXT DEFAULT NULL,
"totalIncludesTax" INTEGER NOT NULL,
"totalTax" REAL DEFAULT NULL,
"typeId" INTEGERNOT NULL,
"url" TEXT DEFAULT NULL,
"username" TEXT DEFAULT NULL,
"vendorContact" TEXT DEFAULT NULL,
"vendorId" INTEGERNOT NULL,
"vendorSO" TEXT DEFAULT NULL,
"customFields" TEXT DEFAULT NULL,
PRIMARY KEY ("id")
);